June 18, 2013

Post: The Doom of Multiple Storage Engines

May 8, 2010 By 22 Comments

…the big “Selling Points” of MySQL is support for Multiple Storage engines, and from the glance view… much more complicated to test. And I believe multi-storage engine use is really not tested very deeply…does not matter). We could save a lot of CPU cycles by having storage format same as processing …

Filed Under: Insight for DBAs, MySQL

Post: Sphinx search performance optimization: multi-threaded search

January 16, 2013 By 10 Comments

… way. If your MySQL or Sphinx query takes 10s to run on a machine with a single CPU core and single disk… to be many times faster. Even more so, Sphinx now supports this out of the box, so you don’t need… following basic configuration (many irrelevant details omitted): source src1 { type = mysql sql_query = SELECT id, text FROM table } index idx1 { type…

Filed Under: MySQL Tagged With: , , ,

Post: Top 5 Wishes for MySQL

June 29, 2007 By 10 Comments

… were known for years. The good thing is now with multi-cores coming even on laptops these issues can’t be… – MySQL does not handle complex queries well, being able to use only one CPU effectively on single node and no true federation support. 4. Be Solid MySQL has very good stability track record, with exception of MySQL…

Filed Under: Insight for DBAs Tagged With:

Post: Making MySQL Replication Parallel

January 30, 2007 By 1 Comment

… by the fact MySQL Replication is single threaded so in reality it is only able to use only single CPU and single disk effectively which is getting worse and worse as computers are getting “wider” these days with multi-core… expect to come quite soon. On other hand if support for Multi-Master is implemented for many applications Parallel Replication could be…

Filed Under: Insight for DBAs Tagged With: ,

Post: InnoDB benchmarks

January 3, 2007 By 15 Comments

… with options: ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb and next startup options were … our needs I developed benchmark suite which support wide range of tables and queries. The … the same such queries were affected on multi-CPU systems. Used hardware: CentOS release 4.4 (Final…

Filed Under: Benchmarks Tagged With: ,

Post: Falcon Storage Engine Design Review

January 12, 2007 By 19 Comments

… are getting multi cores so we can forget about spinlocks wasting CPU time on single CPU boxes … have been implemented outside of MySQL Storage Engine level for MySQL – reading rows in their physical … limited amount of isolation modes is supported, including no support for SELECT FOR UPDATE. This is …

Filed Under: Insight for DBAs Tagged With:

Comment: Bug fix of InnoDB scalability problem

November 15, 2006 By 13 Comments

…MySQL versions the less effort would be need to spent on it. Even support gets more expensive with old version as support… MySQL which is 5 years ago. Number of CPUs however does matter – the effect with large CPU…for long time… it is just only with multi-cores they came to commodity market so …

Filed Under: Insight for DBAs Tagged With: , ,

Post: Detailed review of Tokutek storage engine

April 28, 2009 By 21 Comments

… which you can take there https://launchpad.net/mysql-patch/mytools What makes fractal indexes so …outperforms InnoDB 1.4-2.5x times, but CPU-bound is not so good. I think … – Transactions only support the SERIALIZABLE isolation level. Beside it TokuDB does not scale well on multi-cores even…

Filed Under: Uncategorized Tagged With:

Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1

January 8, 2007 By 117 Comments

…than InnoDB in reads, as InnoDB is transactional, supports Foreign Key and has an operational overhead. As…CPU 5130 @ 2.00GHz stepping : 6 cpu MHz : 1995.004 cache size : 4096 KB 16GB of RAM MySQL version We used MySQL… this is specific Falcon’s way to handle multi-versioning. I think this is a big …

Filed Under: Benchmarks Tagged With: ,
« Older Posts