…, simply decrease the values in the /etc/my.cnf file if you really want to try … output from the ./run_query command, called pivot_results cd shard-query/ $ ./run_query < queries.sql | tee raw |./pivot_results…16M key-buffer-size=64M local-infile=on lock-wait-timeout=300 log-error=/var/log/mysqld-…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set …query-time=5 log-slow-queries=/apps/log/slow-query interactive_timeout=300 wait_timeout=300 thread_cache = 40 max_connections=500 query…flush_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
… 32 GB – RAM 12 Core Processor 1TB – Disk My.cnf ========== freehold: [client] port=3323 socket=/tmp/mysqld_… tmpdir=/home/mysqld/mdmp/tmp slow_query_log=mdmp_slow_queries.log # binary logging and replication…=16 innodb_buffer_pool_size = 4500M innodb_lock_wait_timeout=60 innodb_log_buffer_size = 32M …
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
… MYISAM. My my.cnf variables were as follows on a 4GB RAM system, Red Hat Enterprise with dual SCSI RAID: [mysqld] long_query_time…-innodb skip-locking query_cache_limit=1M query_cache_size=32M query_cache_type=1 max_connections=1500 interactive_timeout=25 wait_timeout=10 connect_timeout=5…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… interesting: MySQL 5.0 Tuning in /etc/my.cnf (included in FDA) [mysqld] sql-mode = IGNORE_… 1 innodb_lock_wait_timeout = 300 innodb_thread_concurrency = 0 innodb_sync_spin_loops = 40 innodb_locks_unsafe_for_… allocating it will likely be faster. query_cache_size = 0M – query cache disabled. Not a big…
Comment: What to tune in MySQL Server after installation
December 15, 2009 By 118 Comments
… 4764 S mysqld Below is my.cnf configuration file [mysqld] datadir=/var… package) old_passwords=1 skip-locking key_buffer = 384M max_allowed_packet =…query_cache_size = 32M log_queries_not_using_indexes = On log_slow_queries=/var/lib/mysql/log-slow-queries…= 2M [mysqlhotcopy] interactive-timeout
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 75 Comments
…am facing major issues with slow query output. The tables are in InnoDB with MySQL … InnoDB are [root@ng-lg-mdb1 ~]# cat /etc/my.cnf|grep innodb innodb_data_home_dir = innodb_data…lock_wait_timeout = 50 A count command with approx 3 million records is taking too long and all my transactions are locked…
Comment: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…my web, this server become very very slow. i have about 400 user active. here of my.cnf…var/lib/mysql tmpdir = /tmp skip-locking key_buffer = 384M max_…64M thread_cache_size = 8 query_cache_size = 32M …write_buffer = 2M [mysqlhotcopy] interactive-timeout #——————————————————————————————– please give me…
