… system Why snapshot based MySQL backups are great ? There are…storage engines It works with MyISAM and Innodb and BDB, It also should work with Solid, PrimeXT and Falcon storage engines…000335″, master_log_pos=401934686; 12) Run SLAVE START to … if you use slave_skip_errors or sql_slave_skip_counter…
Post: Beware the Innodb Table Monitor
November 29, 2011 By 2 Comments
…CREATE TABLE innodb_table_monitor (a INT) ENGINE=INNODB; This, primitively, tells Innodb …dictionary to the mysql error log, which looks something like this: =========================================== 090420 12:09:32…in: storage/innodb_plugin/dict/dict0load.c: line 226, and again in: storage/innodb…
Post: Feature in details: Incremental state transfer after a node crash in Percona XtraDB Cluster
January 31, 2013 By 2 Comments
…data/mysql 130129 23:01:22 mysqld_safe WSREP: Running position recovery with –log_error=/…storage engines, skipping position init 130129 23:01:45 [Note] WSREP: wsrep_load(): loading provider library ‘/usr/local/mysql…catch up, the node has to recieve 12 events, which succesfully happen there: 130129 …
Post: Percona Server 5.1.49-rel12.0
September 15, 2010 By 6 Comments
….1.49-12.0 RC contains a couple of patches from the Facebook-MySQL tree – …based on MySQL 5.1.49. New features added: error_pad – Implements error code compatibilities with MySQL 5…. (Oleg Tsarev, backport from MySQL 5.5) show_engines – Changes SHOW STORAGE ENGINES to report XtraDB when appropriate. (…
Post: NDB API examples, the trivia to make ndbapi_scan works!
November 15, 2009 By 4 Comments
…storage/ndb/ndbapi-examples/ndbapi_scan$ LD_LIBRARY_PATH=/usr/local/mysql-cluster-gpl-7.0.8a/lib/mysql ./ndbapi_scan /usr/local/mysql… ” ENGINE=NDB”)) { if (mysql_errno(&mysql) != ER_TABLE_EXISTS_ERROR) MYSQLERROR(mysql); std::cout << "MySQL … and printing…0 Mercedes Blue 12 Toyota Pink 5 BMW…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…’, ’13834′ ‘Com_show_status’, ’194766′ ‘Com_show_storage_engines‘, ’0′ ‘Com_show_tables’, ’2842′ ‘Com_show_variables’, … 0.00 168 0 cciss/c0d0p5 0.12 0.11 1.14 1650506 17248664 cciss…mysql/log log-slow-queries=/var/log/mysql/slow-queries.log max_connections=650 open_files_limit=6144 max_connect_errors…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
… to log sequence number 3 845737724 (99 %) InnoDB: 12 transaction(s) which must be rolled back or…Now on remote server you have to run MySQL server ® with XtraDB6 storage engine, you can take one of our…and you can see progress of import in error.log InnoDB: import: extended import of testexport/order…
