Author: Alexey Kopytov
Revision Date: 2011-09-30 08:42:41 UTC

Bug #858945: innodb_expand_fast_index_creation should be optional

This fix makes all functionality provided by
innodb_expand_fast_index_creation.patch disabled by default.

It can be enabled by using a new system variable,
innodb_expand_fast_index_creation, that has both global or session
scopes, and can also be specified in a configuration file or on the
command line. The variable is of the boolean type and is FALSE by
default. The session value of TRUE enables optimizations and
improvements provided by the patch. The variable also has no effect when
fast index creation is disabled with the fast_index_creation option
provided by control_online_alter_index.patch.

Since innodb_expand_fast_index_creation is now disabled by default, some
test suite adjustments that were previously required have been reverted.

Author: Alexey Kopytov
Revision Date: 2012-11-30 08:41:50 UTC

innodb_instant_drop_table implementation.

Author: Alexey Kopytov
Revision Date: 2012-09-27 18:14:06 UTC

Fixed out-of-source builds in 5.1.

Author: Alexey Kopytov
Revision Date: 2013-01-30 08:22:49 UTC

Enabled and revived UNIV_LOG_ARCHIVE code.

Author: Alexey Kopytov
Revision Date: 2011-08-01 18:38:21 UTC

Added relay log coordinates to xid diagnostic info.2

Author: Alexey Kopytov
Revision Date: 2013-12-05 11:13:48 UTC

Merged 5.6 trunk.

Author: Alexey Kopytov
Revision Date: 2011-07-09 15:54:48 UTC

Duplicated utf8_general_ci and ucs2_general_ci to utf8_general50_ci and
ucs2_general50_ci, respectively.

This is the 5.0 part of
https://blueprints.launchpad.net/percona-server/+spec/utf8-general50-ci-5.1
and
https://blueprints.launchpad.net/percona-server/+spec/utf8-general50-ci-5.5

Author: Alexey Kopytov
Revision Date: 2013-11-08 10:18:25 UTC

Port of rev. 5743 ("WL#6899 - Reduce lock_sys_t::mutex contention when
converting implicit lock to an explicit lock") from MySQL 5.7.

Author: Vadim Tkachenko
Revision Date: 2013-03-03 22:08:54 UTC

Fixed shutdown + native mutexes

Author: Vadim Tkachenko
Revision Date: 2013-04-10 18:37:47 UTC

Applied patch to support atomic option on directFS/FusionIO.

Author: Vadim Tkachenko
Revision Date: 2013-02-17 22:12:38 UTC

Added cmake routines to build with jemalloc:
  cmake ... -DWITH_JEMALLOC=<path/to/jemalloc/basedir>

Merged r3831(lp:mysqlatfacebook/51)
  mysql>show memory status\G

Added support to enable/disable jemalloc profile at runtime:
  mysql>set jemalloc_prof_active=<ON|OFF>;

Added support to dump jemalloc profile to the file at runtime:
  mysql>set jemalloc_prof_dump=<file>;

Author: Alexey Stroganov
Revision Date: 2013-02-24 23:22:14 UTC

Added initial version of jemalloc_manager plugin

Author: Alexey Stroganov
Revision Date: 2013-10-18 10:52:54 UTC

Implementation of the new flush list flusher that processes ibpi's in order
from oldest to youngest and also calculates precise number of blocks to flush

Author: Alexey Stroganov
Revision Date: 2013-10-17 18:52:01 UTC

Implementation of
https://blueprints.launchpad.net/percona-server/+spec/more-efficient-log-block-checksums

Author: Alexey Stroganov
Revision Date: 2014-10-15 13:13:47 UTC

adjusted logging level

Author: Alexey Stroganov
Revision Date: 2013-11-22 16:56:32 UTC

Fixed bug in last resort execution branch
Adjusted stalled condition to mark group stalled while taking into account high prio and number of waiting threads

Author: Alexey Stroganov
Revision Date: 2013-10-15 07:12:29 UTC

More flushing diags

Author: Alexey Stroganov
Revision Date: 2013-09-27 08:48:28 UTC

Added backoff code for new_index

Author: Alexey Stroganov
Revision Date: 2013-10-01 15:47:34 UTC

Added the very raw support of SCHED_RR as replacement for 'nice'

Author: Alexey Stroganov
Revision Date: 2013-09-24 11:57:05 UTC

Post parallel truncate fixes
Extended purge_tracing to have a levels
As srv_do_purge() may loop many time before return to upper level added
updating of the current_thread_priority flag there as well
The was a bug in calculation of n_total_purged.
   *n_total_purged += (n_pages_purged + n_pages_purged_trunc);
   n_pages_purged_trunc is never explicitly zeroed and only change value once per 128 loops
   and in remain 127 loops previous value of n_pages_purged_trunc was added to n_total_purged
   and such we have wrong estimation of number of purged records.
Added many diagnostics to trace purge activity

Author: Alexey Stroganov
Revision Date: 2013-09-07 17:12:38 UTC

Fixes for parallel truncate and disagnostic

Author: Alexey Stroganov
Revision Date: 2013-10-04 17:52:58 UTC

Tree for tunning/analysis:
+ old LRU_tail + LRU_list_batch
+ changes in flush list flusher
+ bunch of diagnostic
+ ported index backoff
+ log_checksum

Author: Christoffer Hall
Revision Date: 2010-09-02 14:56:18 UTC

Updated sql_no_fcache.patch with ifdefs so it can compile on other platforms.

Author: 林晓斌
Revision Date: 2011-12-20 19:03:32 UTC

modify column type

Author: 林晓斌
Revision Date: 2011-12-05 07:48:21 UTC

add test-case

Author: 林晓斌
Revision Date: 2012-01-01 03:55:05 UTC

add slowlog_in_memory.patch

Author: Andrew Gaul
Revision Date: 2013-12-11 18:49:47 UTC

Consider end LSN when purging changed page bitmaps

Fixes: https://bugs.launchpad.net/percona-server/+bug/1260035

Author: Andrew Gaul
Revision Date: 2013-12-19 05:31:05 UTC

Handle partial writes in os0file.cc:os_file_pwrite

This could cause ibd files to contain bogus trailing zeros and non-page
size file sizes, which XtraBackup asserts on.

Author: George Lorch
Revision Date: 2012-06-05 04:38:09 UTC

In order to offer more control over option visibility, access and range
  limits, the following new option modifiers have been added:
    minimum-<option name>=<value> : Sets the minimum value that clients
      may set <option name> to. If a client does attempt to set the value
      of <option name> lesser than <value>, a warning will be issued and
      the value of <option name> will be set to <value>.
    hidden-<option name>=<TRUE/FALSE> : If set to TRUE, makes any system
      variable named in <option name> invisible and immutable to clients.
    readonly-<option name>=<TRUE/FALSE> : If set to TRUE, makes any
      system variable named in <option name> immutable to clients.

Author: George Lorch
Revision Date: 2012-05-22 02:03:19 UTC

Initial options modifiers parsing/setup code. No implementation for enforcement yet.

Author: George Ormond Lorch III
Revision Date: 2012-10-12 17:40:01 UTC

zarafa

Author: George Lorch
Revision Date: 2012-08-20 21:04:17 UTC

.

Author: George Ormond Lorch III
Revision Date: 2014-03-20 22:44:43 UTC

Author: George Ormond Lorch III
Revision Date: 2012-12-04 01:08:30 UTC

Incorporated range read prefetch logic from:
  http://www.zarafa.com/wiki/index.php/MySQL_5.5_InnoDB_prefetch_patch

Author: George Ormond Lorch III
Revision Date: 2012-11-26 20:56:28 UTC

Incorporated selective code into PS 5.5.25a sql/log_event.h and sql/log_event.cc from PS 5.5 revno 288 and bug fix from lp:~gl-az/percona-server/5.5-bug1053342.

Author: George Ormond Lorch III
Revision Date: 2012-11-27 04:47:35 UTC

Minor fix for lp 1079596:
Fixed unsigned math error in fsp_reserve_free_extents that in some
specific cases (when FSP_SIZE < FSP_FREE_LIMIT) causes the function to
believe that billions more extents have been reserved than have actually
been reserved.

Author: George Ormond Lorch III
Revision Date: 2014-04-29 22:05:12 UTC

bug 1313901 - Binlog events with binlog_format=MIXED are unconditionally logged in ROW format

Temporary commit that removes legacy upstream fix and introduces extra restrictions on STATEMENT replication for queries that make use of temporary tables.

Author: <email address hidden>
Revision Date: 2015-01-17 19:33:17 UTC

Reverted fix for 1070856 for custom build for i47576.

Author: George Ormond Lorch III
Revision Date: 2014-01-27 23:22:01 UTC

Fix for bug1273465 - lintian warnings and errors (new packaging)
Corrected minor spelling errors with the exception of 'yuR' as that does not appear anywhere in the code base.

Author: Hrvoje Matijakovic
Revision Date: 2013-12-11 12:18:07 UTC

Bug fixes for: Bug #1218767, Bug #1065767, Bug #1202719, Bug #1254647 and
DOC-27

Author: Ignacio Nin
Revision Date: 2013-03-04 19:44:15 UTC

Move libmysqlclient.so from the shared package to the devel package

This commit is part of a series of fixes in all the branches of Percona-Server
and Percona-XtraDB-Cluster, for which the goal is to stop including
libmysqlclient.so and libmysqlclient_r.so in the shared packages and include
it in the devel package.

Also, for rhel5, have the shared package obsolete mysql, which is the package
containing the libmysqlclient.so.15 library in the distribution.

Rationale:
Following the model of the upstream (MySQL) packages, a copy of the versioned
library -- libmysqlclient.so.15 for 5.0, libmysqlclient.so.16 for 51 and
libmysqlclient.so.18 for 5.5 -- was included in the shared package with name
libmysqlclient.so.

This creates the problem of making the library packages not compatible to each
other, making it impossible to have PS-shared-51 and PS-shared-55 installed at
the same time, for example. Upstream solved this problem by providing a
shared-compat package (which we also include), containing all the older
versions of the libraries.

This solution is acceptable for manual installation, however it doesn't play
good with our repositories. Since we include all of our software in the same
repository, there are many combinations possible that you can choose. As long
as the user stuck to a particular version, this wouldn't cause trouble -- but
it's impossible to avoid when installing a package that depends on a particular
libmysqlclient.so version, like php-mysql, or percona-toolkit (indirectly via
perl-DBD-mysql). In rhel6, these packages depend on the 5.1 version of the
library, so if Percona-Server-5.5 was installed, the shared package for the 5.1
version got selected by yum but it would conflict at the file level on
libmysqlclient.so. In rhel5 the situation would be even worse, since these
packages depend on the 5.0 version of the library, making 5.1 and 5.5 difficult
to install unless the user would select specifically
Percona-Server-shared-compat. Having 5.1 or 5.5 depend directly on
PS-shared-compat only introduced further problems.

The solution proposed hereby is to follow the model of the distributions, and
have the packages not install libmysqlclient.so, but only the versioned
libraries. The distro packages are prepared to link against the versioned
libraries only, so not having the unversioned libraries should not be a problem
for installing packages. The unversiones libraries are installed in the -devel
packages, since these are needed for linking new programs against it.

This way, PS 5.1, PS 5.5 and PXC can be installed alonside the shared package
for 5.0 (Percona-SQL-shared-50) in rhel5 and 5.1 (Percona-Server-shared-51) in
rhel6, allowing for any combination of software and seamless installs of
percona-toolkit or any other package that would depend on a specific package.

Author: Ignacio Nin
Revision Date: 2013-10-16 15:14:42 UTC

Move the Obsolete: lines to the shared package for CentOS 5

Due to every version of Percona Server (5.1, 5.5, 5.6 and PXC) having a
shared library package that Obsoletes: mysql-libs, upgrading from a
mysql-libs installation would use any available version to obsolete
mysql-libs, when in fact the intended package to replace it is the 5.0
version for CentOS 5 and the 5.1 version for CentOS 6.

After installing the percona repository, a yum upgrade would try to
replace mysql-libs with Percona-XtraDB-Cluster-shared-compat, which
would confuse users.

Solve this by removing all the Obsoletes: lines from the packages that
are not intended to replace mysql-libs *except when explicitely
installed*, and in the correct packages only Obsolete: for the correct
versions of CentOS.

Author: Ignacio Nin
Revision Date: 2012-01-05 00:06:29 UTC

Remove generic dpkg packages for percona-server-server and client

Remove the generic packages percona-server-server and
percona-server-client, which now live in higher version branches (5.1 and
5.5).

Update flags and some minor edits on the dpkg building script.

Author: Ignacio Nin
Revision Date: 2012-09-11 11:05:20 UTC

Build out of source (binary builder)

Instead of building in the source for the binary builder, export to
another directory and build there.

Author: Ignacio Nin
Revision Date: 2013-09-26 19:27:03 UTC

Compile against system readline

Instead of using bundled readline, use the system version of readline. Also
depend on readline for the BuildRequires in RPM and dpkg.

Author: Ignacio Nin
Revision Date: 2013-09-09 15:36:34 UTC

Update FSF's street address

The copyright notices were showing an outdated FSF's street address.
Update to the new address as per http://www.gnu.org/licenses/gpl-2.0.html

Author: Ignacio Nin
Revision Date: 2013-09-30 20:08:29 UTC

Replace the debian init script with the script provided by source

The debian init script had some issues when it came to detecting the
server had been started -- it had a hardcoded 15 seconds wait (although
this could be overridden by my.cnf) and in order to detect a running
server it tried to login to it.

This came with issues when a) the startup time exceeded 15 seconds, which
is something that can easily happen with datasets of hundreds of gigs,
and b) if there was no user available for the init script to use, or the
user had been misconfigured somehow. Of course, these two possibilites
were true too often.

Replace the script with the one provided by MySQL, which uses a PID-file
based detection mechanism to check whether the server has been started or
stopped.

Given that the two init scripts share no common history (the previous one
came from the debian distribution), bzr rm and bzr add it to avoid
pointless conflicts.

Author: buildbot
Revision Date: 2012-09-10 23:29:16 UTC

Move my_print_defaults to the client package in order not to conflict
with the mysql package from the centos repositories.

Have the shared package conflict with mysql-libs.
Have the server package require the client package.

Author: Ignacio Nin
Revision Date: 2012-10-22 22:15:56 UTC

Move the timeouts of the mysql init script to /etc/default

Create an /etc/default/mysql file with default timeouts for the start and
stop script in /etc/init.d. the init script will try to read the file and
if it has numeric values it will take these as defaults.

Author: Ignacio Nin
Revision Date: 2013-06-20 19:09:48 UTC

Merge changes done for issue #26684

Author: Ignacio Nin
Revision Date: 2013-10-16 21:49:48 UTC

Remove the Obsoletes: lines from the shared package except for CentOS 6

Due to every version of Percona Server (5.1, 5.5, 5.6 and PXC) having a
shared library package that Obsoletes: mysql-libs, upgrading from a
mysql-libs installation would use any available version to obsolete
mysql-libs, when in fact the intended package to replace it is the 5.0
version for CentOS 5 and the 5.1 version for CentOS 6.

After installing the percona repository, a yum upgrade would try to
replace mysql-libs with Percona-XtraDB-Cluster-shared-compat, which
would confuse users.

Solve this by removing all the Obsoletes: lines from the packages that
are not intended to replace mysql-libs *except when explicitely
installed*, and in the correct packages only Obsolete: for the correct
versions of CentOS.

Author: Ignacio Nin
Revision Date: 2013-04-18 19:43:39 UTC

Merge from 5.1 the capability to build out of source (binary builder)

This solves bug #1164699 since it leaves the source directory untouched.

Author: Ignacio Nin
Revision Date: 2013-04-20 10:00:59 UTC

Have libmysqlclient_r.so.18 point to libmysqlclient.so.18 (RPM)

For the RPM shared package, the libmysqlclient_r.so.18 symlink was
pointing to libmysqlclient.so instead of the versioned
libmysqlclient.so.18. Since libmysqlclient.so was moved to the devel
package, when installing the shared package the unversioned library was
not present and the symlink would not get installed.

Fix this by pointing the symlink to the versioned library, which is
included in the shared package as well.

Author: Ignacio Nin
Revision Date: 2013-09-09 15:40:35 UTC

Update FSF's street address

The copyright notices were showing an outdated FSF's street address.
Update to the new address as per http://www.gnu.org/licenses/gpl-2.0.html

Author: Ignacio Nin
Revision Date: 2013-09-30 21:08:52 UTC

Replace the debian init script with the script provided by source

The debian init script had some issues when it came to detecting the
server had been started -- it had a hardcoded 15 seconds wait (although
this could be overridden by my.cnf) and in order to detect a running
server it tried to login to it.

This came with issues when a) the startup time exceeded 15 seconds, which
is something that can easily happen with datasets of hundreds of gigs,
and b) if there was no user available for the init script to use, or the
user had been misconfigured somehow. Of course, these two possibilites
were true too often.

Replace the script with the one provided by MySQL, which uses a PID-file
based detection mechanism to check whether the server has been started or
stopped.

Given that the two init scripts share no common history (the previous one
came from the debian distribution), bzr rm and bzr add it to avoid
pointless conflicts. Merge this with the same fix for 5.1, and share the
file id with the corresponding file in that branch.

Author: Ignacio Nin
Revision Date: 2012-09-26 18:56:18 UTC

Add a --debug flag to the binary builder

Add a --debug flag that will create a build with the debug-enabled
binaries. Also add -debug to the binary tarball and directory, as well
as the comment, in case it is a debug build.

Author: buildbot
Revision Date: 2012-09-10 23:32:17 UTC

Move my_print_defaults to the client package in order not to conflict
with the mysql package from the centos repositories.

Have the shared package conflict with mysql-libs.

Author: Ignacio Nin
Revision Date: 2013-10-16 22:06:25 UTC

Remove the Obsoletes: lines from the shared package

Due to every version of Percona Server (5.1, 5.5, 5.6 and PXC) having a
shared library package that Obsoletes: mysql-libs, upgrading from a
mysql-libs installation would use any available version to obsolete
mysql-libs, when in fact the intended package to replace it is the 5.0
version for CentOS 5 and the 5.1 version for CentOS 6.

After installing the percona repository, a yum upgrade would try to
replace mysql-libs with Percona-XtraDB-Cluster-shared-compat, which
would confuse users.

Solve this by removing all the Obsoletes: lines from the packages that
are not intended to replace mysql-libs *except when explicitely
installed*, and in the correct packages only Obsolete: for the correct
versions of CentOS.

Author: Ignacio Nin
Revision Date: 2013-03-15 17:08:52 UTC

Merge fix for bug #1011047

Author: Ignacio Nin
Revision Date: 2013-04-19 15:27:43 UTC

Merge from 5.5 the capability to build out of source (binary builder)

Author: Ignacio Nin
Revision Date: 2013-09-09 15:42:52 UTC

Update FSF's street address

The copyright notices were showing an outdated FSF's street address.
Update to the new address as per http://www.gnu.org/licenses/gpl-2.0.html

Merge the fix from 5.5.

Author: Ignacio Nin
Revision Date: 2013-09-30 21:38:21 UTC

Replace the debian init script with the script provided by source

Merge the change from 5.5.

Author: Ignacio Nin
Revision Date: 2013-10-18 18:20:19 UTC

Merge from trunk in order to resolve conflicts

Author: Ignacio Nin
Revision Date: 2013-05-14 20:02:49 UTC

Merge bugfix for #1174426

Author: Ignacio Nin
Revision Date: 2012-09-11 11:05:20 UTC

Build out of source (binary builder)

Instead of building in the source for the binary builder, export to
another directory and build there.

Author: Ignacio Nin
Revision Date: 2012-09-11 11:04:09 UTC

Build out of source (binary builder)

Instead of building in the source for the binary builder, export to
another directory and build there.

Author: Ignacio Nin
Revision Date: 2013-02-18 22:13:20 UTC

Merge for 5.1-nonconflicting-libmysqlclient for testing purposes.

Author: Ignacio Nin
Revision Date: 2012-06-22 00:12:40 UTC

Merge 5.5-bug1003776 fix in order to test

Author: Ignacio Nin
Revision Date: 2012-09-11 17:22:15 UTC

rewrite

Author: Ignacio Nin
Revision Date: 2013-03-04 17:22:39 UTC

Merge for bug #1144777

Author: Ignacio Nin
Revision Date: 2013-03-06 18:02:38 UTC

Merge the fix for the conflicting problem with Percona-Server-shared-51

Author: Ignacio Nin
Revision Date: 2013-03-05 16:12:31 UTC

Remove innodb_memcached_config.sql from bindir

The file innodb_memcached_config.sql was moved to share/ so remove it
from the binary file list.

Author: Nickolay Ihalainen
Revision Date: 2012-04-25 15:53:38 UTC

merge with 5.1 trunk

Author: Nickolay Ihalainen
Revision Date: 2012-02-07 12:09:34 UTC

Innodb Log archiving purge command documentation

Author: Nickolay Ihalainen
Revision Date: 2012-03-15 20:37:47 UTC

Fixed muttex lock assertion, fix for tests

Author: Kostja Osipov
Revision Date: 2014-05-12 14:35:58 UTC

Merge with the latest Percona Server 5.5

Author: Laurynas Biveinis
Revision Date: 2015-02-05 10:07:31 UTC

Revert fake changes feature as it's not going to be ported to 5.7.

Author: Laurynas Biveinis
Revision Date: 2013-10-03 13:57:12 UTC

Merge lp:percona-server/5.6 rev 453

Author: Laurynas Biveinis
Revision Date: 2013-02-12 06:39:39 UTC

Fix bug 1122462 (InnoDB: Failing assertion: bpage->in_flush_list in
file buf0lru.c line 605).

The issue is that, even after fixing bug 934377 and friends, there is
not enough protection for the "prev" pointer in the
buf_flush_or_remove_pages() loop to start pointing to a flushed page
or become dangling due to a compressed page flush list relocation.

The fix is two part. First is acquiring the compressed page flush
mutex in buf_flush_dirty_pages() (and releasing it in
buf_flush_yield()). This ensures that the prev pointer always points
to a valid page.

The second part is to fix that, while prev cannot become dangling
anymore, it still may get removed from the flush list when the flush
list mutex is released. This is handled by replacing the assertions
at the top of the buf_flush_or_remove_pages() loop with a block state
check.

Remove some comments that do not apply for XtraDB.

Author: Laurynas Biveinis
Revision Date: 2014-05-30 06:51:57 UTC

Bug 1324783: add Valgrind suppressions for quicklz, which is used by
TokuDB.