Yesterday I’ve attended MySQL Customers Conference in London. This event is much smaller size than Users Conference (one day and about 170 people attending) and surely less geeky – there were no one from MySQL Development Support or Consulting teams and Sales Engineers were as close as you could get. Though Anders Karlsson and Ivan […]
To recover a dropped or corrupt table with Percona Data Recovery Tool for InnoDB you need two things: media with records(ibdata1, *.ibd, disk image, etc.) and a table structure. Indeed, there is no information about the table structure in an InnoDB page. Normally we either recover the structure from .frm files or take it from […]
Can Shard-Query scale to 20 nodes? Peter asked this question in comments to to my previous Shard-Query benchmark. Actually he asked if it could scale to 50, but testing 20 was all I could due to to EC2 and time limits. I think the results at 20 nodes are very useful to understand the performance: […]
Following on from our earlier announcement, Paul McCullagh has responded with the answers to your questions – as well as a few I gathered from other Percona folks, and attendees of OpenSQL Camp. Thank you Paul! Whatâ€™s the “ideal” use case for the PBXT engine, and how does it compare in performance? Â When would I […]
The Percona team has kept on expanding. We are very pleased to announce the addition of Morgan Tocker and Matt Yonkovit!
Morgan has been with us for a while. Before joining Percona, Morgan worked as a Technical Instructor for MySQL (and then Sun Microsystems) in…1990′s as a DBA, System Administrator, and all around techie. Before joining Percona, Matt worked at MySQL and Sun Microsystems as a Solution Architect helping to…. He will be a valuable member of both our consulting and development teams.
Morgan and Matt, a big welcome â€” we are fortunate indeed that youâ€™re…
As we’ve said before, the Percona team just keeps growing. This time around, I’m pleased to welcome Ryan and Vladimir.
Ryan Lowe initially joined us from Florida (USA) in June. In his …a consultant, DBA (with Oracle, too!), DBA manager, and programmer makes him a great match for Percona‘s clients. He also contributed some improvements to Wordpress, and he blogs here and on Pablowe.
…and Ryan, a big welcome — we are fortunate indeed you’re working with us. And… go team!
PS: I can’t help but triple-dip, and point out that our own Ewen Fortune has …
We made new binaries for MySQL 5.0.67 build 7 which include patches we recently announced. The -percona release includes:
| innodb_check_defrag.patch | Session status to check fragmentation of the last InnoDB scan | 1.0 | Percona <email@example.com> | GPL | The names are Innodb_scan_* |
| userstatsv2.patch | SHOW USER/TABLE/INDEX statistics | V2 | Google | GPL | Added INFORMATION_SCHEMA.*_STATISTICS |
| show_patches.patch | SHOW PATCHES | 1.0 | Jeremy Cole | N/A | |
| innodb_io_patches.patch | Cluster of past InnoDB IO patches | 1.0 | Percona | GPL | This patch contains fixed (control_flush_and_merge_and_read, control_io-threads, adaptive_flush) |
| innodb_show_hashed_memory.patch | Adds additional information of InnoDB internal hash table memories in SHOW INNODB STATUS | 1.0 | Percona <firstname.lastname@example.org> | GPL | |
| innodb_io_pattern.patch | Information schema table of InnoDB IO counts for each datafile pages | 1.0 | Percona <email@example.com> | GPL | INFORMATION_SCHEMA.INNODB_IO_PATTERN |
| microsec_process.patch | Adds INFOMATION_SCHEMA.PROCESSLIST with TIME_MS column | 1.0 | Percona <firstname.lastname@example.org> | GPL | |
| innodb_locks_held.patch | Add locks held, remove locked records in SHOW INNODB STATUS | 1.0 | Baron Schwartz <email@example.com> | GPL | Bug #29126 fix |
| microslow_innodb.patch | Extended statistics in slow.log | 1.1 | Percona <firstname.lastname@example.org> | GPL | |
| mysqld_safe_syslog.patch | Patch allows redirect output of error.log to syslog-ng | 1.0 | Percona <email@example.com> | GPL | Ported from Debian |
| innodb_fsync_source.patch | Information of fsync callers in InnoDB | 1.0 | Google | GPL | |
| innodb_show_bp.patch | show innodb buffer pool content | 1.0 | Percona <firstname.lastname@example.org> | GPL | |
and -percona-highperf release additionaly includes
| split_buf_pool_mutex_fixed_optimistic_safe.patch | InnoDB patch to fix buffer pool scalability | 1.0 | Yasufumi Kinoshita | BSD | |
| innodb_rw_lock.patch | Fix of InnoDB rw_locks | 1.0 | Yasufumi Kinoshita | BSD |
You can download RPMs for RedHat / CentOS 4.x and 5.x for x86_64, binaries, sources and patches there
Do you know that there are two limits about dirty (modified but not flushed to disk) blocks of InnoDB buffer pool? One is the limit of “amount”. The other is the limit of “age”. – limit of “amount” – As you know, buffer pool of InnoDB works as write-back cache of its datafiles. If the […]
In the previous post I mentioned a way I use to preload Clustered Index (data) for Innodb tables. Though I thought this topic would benefit from a bit more information. But lest first start with feature request for Innodb Team: All ways I mention here are hacks and they can’t be as efficient as native […]
Let us talk few more about disks. You might have read my previous post and Matt’s Reply and it looks like there are few more things to clarify and explain. Before I get to main topic of the article lets comment on IO vs Disk question. If you look at Disk Based databases all data […]