All of Percona’s open-source software products, in one place, to download as much or as little as you need.
To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?
All of Percona’s open-source software products, in one place, to download as much or as little as you need.
How would you compress your MySQL Backup
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 arises for medium and large size databases – for databases below 100GB in size compression performance is usually not the problem (though b
Apache PHP MySQL and Runaway Scripts
All of Percona’s open-source software products, in one place, to download as much or as little as you need.
MySQL File System Fragmentation Benchmarks
All of Percona’s open-source software products, in one place, to download as much or as little as you need.
MySQL Query Cache WhiteSpace and comments
mysql> select /* my little comment */ count(*) from fact where val like "%c%"; +----------+ | count(*) | +----------+ | 0 | +----------+ 1 row in set (8.77 sec) mysql> select /* my little comment */ count(*) from fact where val like "%c%"; +----------+ | count(*) | +----------+ | 0 | +----------+ 1 row in set (0.00 sec) mysql> select /* my little comment2 */ count(*) from fact where val like "%c%"
Researching your MySQL table sizes
All of Percona’s open-source software products, in one place, to download as much or as little as you need.
RAID System performance surprises
Implementing MySQL database in 24/7 environments we typically hope for uniform component performance, or at least would like to be able to control it. Typically this is indeed the case, for example CPU will perform with same performance day and night (unless system management software decides to lower CPU frequency due to overheating). This is also almost the case with Hard Drives – there are poss
InnoDB Performance Optimization Basics
This blog is in reference to our previous ones for ‘Innodb Performance Optimizations Basics’ 2007 and 2013. Although there have been many blogs about adjusting MySQL variables for better performance since then, I think this topic deserves a blog update since the last update was a decade ago, and MySQL 5.7 and 8.0 have been released since then with some major changes. These guidelines work well for
Countless storage engines
Today everybody writes about MySQL Conference & Expo and I am not an exclusion. I am under impression of count of storage engines were presented. In good old time when Oracle bought InnoDB, MySQL did one step – announced MySQL supports Plugginable Storage Architecture. In that time nobody was able to predict what is the outcoming of such feature, but currently we all see it. Let me list Transactio
UC2007 Presentation and Notes
I can’t write I’m just back from MySQL Users Conference both because I’m still in USA visiting customers and because it has ended almost a week ago but I was too busy to write anything about it or post my presentations. This was my 5th MySQL Users Conference so I met a lot of good friends and spend more time speaking to people when expected (even though still did not speak to everyone I wanted to)
System size and Performance Optimization
Performance optimization is never ending story, you can virtually always find something else to optimize but while on generic system, not tuned by expert you often can get significant performance increase in the matter of hours further performance improvements become more and more time consuming and expensive and gains smaller. This observation does not only apply to MySQL but to systems running o
1
リリース、障害情報などのサービスのお知らせ
最新の人気エントリーの配信
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く
