… might have heard that Oracle made the decision not to support MySQL for IBM i any longer. This is certainly understandable. However…’s MySQL on another platform, it will work seamlessly. Why is Percona involved? Because providing quality server builds is a substantial engineering… own Percona Server variant of the MySQL server. We have a history of improving the MySQL server and finding and solving bugs…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… used by current MEMORY tables: mysql> select sum(data_length+index_length) from information_schema.tables where engine=’memory’; +——————————-+ | sum(data_length…. row *************************** SESSION_ID: 7234 TABLE_SCHEMA: test TABLE_NAME: tmp ENGINE: MEMORY NAME: #sql516_1c42_1 TABLE_ROWS: 2 AVG_ROW… and fixed. This is where your MySQL Support contract can be handy. Conclusion Understanding where MySQL can allocate memory can help us to…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… table2 are batched together and sent to the storage engine. The storage engine then uses the MRR interface (which I explained in… Hash Joins. Hash Join As I have told before MySQL has only supported one join algorithm and that is Nested Loop Join… a look at the status counters. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer_size=6M & read…
Comment: Best kept MySQLDump Secret
March 26, 2012 By 11 Comments
… is just how things were designed with MySQL and how transactions were retrofitted to it. MySQL has funny history this way. It… support are all but gone in recent versions. The question is whenever MySQL will ever be redesigned to focus on transactional storage engines…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… it without side load. Setting up 2 MySQL Servers side by side (for example with MySQL Sandbox) can especially be helpful. Once… report the problem through MySQL support channel if often helps to know whenever it is the problem in stick MySQL changes between versions… test on MySQL server of the same version. If you’re Support customer you do not need to do it as Support Engineer can…
Post: Percona is looking for a Support Engineer
November 16, 2010 By 1 Comment
… and with the introduction of our Support and Maintenance services, we’re looking for a new Support Engineer. You would be a part… such as query optimization, replication problems, reproducing bugs and general mysql administration and use inquires, among other things. Work is scheduled…
Post: Free Percona Live tickets and Percona Support contract!
May 23, 2011 By Leave a Comment
… for Percona Live: we’re giving away free tickets through Engine Yard, and we’ve arranged our evening open-bar event… MySQL Support contract from Percona, worth over $15,000! In case you don’t know, Percona Live is a one-day intensive MySQL…, with four tracks of 100% technical content from world-famous MySQL experts. Tickets are still available at http://www.percona.com…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
One of the big “Selling Points” of MySQL is support for Multiple Storage engines, and from the glance view it is indeed great… time. Transaction Support We have to deal with mix of locks on high level as well as on storage engine internally. We… prevents from having hot backup in many cases. Replication Support for different storage engines is a pain in replication. To start we…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
…-rc2 there is a support for MySQL wire protocol and SphinxQL – SQL-like language to query Sphinx indexes. This support is currently in… – unlike MySQL Storage Engines, some of which as InfoBright or KickFire take over execution after parsing, Sphinx MySQL support has nothing to do with MySQL…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… lot of customers who do click analysis, site analytics, search engine marketing, online advertising, user behavior analysis, and many similar types…’ll need in those aggregate tables, and include columns to support these queries. But beware of denormalizing with character data; try… joins on large data sets are very expensive. If MySQL supported sort-merge or hash joins, you’d have other possibilities…
