… the MySQL world, except maybe MyISAM files on top of a clustered filesystem with an external lock manager. You might say that MySQL…: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I… to get the server up with –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…Innodb_row_lock_current_waitsblogpercona.commanual Innodb_row_lock_timeblogpercona.commanual Innodb_row_lock_time_avgblogpercona.commanual Innodb_row_lock_time_maxblogpercona.commanual Innodb_row_lock_waitsblogpercona.commanual Innodb…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…skip-locking innodb_data_home_dir=/db/disk2/data innodb_data_file_path=ibdata1:10240M;ibdata2:10240M;ibdata3:10240M;ibdata4:10240M;ibdata5:10M:autoextend innodb_log_group_home_dir=/var/log/mysql innodb_log_arch_dir=/var/log/mysql innodb_table_locks=0 innodb_buffer_pool_…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…innodb_locks_unsafe_for_binlog=1 innodb_autoinc_lock_mode=2 innodb_buffer_pool_size=400M innodb…: wsrep_notify_cmd is not defined, skipping notification. 120619 13:20:19 [Note]…mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
… physical, 48 bits virtual power management: I tested MySQL-5.1.30 with InnoDB plugin, Xtradb-1.0.2-1, and XtraDB… max_prepared_stmt_count=1000000 query_cache_size=0 skip_grant_tables skip_locking sort_buffer_size=64K table_cache=2048 thread_cache… InnoDB-plugin is dropping down. XtraDB and XtraDB-rel2 seem quite better, I guess this is mostly because fixes to rw_locks…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
…InnoDB: position 0 115, file name portland-bin.001717 All you needed to do is to use –skip… as expected. Innodb during recovery also prints position in the MySQL binary log: InnoDB: Last MySQL binlog file … recommended way with FLUSH TABLES WITH READ LOCK for snapshot creation. This happens when you …
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…MySQL crash recovery, and it can be reduced even further. More on this later. Free No extra commercial tools as Innodb… catch here is FLUSH TABLES WITH READ LOCK actually waits for all statements to complete, … – especially if you use slave_skip_errors or sql_slave_skip_counter. Cloning master you’re…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
… it online, no needs to lock or shutdown server. To export table…skipped. Copying ./tpcc/orders.ibd is skipped. Copying ./tpcc/item.ibd is skipped. Copying ./tpcc/customer.ibd is skipped. Copying ./tpcc/history.ibd is skipped… directory /data/vadim/mysql/export/tpcc. ibd is regular InnoDB ® file, and …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… –datadir=/var/db/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock consult 28852… might find that there are InnoDB tables whose .frm files exist but have been dropped from InnoDB, for example. (The INFORMATION_SCHEMA…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… specific programs # The MySQL server [mysqld] port = 3306 socket = /tmp/mysql.sock bind-address=10.234.94.71 skip-locking key_buffer_size = 2000M…local/mysql/data/ #innodb_log_arch_dir = /usr/local/mysql/data/ innodb_data_home_dir = /db innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group…
