Database cause high server load

[DoctorX]

Hello,
My forum database cause too much server load.
Iam using Mybb.

Any idea to decrease this CPU load? optimization the database?

Thanks

 

[Pirate]

I can believe this easily. I have a mybb forum too with a huge db and it's horrible.

I hope somebody will try to help us with some suggestions.
Thank you!

 

[Mareshal]

Do you use any accelerator? APC, eAccelerator or Varnish? Do you use a vps, dedicated server or a shared account?

 

[DoctorX]

Hello,
No accelerator.
VPS , 2 GB RAM .

 

[accyuklad]

this also depends on how much daily vistors you get im sure that can effect cpu

if you using cpanel get nginx installed it make a big difference but i dont know how to install them but some will know on here or what site will install it for a smal fee

 

[Motion]

Hello,
No accelerator.
VPS , 2 GB RAM .

Use top command and put the result here.
If mysqld using high server resource then cache your mostly used mysql result.

 

[onel0ve]

Hello,
No accelerator.
VPS , 2 GB RAM .

install mysql 5.5.12 its fastest mysql version
then optimize it using mysqltuner
and install memcached for database cache and install Eaccelerator with php 5.3.6 .

 

[DoctorX]

Use top command and put the result here.

Mysql uses 130% .

install mysql 5.5.12 its fastest mysql version
then optimize it using mysqltuner
and install memcached for database cache and install Eaccelerator with php 5.3.6 .

My current version is 5.1.41, is that an old one?
I'll try to do these things.
Thank you.

 

[NewEraCracker]

MySQL 5.5 will break your scripts.
Update to 5.1.57

 

[DLow]

Shoot me a PM

 

[onel0ve]

MySQL 5.5 will break your scripts.
Update to 5.1.57

why era ??
i am using it without any problem :facepalm:

 

[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 :facepalm:

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