# Increased load on server

**URL:** <https://forums.percona.com/t/increased-load-on-server/1261>\
**Category:** Other MySQL® Questions\
**Created:** [September 16, 2009, 9:55am UTC](https://forums.percona.com/t/increased-load-on-server/1261 "2009-09-16T09:55:12Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![phototest](https://avatars.discourse-cdn.com/v4/letter/p/43a26b/32.png) [@phototest](https://forums.percona.com/u/phototest)\
**Post date:** [September 16, 2009, 9:55am UTC](https://forums.percona.com/t/increased-load-on-server/1261/1 "2009-09-16T09:55:12Z")

</div>

Hello all,

I am having a strange problem where my database server load average increase as the number of updates and selects on 3 of my larges tables go up. The biggest ones (160GB) are MyISAM tables and the third is an innodb table (2GB).

The server is my master database so it gets a lot of updates but because the large tables are so big, I have to do selects on them from the master because if I did my selects on the slave it will increase their replication lag. I am considering moving to innodb but I want to make sure I have tried all options before I make that move because the tables are soo large. Has anyone had this problem before and maybe have any ideas how to solve it?

I also noticed that the more the number of active connections I have, the cpu system waits go up when there is a lot of activity on these tables.

An help would be welcomed. my mysql config is show below.  
[mysqld]  
log-bin  
replicate-ignore-db=mysql

log-slave-updates

server-id = 52001001  
set-variable = max\_connections=2500  
set-variable = back\_log=20  
set-variable = key\_buffer=8000M  
set-variable = table\_cache=4000  
set-variable = max\_allowed\_packet=4M  
set-variable = sort\_buffer=2M  
set-variable = record\_buffer=4M  
set-variable = myisam\_sort\_buffer\_size=64M  
set-variable = thread\_cache=200  
set-variable = long\_query\_time=10  
set-variable = query\_cache\_size=256M  
set\_variable = wait\_timeout=60

transaction-isolation = READ-COMMITTED  
skip-slave-start

innodb\_additional\_mem\_pool\_size=20M

innodb\_flush\_method=O\_DIRECT

innodb\_flush\_log\_at\_trx\_commit=2

innodb\_log\_buffer\_size=256M

innodb\_buffer\_pool\_size=2G

# Have eight threads running concurrently

innodb\_thread\_concurrency=8

# let’s have a file per table

innodb\_file\_per\_table

############################################################ ############

log-bin = /var/lib/mysql/b2db01-new-bin

relay-log = /var/lib/mysql/b2db09-relay-bin

log-slow-queries = /var/lib/mysql/slow.log  
skip-name-resolve  
tmpdir = /var/lib/mysql/tmp

#core-file

datadir=/var/lib/mysql  
socket=/var/lib/mysql/mysql.sock

# Default to using old password format for compatibility with mysql 3.x

# clients (those using the mysqlclient10 compatibility package).

old\_passwords=1  
#user=root

[mysql.server]  
user=mysql  
#core\_file\_size = unlimited

[mysqld\_safe]  
log-error=/var/log/mysqld.log  
log=/var/log/mysqld.log  
pid-file=/var/run/mysqld/mysqld.pid

[client]  
socket=/var/lib/mysql/mysql.sock  
#user = root

---

<div class="post-metadata">

**Author:** ![gmouse](https://avatars.discourse-cdn.com/v4/letter/g/b9e5f3/32.png) [@gmouse](https://forums.percona.com/u/gmouse)\
**Post date:** [September 16, 2009, 4:54pm UTC](https://forums.percona.com/t/increased-load-on-server/1261/2 "2009-09-16T16:54:18Z")

</div>

Why is it strange that your load increases if you ask your server to do more for you?  
If a query takes a long time on a MyISAM table, then all update/insert queries have to wait. Check [URL=“[MySQL :: MySQL 8.0 Reference Manual :: 13.7.7.29 SHOW PROCESSLIST Statement](http://dev.mysql.com/doc/refman/5.1/en/show-processlist.html)”] [http://dev.mysql.com/doc/refman/5.1/en/show-processlist.html[/URL]](http://dev.mysql.com/doc/refman/5.1/en/show-processlist.html%5B/URL%5D)