################BEGIN my.cnf################ [mysqld] port = 3306 socket = /tmp/mysql.sock basedir = /usr/local/mysql
log = /var/log/mysql/mysql.log log-slow-queries = /var/log/mysql/mysql-slow.log log-err = /var/log/mysql/mysql.err log-bin = /var/log/mysql/mysql-bin.log log-long-format skip-locking ##Change depending on situation transaction-isolation = READ-COMMITTED ###Tweak Here## set-variable = sort_buffer=512M set-variable = record_buffer=512M set-variable = key_buffer=256M set-variable = log-warnings=1 set-variable = long_query_time=30 ###FOR CACHED QUERIES### set-variable = query_cache_size=128M ###TUNE BASED ON CONNECTIONS### set-variable = max_allowed_packet=32M set-variable = max_connections=50 set-variable = thread_stack=64K set-variable = thread_cache=16 set-variable = thread_concurrency=8 ######################################################## # InnoDB Config ######################################################## ###If you change these... make sure you have a backup !!! (before) ###These are just setup things... not really tweak #innodb_data_home_dir = /usr/local/mysql/data/innodb #innodb_data_file_path = innodb1:500M:autoextend #innodb_log_group_home_dir = /var/log/mysql/innodb #innodb_log_arch_dir = /var/log/mysql/innodb/ #set-variable = innodb_log_files_in_group=3 #set-variable = innodb_log_file_size=10M #set-variable = innodb_log_buffer_size=10M set-variable = innodb_lock_wait_timeout=10 ###Look At These too!! set-variable = innodb_buffer_pool_size=512M set-variable = innodb_additional_mem_pool_size=128M set-variable = innodb_flush_log_at_trx_commit=0 ################END my.cnf################ >what table types? Innodb.etc... It is mainly innodb. >about how many tables? there are around 200 tables >do you do alot of sorting? Lots of sorting and fltering is done >are the exact same queries repeated alot? Not likely >is the machine doing anything else or is mainly a DB server? Nope. Just DB. >can I borrow the machine for awhile? Nope. It is our to be production box >what version of mysql are you running? 4.0.14 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
