Jan
05
2011
--

Announcing Percona Live: San Francisco February 16th

Today we’re announcing Percona Live – a one day event to be held at the Bently Reserve on February 16th in San Francisco.  Live is our way of showcasing some of the awesome work that has been going into MySQL recently – and the theme of this event is Beyond MySQL 5.1.

Our first guest speaker is none other than Jeremy Zawodny.  Jeremy is well known in the MySQL community having been the original author of High Performance MySQL 1st Ed.  He will be presenting on how Craigslist has already upgraded to MySQL 5.5 – and are running on Fusion-io SSDs in production.

Tickets are available for early bird registration at $50.  To signup, or for more information please visit the percona website.


Entry posted by Morgan Tocker |
One comment

Add to: delicious | digg | reddit | netscape | Google Bookmarks

Jan
03
2011
--

Speaking on MySQL/PHP Meetup in Charlotte, NC

I’m speaking at MySQL/PHP Meetup at Charlotte,NC next week with topic being Scaling MySQL Applications. We will have a presentation probably for about an hour and the good amount of time for questions. So come prepared.

Great thanks to Red Ventures, LLC for help organizing and sponsoring this event. I’m hearing there are going to be a door prizes, some snacks and drinks available on this event.


Entry posted by Peter Zaitsev |
No comment

Add to: delicious | digg | reddit | netscape | Google Bookmarks

Dec
30
2010
--

Percona Welcomes Sasha Pachev

Percona is pleased to officially (and belatedly) welcome Sasha Pachev to our team of consultants.

Before joining Percona, Sasha worked as an independent MySQL consultant. Sasha was the original implementer and maintainer of MySQL replication from 3.23 to 4.02. He is also the author of MySQL Enterprise Solutions and Understanding MySQL Internals.

Sasha, a big welcome – we are fortunate indeed you’re working with us!


Entry posted by Ryan Lowe |
No comment

Add to: delicious | digg | reddit | netscape | Google Bookmarks

Dec
29
2010
--

Percona Server 5.1.53-12.4

Percona Server version 5.1.53-12.4 is now available for download. It is now the current stable release version.

Functionality Added or Changed

  •  Percona Server 5.1.53-12.4 is based on MySQL 5.1.53.
  •  New Features Added:
    • Precompiled UDFs for Maatkit (FNV and MurmurHash hash functions to provide faster checksums) are now included in distributions. Fixes feature request #689992. (Aleksandr Kuzminsky)
  •  Other Changes:
    • innodb_doublewrite_file – It’s no longer necessary to recreate your database and InnoDB system files when a dedicated file to contain the doublewrite buffer is specified. (Yasufumi Kinoyasu)

Bugs Fixed

  • Bug #643149 – Slow query log entries were not written in the usual parsing format. (Alexey Kopytov)
  • Bug #671764innochecksum wasn’t distributed with RPM and .DEB packages. (Aleksandr Kuzminsky)
  • Bug #673426 – Use of these system variables as command-line options could cause a crash or undefined behavior: log_slow_timestamp_every, log_slow_sp_statements, slow_query_log_microseconds_timestamp, use_global_long_query_time. (Oleg Tsarev)
  • Bug #673567 – Compiler could produce spurious warnings when building on non_Linux platforms. A check is now made to see if clock_gettime() is present in librt at the configure stage. If yes, -lrt is added to LIBS. (Alexey Kopytov)
  • Bug #673929 – Query cache misses were being reported for some queries when hits were actually occurring. (Oleg Tsarev)
  • Bug #676146 – The development environment test of log_slow_verbosity=innodb on a slave for row-based replication was not working correctly. (Oleg Tsarev)
  • Bug #676147, Bug #676148 – The development environment tests of options log_slow_slave_statements and use_global_long_query_time work only on statement-based replication. They were failing when row-based replication was attempted. A check is now made for the replication type to test. (Oleg Tsarev)
  • Bug #676158 – Setting the query cache size to 512M caused test failure on low memory systems. (Aleksandr Kuzminsky)
  • Bug #677407 – The innodb.innodb_information_schema test could fail sporadically due to flawed logic in the INFORMATION_SCHEMA.INNODB_LOCKS caching mechanism. (contributed by Kristian Nielsen) (Alexey Kopytov)
  • Bug #681486 – A dependency between Debian packages libmysqlclient16 and percona-server-common was removed. (Aleksandr Kuzminsky)
  • Bug #693415 – The test percona_innodb_buffer_pool_shm was failing. It should be run with the --big-test option. As the buffer pool size used in the test is 128M, the shared memory segment should be increased appropriately in order to run the test successfully. (Aleksandr Kuzminsky)
  • Bug #693814, Bug #693815, Bug #693816, Bug #693817, Bug #693819 – Tests in the test environment were updated to reflect past INFORMATION_SCHEMA changes. (Aleksandr Kuzminsky)
  • Bug #693818 – Warning and error messages for stored routines could incorrectly report row numbers due to a change in the slow_extended patch. (Alexey Kopytov)

The Release Notes for this and previous releases can be found in our Wiki.

Downloads are available here and from the Percona Software Repositories. The latest source code for Percona Server, including the development branch, can be found on Launchpad.

Please report any bugs found at Bugs in Percona Server.

For general questions, use our Percona Discussions Group, and for development questions our Percona Development Group.

For support, commercial, and sponsorship inquiries, contact Percona.


Entry posted by Fred Linhoss |
No comment

Add to: delicious | digg | reddit | netscape | Google Bookmarks

Dec
16
2010
--

Percona Server 5.1.53-11.7

Percona Server version 5.1.53-11.7 is now available for download.

The main purpose of this release is to update the current Percona stable release to the latest version of MySQL 5.1.

Functionality Added or Changed

  •  Percona Server 5.1.53-11.7 is now based on MySQL 5.1.53.
  •  New Features Added: None
  •  Other Changes: None

Bugs Fixed

  • Bug #643149 – Slow query log entries were not being done in the usual parsing format. (Alexey Kopytov)
  • Bug #677407 – The innodb.innodb_information_schema test could fail sporadically due to flawed logic in the INFORMATION_SCHEMA.INNODB_LOCKS caching mechanism. (Alexey Kopytov)

Release Notes for this and previous releases can be found in our Wiki.

Downloads are available here and from the Percona release repositories. The latest source code for Percona Server, including the development branch, can be found on Launchpad.

Please report any bugs found at Bugs in Percona Server.

For general questions, use our Percona Discussions Group, and for development questions our Percona Development Group.

For support, commercial, and sponsorship inquiries, contact Percona.


Entry posted by Fred Linhoss |
2 comments

Add to: delicious | digg | reddit | netscape | Google Bookmarks

Dec
13
2010
--

Percona Training in London and Frankfurt

For those that missed it – last week we added training in Frankfurt and London to our website.  This includes our new Operations Training announced in September.

(While in Europe, we’d love to speak at your meetup group on Percona Server and/or MySQL Optimization.  If you’re a meetup organizer in London or Paris, please feel free to get in touch.)


Entry posted by Morgan Tocker |
No comment

Add to: delicious | digg | reddit | netscape | Google Bookmarks

Dec
13
2010
--

Percona Server 5.1.52-12.3

Percona Server version 5.1.52-12.3 is now available for download.

The main purpose of this release is to update the current Percona release candidate to the latest version of MySQL 5.1. The release also includes the HandlerSocket plugin, which provides NoSQL features in Percona Server.

Functionality Added or Changed

  • Percona Server 5.1.52-12.3 is now based on MySQL 5.1.52.
  • New Features Added:
    • HandlerSocket plugin support has been added to all RPM and Debian packages. This is an experimental feature. (Inada Naoki, DeNA Co., Ltd.)
    • show_slave_status_nolock – Allows examination of slave status even when a lock prevents SHOW SLAVE STATUS from operating. (Oleg Tsarev)
    •  innodb_fast_shutdown – Sleeping threads could cause a delay of up to 10 seconds during InnoDB shutdown. The sleeping state of threads was made interruptible to avoid this. (contributed by Kristian Nielsen) (Alexey Kopytov)
  • Other Changes: None

Bugs Fixed

  • Bug #640576 – The false error “innodb_extra_undoslots option is disabled but it was enabled before” was sometimes reported after upgrading from MySQL 5.0. (Yasufumi Kinoyasu)
  • Bug #643463 – Shutting down XtraDB could take up to 10 seconds, even when there was no actual work to do. (Fix contributed by Kristian Nielsen) (Alexey Kopytov)
  • Bug #663757 – On the FreeBSD platform, the “gcc atomic built-in” function isn’t provided, so response_time_distribution now uses the native atomic API on FreeBSD. (Oleg Tsarev)
  • Bug #673426 – Use of some system variables as command-line options caused a crash or undefined behavior. (Oleg Tsarev)
  • Bug #673562 – Debug build was broken due a to failing compile-time assertion in mysqld.cc. (Alexey Kopytov)
  • Bug #673567 – Compiler could produce spurious warnings when building on non-Linux platforms. A check is now made to see if clock_gettime() is present in librt at the configure stage. If yes, -lrt is added to LIBS. (Alexey Kopytov)
  • Bug #673929 – Query cache misses were being reported for some queries when hits were actually occurring. (Oleg Tsarev)
  • Bug #676146 – The development environment test of log_slow_verbosity=innodb on a slave for row-based replication was not working correctly. (Oleg Tsarev)
  • Bug #676147 – The development environment test of option log_slow_slave_statements for row-based replication was not working correctly. (Oleg Tsarev)
  • Bug #676148 – Similar to Bug #676147. A check is now made for the replication type to test. (Oleg Tsarev)

The Release Notes for this and previous releases can be found in our Wiki.

Downloads are available here and from the Percona Release Candidates Repository. The latest source code for Percona Server, including the development branch, can be found on LaunchPAD.

Please report any bugs found at Bugs in Percona Server.

For general questions, use our Percona Discussions Group, and for development questions our Percona Development Group.

For support, commercial, and sponsorship inquiries, contact Percona.


Entry posted by Fred Linhoss |
2 comments

Add to: delicious | digg | reddit | netscape | Google Bookmarks

Dec
13
2010
--

Percona XtraBackup 1.5-Beta

Percona XtraBackup 1.5-Beta is now available for download.

This release adds additional functionality to Percona XtraBackup 1.4, the current general availability version of XtraBackup.

This is a beta release.

Functionality Added or Changed

  • Support for MySQL 5.5 databases has been implemented. (Yasufumi Kinoshita)
  • XtraBackup can now be built from the MySQL 5.1.52, MySQL 5.5.7, or Percona Server 5.1.53-12 code bases (fixes bug #683507). (Alexey Kopytov)
  • The program is now distributed as three separate binaries: 
    • xtrabackup – for use with Percona Server with the built-in InnoDB plugin
    • xtrabackup_51 – for use with MySQL 5.0 & 5.1 with built-in InnoDB
    • xtrabackup_55 – for use with MySQL 5.5 (this binary is not provided for the FreeBSD platform)
  • Backing up only specific tables can now be done by specifying them in a file, using the --tables-file option. (Yasufumi Kinoyasu & Daniel Nichter)
  • Additional checks were added to monitor the rate the log file is being overwritten, to determine if XtraBackup is keeping up. If the log file is being overwritten faster than XtraBackup can keep up, a warning is given that the backup may be inconsistent. (Yasufumi Kinoyasu)
  • The XtraBackup binaries are now compiled with the -O3 gcc option, which may improve backup speed in stream mode in some cases.
  • It is now possible to copy multiple data files concurrently in parallel threads when creating a backup, using the --parallel option. See the xtrabackup Option Reference and Parallel Backups. (Alexey Kopytov)

Bugs Fixed

  • Bug #683507 – xtrabackup has been updated to build from the MySQL 5.1.52, MySQL 5.5.7, or Percona Server 5.1.53-12 code bases. (Alexey Kopytov)

Release Notes for this and previous releases of Percona Xtrabackup can be found in our Wiki.

The latest downloads are available on our website. The latest source code can be found on Launchpad.

Please report any bugs found at Bugs in Percona XtraBackup.

For general questions, use our Percona Discussions Group, and for development questions our Percona Development Group.

For support, commercial, and sponsorship inquiries, contact Percona.


Entry posted by Fred Linhoss |
4 comments

Add to: delicious | digg | reddit | netscape | Google Bookmarks

Dec
07
2010
--

Speaking at MySQL Meetup event in NYC, December 15

I’m going to be in NY next week and as part of the meeting I agreed to speak on New York MySQL Meetup. I’m going to speak about
Scaling MySQL driven applications by us of caching, replication, sharding and other technologies. Hope to see you there.


Entry posted by Peter Zaitsev |
No comment

Add to: delicious | digg | reddit | netscape | Google Bookmarks

Dec
01
2010
--

Doing Re-run of Migrating MyISAM to Innodb Webinar

We had some technical difficulties with Webex today which prevented from all registered attendees to be able to join webinar. I personally would be very upset having booked my time to attend event, pre-registered to ensure there is a space available and when unable to join at the time of event (which is frankly exactly what happened to me).

As result we have scheduled Migrating MyISAM to Innodb webinar to run again on Tuesday, December 7 at 9AM Pacific (Same Time). Here is direct link if you would like to register.

Note we also Webinar on Percona Server, Xtrabackup and XtraDB next week which is great if you would like to learn more about any of these technologies.


Entry posted by Peter Zaitsev |
9 comments

Add to: delicious | digg | reddit | netscape | Google Bookmarks

Powered by WordPress | Theme: Aeros 2.0 by TheBuckmaker.com