…’ ‘Com_show_ndb_status’, ’0′ ‘Com_show_new_master’, ’0′ ‘Com_show_open_tables’, ’0…’, ’895966639′ ‘Table_locks_waited’, ’20096′ ‘Threads_cached’, ’0′ ‘Threads_connected’, ’260′ ‘Threads_created‘, ’124272′ ‘Threads_running’, ’3′ ‘Uptime’, ’4433556′….00 168 0 cciss/c0d0p5 0.12 0.11 1.14 1650506 17248664…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… slave’s SQL thread. This patch allows you to change that behavior with the new parameter –log-slow-… will be set. Sometimes that table must be created on disk instead of in memory, in such …20:03:16 # User@Host: macko[macko] @ localhost [] # Thread_id: 12 # Query_time: 0.026385 Lock_time: 0.000158…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…logging atomically, not just for new connections as in MySQL. This…11:26 # User@Host: msandbox[msandbox] @ localhost [] # Thread_id: 1 Schema: test Last_errno: …-query-digest. # Query 4: 0.12 QPS, 0.00x concurrency, ID … LIKE ‘wp_term_relationships’\G # SHOW CREATE TABLE `wp_blog_one `.`wp_term_…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…thread (srv0srv.c:1671) ==9090== by 0x4C29C90: mythread_wrapper (hg_intercepts.c:221) ==9090== by 0x4E37EFB: start_thread (pthread_create…== by 0x6B68496: log_write_up_to.part.12 (log0log.c:1472) ==9090== by 0x6B0E0E9: … races, and here we see a new kind of error: lock order violation, …
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 Comments
…. Example: mysql> create trigger Copy_data AFTER INSERT on t FOR EACH ROW INSERT INTO t_copy VALUE(NEW.i); mysql> insert… it gets replicated on the slave: CREATE DEFINER=`msandbox`@`localhost` EVENT `year` ON SCHEDULE AT ’2011-12-14 22:03:06′ ON…:54:06 server id 1 end_log_pos 319 Query thread_id=12 exec_time=0 SET TIMESTAMP=1323896046/*!*/; insert into y…
Post: Percona Testing: Innodb crash / recovery tests available
December 21, 2011 By Leave a Comment
… reasons: My attempts at copying the Facebook multi-threaded python load-generation code seemed very, very slow …: Error in sourced command file: No registers. # 2011-12-21T14:25:03 “kewpie/randgen/” is not a … a run, you can try the new option –test-debug. I created this option as many tests might …
Post: Copying InnoDB tables between servers
July 31, 2009 By 10 Comments
….ibd is skipped. Copying ./tpcc/new_orders.ibd is skipped. …(3 845737724) xtrabackup: Stopping log copying thread. xtrabackup: Transaction log of lsn (…number 3 845737724 (99 %) InnoDB: 12 transaction(s) which must… old servers: CREATE DATABASE “testimport”; USE “testimport” CREATE TABLE `order_line` (…
Post: Debugging problems with row based replication
May 6, 2010 By 10 Comments
…MySQL master database and populate it with some data. CREATE TABLE `t1` ( `c1` int(11) NOT NULL AUTO_INCREMENT,… MySQL 5.1 ships with a new version of mysqlbinlog that includes new options that make decoding RBR statements … 12:42:56 server id 1 end_log_pos 340637       Query  thread_id…
Post: Dynamic row format for MEMORY tables
September 6, 2011 By 3 Comments
…points to keep in mind when using this new feature (and these points are probably the reason…-length records too. Default sysbench 0.4.12 schema, one client thread: Fixed-row format (FRF, Percona Server… the default sysbench schema to be the following: CREATE TABLE sbtest (id INT(10) UNSIGNED NOT NULL…
