Need MySQL Specialist For Tuning Of A Linux Server
$30-250 USD
Paiement à la livraison
Problems were started since the day on which we bulk uploaded products thru CSV sheets. After uploading 20000 products we started facing following isues.
•High CPU Usage (some time it goes up to 30) due to that server gets broken down so that our web site.
•High load on memory and CPU due to database queries
Now 1st we contacted our Server hosting company, they said that its happening due to insufficient RAM which was 2MB, we upgraded the RAM to 4GB. Still the problem was as it was, server was getting hanged, website was down al the time, high SPU usage.
Once again we contacted the server peoples and they have provided us with a completely new machine which was well upgraded.
Lets compare the configuration:
Old Machine: Processor 1 VendorGenuineIntelNameIntel® Xeon® CPU X3220 @ 2.40GHzSpeed2400.139 MHzCache4096 KB, 2GB RAM
New Machine:
No. of Processors 4, Xeon® CPU X3220 @ 2.60GHz 4GB RAM
Unfortunately problems are still coming. Now server peoples are saying that our CS Cart database structure is not optimized so we have to get the database STRUCTURE optimized.
Now we contacted CS Cart technical support team and they said that everything is ok at their end and said that the problem is at server end as there s no enough memory or space on server.
-------------
We are getting bellow errors:
Error .1
is missing in the mentioned SQL query:
05/27/2013, 09.50.46 - Database (error) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/tmp/#sql_7e41_75' at line 1 (1064)
Query: SELECT SQL_CALC_FOUND_ROWS products.*, [login to view URL] as product, MIN(IF(prices.percentage_discount = 0, [login to view URL], [login to view URL] - ([login to view URL] * prices.percentage_discount)/100)) as price, descr1.short_description, IF(descr1.short_description = ''.....................
--------------------------------
Error .2
Error: Got error 28 from storage engine (1030)
Query: SHOW COLUMNS FROM cscart_logs
---------------------------------
Error .3
Warning: SQLite3::query() [[login to view URL]]: Unable to execute statement: database disk image is malformed in /home/shopping/public_html/core/classes/cache_backend/[login to view URL] on line 167
Warning: SQLite3::query() [[login to view URL]]: database disk image is malformed in /home/shopping/public_html/core/classes/cache_backend/[login to view URL] on line 49
Need a person who have a strong sense of MySQL tweaks and settings also we require to speed up our website by installing some white listed software on our server or by changing server settings. The work must be done with full transparency and we will require full change log before making the final payment.
Nº du projet : #4580436
À propos du projet
9 freelances font une offre moyenne de 124 $ pour ce travail
Hello, your database query is wrong. hence the you got the error. this is nothing to do with server. Please trust me and provide DB username and password along with machine details. I will login and provide your hints.
Your /home and/or /tmp filesystem is full and your application is using 2 DATABASES (mysql and sqlite3) which could be a misconfiguration.
I've managed dozens on MySQL servers on Linux over the years. Currently maintaining a MySQL cluster that handles one billion records per day. A freebie... The middle error is from a lack of disk space. Honestly, th Plus
I can tweak this. I think this problem occured due to bulk insert need to tweak the bulk insert parameters.