… MySQL. These are great results, plus they can be relevant to a lot of us because commodity x86 based hardware was used for… be very interesting to see for example results on the same hardware just running PostgreSQL instead of MySQL or having Sun box replaced… features which are worth a bit of performance overhead. My best wishes to the Tom Daly and his team in further…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… course, we will also tell you what we think is best for you, which is our job). After the kickoff call, we…. dmesg is useful for several reasons. For one thing, it has a lot of information on the box’s hardware, including RAID controllers…’ll move on to the MySQL server. I mean, let’s just assume the physical hardware and the machine setup is fine…
Post: A piece of Sun/MySQL Marketing
February 27, 2008 By 7 Comments
… related to Sun and MySQL and among other things – These Benchmarks This may be great piece of Benchmarks for Sales and Marketing… to take informed decision and pick best of the component level. As you can see Everything – Hardware, Virtualization, OS, Database Server, Web… run different MySQL and Web instances looks highly dubious to me…. at least this is not what you normally do for high…
Post: Fighting MySQL Replication Lag
September 22, 2008 By 7 Comments
… it. There are many aspects of managing mysql replication lag such as using proper hardware and configuring it properly. In this post… extremely complicated query. It is best to avoid INSERT … SELECT going through replication in 5.0 for many reasons (locking, long query… lot of problems and often save massive hardware purchases or development efforts based on assumption MySQL replication can’t possibly keep up…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…produce large sets of data for the hardware to process from even… too tight for everyone. And for you it is best to …_transactions: 0 Rollback_transactions: 0 mysql> SHOW TABLE_STATISTICS LIKE ‘hosting2%’; +——————————–+———–+————–+————————-+ | Table …
Post: MySQL: what read_buffer_size value is optimal ?
September 17, 2007 By 25 Comments
… for better performance. Lets see if it is really best strategy: To check things out I’ve created table with simple structure: mysql… scans, with 3 runs and averaged results. MySQL 5.1.21-beta was used for tests. mysql> select count(*) from dt2 where slack… curious how much values change on different platforms (OS and Hardware) as well as different file systems as these could all…
Post: MySQL Sizing questions
June 23, 2006 By 4 Comments
…per second MySQL can do” or “how many servers I need to handle 100.000 users” or “which hardware … get the answers from other vendors. 2) The best answer to this question will not be a … application is defined. For example if you would ask me what hardware you need for ecommerce web site with …
Post: KISS KISS KISS
March 1, 2009 By 7 Comments
…”cluster” even on the current hardware for several years. Replication Optimization …intermediary slaves people use. For me simple is best. Complex architectures …MySQL redundancy for very high quality/high scale applications. I’ve seen applications having no downtime running for years on single MySQL…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…MySQL configurations, I didn’t try out different MySQL versions or settings. Moreover, I have been running these benchmarks for… but not during mkfs. This is your best option if you have a proper alignment …had another machine running sideways with the same hardware, but with a misaligned IO. Here’s …
Comment: Finding your MySQL High-Availability solution – The questions
October 17, 2009 By 36 Comments
… happen very slowly * mysql connection are unresponsive connection hangs indefinitely when things crash quickly that is the best situation for failover. When a… – with hundreds of DB servers we get kernel panics weekly. * hardware failure – typically losing a disk. Usually the RAID controller does…
