… install PS 5.5 alongside packages that depend on 5.1/5.0, the -shared packages will work together. For example installing…:2.3.3-6.el5 base 3.8 M Installing for dependencies: Percona-SQL-shared-50 x86_64 5.0.92-b23…_64 5.5.29-rel29.4.402.rhel5 percona-testing 9.1 M Percona-Server-shared-55 x86_64 5.5.29…
Post: Gathering queries from a server with Maatkit and tcpdump
July 1, 2009 By 23 Comments
… Calls R/Call Item # ==== ================== ================ ======= ========== ==== # 1 0x088084BF139954D8 0.1009 90.2% 1 0.100881 SELECT dual # 2 0x261703E684370D2C 0.0110 9.8% 1 0.011017 I’m kind of…: 8 total, 6 unique, 0.15 QPS, 0.00x concurrency ________________ # total min max avg 95% stddev median # Exec time 114ms 0 101ms 14ms 100ms….83 9.76 26.08 # Errors 8 # Rows affe 0 0 0 0 0 0 0 # Warning c 0 0 0 0 0 0 0 # 0% No_good_index_used # 12% No_index_used # Query 1: 0 QPS…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… means replication capacity is 446/74 = 6 You normally would not like to…1.94M 0 9.42k 1.67 0 110.38 0 # Killed 0 0 0 0 0 0 0 # Last errn 34.11M 0 1.55k 29.26 0 185.83 0 # Merge pas 0 0 0 0 0 0 0…0 1 0.00 0 0.06 0 # Tmp table 14.19k 0 2 0.01 0 0.14 0 # Tmp table 8.30G 0 2.01M 7.12k 0 117.75k 0 # 0…
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 8 Comments
… 22105 0.80 100 11704 11741 1.00 10956 0.94 We see here that logging all queries decreases MySQL’s performance on 6… > 1 sec, NOTPM Ratio no_logging / 1 sec_logging Logging all, NOTPM Ratio no_logging / all_logging 1 225 ± 9 211 ± 3 0.94 213 ± 9 0.95 20 767 ± 41 730 ± 35 0.95 751 ± 33 0…
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
… XtraBackup 2.0! We call this version 1.9.1 as we are using the 1.9.x version numbers for betas of 2.0 to clearly differentiate beta releases from the final 2.0 release. We… production use, check out our latest stable release (which was 1.6.5 at the time of writing). This beta adds some…
Post: Statistics of InnoDB tables and indexes available in xtrabackup
September 14, 2009 By 6 Comments
…`mod_is` tinyint(3) unsigned NOT NULL default ‘0‘, `is_adult` tinyint(3) unsigned …2% level 2 pages: pages=6, data=58143 bytes, data/pages=59% level 1 pages: pages=832, …9 estimated statistics in dictionary: key vals: 25964521, leaf pages 27979, size pages 28160 real statistics: level 2 pages: pages=1…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
…0.45 on 32bit Fedora Core 6…0 0 2 2023 1518 498 5 2 10 83 0 1 3 116 56316 9104 549228 0 0 0 2121 1539 497 0 1 24 75 0…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… `country_id` smallint(5) unsigned NOT NULL default ‘0‘, PRIMARY KEY (`id`), UNIQUE KEY `email` (`email`), KEY…back_log=128 Method of benchmark: 1. Prepare table with 1,000,000 records (about 350Mb of …primary key. InnoDB is faster than MyISAM by 6-9%. Falcon shows very bad scalabilty. READ_KEY_POINT…
Post: Analyzing Slow Query Table in MySQL 5.6
February 18, 2013 By 1 Comment
…”] Analyzing SQL Queries with Percona Toolkit, Feb. 25-28, 9-11 a.m. PST[/caption] Next week I’m…server. I read the logging code in MySQL 5.6.10 source, in file sql/log.cc. I discovered …, meaning any query that executes in less than 1.0 seconds counts as 0 seconds. This will skew your average query…
Post: XtraDB feature: save / restore buffer pool
January 20, 2010 By 20 Comments
We recently released XtraDB-9, and while we did not highlight it in announcement, the … in our Launchpad branch lp:~percona-dev/percona-xtradb/extensions-1.0.6 I made small tpcc benchmark to show effect with restored… are welcome to test it, it is available in XtraDB-9 release and also in MariaDB 5.1.41-RC.
