…: MySQL 5.0 Tuning in /etc/my.cnf (included in FDA) [mysqld] sql-mode = IGNORE_SPACE transaction-isolation = READ-COMMITTED max_allowed_packet = 1M max_connections…_cache_size = 0M thread_concurrency = 8 max_heap_table_size=200M log-output = FILE log-slow-queries=/tmp/mysql-slow.log long_query…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 4 Comments
…MySQL, here are some example queries and the corresponding number of concurrency tickets used for each: mysql…max-requests=0 –oltp-dist-type=uniform –max-time=300 –mysql-user=root –mysql-socket=/var/lib/mysql/mysql.sock run Applicable my.cnf…500 innodb_max_dirty_pages_pct=90 max_connections=3000 …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…92-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql socket=/var/run/mysqld/… max_connections = 2500 max_connect_errors = 10 table_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_… is very similar, due to high concurrency response time in the first case is…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 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… thread_cache = 40 max_connections=500 query_cache_size = 2000M # Try number of CPU’s*2 for thread_concurrency thread_concurrency = 8 ft_min…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 139 Comments
… this is a predominantly SELECTed table, I went for MYISAM. My my.cnf variables were as follows on a 4GB RAM system, Red… max_connect_errors=10 thread_concurrency=4 myisam_sort_buffer_size=950M character-set-server=utf8 default-collation=utf8_unicode_ci set-variable=max_connections=1500 log_slow_queries=/var/log/mysql-slow.log sql-mode=TRADITIONAL concurrent_insert=2 low_priority…
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
… 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_packet=…_flush_log_at_trx_commit=2 [mysql.server] user=mysql basedir=/var/lib thread_concurrency = 8 max_allowed_packet = 64M [mysqld_safe] …
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…48 bits virtual power management: I tested MySQL-5.1.30 with InnoDB plugin… (split_buffer_pool_mutex patch). my.cnf is [mysqld] user=root binlog_…_size=1M max_allowed_packet=1M max_connections=3000 max_heap_table_size=64M max_prepared_… thread_cache_size=16 thread_concurrency=16 thread_stack=196K tmp_…
Comment: What to tune in MySQL Server after installation
December 7, 2006 By 116 Comments
… my tables are MyIsam. Following is out of mytop MySQL … 3000 to 8000. My.cnf key_buffer = 4096M max_allowed_packet = 32M… query_cache_size = 512M max_connections = 300 max_user_connections = 300 max_connect_errors = 99 wait_timeout=…CPU’s*2 for thread_concurrency thread_concurrency = 8 Please suggest …
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
…MySQL and am not getting the high insert throughput as in this benchmark. Could you post the my.cnf…CREATE_USER,NO_ENGINE_SUBSTITUTION” max_connections=100 query_cache_size=0…concurrency=8 RAM: 1GB Processor: Intel P4 2.253GHz Cache size: 512KB Front side bus: 530 MHz Harddrive: WDC WD400BB-75DEA0 Max…
Comment: What to tune in MySQL Server after installation
June 22, 2009 By 116 Comments
…Mysql configuration is as follows::: [root@crm ~]$ vi /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql…mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid max_connections…
