…year has tens of millions of flights: mysql> select count(*) from ontime_one.ontime_fact; +———–+ | count(*) | +———–+ | … a single commodity database server with 6 cores (+6ht) and 24GB of memory was selected… encounter issues, please file a bug on the bug tracker. You can get Shard-Query…
Post: Percona Server 5.1.55-12.6
March 7, 2011 By 5 Comments
….6 is now available for download. It is now the current stable release version. Changes Fixed compiler warnings in both the core server and in XtraDB. (Alxey Kopytov, Yasufumi Kinoshita) Bugs Fixed Bug #602047 – The ROWS_READ columns… non-zero. Locking was relaxed to alleviate this. (Yasufumi Kinoshita) Bug #724674 – Ported an updated version of the original implementation of…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… : 4096 KB physical id : 1 siblings : 4 core id : 3 cpu cores : 4 fpu : yes fpu_exception : yes …, take a look at this bug report (not a bug). Looking at MySQL status Now we’re starting to … (without closing the connection properly). This is happening 6 times every ten seconds. We need to figure …
Post: Intel Woodcrest vs AMD Opteron for MySQL
June 8, 2006 By 9 Comments
… is something on a way. Same site publishes Core vs K8 architecture comparison which is very interesting … Woodcrest at 3 Ghz beats Irwindale at 3.6 Ghz up to 3 times , which means performance… MySQL could be slower on Linux with many connections with increasing number of CPUs. This is known bug …
Post: My "hot" list for next InnoDB features
March 30, 2009 By 18 Comments
… I expect InnoDB-plugin will run fine on 16-24 cores boxes for many workloads. And now it is time to… full 32GB buffer_pool. There is reported bug http://bugs.mysql.com/bug.php?id=29847, with ETA MySQL-6.0 Preload table / index into buffer…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
… size. For example right now you can get 8 core x86-64 box with 32G with good price/performance… likely to have more bugs on all levels starting from Hardware and going down to MySQL. Then now even if…higher and you need to scale 10x within next 6 months by your conservative growth forecast. So you go…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… a hi amount of concurrent writes to about 6 tables, what version of Innodb/MySQL would you recommend? I’ve been staying… innodb_buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement, concurrent inserts, instrumentation, etc…
Post: FreeBSD tests
June 15, 2006 By 15 Comments
…experiments with different OS and today I tested FreeBSD 6.0 on my box. (more details about box …is known problem and is not MySQL fault. More info is available in FreeBSD bug report I’m not … Configuration params: Box: Dual Core Athlon 3800+, 1Gb of RAM, Motherboard ASUS A8N-E MySQL 5.0.22 params for…
Post: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
… results for MyISAM using MySQL 5.0.45 run on 4 Core System: Threads queries/sec …MySQL 5.0 versions. We also decided to take a time and see may be brand new Falcon (significantly updated in 6…Cores. Here is comparison of MyISAM Innodb and Falcon results in the graphical form: I’ve created bug…
Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
December 16, 2008 By 25 Comments
…to scalability for systems with 8+ cores. documentation Buffer pool fixes Improvements of…for existing MySQL-5.1.30 installation http://www.percona.com/mysql/5…. https://bugs.launchpad.net/percona-xtradb. You can also report bugs there. … questions. We are looking for 6-month release cycle of XtraDB. …
