… an example, take a look at this bug report (not a bug). Looking at MySQL status Now we’re starting to get into… server is not heavily loaded, I may even do some INFORMATION_SCHEMA queries to help me find the biggest tables and so… exist but have been dropped from InnoDB, for example. (The INFORMATION_SCHEMA query will surely trigger errors about this.) There are a…
Post: Percona Server and XtraBackup weekly news, February 5th
February 6, 2011 By 2 Comments
… decided to try a series of blog posts keeping people informed about what’s happening in Percona Server and Percona XtraBackup…. There was discussion about changing the column names in the INFORMATION_SCHEMA.QUERY_RESPONSE_TIME table, because their meaning is vague and… increment the counters at all. Mark Callaghan found a bug in INFORMATION_SCHEMA.INNODB_SYS_TABLES in the 5.1 server code. Percona…
Post: MySQL Binaries Percona build10
December 11, 2008 By 12 Comments
…slow_query_log_file | /var/lib/mysql/slow_query.log | for compatibility with MySQL 5.1 and | userstat_…Information schema table of InnoDB IO counts for each datafile pages | 1.0 | Percona | GPL | INFORMATION_SCHEMA.INNODB_… | 1.0 | Baron Schwartz | GPL | Bug #29126 fix | | microslow_innodb.patch | …
Post: Percona Server version 10
April 13, 2010 By 3 Comments
… bugs in the release: Bug #551379:Change SE Name at mysql start Bug #550867:5.1.45+xtradb-10 compilation fails on Ubuntu Karmic Bug #547230:Add new columns to innodb_table_stats Bug #548442:INFORMATION_SCHEMA.TABLE_STATISTICS is broken in XtraDB 9.1 Bug #509017:srv_table_reserve_slot() should be protected by kernel_mutex Bug…
Post: MySQL - to use or not to use
May 28, 2007 By 10 Comments
… than MySQL adding in newer MySQL releases. In other cases I can see people using for example SubQueries and Partitions and information schema for ease of management but rarely I would see large amount of big post MySQL 4 features used… party support, which indeed works as MySQL is OpenSource and nothing stops you from fixing bugs yourself or adding your own features…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
… ontime information with the FAA, so there are only 29 air carriers in the table: mysql> select… clear by the following schema diagram:Diagram of the ontime dimensional schema Test environment For this benchmark… and encounter issues, please file a bug on the bug tracker. You can get Shard-Query (…
Post: Percona Server 5.5.8 Beta Release
February 16, 2011 By 16 Comments
…More pluggability, including pluggable authentication In addition to building on MySQL 5.5, here are the changes we’ve made … The INFORMATION_SCHEMA table XTRADB_ENHANCEMENTS was removed. (Yasufumi Kinoshita) Several fields in the INFORMATION_SCHEMA table INNODB_INDEX_STATS were renamed. Bug fixed: #…
Post: Percona Server 5.1.53-12.4
December 29, 2010 By Leave a Comment
… Percona Server 5.1.53-12.4 is based on MySQL 5.1.53.  New Features Added: Precompiled UDFs for… Kuzminsky) Bug #693814, Bug #693815, Bug #693816, Bug #693817, Bug #693819 – Tests in the test environment were updated to reflect past INFORMATION_SCHEMA changes. (Aleksandr Kuzminsky) Bug #693818…
Post: 5.0.77 / 5.0.82 -build16 Percona binaries
June 11, 2009 By 4 Comments
… segments created when new db is created. New information_schema table innodb_rseg shows information about all rollback segments innodb_thread_concurrency_timer… query Bug #378761: compilation fails on 5.0.77 Bug #381900: mysql-test information_schema fails on 5.0.77 with –with-debug Bug #382783…
Post: Instrumentation and the cost of Foreign Keys
September 20, 2010 By 9 Comments
… to know where that lock is? Check information_schema.innodb_locks: mysql> SELECT * FROM information_schema.innodb_locks\G *************************** 1. row *************************** lock_id: … feature in all new releases of MySQL and Percona Server. See BUG #53336 for more examples of pure …
