Need MySQL Specialist For Tuning Of A Linux Server - repost

We need a MySQL specialist who can optimize our database and tweak settings on our server. Also he install some plugins to make our website faster. Kindly note that its a repost, we got it done previously on but it couldn't help, so before biding you just read the error documents which are attached and bid only if you are confident to do it quickly. 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 300) 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 have increased the size of /tmp to 20Gb but still facing the same problem. Bellow is the mail which we received recently from CS Cart. ------------------------------------------------------------ The problem occurred with the cscart_products table in your store database. The mentioned error is a server-related issue as I mentioned earlier. It means that the MySQL server cannot create/update the file #sql_563f_51 in the /tmp directory (partition) and most probably it is due to insufficient space in this directory. I am sorry to hear that increasing the available size of the /tmp directory did not help you. Please let me explain you how exactly the /tmp folder is used by a MySQL server. When some data loaded from the database are to be ordered or sorted in any way, the ORDER BY or SORT BY MySQL clauses are used in a query. When such a MySQL query executes, MySQL server selects all the necessary data and puts it to the /tmp directory on a server so that it could be sorted/ordered there at the next step. Unfortunately, I cannot tell you how much free disk space should be allocated on the partition with the /tmp directory of your server. It depends on particular queries and the size of your CS-Cart store database. The more data size is selected from the database, the more free disk space needs to be allocated in the /tmp directory. I would like to ask you to provide us with the name of the CS-Cart page on which you have the mentioned problems. Also I would like to draw your attention to the fact that the /tmp directory is a service one used by a MySQL server. Neither PHP software (including CS-Cart) has control over the content of this directory or force a MySQL server to use it in some specific way. This MySQL server behavior is controlled only by its internal settings. For example, your current MySQL server settings forbid deleting any temporary files and it results in a quick filling up of the /tmp directory. Please hire a MySQL expert that can check it for you. Thank you. ---