May 25, 2012

Post: Shard-Query turbo charges Infobright community edition (ICE)

…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

….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

… : 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

… 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

… 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

… 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

… 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

…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

… 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 6Cores. 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

…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. …