…the same hardware just running PostgreSQL instead of MySQL or having Sun box replaced with comparable Dell or HP box. Unfortunately such …= 1 innodb_data_home_dir = /data/mysql/var innodb_data_file_path = ibdata1:10000M:autoextend innodb_file_per_table innodb_log_group_home_dir = /log/mysql/var/ …
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…://10.116.39.76 # replace this with the IP of your first…:21:18 InnoDB: highest supported file format is Barracuda. 120619 13:…table with data for the benchmark. # sysbench –test=oltp –db-driver=mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql…
Post: table_cache negative scalability
November 16, 2009 By 23 Comments
…table replacement in table cache based on LRU logic. MySQL Sandbox helped me to test this with…table is opened. In this case the performance was so great because all 100.000 tables data…
Post: Debugging problems with row based replication
May 6, 2010 By 12 Comments
…lets create a test table on a MySQL master database and populate it with some data. CREATE TABLE `t1` ( `c1`… log file: mysql_sandbox25162-relay-bin.000002 at position: 340718. MySQL 5.1 ships with a …This omits any base64 output and instead replaces the output with semi-valid SQL statements. I …
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 10 Comments
…-file-per-table –target-dir=/mnt/mysql/export/ –tables=data # xtrabackup_55 –prepare –export –innodb-file-per-table –target-dir=/mnt/mysql/export ALTER TABLE data DISCARD TABLESPACE; # replace ibd with the export files…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table max_connections=2000 table_cache=2000 Percona Server 5.1 Results For better presentation let’s also slice this data… and by no means a replacement to proper future 5.6 tuning. MySQL 5.6.2 Results With Purge Sleeps Removed I’ve…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
… disk tables and HEAP for in memory tables. So first MySQL versions did not bother naming variables with … file” in this case it does not do fsync() or anything like it to make sure data …tables. key_cache_age_threshold, key_cache_block_size, key_cache_division_limit Key Cache/Key Buffer replacement…
Post: Living with backups
November 6, 2008 By 28 Comments
… all MySQL tables into a text file or ordinarily copies the binary files from the data directory …flushing the data out of the cache. It happens by replacing old and unused blocks with …MySQL data files do not comply with this requirement. The trick could be used here perhaps to read the file with…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…) System copes fine with these figures. Queries/sec…table‘, ’0′ ‘Com_repair’, ’0′ ‘Com_replace‘, ’20801587′ ‘Com_replace_select’, ’0′ ‘Com_reset’, ’0′ ‘Com_restore_table…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…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
…file may be open or closed. Furthermore besides MySQL table_cache Innodb maintains its own (called data dictionary) which keeps all tables ever accessed since table…with table_open_cache=64 and tried innodb_open_files=64 and 16384. Reading 100.000 tables first time after MySQL…for replacing open files…
