… drop in replacement for MySQL, downloads are available here and from the Percona Software Repositories. Based on MySQL 5.1.69, this release will… being limited to 32-bit signed integers. Fixed so that these values can be 64-bit unsigned integers now. Bug fixed #714925. mysql_set_permission…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… this box had. MySQL Also was very slow running some queries so we changed scripts a bit to kill extremely …by MySQL 5.1 time so if it is less than 1 MySQL 6.0 is faster if more than 1 slower: Query MySQL 5.0.23 MySQL … query processing was not too bad, however with 16,32,64 cores it is just too bad.
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
…with queries from TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. MySQL 6.0 is interesting here, as …to read other columns. But for 6 picture is a bit different. At start I had: Device: rrqm/s wrqm/…svctm %util sda 16.22 1.23 534.29 1.85 132547.02 24.64 66273.51 12.32 247.27 0.30 …
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…32 bit we cannot turn up the innodb_buffer_pool higher than 1…Delayed_writes’, ’0′ ‘Flush_commands’, ‘5‘ ‘Handler_commit’, ’19092941′ ‘Handler_delete…1 70 10 mysql conf: [mysqld] server-id=5908 port=3309 socket=/tmp/mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql… # Default 64 was …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…32 and 64 bit varieties. Due to memory requirements, the InnoDB versions are only available on 64 bit instances. MySQL…-innodb-demo-64bit x86_64 Percona Server 5.5.11 with XtraDB. Requires …_fact;” | ./run_query Array ( [count(*)] => 135125787 ) 1 rows returned (0.084244966506958s, 0.078309059143066s…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…) Kernel | 2.6.32-31-server Architecture | CPU = 64-bit, OS = 64-bit # Processor ################################################## Processors | physical = 2… couple interesting surprised I faced: 1. After I got (what I …5.0.92-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…64-bit CPU. From this and what I saw earlier I can see whether someone installed a 32-bit OS on 64-bit… commands. For example, ‘top -n 1‘ and ‘uptime’. That shows me what… in some cases): vmstat 5 5 iostat -dx 5 5 If you don’t … is a 64-bit build, if I’m on a 64-bit OS. Examining MySQL configuration …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…5.0.xx, where xx >= 30 should be better than 4.1.xx. PZ: I should note MySQL 5.0 vs 4.1…Mysql server for a client, upgrading their main database (from 16GB, 2 two-year old HT’ed XEONs to 32… in contiguous blocks of 64 pages == 1 MB. Then a…MySQL Master Master Manager can help you to automate it a bit…
Post: Air traffic queries in MyISAM and Tokutek (TokuDB)
November 5, 2009 By 26 Comments
… – to design proper indexes is additional research, especially when MySQL optimizer is not smart in picking best one. … MyISAM: 36.7GB TokuDB: 6.7GB I am a bit surprised that TokuDB is slower loading data, but …Q8 (10y)119.5484.64 Q969.0547.67 For reference I used 5.1.36-Tokutek-2.1.0 for both MyISAM…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 3
October 19, 2009 By 25 Comments
…MySQL/Innodb when I had enough memory but I increased the threads from 64…Tyrant may stumble a bit. Bottom line given …32 Threads, Tyrant was started with 8 threads and 128M of memory, memached was started with 16 threads ( 1.4 memcached ), mysql was 5.1 XtraDB. …
