…performance improvements, however these days it is rarely important to MySQL…server during its lifetime comes down to this rather boring process – install, configure, tune, start/stop MYSQL, upgrade MySQL, 10x start/stop MySQL, upgrade MySQL…hardware…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 38 Comments
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
…hardware failure, the level of availability of this solution is affected by the availability of the MySQL replication link between the servers…MySQL servers replicating each other, there is a third server, called the manager, that controls both MySQL server…
Post: Percona Live London 2012 talks you do not want to miss
October 30, 2012 By Leave a Comment
… Hardware for MySQL by Kenny Gryp is a great talk if you want to learn how to chose hardware for best MySQL performance and maximum efficiency. MySQL…’m also giving talks myself – Using Percona Server in Production tutorial and Optimizing MySQL Configuration and I’d love to see you…
Post: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
…’re designing the system so it can tolerate hardware failures should we bother about hardware quality at all ? The answer is yes… may be system performance impact and (in particular if you use MySQL Replication for HA) the switch to the new server may not… performance gotchas (ie 8 core server can be slower than 4 core with MySQL). It is best if you just put couple of spare servers…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…example results on the same hardware just running PostgreSQL instead of MySQL or having Sun box…calls checking various server changes which typically never change). We can also see Server prepared …little bit lless of performance. innodb_thread_concurrency = 0 Good! So Innodb performed best in this …
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
… a server with standard hardware RAID …best choice for operability in the majority of normal configurations. Are there ways to squeeze more performance out of a server…mysql‘s tmpdir elsewhere) Everything else for MySQL (/mnt/data or similar): (sym-link /var/lib/mysql into here when you setup mysql…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
…about the servers. OK, I’ll give you more information. Both servers are real production servers, with powerful hardware …in MySQL to guide your decisions. It is also not the be-all and end-all of MySQL performance…, what about InnoDB tuning? What is the best way to choose an innodb_buffer_pool_size…
Post: MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)
December 21, 2010 By 11 Comments
… for MySQL 5.5.8 and Percona Server on the fastest hardware I have in our lab: a Cisco UCS C250 server with… provides the best throughput innodb_io_capacity=20000; a difference from the FusionIO case, it gives better results for MySQL 5… you are looking for high MySQL performance, and we tune Percona Server to get the most from such hardware. Actually, from my benchmarks, I…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…either it’s not even possible or, at best, economically inefficient to allocate the entire machine …SQL performance is very tricky, it’s very easy to produce large sets of data for the hardware…a dedicated server because their usage is very high temporarily block users having huge spike in MySQL usage…
Post: A piece of Sun/MySQL Marketing
February 27, 2008 By 7 Comments
…informed decision and pick best of the component level. As you can see Everything – Hardware, Virtualization, OS, Database Server, Web Server are all different…Virtualization Software” used with Windows is a crap ? Remembering horrible MySQL performance loss from Xen and VMWARE It is quite possible. …
