Mysql Configuration My.cnf

[mysqld]
set-variable = max_connections=1500
socket          = /var/lib/mysql/mysql.sock
key_buffer =2048M
table_cache = 36272
open_files_limit = 16344
join_buffer_size = 8M
read_buffer_size = 8M
sort_buffer_size = 8M
tmp_table_size=512M
read_rnd_buffer_size=8M
max_heap_table_size=256M
myisam_sort_buffer_size=256M
thread_cache_size=8
thread_cache=8192
query_cache_type=1
query_cache_limit=512M
query_cache_size=1024M
thread_concurrency = 8
wait_timeout = 60
connect_timeout = 60
interactive_timeout = 60
long_query_time=1
log-slow-queries = /var/log/mysqlslowqueries.log
max_allowed_packet=128M
 

Latest Post

Popular Post

Our Skills

Author

Project Director Information Architect Database Administrator Unix Administrator Senior Developer Project Manager Product Manager Web Marketer Cloud Engineer

Contact Us

For any questions or project ideas please contact me at the following.

I'm here