by Peter Zaitsev | Aug 22, 2008 | Benchmarks, Insight for DBAs
(There is an updated version of the content in this post by Percona’s Stephane Combaudon available here.) After my previous post there were questions raised about Index Merge on Multiple Indexes vs Two Column Index efficiency. I mentioned in most cases when...
by Peter Zaitsev | Aug 21, 2008 | Insight for DBAs
Quite common beginners mistake is not to understand how indexing works and so index all columns used in the queries…. separately. So you end up with table which has say 20 indexes but all single column ones. This can be spotted with a glance view. If you have...
by Peter Zaitsev | Aug 21, 2008 | Hardware and Storage
So you need to design highly available MySQL powered system… how do you approach that ? Too often I see the question is approached by focusing on expensive hardware which in theory should be reliable. And this really can work quite well for small systems. It is...
by Peter Zaitsev | Aug 18, 2008 | Insight for Developers
Today I worked on rather interesting customer problem. Site was subject what was considered DDOS and solution was implemented to protect from it. However in addition to banning the intruders IPs it banned IPs of web services which were very actively used by the...
by Baron Schwartz | Aug 18, 2008 | Insight for DBAs
There are quite a few “tuning primers” and “my.cnf generators” and “sample my.cnf files” online. The ultimate tool for generating an optimal my.cnf is not a tool. It’s a human with many years of experience, deep knowledge of...
by Peter Zaitsev | Aug 12, 2008 | Insight for DBAs
Today I was working with the client loading data to MyISAM tables at very high rate. Hundreds of millions rows are loaded daily into single MySQL instance with bursts up to 100K of records/sec which need to be inserted (in the table with few indexes). It was good not...
by Peter Zaitsev | Aug 11, 2008 | Percona Events
I should be faster with publishing slides but things are how they are. The slides from my OSCON2008 talk are now published at Percona Presentation Pages. Enjoy 🙂
by Peter Zaitsev | Aug 9, 2008 | Insight for Developers
Quite commonly in applications, you would need to use some kind of “status” field – the status of an order – “new”, “confirmed”, “in production”, “shipped” status of a job, message, etc. People...
by Peter Zaitsev | Aug 8, 2008 | Percona Events
Wow!. New MySQL Community release – MySQL 5.0.67 is just out which as manual says first community release since 5.0.51b. I just recently complained about community release irregularity and I’m glad to see the new release after all. I only hope this will...
by Peter Zaitsev | Aug 7, 2008 | Insight for DBAs
One common question I guess is how much should I see performance improved in case I increase memory say from 16GB to 32GB. The benefit indeed can be very application dependent – if you have working set of say 30GB with uniform data access raising memory from...
by Peter Zaitsev | Aug 6, 2008 | Percona Events
People are asking me if Percona will support Drizzle and what is in general our position regarding this project. First about Support. We surely will support the customers if they select to run the Drizzle instead of MySQL Server. For us it is same as supporting MySQL...
by Peter Zaitsev | Aug 4, 2008 | Hardware and Storage
I did not usually go to “Elite” servers on Dell web site but looking at customers system today I went to check Dell Poweredge R900. This monster takes up to 4 Quad Core CPUs and has 32 memory slots, which allows to get 128GB of memory with 4GB of memory...
by Baron Schwartz | Aug 4, 2008 | Insight for Developers
We recently examined a customer’s system to try to speed up an ETL (Extraction, Transformation and Loading) process for a big data set into a sort of datamart or DW. What we typically do is ask customers to run the process in question, and then examine...
by Evgeniy Firsov | Aug 4, 2008 | Percona Software
Recently, we added information schema support to Google’s userstats patch. There are three information schema tables added: user_statistics, table_statistics, index_statistics. One can now use select * from information_schema.user_statistics along with show...
by Peter Zaitsev | Aug 2, 2008 | Insight for DBAs
Quite frequently I see customers looking at MySQL recovery as on ability to restore data from backup which can be far from being enough to restore the whole system to operating state, especially for complex systems. Instead of looking just at data restore process you...
by Peter Zaitsev | Aug 2, 2008 | Insight for DBAs
Have you ever seen the replication stopped with message like this: Last_Error: Could not parse relay log event entry. The possible reasons are: the master’s binary log is corrupted (you can check this by running ‘mysqlbinlog’ on the binary log), the...
by Peter Zaitsev | Aug 1, 2008 | Insight for Developers
JOINs are expensive and it most typical the fewer tables (for the same database) you join the better performance you will get. As for any rules there are however exceptions 🙂 The one I’m speaking about comes from the issue with MySQL optimizer stopping using...
by Peter Zaitsev | Aug 1, 2008 | Percona Events
July 31st 2006 was my last day working for MySQL and August 1st I started what later was incorporated Percona with Vadim joining me September 1st as co-founder. Two years is a significant anniversary for any startup – surviving (and being profitable) for 2 years...
by Vadim Tkachenko | Jul 31, 2008 | Percona Software
We prepared RPMs of our release for RedHat 5 / CentOS 5 x86_64 platform. https://www.percona.com/blog/mysql/RPM/RHEL5/5.0.62/ There was question what patcheset includes and if there is manuals. We have: microsecond resolution in slow-log extended query plan in...
by Baron Schwartz | Jul 30, 2008 | Insight for DBAs
I use Maatkit for a lot of grunt work and thought you might appreciate this quick tip. Suppose you have a bazillion tables to convert from MyISAM to InnoDB, but they are mixed in with other tables that are already InnoDB, or are another storage engine that you...
