… statistics per client’s hostname, not per user FLUSH USER_ and CLIENT_STATISTICS commands Our port includes: INFORMATION_SCHEMA tables – USER_STATISTICS, CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS Access protection – USER_STATISTICS, CLIENT_STATISTICS available only for user with…
Comment: Percona Server and Percona XtraBackup
August 3, 2008 By 25 Comments
using userstats patch, is it somehow possible to flush user_statistics? there is FLUSH TABLE_STATISTICS; FLUSH INDEX_STATISTICS but not something like FLUSH USER_STATISTICS
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
… new set of commands such as SHOW TABLE_STATISTICS, SHOW INDEX_STATISTICS and SHOW USER_STATISTICS. The first two can interest anyone to periodically….00 sec) The statistics for tables and indexes can be cleaned with the corresponding FLUSH command (e.g. FLUSH INDEX_STATISTICS). All that can…
Post: New patches, new builds
September 5, 2008 By 24 Comments
…patch to control insert buffer and flushing | 1.0 | Yasufumi Kinoshita | BSD | | | mysqld…USER_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS to INFORMATION_SCHEMA mysql> select * from information_schema.table_statistics; +————————-+———–+————–+———————-+ |…
Post: The perils of InnoDB with Debian and startup scripts
January 28, 2009 By 13 Comments
…set innodb_flush_method=O…user | statistics | select … | 6344 | user | | NULL | 6345 | user | Updating | update … | 6346 | user | Sorting result | insert … | 6351 | user | | NULL | 6355 | user | | NULL | 6356 | user | statistics | select … | 6357 | user | statistics | select … | 6358 | user…
Post: MySQL Binaries Percona build10
December 11, 2008 By 12 Comments
… potential logging and statistics overhead, so now you can fully turn on / off query statistics for microslow patch and user statistics in runtime. Next… | GPL | This patch contains fixed (control_flush_and_merge_and_read, control_io-threads, adaptive_flush) | | innodb_show_hashed_memory.patch | Adds…
Comment: MySQL extensions for hosting
April 24, 2008 By 11 Comments
… statistics). I may be biased, but I could not do without this feature. It makes it very easy to determine which users… over time. Once a load problem is isolated to one user, statement sampling can be used to determine the statements that… a column for IO per user to SHOW USER_STATISTICS. I think that the patch left out FLUSH TABLE_STATISTICS, but that will be in…
Post: Percona build7 with latest patches
November 14, 2008 By 26 Comments
…_scan_* | | userstatsv2.patch | SHOW USER/TABLE/INDEX statistics | V2 | Google | GPL | Added INFORMATION_SCHEMA.*_STATISTICS | | show_patches.patch | SHOW PATCHES … | This patch contains fixed (control_flush_and_merge_and_read, control_io-threads, adaptive_flush) | | innodb_show_hashed_memory.patch …
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
…) innodb_ibuf_active_contract = 1 innodb_adaptive_flushing = false innodb_adaptive_checkpoint = estimate
Comment: Slow Query Log analyzes tools
June 10, 2008 By 83 Comments
…, but didn’t give the mysql user write permision to it. I then used mysqladmin to flush all the logs, and when…/sed/sort/uniq liberally. # my $DBHOST=”slush”; my %passwords = ( “user” => “pass”, “reporting” => “reporting”, “user-no-pw” => “”, “etc” => “etc” ); # skip the first 3… type line if(s/^\s+([0-9]+) ((Query)|(Quit)|(Connect)|(Statistics)|(Binlog Dump Log))//) { # If we enter this loop, it means…
