PlanetMysql.ru – информация о СУБД MySQL

Dear Community,

Percona Server 5.0.90, build 21 is available for use.

Comparing to the previous release it has following new features:

• The build is based on MySQL-5.0.90
• The name of the packages are changed to Percona-SQL-server, Percona-SQL-client, etc.

Fixed bugs:

• Fixed Bug #539190
• Fixed Bug #479106
• Fixed tests mysql, mysql_upgrade, ssl*

See release notes for earlier changes.

RPMs and DEB packages are available in Percona repository.

As usual you can download binaries and sources with the patches from Percona web site.

To upgrade from MySQL server to Percona SQL you need remove MySQL installation first, then install Percona-SQL-server and Percona-SQL-client:

If you are running applications which depend on libmysqlclient, install  Percona-SQL-shared-compat

before removing MySQL

The Percona Server lives on Launchpad : https://launchpad.net/percona-server and you can report bug to Launchpad bug system:

https://launchpad.net/percona-server/+filebug. The documentation is available on our Wiki

For general questions use our Pecona-discussions group, and for development question Percona-dev group.

For support, commercial and sponsorship inquiries contact Percona.

innodb_rw_lock.patch

Entry posted by Aleksandr Kuzminsky | No comment

Add to: | | | |

Dear Community,

Percona Server 5.0.90, build 21 is available for use.

Comparing to the previous release it has following new features:

• The build is based on MySQL-5.0.90
• The name of the packages are changed to Percona-SQL-server, Percona-SQL-client, etc.

Fixed bugs:

• Fixed Bug #539190
• Fixed Bug #479106
• Fixed tests mysql, mysql_upgrade, ssl*

See release notes for earlier changes.

RPMs and DEB packages are available in Percona repository.

As usual you can download binaries and sources with the patches from Percona web site.

To upgrade from MySQL server to Percona SQL you need remove MySQL installation first, then install Percona-SQL-server and Percona-SQL-client:

If you are running applications which depend on libmysqlclient, install  Percona-SQL-shared-compat

before removing MySQL

The Percona Server lives on Launchpad : https://launchpad.net/percona-server and you can report bug to Launchpad bug system:

https://launchpad.net/percona-server/+filebug. The documentation is available on our Wiki

For general questions use our Pecona-discussions group, and for development question Percona-dev group.

For support, commercial and sponsorship inquiries contact Percona.

innodb_rw_lock.patch

Entry posted by Aleksandr Kuzminsky | No comment

Add to: | | | |

Recently Alexandr announced new Percona-XtraDB-9.1 release, and now it is good time to summarize features we have and what is expected soon.

This release contains long waited features from 5.0:

• extended slow.log
• USER/TABLE/INDEX/CLIENT_STATISTICS + THREAD_STATISTICS

Extended slow.log is now even more extended, there is additional information for each query:

That is you can see how many bytes was returned by query, was temporary table used,
was it disk table or in-memory, and how big was temporary table.

Also you can profile each individual query from stored procedures, so now you should not
guess what took so long in stored procedure.

What we are working on right now is:

• InnoDB pagesize, so you will be able to specify 4K, 8K, 16K pagesize when you created database
• InnoDB fast checksums, idea and implementation was taken from Facebook patches
• InnoDB big log files ( bigger 4GB). As our benchmarks on FusionIO shows, you may need
  4GB+ log files to get more performance on fast storage systems
• SHOW TEMPORARY FILES, patch from Venu Anuganti
• INFORMATION_SCHEMA.SYS_TABLES and SYS_INDEXES to show internal InnoDB data dictionary

Full list of XtraDB engine features (what makes it different from InnoDB-plugin) on the state as it is right now:

Performance improvements

• Improved buffer_pool scalability
• Fast recovery
• Improved IO path
• Improved rollback segment scalability
• Separate purge thread
• Limited size of data dictionary in memory
• Increased number of concurrent write transactions (undo slots) ( up to 4000 )
• Fast checksums ( in release process )
• Support of different pagesizes ( 4K, 8K, 16K) ( in release process )

Usability / operations

• Show content of buffer_pool
• Import / export of dedicated tables
• Import / export of buffer_pool
• Transactional replication
• Show internal InnoDB data dictionary
• Show InnoDB locking/io profiling in slow.log

I hope you enjoy our work!

Entry posted by Vadim | No comment

Add to: | | | |

Dear Community,

As of today release 0.9.5rc is available.

In this release there are following changes:
Changelog:

• Option –no-lock is added to innobackupex-1.5.1. Use it only while ALL your
  tables are InnoDB and you DO NOT CARE about binary log
  position of backup
• XtraBackup is ported for InnoDB Plugin 1.0.4. Barracuda file format as well as compressed tables are supported. We thank a well known Social Network site for the sponsorship.
  
• Windows conscious change more
• Impoved error messages in innobackupex
• Windows conscious experimental change
• Suppress purge when –stats
• Build number in RPM name. For instance, in the name xtrabackup-0.9.5rc-50.rhel5.x86_64.rpm 50 is the build number.
• Suppress master_thread ibuf operations for –stats
• Suppress ibuf operations for –stats
• fFx fatal bug at –backup when added –stats
• New option –stats to gather index stats
• Fixed some bugs for a 32bit platform

Fixed bugs:

• Bug #435634 in Percona-XtraBackup: “xtrabackup can’t write to a file on windows”
• Bug #437788 in Percona-XtraBackup: “xtrabackup.exe can’t write to a file”
• Bug #386535 in Percona-XtraBackup: “ibbackup_binlog_marker bug still persists”
• Bug #402884 in Percona-XtraBackup: “tries to create temporary tables in relative ./tmp directory”
• Bug #417178 in Percona-XtraBackup: “can’t backup tables with $ in name”

The binary packages for RHEL4,5, Debian, FreeBSD, MacOS as well as source code of the XtraBackup is available on http://www.percona.com/mysql/xtrabackup/0.9.5rc/.

The Debian package is also available via APT. Just add these lines  in /etc/apt/sources.list

deb http://repo.percona.com/apt lenny main
deb-src http://repo.percona.com/apt lenny main

Update the local database

# apt-get update

And install xtrabackup

# apt-get install xtrabackup

The project lives on Launchpad : https://launchpad.net/percona-xtrabackup and you can report bug to Launchpad bug system:
https://launchpad.net/percona-xtrabackup/+filebug. The documentation is available on our Wiki.

For general questions use our Pecona-discussions group, and for development question Percona-dev group.

For support, commercial and sponsorship inquiries contact Percona.

Entry posted by Aleksandr Kuzminsky | No comment

Add to: | | | |

This comes rather quickly as the last revision – 150 was just uploaded a few days ago. This is because there was a new method of checking config options in the bin/ scripts that utilizes the codeigniter config files instead of config.cfg in the base directory, the problem was the all of the required bin/ files were updated to this new method except for the alerter script. This was mentioned in bugtrack issue #48 and subsequently fixed this morning. So you can either download the new version which has some other nice fixes or just fix the one file. As usual the download can be had from the download page.

If you choose to just fix the one file you will need to change the following code in bin/kontroll-alerter-5.0.x_linux-x86-2.0.1.pl – here is a link to the diff of the two files.
New function
sub config_connect {
my $cfgapp = "../system/application/config/bin-read-configs.php";
$mysql_r_user = `php $cfgapp read username`;
$mysql_r_pass = `php $cfgapp read password`;
$mysql_r_db = `php $cfgapp read database`;
$mysql_r_host = `php $cfgapp read hostname`;
$mysql_w_user = `php $cfgapp write username`;
$mysql_w_pass = `php $cfgapp write password`;
$mysql_w_db = `php $cfgapp write database`;
$mysql_w_host = `php $cfgapp write hostname`;
$error_log = "../system/logs/sys_error.log";
$debug_log = "../system/logs/sys_debug.log";
}


And then at the very bottom of the script change this simple line:
config_connect($config);
To
config_connect();

The latest version is available for download. Big changes include a debug log file view tab, redesigned system management screen, authentication ACL fixes, host state fixes for server-loop, AJAX’d user/host/client pages, data grids for all pertinent tables, and a fix for the slate theme submit button. If you are running an older version of Kontrollbase I would highly recommend upgrading. I’ll be adding an “upgrade” page to the documentation today for just that purpose. Download the new release here: http://kontrollsoft.com/software-downloads

The latest release has a lot of great improvements that you’ll be sure to enjoy.

• ExtJS upgraded to version 3
• Host, User, Client, Alerts pages all updated to use GridPanels
• Documentation on the VMware Virtual Appliance added to docs
• More JSON responders to replace static page status events
• Login no longer has an “OK” on successful authentication
• New CSS UI theme – Slate

As usual you can download here: http://kontrollsoft.com/software-downloads

Kontrollbase VMware appliance is uploaded and ready for use. Get it here: http://kontrollsoft.com/software-downloads

We’re pleased to announce that Kontrollbase 2.0.1-rev70 is available as a VMware Appliance. This means you can download it and run it with VMware Player, Vmware Server 2, or ESXi 3.5 which greatly simplifies the whole installation process. It’s configured as follows:

• CentOS 5.2 64bit
• 1024MB RAM
• 8GB partition – autosized
• Apache 2
• MySQL 5.0
• PHP 5

So, get it now by downloading here: http://kontrollsoft.com/software-downloads