… Server version: 5.1.55-rel12.6-log Percona Server (GPL), 12.6, Revision 200 the “innodb_scan%” status variables do not exist, but in Server version: 5.0.92-50-log Percona…
Comment: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
… may be use a feature available in Percona Server http://www.percona.com/doc/percona-server/5.5/scalability/innodb_io_55.html#innodb_checkpoint_age_target. To me LRU_list to flush_list ratio of 3:1…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…. If you’re running Percona Server you can get the value from User Statistics *************************** 1. row *************************** USER:user TOTAL_CONNECTIONS: 1 CONCURRENT_CONNECTIONS: 0… is because IO handling requires significant number of CPU. With Percona Server, enabled full query logging and log_slow_verbosity=full you… 0.99 # Bytes sent 8.77G 11 55.41M 5.15k 3.88k 258.55k 1.46k # Merge passes 0 0 0 0…
Comment: NO Security vulnerability in Percona Server / XtraDB Cluster provided binaries
June 12, 2012 By 13 Comments
… this on my server running percona 5.5-20-55 on oneiric, installed from deb files, and got in: $ for i in `seq 1 1000`; do… \g. Your MySQL connection id is 7487309 Server version: 5.5.20-55-log Percona Server (GPL), Release 24.1 Copyright (c) 2000, 2011, Oracle and/or…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
… mysql-data-201202230157 sb swi-a- 5.00g mysql-data 0.00 mysql-logs… #120223 1:59:55 server id 1 end_log_pos 336797275 Query thread_id=47 exec_time=1…/etc/init.d/mysql start Starting MySQL (Percona Server) [ OK ] You should shutdown MySQL first…
Post: Impossible - possible, moving InnoDB tables between servers
June 8, 2009 By 9 Comments
…expand_import=1 setting) 4) run alter table IMPORTEDTABLE discard tablespace; 5) copy .exp and .ibd files to destination server 6… 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 … Some more information available on http://www.percona.com/docs/wiki/percona-xtradb:patch:innodb_expand_import If you …
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… correct in how to properly build the server to use it (bug 61587). We at Percona regularly use Memcheck for our development…-helgrind-55.patch Now let’s see what kind of goodies does Helgrind find on MySQL server. Let’s take a recent 5.1 bzr version (pre-5.1.61) and a single test, innodb…
Post: Innodb Table Locks
July 31, 2012 By 4 Comments
… LOCKS space id 84 page no 55 n bits 1272 index `k` of table … about locks held (feature available in Percona Server) we can see the table is locked …sec fetching rows mysql tables in use 1, locked 1 9417 lock struct(s), heap … table level lock (mostly with MySQL 5.0 and older MySQL versions). MySQL …
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… to handle the write workload. Since we’re running Percona‘s patched server, we can actually measure what’s in the buffer….55 4.09 6.29 site.user_achievements 1.36 1.20 0.35 site.clicks 1.26 3.05 5.13 site.actions_finished 1… if you just put a replication workload on the server, that falls to 1.32G. Other tables are similar. The mixed workload…
