…my.cnf to those server is currently running with. The problem however this only works well if settings are set in my.cnf…YES userstat FALSE verbose TRUE wait-timeout 28800 Which is however …Right now I can select: mysql> select @@global.sort_buffer_size; +—————————+ | @@global.sort_…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…,63.366,14.573 InnoDB my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine…-size=16M key-buffer-size=64M local-infile=on lock-wait-timeout=300 log-error=/var/log/mysqld-innodb.log max-allowed…=256K tmp-table-size=64M transaction-isolation=READ-COMMITTED user=mysql wait-timeout=86400 To be continued You can now set up a…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… previous SpecJAppServer Benchmarks several years ago while being employed by MySQL. These are great results, plus they can be relevant to… to disable them. The MySQL Settings are probably what is the most interesting: MySQL 5.0 Tuning in /etc/my.cnf (included in FDA… = 16M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 300 innodb_thread_concurrency = 0 innodb_sync_spin_loops = 40…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… system runs mainly # MySQL. # # You can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /usr/local/mysql/data) or # ~/.my.cnf to set…_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash # Remove the next…
Comment: What to tune in MySQL Server after installation
December 7, 2006 By 118 Comments
… gig network. All my tables are MyIsam. Following is out of mytop MySQL on localhost (5…18.7k qps varies from 3000 to 8000. My.cnf key_buffer = 4096M max_allowed_packet = 32M table… 300 max_connect_errors = 99 wait_timeout=10 interactive_timeout = 10 #set-variable=wait_timeout=3000 # Try number of CPU…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
… My.cnf ========== freehold: [client] port=3323 socket=/tmp/mysqld_mdmp.sock character-sets-dir=/home/mysqld/sys/5.5.8/share/mysql/charsets…_wait_timeout=60 innodb_log_buffer_size = 32M innodb_log_file_size = 512M innodb_open_files=2048 #Replication-skip replicate-ignore-table=mysql…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
… predominantly SELECTed table, I went for MYISAM. My my.cnf variables were as follows on a 4GB RAM…_type=1 max_connections=1500 interactive_timeout=25 wait_timeout=10 connect_timeout=5 thread_cache_size=60 … the application. Just my experience. I know some big websites are using MySQL, but we had …
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
… information, this is my.cnf: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql max_connections=600 connect_timeout=30 wait_timeout=15 max_allowed…_size=64M innodb_flush_log_at_trx_commit=2 [mysql.server] user=mysql basedir=/var/lib thread_concurrency = 8 max_allowed_packet…
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 75 Comments
… with slow query output. The tables are in InnoDB with MySQL 5 and RHEL 5. Its a 32 bit machine with…/my.cnf|grep innodb innodb_data_home_dir = innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /usr/local/mysql… innodb_lock_wait_timeout = 50 A count command with approx 3 million records is taking too long and all my transactions are locked…
Comment: MySQL random freezes could be the query cache
March 29, 2009 By 23 Comments
… new thread Also issuing a /usr/local/etc/rc.d/mysql-server restart command just hangs as well, have to issue… start. Here is our my.cnf: skip-name-resolve max_connections = 2000 skip-innodb log-bin = /usr/mysql/logs/mysql-bin.log binlog-do-db=tp server-id=1 wait_timeout = 15 key_buffer = 16M key…
