mmofacts.com

Mysql settings

posted 15 years, 7 months ago by BasTijs_en

I'm storing sessions in my database and sometimes I get logged out without any reason. I think its because of the mysql settings. To low memory settings.

What are good settings for a dedicated server?

On my localhost I got, I still have to check the settings on my server:

skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M

posted 15 years, 6 months ago by Klaus_en

That depends on your hardware and apllication. Try this script to analyze your settings: http://www.day32.com/MySQL/

posted 15 years, 3 months ago by G-Projects

Original from Klaus

That depends on your hardware and apllication. Try this script to analyze your settings: http://www.day32.com/MySQL/

That helped me :)

Reply to this discussion