… 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: How Can Percona MySQL Server Development Services Help ?
January 28, 2013 By 3 Comments
…interface. If you have some custom authentication, auditing, or storage engine needs, we can help. It also might be more …most performance from your MySQL server via our Percona MySQL Consulting, Percona MySQL Support, and Percona MySQL Remote DBA services. With our MySQL Server Development Services…
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: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 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: 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: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
Now as new MySQL Storage engine – Falcon is public I can write down my thought about … implemented outside of MySQL Storage Engine level for MySQL – reading rows in their physical order can be applied to most storage engines, it certainly… Modes So far limited amount of isolation modes is supported, including no support for SELECT FOR UPDATE. This is also why Falcon…
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…
Post: Countless storage engines
May 3, 2007 By 6 Comments
… count of storage engines were presented. In good old time when Oracle bought InnoDB, MySQL did one step – announced MySQL supports Plugginable Storage Architecture…. Also this engine will not support index coverage optimization, that makes Falcon less attractive from performance reasons. Solid The engine with both pessimistic…
