by Baron Schwartz | Jun 24, 2008 | Percona Events
If you’re a Perl and/or Python expert (preferably both), Percona may have a job for you. We’re looking to either hire or sponsor significant development efforts for some open-source tools for MySQL, including but not limited to Maatkit and the...
by Baron Schwartz | Jun 23, 2008 | Insight for DBAs
How many of you use the MySQL command-line client? And did you know about the pager command you can give it? It’s pretty useful. It tells MySQL to pipe the output of your commands through the specified program before displaying it to you. MySQL Command-line...
by Vadim Tkachenko | Jun 22, 2008 | Percona Events
Why one may wonder, it’s just Swedish beer (State of Doplhin, MySQL UC 2006). One week ago Jim Starkey sent message http://www.firebirdnews.org/?p=1742 so he will not work for MySQL anymore and starting new project. While that’s fully Jim Starkey’s...
by Vadim Tkachenko | Jun 17, 2008 | Insight for Developers
We often recommend to set lighttpd in front of apache to handle http requests (more about https://www.percona.com/blog/speedup-your-lamp-stack-with-lighttpd/ ) , redirect dynamic requests to apache and handle static files by itself. I just gathered step-by-step...
by Peter Zaitsev | Jun 13, 2008 | Percona Events
I should have written about it a while ago but I never had a change. I’m speaking at Velocity conference taking place in the Bay Area 23-24 of June. At the same conference we will have a book signing event for our book High Performance MySQL 2nd Edition which is...
by Peter Zaitsev | Jun 9, 2008 | Hardware and Storage
We know MySQL Backups using LVM are pretty cool (check out mylvmbackup) or MMM though it is quite typical LVM is not configurable properly to be usable for MySQL Backups. Quite frequently I find LVM installed on the system but no free space left to be used as snapshot...
by Peter Zaitsev | Jun 5, 2008 | Insight for DBAs
Backing up MySQL Database most people compress them – which can make a good sense in terms of backup and recovery speed as well as space needed or be a serious bottleneck depending on circumstances and approach used. First I should mention this question mainly...
by Peter Zaitsev | Jun 4, 2008 | Insight for DBAs
I already wrote about some MySQL Error Messages which are confusing, here is one more: 080603 20:53:10 [Note] Slave: connected to master '[email protected]:3306',replication resumed in log 'master-bin.003676' at position 444286437 080603 20:53:10 [Note] Slave: received...
by Peter Zaitsev | Jun 2, 2008 | Uncategorized
I was working with the customer today investigating MySQL over DRBD performance issues. His basic question was why there is so much overhead with DRBD in my case, while it is said there should be no more than 30% overhead when DRBD is used. The truth is –...
by Peter Zaitsev | May 31, 2008 | Insight for DBAs
There are some tools we commonly use doing performance review and optimization and we often ask each other where that particular stuff is located on the web or what is exactly name of the command what does that. Initially I thought creating internal Percona Wiki page,...
by Baron Schwartz | May 31, 2008 | Insight for DBAs
Do you have skip_name_resolve set in your /etc/my.cnf? If not, consider it. DNS works fine, until it doesn’t. Don’t let it catch you off guard. Do you really need to restrict MySQL users based on hostnames? If you don’t, you should probably disable...
by Peter Zaitsev | May 28, 2008 | Insight for DBAs
MySQL Server does not require you to specify name of the index if you’re running ALTER TABLE statement – it is optional. Though what might be good practical reasons to specify the key name or omit ? Things what you should be looking at is how MySQL names...
by Baron Schwartz | May 26, 2008 | Insight for DBAs
A while ago I wrote about how to make MySQL replication reliable, part of which is to eliminate temporary tables. The idea is this: if a slave is stopped (or crashed) while a temporary table is open and is then restarted, the temporary table doesn’t exist...
by Baron Schwartz | May 24, 2008 | Insight for DBAs
Much has been written about the new InnoDB pluggable storage engine, which Innobase released at the MySQL conference last month. We’ve written posts ourselves about its fast index creation capabilities and the compressed row format, and how that affects...
by Peter Zaitsev | May 24, 2008 | Insight for DBAs
I’m not big fan on flow control functions like IF or CASE used in MySQL Queries as they are often abused used to create queries which are poorly readable as well as can hardly be optimized well by MySQL Optimizer. One way I find IF statement very useful is...
by Peter Zaitsev | May 20, 2008 | Insight for Developers
Sometimes due to programming error or due to very complex query you can get your PHP script running too long, well after user stopped waiting for the page to render and went browsing other sites. Looking at Server-Status I’ve seen scripts executing for hours...
by Vadim Tkachenko | May 20, 2008 | Insight for DBAs
Remembering that I did RENAME DATABASE in MySQL 5.1.21 and found it useful I tried it with 5.1.24 (I was playing with 20GB InnoDB database, so dumping is not fastest way) and all my tries finished with “Syntax error”. So RTMF and documentation says...
by Peter Zaitsev | May 18, 2008 | Insight for DBAs
Quite frequently I would log in to customers system and find MySQL using too much memory. I would look at memory consumed by Innodb (it is often higher than innodb_buffer_pool_size) substract memory used by other global buffers such as query_cache_size and key_buffer...
by Baron Schwartz | May 14, 2008 | Insight for DBAs
Recently I had an interesting surprise with concurrent inserts into a MyISAM table. The inserts were not happening concurrently with SELECT statements; they were blocking and the process list was filling up with queries in Locked status. My first thought was that the...
by Peter Zaitsev | May 13, 2008 | Percona Events
Looking at Kaj’s Blog Annoucement MySQL has pulled back on the plans to release portions of the servers as close Source only. I am extremely happy to hear these news ! This is good for MySQL as a company, MySQL customers and MySQL users. I’m hoping...
