… switch to Oracle’s MySQL on another platform, it will work seamlessly. Why is Percona involved? Because providing quality server builds is a…’ve proven by providing our own Percona Server variant of the MySQL server. We have a history of improving the MySQL server and finding and solving…
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 22, 2012 By 9 Comments
… Performance MySQL. Is that the same title as the O’Reilly “High Performance MySQL” by Jeremy Zawodny & Derek Balling (which I own, but… avalable on DotDeb.org, and I find my qps dropping by 2/3 – with no changes to what is happening on the server. Any ideas on what is happening here? It seems as if MySQL 5.5 has been…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…database server will continue to function, however, because the file isn’t really deleted. The MySQL server keeps…times. The pmp-check-mysql-file-privs plugin checks whether MySQL owns every file and directory within… of MySQL on the same files in the data directory, and refusing to shut down MySQL so…
Post: Three ways that the poor man's profiler can hurt MySQL
December 2, 2011 By 19 Comments
… key tool in helping us analyze MySQL when customers are having trouble. We have our own implementation of it in Percona Toolkit…’ve witnessed: The server freezes for the duration of the process. This is the most obvious impact on the running server: GDB forklifts… it go on working. But this can take a while. It’s usually a couple of seconds, but on big servers with a…
Post: How to use tcpdump on very busy hosts
April 18, 2011 By 17 Comments
… got more than 60% dropped packets on a server with roughly 50MB/s of traffic on port 3306, system load of about 10… exclude all queries which it believes took longer than the servers long-query-time of 1 second tcpdump traffic only from… draft of a script to automate this; use at your own risk and update to suit your needs. #!/bin/bash # Set…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
… series of posts showing benchmark results on Amazon EC2 servers with RAID’ed EBS volumes and MySQL, versus RDS machines. For reasons that… isn’t as broad as what you can push your own servers to deliver. Here’s why: you’re limited in the… stock MySQL than it is to Percona Server. I haven’t run extensive benchmarks against RDS 5.5, Percona Server 5.5, and MySQL…
Post: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
… to keep single Cisco router because it has its own internal high availability on the component level which makes it extremely unlikely… and (in particular if you use MySQL Replication for HA) the switch to the new server may not be 100% clean with… 8 core server can be slower than 4 core with MySQL). It is best if you just put couple of spare servers in…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 37 Comments
…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…
Post: MySQL Blob Compression performance benefits
January 11, 2008 By 17 Comments
…on network traffic a bit, though this is not generally the problem. Compression on the server gives you ability to do some server…MySQL tools. Some people get best of both worlds by taking COMPRESS/UNCOMPRESS functions from the MySQL code and having them work on… BLOB gets its own page (allocated …
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… of same queries an Prepared Statements can be more efficient on the server side but I guess something is not as well… I assume storing each table in its own file worked better for this benchmark. Depending on workload it can be a bit… server: UFS Options for log and data noatime, nologging mysqld moved into the FX scheduling class via priocntl -s -c FX mysql…
