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 [...]
In preparing for this month’s Percona Live MySQL Conference and Expo, I’ve been reminiscing about the annual MySQL User Conference’s history – the 9 times it previously took place in its various reincarnations – and there are a lot of good things, fun things to remember. 2003 was the year that marked the first MySQL user conference [...]
We announced a while back that we were going to continue the traditional MySQL conference in Santa Clara, because O’Reilly wasn’t doing it anymore. But we haven’t given an update in a while. Here’s the current status: We created a conference committee. We created a conference website that allows people to create an account and [...]
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…
One question which comes up very often is when one should use SAN with MySQL, which is especially popular among people got used to Oracle or other Enterprise database systems which are quite commonly deployed on SAN. My question in such case is always what exactly are you trying to get by using SAN ?
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 have a lot of customers who do click analysis, site analytics, search engine marketing, online advertising, user behavior analysis, and many similar types of work.Â The first thing these have in common is that they’re generally some kind of loggable event. The next characteristic of a lot of these systems (real or planned) is [...]
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 <firstname.lastname@example.org> | 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 <email@example.com> | GPL | |
| innodb_io_pattern.patch | Information schema table of InnoDB IO counts for each datafile pages | 1.0 | Percona <firstname.lastname@example.org> | GPL | INFORMATION_SCHEMA.INNODB_IO_PATTERN |
| microsec_process.patch | Adds INFOMATION_SCHEMA.PROCESSLIST with TIME_MS column | 1.0 | Percona <email@example.com> | GPL | |
| innodb_locks_held.patch | Add locks held, remove locked records in SHOW INNODB STATUS | 1.0 | Baron Schwartz <firstname.lastname@example.org> | GPL | Bug #29126 fix |
| microslow_innodb.patch | Extended statistics in slow.log | 1.1 | Percona <email@example.com> | GPL | |
| mysqld_safe_syslog.patch | Patch allows redirect output of error.log to syslog-ng | 1.0 | Percona <firstname.lastname@example.org> | 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 <email@example.com> | 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