CODEWITHSUNDEEP
mysqlapacheapache2debian
BlackMouse
BlackMouse

Reputation: 4552

Debian, mysql: How can I tune these values

I have a debian VPS with 16 GB ram (CPU: 4 * 2Ghz).

I notice some performance issues when I now have about 2,000 request / seconds.

The CPU is at: 

41% user, 8% kernel, 2% IO, 49% idle

and ram: 

15.71 GB total, 4.97 GB used

I'm a complete noob when it comes to servers, so I dont want to mess around to much. I notice a performance increase when raising max_connections from 1,000 to 2,000, and increased key_buffer from 512 to 1024M.

If anyone could take a look at the values below, and let me know if there's any tweaks I can do, that would be awesome. Thanks in advance: 

    # * Fine Tuning
#
key_buffer      = 1024M
max_allowed_packet  = 512M
thread_stack        = 192K
thread_cache_size       = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover         = BACKUP
max_connections        = 2000
#table_cache            = 64
#thread_concurrency     = 10
#
# * Query Cache Configuration
#
query_cache_limit   = 32M
query_cache_size        = 128M

Upvotes: 1

Views: 508

Answers (1)

leepfrog
leepfrog

Reputation: 381

First of all: Make a backup of your my.cnf to go back if anything goes wrong.

Then use mysqltuner.pl to give you some basic information about your database and some tuning advice. Before you make changes be sure to refer to the mysql documentation what the setting actually does and evaluate if it (seems) to make sense. Then apply the changes and run mysqltuner again after 24+h to see the changes

Upvotes: 3

Related Questions