June 18, 2013

Post: What do we optimize with mk-query-digest ?

December 15, 2009 By 2 Comments

… (together with other interactions – memcache, remote sites etc) is a key to understanding what causes performance issues. If you have slow queries… is) – it is however perfectly possible to get bad performance with MySQL responsible for large portion of response time without any slow…

Filed Under: Insight for Developers, MySQL

Post: MySQL MyISAM Active Active Clustering - looking for trouble ?

March 15, 2007 By 4 Comments

… about what exactly are you looking for with this setup. Performance ? This configuration adds effectively global table locks besides extra overhead… to be invalidated with remote writes which makes even less efficient. So this configuration would unlikely be well performing compared to other… takes long time for large tables. Furthermore as I remember MySQL simply was not repairing corrupted tables in this configuration even…

Filed Under: Insight for DBAs Tagged With: ,

Post: Getting real life query speeds with MySQL

January 10, 2007 By 10 Comments

To check for query performance improvements followed indexing/query changes or MySQL configuration changes our customers often decide to run the query… ways too). Most typically you however are interested on server performance when it is warmed up. This is the stage your… to simulate situation even remotely close to real world. Get large number of similar queries from your MySQL server logs or generate…

Filed Under: Benchmarks, Insight for Developers

Post: Percona XtraDB Cluster Feature 1: High Availability

January 17, 2012 By 20 Comments

… point is that you can convert your existing MySQL / Percona Server into Node and roll Cluster using… All data is available locally, no need for remote access. No central management. You can loose any… of time you can shutdown any Node to perform maintenance or make configuration changes. Or Node may…

Filed Under: Insight for DBAs, MySQL, Percona Software

Post: Site was down today, support and web hosting.

August 31, 2007 By 27 Comments

… a half year we had pretty good track record with MySQL Performance Blog – there were times when site was slow (especially when… price for hardware with decent base specs – 64bit CPUs, RAID remote reboot and serial console, backup etc. Plus we had one… less lucky and in about a week after we moved MySQL Performance Blog to the new server, it stopped responding. I went…

Filed Under: Events and Announcements Tagged With:

Post: Adventures in archiving

February 11, 2013 By 16 Comments

… before going ahead and using it.[/caption] One of our Remote DBA service clients recently had an issue with size on… following options for further testing. InnoDB’s inbuilt row compression MySQL‘s inbuilt compress() function leveraging zlib to provide compression of… to be aware that Archive does not have good performance. e.g. mysql> select id from archive_table order by id desc…

Filed Under: MySQL Tagged With: , ,

Post: Sphinx search performance optimization: multi-threaded search

January 16, 2013 By 10 Comments

…, so you don’t need to pretend you are querying remote nodes. Also, you get a bonus: once you configure server… following basic configuration (many irrelevant details omitted): source src1 { type = mysql sql_query = SELECT id, text FROM table } index idx1 { type…’s how we would change the configuration: source src1 { type = mysql sql_query = SELECT id, text FROM table } source src1p0 : src1…

Filed Under: MySQL Tagged With: , , ,

Post: Percona Server 5.5.14-20.5

August 17, 2011 By 4 Comments

…14-20.5 milestone at Launchpad. Improvements Performance Improvements fsync() has been replaced with fdatasync… environment, its client connection to the remote server was closed leading to an …Bugs Fixed #813587 / #51196 and#61790 in MySQL (Alexey Kopytov). Querying global_temporary_tables …

Filed Under: MySQL

Post: MySQL 5.6: Improvements in the Nutshell

January 27, 2013 By 16 Comments

… of improvements available in MySQL 5.6 which I …Information Tables – - Buffer Pool Information Tables – Improved PERFORMANCE_SCHEMA – - Reduced Overhead – - Simplified Configuration – - Table …DDL – Import/Export for Partitioned Tables – Remote Binlog Backup – Innodb Transportable Tablespaces – …

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , ,

Post: Back from RIT2007

April 20, 2007 By 6 Comments

… get your computer on the speakers table neither you had remote control so you had to say “next slide” all the… inconvenient. As you guess you can’t tell much about MySQL Performance Optimization in just 15 minutes so I had to keep… wrote specially for this conference on MySQL Presentations page. Next week I’m going to MySQL Users Conference to have some more…

Filed Under: Events and Announcements Tagged With:
« Older Posts
Newer Posts »