MySQL 5.5 and Percona Server 5.5 do not solve all scalability problems even for read … of this pattern and got a simplified part of production workload which focuses only on one query but yet … Server 5.1 and around 6 for Percona Server 5.5 which is way too little for what you would expect from 24 …
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…virtual power management: I tested MySQL-5.1.30 with InnoDB plugin, Xtradb-1.0.2-1, and XtraDB-1.0.2-2 (rel2)….to worry about in 16+ cores boxes. Intel Based 24 Core Servers are not mainstream these days but …they are very soon to come. Also in real production there may be not a lot database fits “in…
Comment: Partially OpenSourced
April 15, 2008 By 21 Comments
I’m trying to parse the recent news about 5.1.24 and I can’t figure it out. From the few … you go the mySQL enterprise server page http://www.mysql.com/products/enterprise/server.html the page title is “MySQL Enterprise Server 5.1” I really… further supports what Eric Bergen pointed out. Why not release 5.1.24 as GA to the community first? I would think 1000s…
Post: Interested to learn about New Innodb Plugin Performance ?
April 15, 2008 By 2 Comments
… heard Innodb Announced new Plugin version for MySQL 5.1 So now you can see Heikki and … bug which was fixed in less than 24 hours) as well as performance improvements to …production slaves to see how well it works. There are still usability issues with this release (which you can blame both MySQL…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
…and MyISAM storage engine. The benchmarks are done with MySQL 5.0.45 on 32bit Fedora Core 6 on Pentium…498 5 2 10 83 0 1 3 116 56316 9104 549228 0 0 0 2121 1539 497 0 1 24 …we’ve observing (and which is indeed very good production practice, if your temporary tables are moderately sized). Unfortunately…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… Processors | physical = 2, cores = 12, virtual = 24, hyperthreading = yes Speeds | 24×1600….========= ========== ===== ======= ====== ======= ========= 0(no name) 1.088 TB 1 (1-0-0) …5.0.92-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql… the difference in production as I had…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… most common questions, I might have missed some. 1. What level of HA do you need? Since … manager 99% Heartbeat/SAN (depends on SAN) 99.5% to 99.9% Heartbeat/DRBD 99.9% NDB … Migration to Production MySQL replication 4 hours 12 hours Master-Master with MMM manager 8 hours 24 hours Heartbeat/SAN…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 18 Comments
…article MySQL Performance: Analyzing Percona’s TPCC-like Workload on MySQL 5.5 …start localhost tpcc500 root “” 500 24 10 3600 From graph … FusionIO card information is Found 1 ioDrive in this system …Product Number:FS1-002-321-CS SN:10973 ioDIMM3, PN:00119401203, Mfr:004, Date:20091118 Firmware v5.0.5…
Post: MLC SSD card lifetime and write amplification
November 15, 2011 By 8 Comments
…. As we know, a MLC NAND module can handle 5,000-10,000 erasing cycles, after which it gets… 24/7 non-stop. 15PB (of total writes) / 1125.65GB (per hour) = 13,325.634 hours = 555.23 days = 1…. non-stop tpcc-mysql workload we may expect the card will last 1.52 years. However, in real production you do …
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…1 and run following query: mysql> select * from information_schema.user_statistics where user=”#mysql_system#” \G *************************** 1. row *************************** USER: #mysql_system# TOTAL_CONNECTIONS: 1…1.88 1.96 24.68 1.96 # Tmp disk 4.15k 0 1… in production (especially… on 5 minute …
