|
And here are the contents of my my.conf file:
MY.CONF CONTENTS:
big-tables
connect_timeout = 1200
datadir = /var/lib/mysql
default-storage-engine = InnoDB
interactive_timeout = 1200
join_buffer_size = 32M
key_buffer = 4096M
log=mysql.log
log-error=/var/log/mysqld.log
log-slow-queries = /var/log/mysqlslowqueries.log
long_query_time = 1
max_allowed_packet = 256M
max_connections = 2500
max_heap_table_size = 512M
myisam_sort_buffer_size = 1024M
open_files_limit = 16344
pid-file=/var/run/mysqld/mysqld.pid
query_cache_limit = 512M
query_cache_size = 2048M
query_cache_type = 1
read_buffer_size = 32M
read_rnd_buffer_size = 32M
skip-grant-tables
socket = /var/lib/mysql/mysql.sock
sort_buffer_size = 32M
symbolic-links=0
table_cache = 36272
thread_cache = 8192
thread_cache_size = 1024
thread_concurrency = 16
tmp_table_size = 1024M
user=mysql
wait_timeout = 3000
Also, along with the mysql issue I'm currently facing, I have a very large Joomla site and on this same site is a Magento store with 150,000 SKU's, so any performance optimizations to the above php.ini and my.conf file would be appreciated as I need all the help that I can get to increase speed due to the extremely large catalog. Thanks for any help you guys can provide.
|