MySQL is the only process that runs on these boxes. We dedicate the servers to MySQL since the DBs are so large. One of the possible problems is that these servers used to be MyISAM DBs, but we upgraded to InnoDB once we moved from 3.23.33 to 4.0.16. It is hard to tell the MyISAM variables from the InnoDB ones, so that I can optimize for InnoDB. I know that those prefixed with InnoDB are for such, but not which others may affect it as well. We only use MyISAM for the mysql system DB. The build is 4.0.16 from a RedHat RPM binary. These settings used to work great on the older MySQL, older hardware, same 4GB RAM, and much higher user access.(It was for the old MP3.com DBs)
Here is the whole mysqld section in the my.cnf: [mysqld] user = mysql port = 3306 socket = /home/mysql/mysql.sock tmpdir = /usr2/tmp skip-locking server-id = 13 set-variable = back_log=10 set-variable = max_connections=800 set-variable = key_buffer=256M set-variable = max_allowed_packet=8M max_allowed_packet =8M set-variable = thread_stack=128K set-variable = record_buffer=4M set-variable = sort_buffer=64M #set-variable = wait_timeout=120 skip-slave-start # Start logging log-slow-queries = slow.log #log = query_log log-slave-updates log-bin # This MySQL options file was generated by innobackup. innodb_data_home_dir=/home/mysql innodb_data_file_path=ibdata1:20000M:autoextend innodb_log_group_home_dir=/home/mysql/ innodb_log_files_in_group=2 innodb_log_file_size=512M innodb_buffer_pool_size = 1512M innodb_additional_mem_pool_size = 20M And a note: /home is actually on a large filesystem separate from /, so there is not OS/DB access issues. -----Original Message----- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Friday, June 11, 2004 7:45 AM To: [EMAIL PROTECTED] Subject: Re: Server optimization issue "Misao" <[EMAIL PROTECTED]> wrote: Take a deep look at http://dev.mysql.com/doc/mysql/en/Server_system_variables.html But ensure that this is MySQL who takes so much memory. Watch other variables like key_buffer. MySQL probably should not take that much memory if these are the only variables specified: > Here are my InnoDB settings in my.cnf: > innodb_log_files_in_group=2 > innodb_log_file_size=512M > innodb_buffer_pool_size = 1512M > innodb_additional_mem_pool_size = 20M What are the OS and MySQL build? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
