…binlog-ignore-db commands. This is there a lot of people stop reading documentation, specify databases they … pre MySQL 5.0 way to break such replication is also using multi-table update or delete statements… have several group of slaves which need different data sets replicated to them – you can use …
Post: Recovering CREATE TABLE statement from .frm file
December 17, 2008 By 5 Comments
… copy .frm file back to the database we will see the following MySQL creative error message: mysql> show tables; +—————-+ | Tables_in_test | +—————-+ | queue… data files but have forgotten to delete the corresponding .frm files of InnoDB tables, or you have moved .frm files to another database… to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 17 Server version: 5.1.30-community-log MySQL Community…
Post: Logging Foreign Key errors
September 27, 2012 By Leave a Comment
… the first columns, or the data types in the referenced table …DELETE CASCADE The index in the foreign key in table is “PRIMARY” See http://dev.mysql… KEY. So, the command that causes the error was: mysql> ALTER TABLE employees DROP…the last error happened on the databases is not enough information to …
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
…which is quite helpful for MySQL Performance optimization tasks but…commands or stored procedure calls are not, even if stored procedure would simply preform select to retrieve data… see different states of the database, depending on the updates… by (Com_insert+Com_delete+Com_update+Com_replace)/Qcache…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
…connections to MySQL, which often happens when several transactions kill the database performance …innodb_status.
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…this info to improve MySQL Performance. To start with basics SHOW INNODB STATUS is command which prints …parent` (`id`) ON DELETE CASCADE Trying to add in child table, in index `par_ind` tuple: DATA TUPLE: 2… Buffer pool size 262144 Free buffers 0 Database pages 258053 Modified db pages 37491 Pending …
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…mysql -S /tmp/mysql-ib.sock -e “LOAD DATA INFILE ‘/data…database=ontime -t -s “COPY 700000 records INTO ontime FROM ‘/data…data. LucidDB Here it took time to find how to execute command from command…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…create_table’, ’2661′ ‘Com_show_databases‘, ’93′ ‘Com_show_errors’, ’0′…Delayed_writes’, ’0′ ‘Flush_commands‘, ’5′ ‘Handler_commit’, ’19092941′ ‘Handler_delete‘, ’0′ ‘…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: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
…or indexes, changing data type, converting data to different character set – MySQL master-…,col1,col2,..) VALUES (id,value1,value2,..)”), deletes or updates of rows … mysql -u root db < changes.sql At this step we load sql commands…method depending on your overall database size, scope of changes, and…
