Need MySQL Specialist For Tuning Of A Linux Server

En cours Publié le Jun 1, 2013 Paiement à la livraison
En cours 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.

Ingénierie MySQL PHP Architecture Logicielle Hébergement Web

Nº du projet : #4580436

À propos du projet

9 propositions Projet à distance Actif Jun 21, 2013

9 freelances font une offre moyenne de 124 $ pour ce travail

sabdsouza

I can help you with this

$80 USD en 3 jours
(158 Commentaires)
6.6
adilchang

Hi, i am aware of this issue , Please read my PM

$55 USD en 0 jours
(119 Commentaires)
6.2
univane

Hi, After going through with yoour SPECS it is very clear that problem is in CSCART mysql queries. In order to work your website properly we must tune these queries. Kindly allow me to do the same if found suitable. Plus

$222 USD en 10 jours
(23 Commentaires)
4.4
igotmail9

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.

$147 USD en 3 jours
(4 Commentaires)
3.0
goarilla

Your /home and/or /tmp filesystem is full and your application is using 2 DATABASES (mysql and sqlite3) which could be a misconfiguration.

$105 USD en 3 jours
(5 Commentaires)
3.0
pathikritrocks

please check PMB

$35 USD en 3 jours
(1 Évaluation)
1.1
mgargiullo

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

$166 USD en 3 jours
(0 Commentaires)
0.0
goltiwanisap

you have an interesting problem to solve. please check pm

$155 USD en 3 jours
(0 Commentaires)
0.0
linuxservices

I can tweak this. I think this problem occured due to bulk insert need to tweak the bulk insert parameters.

$155 USD en 3 jours
(0 Commentaires)
0.0