Even though I didn’t go to MySQL conf this year (really sad about this), this week is gonna be most active in the community so I decided to do some community stuff too 🙂 Today I’ve released version 0.3 of our innodb recovery toolkit. Now it became much faster, stable and accurate. At this moment it is possible to recover almost any table from corrupted/deleted tablespace without so much effort as it was before. Here is a short changes list (since 0.1 announced here):
- More MySQL data types added: DECIMAL (both old and new), DATE, TIME
- CHAR data type handling improved in table definitions generator
- Indexes filtering added to page_parser
- 64-bit stat() support added to all tools
- Linux has no isnumber() function so we define our own implementation (pretty simple)
- Lots of fixes in create_defs.pl script – now it generates definitions which could recover your data in 80% cases w/o any changes.
- Min/max record size calculation fixed in constraints-based parser.
- Nullable fixed-size columns support is fixed.
- Debug logging is much cleaner now.
As always, if you need any help with your recovery, we would love to help.
I’m returned from my 1-week vacation today and want to say – I’ve never been so productive as I was there 😉 Blue ocean, hot sun and white sand really helped me to finish my work on the first release of one really awesome project.
Today I’m proud to announce our first public release of the Data Recovery Toolkit for InnoDB – set of tools for checking InnoDB tablespaces and recovering data from damaged tablespaces or from dropped/truncated InnoDB tables.
Read the rest of this entry →
[lang_en]
At this week I came across great blog of Peter Zaitsev and Vadim Tkachenko – two developers from High Performace Group at MySQL Inc. This blog’s name is MySQL Performance Blog and, as you probably assume, it is about misscelaneous sides of MySQL optimization and related stuff. So, if you are MySQL administrator or, even, developer, that works with MySQL, I would advise you to take a look at this blog – there are lots of useful MySQL optimization info.
[/lang_en]
[lang_ru]
На этой неделе я случайно наткнулся на отличный ресурс Петра Зайцева и Вадима Ткаченко – двоих разработчиков из High Performace Group в MySQL Inc. Их блог называется MySQL Performance Blog и, как Вы уже могли догадаться, в нем рассказывается о различных аспектах оптимизации MySQL и различных вещах, относящихся к оптимизации. Потому, если вы являетесь администратором MySQL или, просто, разработчиком, работающим с MySQL, я хочу настоятельно порекомендовать Вам взглянуть на этот блог – там очень много полезной информации по оптимальной работе с MySQL.
[/lang_ru]