June 19, 2013

Post: 10 years of MySQL User Conferences

April 11, 2013 By 6 Comments

…with MySQL to put on an amazing conference with O’Reilly’s style of mixing fun with business. The conference name changes to “MySQL…

Filed Under: Events and Announcements, Insight for DBAs, Insight for Developers, MySQL, Percona Live Tagged With: , , ,

Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2

April 12, 2013 By 3 Comments

…2 significantly reduces the impact of the list scan by replacing it with more efficient operations. In a nutshell, it maintains …following kinds of transactions: MySQL transactions started with START TRANSACTION READ ONLY MySQL transactions created by a non-locking SELECT statement in the autocommit…

Filed Under: Benchmarks, MySQL Tagged With: , , ,

Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer

March 29, 2013 By 10 Comments

… 528M RAM Host-Only network 1 Box with http/php, 1 box with memcache or mysql started PHP script Zend framework libmemcached PECL… max per/cmd 0.0951 ms range per/cmd InnoDB MySQL Select (same table): Fetching [1,000,000] items: 441573 ms total… (~.06 ms/op) MySQL Select showed 27% increase over InnoDB fetch (~.09 ms/op) This replaced $cache->load() with $db->query(“SELECT * FROM memcached.container…

Filed Under: MySQL Tagged With: , , , ,

Post: How to recover table structure from InnoDB dictionary

April 22, 2013 By 4 Comments

…indexes of the table. mysql> select * from SYS_TABLES WHERE NAME=’sakila/actor’; … ibdata1 with page_parser ./page_parser -f /var/lib/mysql/…MySQL server. Use LOAD DATA INFILE constraints_parser generates mysql>LOAD DATA INFILE ‘/path/to/SYS_FIELDS’ REPLACE…

Filed Under: Insight for DBAs, MySQL Tagged With: , , , , , ,

Comment: MySQL Partitioning - can save you or kill you

April 30, 2013 By 45 Comments

…. 3. Insert on Duplicate Key (I dont do replace… ever)… if across partitions, will be slower, if… easily be quicker on a partitioned table, as Mysql can fire off one thread per partition (at… not only about the ‘Selects‘ and Inserts, its also about what you do with the table. Removing partitions…

Filed Under: Insight for DBAs, MySQL Tagged With: , ,

Post: Distro Packages, Pre-built Binaries or Compile Your Own MySQL

September 4, 2012 By 7 Comments

…MySQL packaging team does not always include with every release the latest and greatest, simply, select…replaced/overwritten during an update by simply keeping package folders on unique directories. Lastly, running your MySQL…you make your application behave properly with MySQL? A paradigm shift like …

Filed Under: MySQL

Post: UDF -vs- MySQL Stored Function

September 6, 2010 By 8 Comments

… an SQL statement: mysql> select REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( LOWER(author), ‘aa’, ‘a’), ‘bb’, ‘b’),…With that speed I could even scan the whole table of 7 million records: mysql> select…

Filed Under: MySQL Tagged With: , ,

Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit

November 24, 2011 By 2 Comments

…d ==9090==    at 0x4C28FDF: malloc (vg_replace_malloc.c:236) ==9090==    by 0x6BE309B: …by 0x6A5E0C: JOIN::exec() (sql_select.cc:1863) ==9090==    by 0x6A7D72: mysql_select(THD*, Item***, TABLE_LIST*, …consider backporting and using MySQL 5.5 atomic operation primitives with proper memory barriers, so…

Filed Under: MySQL

Post: Ultimate MySQL variable and status reference list

January 8, 2011 By 4 Comments

…MySQL manual, especially ….commanual Com_replace_selectblogpercona.commanual …Select_full_joinblogpercona.commanual Select_full_range_joinblogpercona.commanual Select_rangeblogpercona.commanual Select_range_checkblogpercona.commanual Select… updatable_views_with_limitblogpercona.commanual …

Filed Under: Insight for DBAs, MySQL

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

… default ft_min_word_length. First, MyISAM, with MySQL 5.5, on the SEO data set: mysql: SELECT id, title, MATCH(title, body) AGAINST… Forms | 6.4749345779418945 | | 7119 | Maine Tax Forms | 6.400341510772705 | +——+——————–+——————–+ With 5.6: mysql: SELECT id, title, MATCH(title, body) AGAINST (‘corporation commission forms… hoping to use InnoDB FTS as a simple drop-in replacement for your current MyISAM FTS, the results may surprise you…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,
« Older Posts