… and want to announce new builds for 5.0.62, 5.0.67 and 5.1.26 versions. One of biggest changes … | 1.0 | Yasufumi Kinoshita | BSD | | | userstats.patch | SHOW USER/TABLE/INDEX statistics | 1.0 | Google | GPL | Added INFORMATION_SCHEMA.*_STATISTICS | | show_patches.patch | SHOW PATCHES | 1.0 | …
Post: MySQL Binaries Percona build10
December 11, 2008 By 12 Comments
… for compatibility with MySQL 5.1 and | userstat_running | OFF | to control gathering of user statistics. With both slow_query…| | userstatsv2.patch | SHOW USER/TABLE/INDEX statistics | V2 | Google | GPL | Added INFORMATION_SCHEMA.*_STATISTICS | | show_patches.patch | SHOW PATCHES | 1.0 | Jeremy Cole…
Post: Checking for a live database connection considered harmful
May 5, 2010 By 38 Comments
… the ‘ping’ or ‘statistics‘ command at the MySQL protocol level, which will increment Com_admin_commands in SHOW GLOBAL STATUS, or a… R/Call Item # ==== ================== ================ ====== ======== =============== # 1 0x5E796D5A4A7D1CA9 10651.0708 73.1% 120487 0.0884 ADMIN STATISTICS # 2 0x85FFF5AA78E5FF6A 1090.0772 7.5% 23621 0.0461 BEGIN… UPDATE user_datas # 5 0x813031B8BBC3B329 822.0041 5.6% 23299 0.0353 COMMIT # 6 0xA873BBC4583C4C85 278.4533 1.9% 6985 0.0399 SELECT users user_devices…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…1 and run following query: mysql> select * from information_schema.user_statistics where user=”#mysql_system#” \G *************************** 1. row *************************** USER: #mysql_system# TOTAL_CONNECTIONS: 1… replication capacity on 5 minute intervals (or…they will show number close to 1. …
Post: Percona build7 with latest patches
November 14, 2008 By 26 Comments
We made new binaries for MySQL 5.0.67 build 7 which include patches we recently announced. … Innodb_scan_* | | userstatsv2.patch | SHOW USER/TABLE/INDEX statistics | V2 | Google | GPL | Added INFORMATION_SCHEMA.*_STATISTICS | | show_patches.patch | SHOW PATCHES | 1.0 | Jeremy Cole | N/A…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… the official database distribution starting 5.1.21 release. Below you will …select.cc patching file sql/sql_show.cc patching file sql/structs….to become root user, unless you are already (garfield:~/work/mysql-5.0.51a) %…plan details and InnoDB engine per-query statistics. With this option you may …
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…, which showed MySQL 5.6.10 to be much slower than MySQL 5.5.30 … Star Schema Benchmark – Scale Factor 1 – Mysql 5.5 vs 5.6 response times are in…p2.duration, p1.cpu_user + p1.cpu_system p1_cpu, p2.cpu_user + p2.cpu…| 0 | 0 | 0 | 0 | 29 | 29 | | 9 | statistics | 0.000130 | 0.000097 | 0.000000 | 0….
Post: Percona builds with Percona patchsets
July 16, 2008 By 35 Comments
… slow log) InnoDB statistic (show extended InnoDB usage during query execution in slow log) Google’s patches with user statistics, and statistics about tables and…, taken from http://mirror.provenscaling.com/mysql/enterprise/source/5.0/) and 5.1.26-rc release, and they are currently available only…
Post: Beware the Innodb Table Monitor
November 29, 2011 By 2 Comments
… the system, but also there were over a hundred user queries in SHOW PROCESSLIST that were stuck in the ‘Opening Tables’ state… looks like dict_update_statistics is called twice for each table, at least in the latest Percona Server 5.1 in: storage/innodb…, the io-wait spike is explained by table statistics being regenerated, and the SHOW PROCESSLIST connections stuck in ‘Opening Tables’ were waiting…
Post: Percona-XtraDB-9.1: released and new coming features
March 17, 2010 By 14 Comments
… features from 5.0: extended slow.log USER/TABLE/INDEX/CLIENT_STATISTICS + THREAD_STATISTICS ( coming in …# Bytes_sent: 4973 Tmp_tables: 1 Tmp_disk_tables: 1 Tmp_table_sizes: 7808 That… of buffer_pool Transactional replication Show internal InnoDB data dictionary Show InnoDB locking/io profiling…
