…-per-table –target-dir=/mnt/mysql/export/ –tables=data # xtrabackup_55 –prepare –export –innodb-file-per-table –target-dir=/mnt/mysql/export ALTER TABLE… extended import of data is being started. InnoDB: Import: 9 indexes have been detected. InnoDB: Progress in %: 1 2 3 4… but not the InnoDB log files. See InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
I am constantly referring to the amazing MySQL manual, especially the option and variable reference table. But just …
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
… resize_inode dir_index filetype needs_recovery extent 64bit flex_bg spars e_super large_file huge_file uninit_bg dir_nlink extra… is probably not needed for partition you store MySQL data on, as chances are MySQL server is only one doing writes on… as needed, same as you would every so often check MySQL tables for corruption. To change those options you can run…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
… 100 1000 10000; do ./benchmark.php $i 10000000; mysql -e’drop database test1′; mysql -e’create database test1′; done; tables: 1; total… later contrary to my expectation this filesystem was created without dir_index option which should add significant overhead for insert with many… 100 1000 10000; do ./benchmark.php $i 10000000; mysql -e’drop database test1′; mysql -e’create database test1′; done; tables: 1; total…
Post: Air traffic queries in InfiniDB: early alpha
November 2, 2009 By 19 Comments
…dir/000.dir/003.dir/233.dir ./000.dir/000.dir/003.dir/233.dir/000.dir ./000.dir/000.dir/003.dir/233.dir/000.dir/FILE000.cdf ./000.dir/000.dir/003.dir/241.dir ./000.dir…_length: 0 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto…table at the bottom) Query Q1: mysql> SELECT DayOfWeek, count(*) AS c …
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
… required for replication log-bin=db1-bin log-bin-index=db1-bin.index binlog-ignore-db=chrome_vin binlog-ignore-db=dummyData…_home_dir = /usr/local/mysql/data/ #innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend #innodb_log_group_home_dir = /usr/local/mysql/data/ #innodb_log_arch_dir = /usr/local/mysql/data/ innodb_data_home_dir = /db innodb_data_file…
Post: Copying InnoDB tables between servers
July 31, 2009 By 10 Comments
…/my.reg.cnf –backup –tables=tpcc.order_line* –target-dir=/data/vadim/mysql/export/ xtrabackup: tables regcomp(): Success xtrabackup Ver 0.8…/my.reg.cnf –prepare –export –use-memory=8G –target-dir=/data/vadim/mysql/export/ xtrabackup Ver 0.8.1rc Rev 78 for… import of testexport/order_line is started. InnoDB: import: 2 indexes are detected. InnoDB: Progress in %: 1 2 3 4 5…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…’ ‘Com_create_db’, ’0′ ‘Com_create_function’, ’0′ ‘Com_create_index‘, ’0′ ‘Com_create_table’, ’31′ ‘Com_dealloc_sql’, ’0′ ‘Com…/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…;ibdata5:10M:autoextend innodb_log_group_home_dir=/var/log/mysql innodb_log_arch_dir=/var/log/mysql innodb_table_locks=0 innodb_buffer…
Comment: Full text search for all MySQL Storage Engines
June 29, 2006 By 37 Comments
…. Vadim: Darn, what are the odds that mysql will use sphinx as its native fulltext index instead of todays version/edition ? 15… matches): — PROFILE — root: 12.86, self: 0.00 query_load_dir: 0.01, self: 0.00 read_hits: 0.01 query… several seconds while TBGsearch takes a few milliseconds. The sphinx index takes 648 MB spd-file and 3.09 MB spi…
Post: Lost innodb tables, xfs and binary grep
November 9, 2010 By 11 Comments
… about the system and how data was lost: MySQL had a dedicated partition on XFS file system…by just mapping data dictionary table records to index records. Instead I had to grep for specific…s binary representation 0x31EB1F9C and ran “bgrep 31EB1F9C /dir” – there were only like 10 other matches across…
