… same in 5.5. Here is the related output from show engine innodb status: —TRANSACTION BB0E42A, ACTIVE 3 sec fetching rows…(1) as installed_count from client_app_inventory cai inner join device d on (cai.client_id = d.client_id) inner join label…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…( array( ‘host’ => ’192.168.57.51′, ‘port’ => 11211, ‘weight’ => 1, ) ), ‘client‘ => array( ‘compression’ => true, ), ); $cache = Zend_Cache::factory(‘Core’, ‘Libmemcached’, $frontendOpts… doesn’t show any multi-threading or other advanced operation, it is using identical code to eliminate variation due to client libraries…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
…-recurring engineering” (a new feature paid for by a specific client) things having tended to not be integrated into the main… in mainline, it always remains a patch for that one client – they could spend time on it internally for every update… extra syntax having been added in a sloppy way. He showed how, when done differently, it didn’t have that problem…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be… Lorch III). Fixed the upstream bug #62578 which caused MySQL client to abort the connections on terminal resize. Bug fixed #925343… be loaded with Perl and Python clients when plugin-dir option was set in the [client] section of the my.cnf. Bug…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be… Lorch III). Fixed the upstream bug #62578 which caused MySQL client to abort the connections on terminal resize. Bug fixed #925343… be loaded with Perl and Python clients when plugin-dir option was set in the [client] section of the my.cnf. Bug…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… for server communication instead of spawning the MySQL command line client. Support for InnoDB 5.0 and InnoDB 5.1 builtin… perform the Incremental Backups now. Bugs Fixed: innobackupex is using SHOW MASTER STATUS to obtain binlog file and position. This could…
Comment: Percona Server 5.5.30 with TokuDB for MySQL
April 29, 2013 By 26 Comments
Mark, There is no many steps if you are on the good platform (CentOS or Fedora). I do scripts/mysql_install_db –datadir=/data/mysql bin/mysqld –datadir=/data/mysql and it is all good. connect from mysql client and check SHOW ENGINES;
Post: Google's user_statistics V2 port and changes
September 12, 2008 By 9 Comments
…_sent, etc) New command SHOW CLIENT_STATISTICS, which shows statistics per client‘s hostname, not per user FLUSH USER_ and CLIENT_STATISTICS commands Our port includes: INFORMATION_SCHEMA tables – USER_STATISTICS, CLIENT…
Post: SHOW OPEN TABLES - what is in your table cache
December 14, 2008 By 3 Comments
… examine what tables do you have open right now: mysql> show open tables from test; +———-+——-+——–+————-+ | Database | Table | In_use | Name_locked… command lists all non-temporary tables in the table-cache, showing each of them only once (even if table is opened… used. Note however if you’re starting MySQL Command line client without “-A” option it opens all tables in the active…
Comment: Percona RPMS for RedHat 5 / CentOS 5 x86_64
July 31, 2008 By 4 Comments
… Schema to export the output from the monitoring rather than SHOW {TABLE,USER,INDEX}_STATISTICS. That sounds great. We are still… log. And we are trying to add SHOW CLIENT_STATISTICS that will aggregate resource consumption by client IP. That should be out in…
