…, but we make our money from services, not software. Our job is to tell our customers what we think is best… this is Percona XtraBackup. We have also worked to create open-source tools for monitoring, query analysis, replication management, and other… versions. And we can and will continue to provide an open-source database server that delivers improved performance and functionality to…
Post: Living with backups
November 6, 2008 By 28 Comments
… is out and ready to save someone’s life (or job at least). Unfortunately taking backup does not come free of… with the system cache. By specifying O_DIRECT flag when opening a file, an application tells the system to bypass the… well. The problem is when accessing a file that was opened with O_DIRECT flag, the file needs to be aligned…
Post: A note about Pythian
April 17, 2008 By 4 Comments
… an enlightening talk, and I was very impressed by Paul openness and willing to share with me a lot of internal…. I wish there would be more people out where as open and helpful even when it comes to somewhat competing businesses… do a lot of Architecture Design Scaling jobs and some custom MySQL Extensions/porting patches jobs. Paul can well deal with Fortune…
Post: HighLoad 2007 Review
October 6, 2007 By 1 Comment
….Ru had sessions covering their internal architecture. Speakers were very open in many cases sharing data about their internal implementation, for… no place to sit. Registration was the other problem. Registration opened at 9 and sessions were supposed to start at 10… people I spoke to were approached about job opportunities so it was great place for job hunting as well. Third – It was…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… common cause of serious incidents is application misbehavior, such as opening a transaction but never committing it, which creates a lot… hand instead of through the init script. Overly zealous cron jobs to delete old files in /tmp can do the same… pile-up of connections all trying to open or close tables can indicate LOCK_open contention. Replication is delayed or stopped. Our…
Post: Intro to OLAP
July 12, 2010 By 10 Comments
… updated and in the complexity of the many scripts or jobs which might be necessary to keep the tables in sync… here. Our discussion will focus on Mondrian. Mondrian is an open source ROLAP server featuring an in-memory OLAP cache. Mondrian is part of the Pentaho open source business intelligence suite. Mondrian is also used by other…
Comment: The #1 mistake hosting providers make for MySQL servers
August 2, 2008 By 30 Comments
… 30/s) (this will not show more MySQL usage, but opens a second perl by about 25% – I have to check… will do the job up to 150/s, while the Update job is doing 200/s – and an other job is closing sets…
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
… us via email and ICQ asking for free help. Small jobs are tough From the very beginning our focus was efficiency… minimal number of hours at all. Large number of such jobs of course is challenging to manage and add a lot… which we rather would not disclose for now. In the Open Source area we work on Sphinx Search as well as…
Post: Recovery deleted ibdata1
August 10, 2012 By 9 Comments
… – ibdata1 – and redo logs – ib_logfile*. MySQL keeps InnoDB files open all the time. The following recovery technique is based on… in the file system and reachable to processes which have opened it. Thus, from user perspective nothing has changed after the… bunch of existing ibd files. This situation will be a job for ibdconnect, but as long as MySQL isn’t restarted…
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
… stall” is a long-running transaction. If a transaction remains open for a very long time without committing, and has modified… the source code. The problem comes when the transaction remains open, but either it isn’t running queries anymore, or it… for lots of short, small transactions. Don’t design batch jobs that run in loops and update data, unless you make…
