…New Features: Percona Server for MySQL has implemented priority connection scheduling for the Thread …the upstream bug #63144. CREATE TABLE or CREATE TABLE IF NOT …ac was incompatible with automake 1.12. Bug fixed #1099387 (Alexey Bychko… back from the upstream MySQL 5.6 the fix for unnecessary log…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…New Features: Percona Server for MySQL has implemented priority connection scheduling for the Thread…the upstream bug #63144. CREATE TABLE or CREATE TABLE IF NOT …ac was incompatible with automake 1.12. Bug fixed #1099387 (Alexey Bychko… back from the upstream MySQL 5.6 the fix for unnecessary log…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…’ ‘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′ … 69.5% cpu03 12.7% 0.0% 6.7% 0.0% 0.0% 6.7% 73.7%…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 4 Comments
…. Example: mysql> create trigger Copy_data AFTER INSERT on t FOR EACH ROW INSERT INTO t_copy VALUE(NEW.i); mysql> insert…:33:41 server id 1 end_log_pos 2055 Query thread_id=6 exec_time=0 error_code=0 SET TIMESTAMP=1323815621… Intvar SET INSERT_ID=6/*!*/; #111214 21:54:06 server id 1 end_log_pos 319 Query thread_id=12 exec_time=0…
Post: Debugging problems with row based replication
May 6, 2010 By 12 Comments
…master database and populate it with some data. CREATE TABLE `t1` ( `c1` int(11) NOT NULL AUTO… 5.1 ships with a new version of mysqlbinlog that includes new options that make decoding RBR statements… at 340718 #100506 12:42:56 server id 1 end_log_pos 340637 Query thread_id=6 exec_time=0…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…atomically, not just for new connections as in MySQL…26 # User@Host: msandbox[msandbox] @ localhost [] # Thread_id: 1 Schema: test Last_errno…19 0x5DE709416871BF99 0.0454 0.6% 260 0.0002 …-digest. # Query 4: 0.12 QPS, 0.00x concurrency, … ‘wp_term_relationships’\G # SHOW CREATE TABLE `wp_blog_one `.`wp_…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
…/warehouse.ibd is skipped. Copying ./tpcc/new_orders.ibd is skipped. Copying …to (3 845737724) xtrabackup: Stopping log copying thread. xtrabackup: Transaction log of lsn (3 … on old servers: CREATE DATABASE “testimport”; USE “testimport” CREATE TABLE `order_line` ( `…2 3 4 5 6 7 8 9 10 11 12 13 14 15…
Post: Logging Deadlock errors
September 19, 2012 By 4 Comments
…New york2′ where name=’New York’ *************************** 2. row *************************** server: 127.0.0.1 ts: 2012-09-17 12:13:36 thread…
Post: Binary log file size matters (sometimes)
May 24, 2012 By 6 Comments
…new binary log is created…Threads_running | 2 | | Threads_running | 2 | | Threads_running | 3 | | Threads_running | 5 | | Threads_running | 4 | | Threads_running | 3 | | Threads_running | 2 | | Threads_running | 3 | | Threads_running | 108 | | Threads_running | 174 | | Threads…
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
…0 milestone at Launchpad. New Features: Ported the Thread Pool patch from … 12.04 server. Bug fixed #1103655 (Ignacio Nin). The master thread…compatible with innodb_force_recovery=6. When starting the server log… fixed #1083596 (Laurynas Biveinis). Newly created bitmap file would silently overwrite…
