June 19, 2013

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 under… saying about XA which were released in MySQL 5.0 without consistent work with MySQL close Partner – Innobase to ensure Group Commit… inside who can figure things out and even patch MySQL if needed. So MySQL went to chase Enterprise market and develop enterprise…

Filed Under: Insight for DBAs Tagged With:

Post: MySQL on Amazon RDS part 1: insert performance

March 15, 2011 By 37 Comments

… Relational Database Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance …: 68 GB of memory, 26 ECUs (8 virtual cores with 3.25 ECUs each), 64-bit platform, … performance of an RDS instance, we need a multi-threaded long-term insert benchmark such as IIBench. …

Filed Under: Cloud and NoSQL, MySQL

Post: What to do with MySQL Full Text Search while migrating to Innodb ?

September 10, 2009 By 12 Comments

… Table Locks is probably the most important issue – with modern multi core servers not only the fact you can’t well mix… can you do ? Leave Tables as MyISAM The beauty of MySQL storage engines is you do not have to convert all… full text search. In certain cases you can just use MySQL triggers to maintain such table, in other cases this would…

Filed Under: Insight for Developers Tagged With: ,

Post: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB

January 7, 2010 By 48 Comments

…. Though LucidDB and MonetDB are also have multi-thread loaders, only InfoBright ICE used single core. InfiniDB: 24 010 sec MonetDB: 42… scalability on InfiniDB’s blog http://infinidb.org/infinidb-blog/mysql-parallel-query-processing-of-ssb-queries-via-infinidb-.html SSB… results. But I hope InfoBright will be able to reuse multi-cores / multi-disks soon. I’d like MonetDB is able to use…

Filed Under: Benchmarks, MySQL Tagged With:

Comment: Bug fix of InnoDB scalability problem

November 15, 2006 By 13 Comments

… actually care about 4.1 Now about 4.0 and multi cores. No one is speaking about 4.0 only 4.1… FOREVER, attaching it to multi core CPUs is nothing else but a trick to hide complete failure of MySQL/Innodb fixing this bug… however existed for long time… it is just only with multi-cores they came to commodity market so amount of complaints increased.

Filed Under: Insight for DBAs Tagged With: , ,

Post: Shard-Query EC2 images available

May 11, 2011 By 2 Comments

…and performance of the splitter. It is multi-threaded(actually multi-process) and is able to hash … data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’…workers 80 I normally start (2 * TOTAL_CLUSTER_CORES) workers. That is, if you have 20 machines…

Filed Under: 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… following basic configuration (many irrelevant details omitted): source src1 { type = mysql sql_query = SELECT id, text FROM table } index idx1 { type…’s how we would change the configuration: source src1 { type = mysql sql_query = SELECT id, text FROM table } source src1p0 : src1…

Filed Under: MySQL Tagged With: , , ,

Post: XtraDB benchmarks - 1.5X gain in IO-bound load

December 18, 2008 By 30 Comments

… OS. This is quite typical server we recommend to run MySQL on. What is important I used Noop IO scheduler, instead… to multi-core and multi-disks utilization. Also results may be different if load is CPU bound. I compared MySQL 5.1.30 trees – MySQL 5.1.30 with standard InnoDB, MySQL 5.1.30 with InnoDB-plugin-1.0.2 and MySQL…

Filed Under: Benchmarks Tagged With:

Post: Detailed review of Tokutek storage engine

April 28, 2009 By 21 Comments

… tried iiBench, which you can take there https://launchpad.net/mysql-patch/mytools What makes fractal indexes so interesting is the… well on multi-cores even in only SELECT queries. What this practically means it that you can’t get benefit of multi-core boxes… application, it can be from simple apache logs put into mysql, application performance logs to more complex log like clicks, user…

Filed Under: Uncategorized Tagged With:

Post: Percona Testing: Innodb crash / recovery tests available

December 21, 2011 By Leave a Comment

… unfortunately, no tests have been created for the main MySQL branch. The MySQL at Facebook branch has a number of tests that… is for two reasons: My attempts at copying the Facebook multi-threaded python load-generation code seemed very, very slow I…:02 bindir is mysql-5.5/sql # 2011-12-21T14:25:02 core is “kewpie/randgen/” is not a core dump: Is a…

Filed Under: MySQL
« Older Posts
Newer Posts »