by Peter Zaitsev | Dec 20, 2007 | Insight for DBAs
In MySQL 4.1 and above the longest part of recovery after crash for Innodb tables could be UNDO stage – it was happening in foreground and was basically unbound – if you have large enough transaction which needed to be undone this could take long hours....
by Andrew Aksyonoff | Dec 20, 2007 | Insight for Developers
mysql_connect() function in PHP’s MySQL interface (which for reference maps to mysql_real_connect() function in MySQL C API) has a $client_flags parameter since PHP 4.3.0. This parameter is barely known and almost always overlooked but in some cases it could...
by Peter Zaitsev | Dec 19, 2007 | Insight for Developers
MySQL Storage Engines implementing Multi Version Concurrency Control have several internal identifiers related to MVCC. I see a lot of people being confused what they are and why they are needed so I decided to take a time to explain it a bit. This is general...
by Andrew Aksyonoff | Dec 18, 2007 | Insight for Developers
Just had an interesting issue with an encoding mess on a column containing non-ASCII (Russian) text. The solution was not immediately obvious so I decided it’s worth sharing. The column (actually the whole table) was created with DEFAULT CHARSET cp1251. Most of...
by Vadim Tkachenko | Dec 16, 2007 | Percona Events
I published slides from my two talks from our Egypt company meeting. First one is about Sphinx search engine. The originally presentation was prepared by Andrew Aksenoff, author of Sphinx for HighLoad.ru conference, I translated it on English for our meeting. And...
by Peter Zaitsev | Dec 12, 2007 | Percona Events
So we’re back from the company meeting which took place last week in Hurghada, Egypt. It was a great opportunity to meet a lot of people for the first time in person to work together and have some fun. Because of charter flight schedule this was rather long...
by Peter Zaitsev | Dec 9, 2007 | Insight for DBAs
If you enable logging of all queries as “slow queries” using the patch or MySQL 5.1 you can get log file to grow huge. Same may happen with general log file. In some cases we’ve got log file sizes of 100G or more which may need to be cleaned up. Here...
by Peter Zaitsev | Nov 29, 2007 | Percona Events
Our company, Percona is even more Virtual than MySQL AB – we have no offices and 100% of staff members work out of their homes (or traveling, onsite with customers etc). We also probably have just couple of cities where more than one Employee lives. Working as a...
by Alexey Kovyrin | Nov 26, 2007 | Insight for DBAs
As Peter mentioned in one of previous posts, we’ve done huge work developing robust strategies of InnoDB data recovery to provide our customers effective data recovery services and one of major parts of these strategies is our toolkit for InnoDB data recovery....
by Peter Zaitsev | Nov 25, 2007 | Percona Events
I have now posted slides for the talk I gave in Zurich last week in MySQL Performance Presentations section. That was fun talk and fun trip in general. Thank you for inviting.
by Maciej Dobrzanski | Nov 22, 2007 | Insight for Developers
Recently I had a case with a web server farm where a random node went down every few minutes. I don’t mean any of them rebooted except once or twice, but rather they were slowing down so much that practically stopped serving any requests and were being pulled...
by Peter Zaitsev | Nov 18, 2007 | Percona Events
I’m visiting customer in Zurich next week and also was invited to give a talk on MySQL Performance Wednesday November 21. If you’re in the area please feel free to drop by I’ll start by talking about Query Optimization and we’ll keep it...
by Peter Zaitsev | Nov 18, 2007 | Insight for Developers
I was thinking today of how people tend to use MySQL in modern applications and it stroke me in many cases MySQL is not used to process the data, at least not on the large scale – instead it is used for data storage and light duty data retrieval. Even in this...
by Peter Zaitsev | Nov 13, 2007 | Insight for DBAs
People are sometimes contacting me and asking about bugs like this which provide a trivial way to crash MySQL to the user with basic privileges and asking me what to do. My answer to them is – there is nothing new to it and they just sit should back and relax 🙂...
by Peter Zaitsev | Nov 12, 2007 | Insight for DBAs
At Percona we are pleased to announce couple of services which should be helpful to MySQL Community and which are not offered by MySQL, Oracle and other companies I know about. First we now do Data Recovery for MySQL. We’re mainly focused on Innodb with this one...
by Peter Zaitsev | Nov 12, 2007 | Percona Events
Baron have been updating you a lot about chapter by chapter progress so I should not repeat it, instead I thought it would be a good idea to write a bit about how we work on the book. Generally, quite similar to the previous book this is long process, which is...
by Peter Zaitsev | Nov 7, 2007 | Insight for DBAs
To get this straight – I’m not a big fan of filtered or partial MySQL Replication (as of version MySQL 5.0) – there is enough gotchas with replication itself and getting things right with filtering can get quite bumpy road. In some applications...
by Peter Zaitsev | Nov 4, 2007 | Insight for Developers
I now got answers to the second portions of the questions you asked Heikki. If you have not seen the first part it can be found here. Same as during last time I will provide my comments for some of the answers under PZ and will use HT for original Heikkis answer. Q26:...
by Peter Zaitsev | Nov 1, 2007 | Insight for Developers
Look at this post recently published on TechCrunch – It is ugly standard 404 error message, but what is interesting is the server line which shows nginx 0.5.32 I have checked and indeed images served from assets.hulu.com have nginx server in response header....
by Maciej Dobrzanski | Oct 31, 2007 | Percona Software
Microslow patch is used by many DBAs and developers to accurately time their queries and to catch those which run less than a second as they can also be a performance killer for a busy application. Recently I have started the development of an updated version of the...
