Database cause high server load

[onel0ve]

MySQL 5.5 will break your scripts.
Update to 5.1.57

why era ??
i am using it without any problem

[bhanuprasad1981]

you can also try using mariadb instead of mysql for better performance

[Piracy King]

optimize your database daily..
upgrade to latest version of mysql

install eaccelerator

u can disable innodb if u r not using..

[Motion]

optimize your database daily..
upgrade to latest version of mysql

install eaccelerator

u can disable innodb if u r not using..

The best option to reduce server load:

If mysqld using high server resource then cache your mostly used mysql result.

[Pirate]

DoctorX: Do you solved the problem, or are the cpu load better now?
Your site is faster than 2-3 days ago.

[Whoo]

Enable slow_query_log in my.cnf, then analyze the slow queries and see which one you can remove/optimize.

[NewEraCracker]

why era ??
i am using it without any problem

MySQL removed some legacy features in v5.5

When MySQL 5.1 gets unsupported. MariaDB all the way

[DoctorX]

DoctorX: Do you solved the problem, or are the cpu load better now?
Your site is faster than 2-3 days ago.

Hello,
I have just disabled persistent connection to db via php.ini.
but still have high load especially at mid night, but the performance somewhat is better than before.

Enable slow_query_log in my.cnf, then analyze the slow queries and see which one you can remove/optimize.

Even if i did this, i really don't know how optimize it.
Iam running just a forum on the server, i didn't make any manual changes to my current mysql database, it is the default one of any Mybb forum.
But i think that the the high post count daily may be the culprit (many posts within 1 min) , and don't know what to do regarding this.

[chrishar]

how many visitors your site is getting per day on average?
is your db is mysql or postgres?

[sady92]

Hi,

Optimizating my.cnf is a really hard work bur you should optimize it from your server specs..

This whole week i was trying to optimize my.cnf not becouse i am having high CPU usage just for been ready

You can use the command "/usr/local/cpanel/3rdparty/mysqltuner/mysqltuner.pl" into SSH thru putty and you will get some suggestions..

This thing should made every day or every 1-3 days to see what the script will suggest you to change

this is a loong term run so you wont see the changes imediatly