…memory available but since we run on 32 bit we cannot turn up the innodb_buffer_…mysql conf: [mysqld] server-id=5908 port=3309 socket=/tmp/mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql…thread_cache_size=40 table_cache=512 # Default 64 was used before. skip-locking innodb_data_…
Comment: What to tune in MySQL Server after installation
October 8, 2012 By 118 Comments
… 80 GB SSD MLC CentOS 5 x 64 bits RAID-5 HW In this server is installing MySql 5.5.21 and the sorftware… = 12M read_buffer_size = 4M [Server] server-id = 1 log-bin=/data/mysql/drbd [Server] server-id = 1 log-bin=/data/mysql/drbd expire_logs_days = 5 max_binlog_size = 100M [client] socket=/data/mysql/mysql.sock [Server] server-id = 1…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
…6.0: +—-+————-+———-+——-+—————+—————+———+——+———+———————————————–+ | id | select_type | table | type |…server. This is because of Random I/O we had during execution of query, as MySQL…is a bit different. At…24.64 66273…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… access to modern multiCPU servers, without them I … (`id`), UNIQUE KEY `email` (`email`), KEY `country_id` (`country_id`,`state_id`,`city… of RAM MySQL version We used MySQL 5.1.16-…bit better. Unfortunately InnoDB shows bad scalability for 8CPU box, in many cases the transition from 16 threads to 64…
