Portal Home > Knowledgebase > Articles Database > SQL optimization

SQL optimization

Posted by robc12, 10-03-2012, 07:15 AM

Hai one of a vps taking more cpu usage (Its MYSQL ) Some time the load was very low but some time it going too big i thought it is due to sql. when i doing a monitoring i can see the sql load was too big. it possible to compress ? by Channing its programs or any other way.

---

Posted by nehir, 10-03-2012, 08:37 AM

Possible due bad mysql configuration or slow queries. There are 2 great & free mysql optimization tools: mysqltuner and tuning primer

---

Posted by Hire Developer, 10-09-2012, 06:38 AM

Below is the link where you can see good information regrading SQL optimization: http://hungred.com/useful-informatio...e-sql-queries/ Regards,

---

Add to Favourites    Print this Article

Node.js on cPanel question (Views: 777)

ERROR 2003 oon mysql (Views: 30300)

To resell or not to resell? (Views: 755)

SSL certificate for multiple subdomains? (Views: 775)

Deciding on host ... (Views: 758)