by Pablo Svampa | Apr 30, 2025 | Benchmarks, Insight for DBAs, Insight for Developers, PostgreSQL
Indexing is one of PostgreSQL’s most effective tools for improving query performance, but like any powerful tool, it can cause real problems when overused. A while ago, my colleague Jobin wrote a blog post exploring the negative side effects of over-indexing in...
by Roberto De Bem | Feb 26, 2025 | Insight for DBAs, MySQL
Typically, we receive customer tickets regarding crashes or bugs, where we request a core dump to analyze and identify the root cause or understand the unexpected behavior. To read the core dumps, we also request the linked libraries used by the server’s MySQL....
by Peter Zaitsev | Jun 1, 2023 | Insight for Developers, MySQL
Updated June 1, 2023. Suboptimal MySQL ORDER BY implementation, especially together with MySQL LIMIT is often the cause of MySQL performance problems. Here is what you need to know about MySQL ORDER BY LIMIT optimization to avoid these problems. Try Now: Free your...
by Colin Charles | Jun 8, 2018 | MariaDB, MongoDB, MySQL, Storage Engine
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Some big news out from Microsoft about their acquisition of GitHub for $7.5 billion. GitHub hosts many projects, including...
by Dave Avery | Feb 22, 2018 | Insight for DBAs, Insight for Developers, MySQL, Percona Live
Welcome to the first interview blog for the upcoming Percona Live 2018. Each post in this series highlights a Percona Live 2018 featured talk that will be at the conference and gives a short preview of what attendees can expect to learn from the presenter. This blog...
by Michael Coburn | Feb 6, 2018 | Monitoring, MySQL, Open Source, Percona Software
In this blog post, we’ll introduce how you can look at some experimental Percona Monitoring and Management (PMM) features using Percona Labs builds on GitHub. Note: PerconaLabs and Percona-QA are open source GitHub repositories for unofficial scripts and tools...
by Evgeniy Patlan | Jan 20, 2017 | Insight for Developers, MySQL
In this blog, we’ll look at how to manually build Percona Server for MySQL RPM packages. Several customers and other people from the open source community have asked us how they could make their own Percona Server for MySQL RPM binaries from scratch. This...
by Dave Rosenlund | Dec 10, 2014 | MySQL
Want to tweet out a personalized holiday video to your friends? Heckenlights is a Christmas lights installation playing Christmas songs that lets viewers customize and share it. Heckenlights was created by software developer Mark Paluch (@mp911de) who thought it was...
by Peter Zaitsev | Jan 30, 2014 | MySQL, Percona Events, Percona Live
The Percona Live MySQL Conference and Expo 2014 is just two months away. I’m very excited about this year’s event which continues our tradition of open technical discussions and inviting all parties to the table. We have a great amount of technical talks...
by Stewart Smith | Sep 27, 2013 | MySQL, Percona Software
I recently blogged on setting up Experimental Git mirror of Oracle MySQL trees up on GitHub. I’m now happy to announce that there are also mirrors for: Percona Server Percona XtraBackup Percona Playback I’ve also updated the Oracle MySQL GIT mirror to...
by Aurimas Mikalauskas | Oct 29, 2007 | Insight for DBAs
Suppose you want to remove auto_increment from 100G table. No matter if it’s InnoDB or MyISAM, you’d usually ALTER TABLE huge_table CHANGE id id int(6) NOT NULL and then wait hours for table rebuild to complete. If you’re unlucky i.e. you have a lot...
by Peter Zaitsev | Oct 26, 2007 | Insight for Developers
Its almost a month since I promised Heikki Tuuri to answer Innodb Questions. Heikki is a busy man so I got answers to only some of the questions but as people still poking me about this I decided to publish the answers I have so far. Plus we may get some interesting...
by Peter Zaitsev | Oct 26, 2007 | Percona Events
What is the difference between “MySQL Support” and “Support for MySQL” ? In my mind there is not much difference in meaning just first one is shorter and I would use it also because how people would search stuff in Google. It turns out however...
by Peter Zaitsev | Oct 26, 2007 | Percona Events
Try number two. We have moved to the new server yet again, now it is server hosted by ServerBeach as recommended by Kevin Burton and few other guys. Lets hope this will run stable and we’ll not need to move it back in emergency in less than a week as we had to...
by Peter Zaitsev | Oct 24, 2007 | Percona Events
OK, I am not getting too much people feedback on what would they like to hear about on MySQL Users Conference, so I went ahead and submitted few presentation ideas. I do not expect all of them would be accepted, furthermore it would be hard to prepare so many good...
by Peter Zaitsev | Oct 24, 2007 | Percona Events
About three months ago I announced ClickAider to become available to general public. And I think it is about the time to write about the progress we have with this project for those who interested. The project generates decent interest and we have about 3000 sites...
by Peter Zaitsev | Oct 22, 2007 | Percona Events
If you have been MySQL User for many years you might remember the times when MySQL had “zero bugs policy”, this is when all known bugs really were fixed before release was made. To be honest at that time bugs were reported via bugs mailing list not via...
by Peter Zaitsev | Oct 22, 2007 | Percona Events
It is submission time now, with about one week left till proposal submission deadline. Both me and Vadim had submitted few talks to the Grand Jury which will make elite selection of sessions for MySQL Users Conference and we plan to submit few more. Our experience in...
by Peter Zaitsev | Oct 17, 2007 | Percona Events
I already wrote once about hosting troubles which we had with this site a while back. Today we had another trouble to one of the European hit servers for ClickAider project. We had purchased this 1and1 server few months ago, before we were running into troubles and as...
by Peter Zaitsev | Oct 17, 2007 | Insight for Developers
One of the first rules you would learn about MySQL Performance Optimization is to avoid using functions when comparing constants or order by. Ie use indexed_col=N is good. function(indexed_col)=N is bad because MySQL Typically will be unable to use index on the column...
