Tadeu Alves wrote:
Thanks for this heads up i was thinking into some of these i was
looking into the page that has the calculation of each looking into
mysqlperformance blog
it's a good idea of add more memory into this variables?
query_cache_size= 1000M to 2000M and
innodb_buffer_pool_siz
Hi,
probably your system is swapping on disk,
immediately reduce the sort_buffer_size, it is a per connection buffer, and
your setting is way too high:
sort_buffer_size=1000M (with 8 client threads you finish your ram)
set it to something between 256K and 8 M
sort_buffer_size=1M
also
read_rn
Helo there guys today ive got a brig problem my server that runs only Mysql
is undegoind a very load, the server is ok but memory and cpu usage are very
high
mys server configuration is a
2x Quad Core Intel® Xeon® E5450, 2x6MB Cache, 3.0GHz, 1333MHz FSB
8GB 800MHz Memory
2x SAS 73GB 15000RPM in RA
