… LRU Dump/Restore patch, which provides similar improvements in restart performance and has the advantage of persisting across machine restarts. The… engine and a replication environment, its client connection to the remote server was closed leading to an unappropriated network error and stopping…
Post: Percona Server 5.5.14-20.5
August 17, 2011 By 4 Comments
… the 5.5.14-20.5 milestone at Launchpad. Improvements Performance Improvements fsync() has been replaced with fdatasync() to improve perfomance… engine and a replication environment, its client connection to the remote server was closed leading to an unappropriated network error and stopping…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
…: Monitor a database table, or tables for changes. Improve ETL performance by identifying the data which has changed. Maintain materialized views…. It is possible to read from and/or write to remote servers, but this example uses the local machine which is the…_demo\G *************************** 1. row *************************** dml_type: 1 uow_id: 10 fv$server_id: 999 c1: 2 c2: 2 *************************** 2. row *************************** dml_type…
Post: Percona is hiring performance experts
February 13, 2009 By 2 Comments
… who are top-level, senior experts in LAMP/Open-Source performance and scalability. Most of our work involves MySQL (at least… of work. It is not all remote DBA, nor is it all urgent troubleshooting or performance audits; it’s everything you can… problem in my application. Calculate when I’ll outgrow the server! Can you benchmark my application? Make me a new database…
Page: About This Blog
May 3, 2006 By 48 Comments
… Performance Previously I was employed as Manager of High Performace Group at MySQL Inc, I specialise MySQL Server performance as well as in performance… Performance consulting engagements. During last few years I’ve been to many big web shops and enterprises as well as worked remotely…
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 … you however are interested on server performance when it is warmed up. This is the stage your server should spend more than 99… to simulate situation even remotely close to real world. Get large number of similar queries from your MySQL server logs or generate…
Post: Advanced index analysis with mk-index-usage
November 11, 2010 By 2 Comments
… up an SSH tunnel from my laptop to the MySQL Performance Blog server — another 30 seconds. Now I’m set up: I… query EXPLAIN and find out the index usage on the remote server, and store the results in my MySQL sandbox instance. The… fraction of queries to have very different performance, in general — you want consistent performance. Maybe the performance IS consistent, we don’t know…
Post: MySQL Server Upgrade
August 11, 2006 By 9 Comments
Today I’ve upgraded MySQL Server on the host running MySQL Performance Blog. MySQL 4.1.12 was running here for well… know there were some security fixes but I have dedicated server with remote MySQL access closed by firewall and only trusted people… optimize well and so MySQL 5.0 will likely reduce performance. It is probably just 5-10% for most queries but…
Post: MySQL Performance Blog was down today
November 21, 2009 By 3 Comments
MySQL Performance Blog (and percona.com too) were down today because the … we had. Provider was not willing to do it as remote hands so I had to drive to the data center… redundant – currently we were quite cheap and a lot of servers have single network card (so you can’t use trunking…
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
…, while remote consulting would work great. Interesting enough in many cases Remote Consulting turns …as adding few indexes and tuning MySQL Server settings. It is more the question …MySQL and LAMP systems in general, LAMP performance optimization, replication and high availability, scaling, writing…
