… the MySQL manual. You can configure the slave to only replicate a specific database, a set of databases, or specific tables; you… the MySQL world, except maybe MyISAM files on top of a clustered filesystem with an external lock manager. You might say that MySQL… to get the server up with –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run a…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…table_definition_cacheblogpercona.commanual table_lock_wait_timeoutblogpercona.commanual Table_locks_immediateblogpercona.commanual Table_locks_waitedblogpercona.commanual table_open_cacheblogpercona.commanual table…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
…table or table by mask: xtrabackup –defaults-file=/etc/my.reg.cnf –backup –tables=tpcc.order_line* –target-dir=/data/vadim/mysql/export/ xtrabackup: tables…
Post: Resyncing table on MySQL Slave
June 29, 2008 By 11 Comments
… your table schema does not change you can do something like this on the master: LOCK TABLE tbl WRITE; SELECT * FROM table INTO OUTFILE… you can’t rename locked tables (ERROR 1192 (HY000): Can’t execute the given command because you have active locked tables or an active…’ into table rep_new; Query OK, 0 rows affected (0.01 sec) Records: 0 Deleted: 0 Skipped: 0 Warnings: 0 mysql> rename table rep…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
… “Query Cache” which is quite helpful for MySQL Performance optimization tasks but there are number …locking table for write would not invalidate query cache so you can get results even if table is locked… proceeds with query lookup in cache if not – skips it. Does not support prepared statements and …
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
… into two bugs: MySQL 5.6.7 locks itself on CREATE INDEX MySQL 5.6.7-rc crashed under tpcc-mysql workload But at… adaptive flushing still requires big log files. MySQL configuration: [mysqld] gdb innodb_file_per_table = true innodb_data_file_path = ibdata1:100M…_size = 10G myisam_repair_threads = 1 myisam_recover user=root skip-grant-tables
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…-write snapshot is you can actually start MySQL Server on it and perform recovery, check tables or do whatever else you might… backup of MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL and run FLUSH TABLES WITH READ LOCK Note – this… could have accomulated – especially if you use slave_skip_errors or sql_slave_skip_counter. Cloning master you’re starting from consistent…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…
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 max_allowed_packet = 32M # table_cache=20M # open…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…A table (or entire schema) was dropped accidentally Your InnoDB table was corrupt and mysql…lock times here when non-transactional tables are used Almost no locking, if not using myisam tables Built in compression Each table… the current charset mysqldump … -d -R –skip-triggers, out to the schema …
