… an ALPHA quality release and is not intended for production. If you want a high quality, generally available release, the current…. innobackupex now uses Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client. Support for InnoDB 5.0 and InnoDB 5.1-builtin has been removed from Percona XtraBackup for MySQL…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… some benchmarks for the use case where the MySQL working set is significantly larger than the InnoDB… appropriate sysctl setting; with vCache, there is a command-line binary which can modify many of the…edge to FlashCache due to configuration flexibility, but if the GA release of vCache added some of…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…`. However it will interesting how both InnoDB and TokuDB performs if PK is (`id`,`hid`,`mid`). This also will affect select…, if you want to repeat this benchmark, the sysbench code is on Launchpad lp:~vadim-tk/sysbench/insert-roll-2, command line to run: sysbench –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
April 3, 2013 By 10 Comments
…, means different server version. HS does not compile with MySQL 5.6 (yet). If you compare HS @ 5.5 with InnoDB Memcache @ 5.6 you should see roughly the same performance with simplistic PHP command line tests. However, apples and oranges – think of features… see also http://de.slideshare.net/nixnutz/nosql-in-mysql Independent…
Post: Be productive with the MySQL command line
December 21, 2012 By 14 Comments
…is easily solved by using the pager command: mysql> pager more PAGER set to ‘more’ mysql> select title from sakila.film; +—————————–+ | title | +—————————–+ | … of its hidden features, it can be very powerful. If you enjoyed these tips, I will write another post …
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
…this is improvement from complete disaster to something absolutely unacceptable. If we look at the gain system shows from performance at…select,do_select,JOIN::exec,mysql_select,handle_select,execu te_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_command,do_handle_one_connection…
Post: Fun with the MySQL pager command
January 21, 2013 By 6 Comments
… be done with: mysql> SELECT COMMAND,COUNT(*) TOTAL FROM INFORMATION_SCHEMA.PROCESSLIST GROUP BY COMMAND ORDER BY TOTAL DESC; +————-+——-+ | COMMAND | TOTAL | +————-+——-+ | Sleep |…efficient way. You can even write your custom script (if it is too complicated to fit in a single…
Post: MySQL and predictive option handling - beware
October 29, 2012 By 2 Comments
MySQL command line utilities have an interesting property – if you only use the prefix of the option or command it will go over the… especially if you make a typo. I made one today (thankfully on the test box). MySQL init Scripts use “stop” and “start” commands…@smt2:/var/lib/mysql# mysqladmin stop Slave stopped It would be quite confusing if mysqladmin would have “stop” command which does not do…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…prior to MySQL 5.5.3 Metadata Locking behavior prior to MySQL 5.5.3 Prior to MySQL … same query could return different results if executed twice and if a DDL was executed between the query… Id | User | Host | db | Command | Time | State | Info | …
Post: Auditing login attempts in MySQL
December 28, 2012 By 4 Comments
… we can get other statistics that can be very useful if MySQL is running on a multi-tenant environment or we need… ROWS_UPDATED: 1017714 TABLE_ROWS_READ: 1484751 SELECT_COMMANDS: 14 UPDATE_COMMANDS: 103 OTHER_COMMANDS: 3556 COMMIT_TRANSACTIONS: 0 ROLLBACK_TRANSACTIONS: 0 DENIED… get the connection time, bytes received and sent, rows accessed, commands executed and so on. Very valuable information. It is important…
