Mysql Params

5 posts / 0 new
Topic locked
Last post
#1 Tue, 12/20/2011 - 04:33
saoullabit

Mysql Params

Hi all, after few days looking at some performances issues with fcgi, I found mysqltuner (https://github.com/rackerhacker/MySQLTuner-perl) I made few changes on the mysql configuration via Virtualmin (pro) BUT I have some variables to set but I can't do it on the virtualmin interface, like :

  1. query_cache_limit (> 2M, or use smaller result sets)
  2. join_buffer_size (> 128.0K, or always use indexes with joins)
  3. tmp_table_size (> 16M)
  4. max_heap_table_size (> 16M)
  5. thread_cache_size (start at 4)
  6. table_cache (> 64)

Where, on Debian Squeeze, I can change these variables, or is there is a way to change it on virtualmin ?

Regards, Marc

Tue, 12/20/2011 - 07:47
andreychek

Howdy,

You can tweak some MySQL variables using Virtualmin.

To do that, go into Webmin -> Servers -> MySQL -> MySQL Server Configuration, and the variables you can tweak are on that screen.

Alternatively, for direct access to the config file so that you can edit any of the variables, you can edit /etc/mysql/my.cnf. Most of the variables you're discussing would go under the [mysqld] section.

-Eric

Wed, 12/21/2011 - 08:56
saoullabit

Hi there,

I changed some stuffs on the my.cnf, that minimized general load ... But Still have some perf. issues. Still looking how to optimize fcgi for PHP5

Is there is a way to allow more RAM to a php5 cgi process owner without impacting the rest of the users ?

Regards, Marc

Wed, 12/21/2011 - 09:22
andreychek

I'm not sure of a way to configure PHP like that... but you can solve the problem in a similar way by researching caching solutions.

Many applications support various forms of caching -- memcache is one example.

If your application can be configured to use memcache, and it's doing a lot of database lookups -- that can really improve the performance you're getting.

There's other types of caching solutions as well, memcache is just one which caches things such as database lookups.

-Eric

Wed, 12/21/2011 - 09:24
saoullabit

Thanls a lot I'll lookup that way ...

I don't think that there is a memcache plugin in virtualmin ... True ? ;-)

Regards. Marc.

Topic locked