…prepStmtCacheSize=512 …table_cache = 6000 read_rnd_buffer_size = 2M sort_buffer_size = 32k thread_cache = 16 query_cache_size = 0M thread_concurrency = 8 max_heap_table_size=200M log-output = FILE log-slow-queries=/tmp/mysql…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
… 512 bytes, in test with FusionIO I use 4096 bytes, to align IO with internal FusionIO size. You can see that MySQL…] socket=/var/lib/mysql/mysql.sock [mysqld] core basedir=/usr/local/mysql user=root socket=/var/lib/mysql/mysql.sock skip-grant-tables server_id=1…_capacity=500 max_connections=3000 query_cache_size=0 skip-name-resolve table_cache=10000 [mysql] socket=/tmp/mysql.sock (post edited by Fred Linhoss…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…/mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql… used. sort_buffer_size=2M query_cache_size=10M # Might be increased thread_cache_size=40 table_cache=512 # Default 64 was used before. skip… innodb_log_group_home_dir=/var/log/mysql innodb_log_arch_dir=/var/log/mysql innodb_table_locks=0 innodb_buffer_pool_size…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql-5…=1G –falcon_max_record_memory=2GB –falcon_page_cache_size=1500M –max-connections=1500 –table-cache=512 –net_read_timeout=30 –net_write_timeout…-connections=1500 –table-cache=512 –net_read_timeout=30 –net_write_timeout=30 –back_log=128 Method of benchmark: 1. Prepare table with 1…
Comment: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 100 Comments
… default NULL, `AUTHOR_ALIAS` varchar(128) default NULL, `AUTHORS` varchar(512) default NULL, `SUBTITLE` varchar(1600) default NULL, `ORIG_PUBLISH_DATE…CNF ——- [mysqld] socket = /var/lib/mysql/mysql.sock skip-locking key_buffer = 384M max_allowed_packet = 256M table_cache = 512M sort_buffer_size = 2M…
Comment: What to tune in MySQL Server after installation
October 8, 2012 By 118 Comments
…indexes [Cache] query_cache_type = 1 query_cache_size = 64M query_cache_limit = 64M thread_cache_size = 70 table_cache = 2048 table_open_cache = 512 [Buffers]…mysql/mysql.sock [Server] server-id = 1 log-bin=/data/mysql/drbd expire_logs_days = 5 max_binlog_size = 100M [client] socket=/data/mysql/mysql…
Comment: What to tune in MySQL Server after installation
December 15, 2009 By 118 Comments
… is my.cnf configuration file [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for… table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size = 32M log_queries_not_using_indexes = On log_slow_queries=/var/lib/mysql/log-slow…
Comment: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… = /usr datadir = /var/lib/mysql tmpdir = /tmp skip-locking key_buffer = 384M max_allowed_packet = 1M table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size = 32M thread_concurrency = 8 log-bin=mysql-bin #innodb_buffer_pool_size…
Post: InnoDB benchmarks
January 3, 2007 By 15 Comments
…compiled from sources with options: ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb and next startup options were used: libexec/…connections=1500 –table-cache=512 Description of benchmark Specially for our needs I developed benchmark suite which support wide range of tables and …
Comment: Why MySQL could be slow with large tables ?
August 21, 2006 By 141 Comments
… think you can give me some advise. I am running MySQL 4.1 on RedHat Linux. The box has 2GB of… = 8M table_cache = 512 sort_buffer_size = 32M read_buffer_size = 32M read_rnd_buffer_size = 128M myisam_sort_buffer_size = 256M thread_cache = 32 query_cache_size = 256M I am running data mining process that updates/inserts rows to the table (i.e…
