… amazing MySQL manual, especially the option and … Connectionsblogpercona.commanual consoleblogpercona.commanual core_fileblogpercona.commanual Created_tmp_…tablesblogpercona.commanual optimizer_prune_levelblogpercona.commanual optimizer_search_depthblogpercona.commanual optimizer_switchblogpercona….
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… as well for our performance optimization works – we would like to get much more stats from MySQL and it would be great… were known for years. The good thing is now with multi-cores coming even on laptops these issues can’t be under… on MySQL because subqueries optimizer weakness. I’m saying about XA which were released in MySQL 5.0 without consistent work with MySQL close…
Post: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 7, 2010 By 46 Comments
…. Though LucidDB and MonetDB are also have multi-thread loaders, only InfoBright ICE used single core. InfiniDB: 24 010 sec MonetDB: 42… that query can’t be resolved by InfoBright optimizer and I need to enable MySQL optimizer. InfiniDB is otherwise was IO-bound, and… results. But I hope InfoBright will be able to reuse multi-cores / multi-disks soon. I’d like MonetDB is able to use…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…of the splitter. It is multi-threaded(actually multi-process) and is able … 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘…I normally start (2 * TOTAL_CLUSTER_CORES) workers. That is, if you have…response time, get a good plan optimizer-prune-level=0 partition=ON …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…innodb_buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement, concurrent inserts, instrumentation, … table / index fragmentation, without having to run the OPTIMIZE? HT: Since OPTIMIZE rebuilds the whole table, it may last way …
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…sorts in different threads – using multiple cores becomes increasingly important as their …full statement duration. The problem with multi value inserts however is the following -…optimized on systems with 1-2 SATA drives so they are far from optimal for server grade IO subsystems. These are for MySQL…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… frequent. And now even laptops are getting multi cores so we can forget about spinlocks wasting … have been implemented outside of MySQL Storage Engine level for MySQL – reading rows in their physical…would be very interesting to see how these optimizations will show themselves in practice. The other…
Post: MySQL and PostgreSQL SpecJAppServer benchmark results
July 25, 2007 By 13 Comments
… see MySQL Scores 720.56 and PostgreSQL scores 778.14 JOPS on 12 cores. …MySQL sweet spots come from. MySQL performance gains usually come from MySQL unique features – non transactional MyISAM, Multi… and MySQL is very fast, while SubSelect optimization is very bad in MySQL for many cases until MySQL…
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
…to growth while keeping our core values of quality and … investment and start building multi level support systems to …MySQL and LAMP systems in general, LAMP performance optimization, replication and high availability, scaling, writing whitepapers, helping people with data recoveries, implement MySQL…
Post: Power of MySQL Storage Engines
March 5, 2007 By 3 Comments
… – all of them are transactional storage engines with multi versioning and row level locks so it is … which are not designed to be run as core storage engines and are not match of functions … interested in special techniques applying to optimizes certain types of queries with MySQL, it is not easy to …
