Author: Laurynas Biveinis
Revision Date: 2015-02-13 06:15:23 UTC

Automerge lp:~vlad-lesin/percona-server/5.6-bug-1354988

Author: Laurynas Biveinis
Revision Date: 2015-02-13 06:13:55 UTC

Automerge lp:~vlad-lesin/percona-server/5.5-bug-1354988

Author: Jenkins Master
Revision Date: 2014-12-18 14:58:20 UTC

Merge lp:~hrvojem/percona-server/bug1218767-5.1
http://jenkins.percona.com/job/merge-PS-5.1-docs-kickoff/32/

Author: Mattias Jonsson
Revision Date: 2011-12-14 13:05:22 UTC

merge

Author: Vlad Lesin
Revision Date: 2014-03-20 15:39:27 UTC

Facebook readahead.

Author: Tomislav Plavcic
Revision Date: 2015-10-20 10:43:03 UTC

Added my.cnf to rpm shared package since it obsoletes mysql-libs

Author: Tomislav Plavcic
Revision Date: 2015-02-12 15:25:08 UTC

Fixed mysql client error reporting and MYSQLD_SAFE my.cnf section

Author: Tomislav Plavcic
Revision Date: 2015-02-11 10:17:32 UTC

Remove opt flags from debug build

Author: Tomislav Plavcic
Revision Date: 2015-02-11 09:27:51 UTC

Remove opt flags from debug build

Author: Jenkins Master
Revision Date: 2015-02-06 14:26:54 UTC

Merge lp:~hrvojem/percona-server/rn-5.6.22-72.0-5.6
http://jenkins.percona.com/job/merge-PS-5.6-docs-kickoff/73/

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: Jenkins Master
Revision Date: 2015-01-22 10:19:51 UTC

Merge lp:~hrvojem/percona-server/bug1406482-5.5
http://jenkins.percona.com/job/merge-PS-5.5-docs-kickoff/69/

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

Reverted fix for 1070856 for custom build for i47576.

Author: Tomislav Plavcic
Revision Date: 2015-01-03 16:14:05 UTC

partial change

Author: Tomislav Plavcic
Revision Date: 2014-12-31 12:57:27 UTC

Restored my.cnf behaviour for centos5/6 - bug1405667
Updated rpm patch for centos7 for library rename - bld-235

Author: Tomislav Plavcic
Revision Date: 2014-12-31 12:51:10 UTC

Restored my.cnf behaviour for centos5/6 - bug1405667
Updated rpm patch for centos7 for library rename - bld-235

Author: Tomislav Plavcic
Revision Date: 2014-12-23 16:20:41 UTC

Changed build options in build-binary.sh and rpm spec

Author: Tomislav Plavcic
Revision Date: 2014-12-23 16:03:13 UTC

Changed build options in build-binary.sh and rpm spec

Author: Jenkins Master
Revision Date: 2014-12-18 14:58:20 UTC

Merge lp:~hrvojem/percona-server/bug1218767-5.1
http://jenkins.percona.com/job/merge-PS-5.1-docs-kickoff/32/

Author: Laurynas Biveinis
Revision Date: 2014-12-04 13:28:12 UTC

Apply the fix for 1395543

Author: Laurynas Biveinis
Revision Date: 2014-12-04 10:55:15 UTC

Apply the fix for bug 1395543

Author: Tomislav Plavcic
Revision Date: 2014-11-21 15:37:38 UTC

Enabled -DSAFE_MUTEX in Cmake for debug build when enabled INNODB_MEMCACHED
Added WITH_DEBUG=ON in build-binary for debug build

Author: Tomislav Plavcic
Revision Date: 2014-11-21 15:33:03 UTC

Added WITH_DEBUG=ON in build-binary for debug build

Author: Tomislav Plavcic
Revision Date: 2014-11-18 09:53:16 UTC

Enabled -DSAFE_MUTEX in Cmake for debug build when enabled INNODB_MEMCACHED
Added WITH_DEBUG=ON in build-binary for debug build

Author: Vlad Lesin
Revision Date: 2014-11-05 22:13:34 UTC

Consider statement as 'write' if restrictive enough
(MDL_SHARED_WRITE and above) MDL lock is acquired.

Author: Vlad Lesin
Revision Date: 2014-10-29 21:50:36 UTC

If a statement would be cancelled when --read-only option is on consider
this statement as 'write'.

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

adjusted logging level

Author: Vlad Lesin
Revision Date: 2014-09-29 09:04:20 UTC

Bug #1351128 fix.

The bug's summary:

1) The value in pins->stack_ends_here is actually incorrect. This value is
calculated when the thread is initialized in my_thread_init(). The problem is
that the value doesn't take into account existing stack usage and just adds the
thread stack size to calculate the beginning of the stack.

2) _lf_pinbox_real_free() is using alloca() in a very unsafe way. alloca()
should only be used by leaf functions, since you cannot predict the amount of
stack space that non-leaf functions will use. As pins->stack_ends_here is
calculated in wrong way and there is no window for the qsort() which is invoked
from _lf_pinbox_real_free() after alloca(), stack overflow can take place.

The solution:

1) Take into accout the current stack offset when stack size is calculated
in my_thread_init();

2) Don't allocate the whole free stack space in _lf_pinbox_real_free(),
take some window for qsort();

Author: Alexey Kopytov
Revision Date: 2014-09-26 14:13:29 UTC

Bug #1360064: LOCK TABLES FOR BACKUP should be incompatible with LOCK
              TABLES, FLUSH TABLES ... WITH READ LOCK, FLUSH TABLES
              ... FOR EXPORT in the same connection

Made sure that an error is thrown on attempt to execute LOCK TABLES FOR
BACKUP in a session which has the following active lock statements:

- LOCK TABLES READ/WRITE;
- FLUSH TABLES <table_list> WITH READ LOCK;
- FLUSH TABLES <table_list> FOR EXPORT.

And vice versa, an attempt to execute any of the above statements in a
session holding a backup tables lock, also fails with an error.

Author: Vlad Lesin
Revision Date: 2014-09-11 11:20:10 UTC

Bug #1322218 fix.

Merged from 5.1.

The difference between this and 5.1 fix is in preventing floating point error
in the case if "users" table is not created.

Author: Vlad Lesin
Revision Date: 2014-09-08 10:23:19 UTC

Bug #1322218 fix.

In the case if mysqld returns error don't continue mysql_install_db script
execution.

The second case when floating point error happens due to dividing by zero when
the number of records in "users" table is null or there is no such table is not
fixed as 5.1 does not contain such code.

Author: George Ormond Lorch III
Revision Date: 2014-09-09 17:46:59 UTC

Fixed .lintian-overrides files to only override actual upstream/unfixable/false positives.
Removed empty percona-server-common package and redirected dependency to mysql-common.
Removed empty package source files.

Author: Vlad Lesin
Revision Date: 2014-09-09 12:21:53 UTC

Implement this
https://blueprints.launchpad.net/percona-server/+spec/binary-answer-5.6
blueprint.

The task can be splitted on server and client parts.

Server-side.

If we look into mysqld_stmt_prepare() function we can see the code like this:

Protocol *save_protocol= thd->protocol;
thd->protocol= &thd->protocol_binary;
stmt->prepare(...);
thd->protocol= save_protocol;

The THD class contains this members:

Protocol *protocol; // Current protocol
Protocol_text protocol_text; // Normal protocol
Protocol_binary protocol_binary; // Binary protocol

So for server-side is enough to add new command COM_STMT_EXECUTE_IMMEDIATE which
would do absolutely the same things as COM_QUERY does but with replacing
thd->protocol with &thd->protocol_binary before processing and restore protocol
pointer after processing.

Client side.

Standard C API has already have all necessary infrastructure to parse binary
protocol. So the task is to use this infrastructure. The idea is to add new
function mysql_stmt_execute_immediate() which would send
COM_STMT_EXECUTE_IMMEDIATE to server, initialize MYSQL_STMT object to use it
for parsing result with standard functions for parsing the result of
"execute prepared statement". As well mysql_stmt_bind_immediate() is necessary
to initialize certain MYSQL_STMT fields which are usually initialized inside of
mysql_stmt_prepare() and to invoke standard mysql_stmt_bind_result() function
to describe the result data.

There are two functions to execute prepared and non-prepared queries
correspondingly: mysql_stmt_execute() and mysql_real_query(). Both functions
use the same function cli_read_query_result() to get information about fields
count, their names. So this part of result parsing is the same. But rows parsing
is absolutely different.

For non-prepared query mysql_fetch_row()->read_one_row() calls just set pointers
in array of rows to the certain values in read packet. As all values are in the
text format we have the array of pointers to null-terminated strings as the
output of the function.

But when binary data are parsed in mysql_stmt_fetch()->stmt_fetch_row() the
functions use information about field types from MYSQL_STMT::bind array.
For each element of this array
mysql_stmt_bind_result()->setup_one_fetch_function() sets the pointer to the
function which parses binary data of corresponding type to the buffer. For
example fetch_result_int32() is set up for MYSQL_TYPE_LONG data type.

So we have to develop new function mysql_stmt_execute_immediate() which would
mix mysql_real_query() and mysql_stmt_execute().

Use tests/stmt_execute_immediate.cc as the source of information about the
sequence of C API calls to send query and receive and parse binary answer.

stmt_execute_immediate.cc could be the part of mysql_client_test.c but the
customer disabled this test in his tree.

The new parameter --binary-protocol is added to mysqltest to allow communication
between client and server with binary protocol without "prepare" using
mysql_stmt_execute_immedate() function to send query.

Author: Laurynas Biveinis
Revision Date: 2014-09-01 08:10:29 UTC

Fix bug 1360942 (Non-ASCII rendering of apostrophe in LOCK TABLES FOR
BACKUP error message) by replacing the 'RIGHT SINGLE QUOTATION MARK'
(U+2019) apostrophe in errmsg-utf8.txt with an ASCII one. Update the
testcases.

Author: Sergei Glushchenko
Revision Date: 2014-08-31 08:49:54 UTC

test deadlock fix on concurrent delete

Author: Alexey Bychko
Revision Date: 2014-08-08 09:20:12 UTC

https://jira.percona.com/browse/BLD-136
[+] added Percona-specific build configs

Author: Sergei Glushchenko
Revision Date: 2014-08-04 09:24:16 UTC

attempt to fix

Author: Tomislav Plavcic
Revision Date: 2014-07-30 14:35:39 UTC

Added support for yassl build in build-binary.sh

Author: Tomislav Plavcic
Revision Date: 2014-07-30 12:39:21 UTC

Added option to build-binary to build with yassl

Author: Laurynas Biveinis
Revision Date: 2014-06-26 09:42:10 UTC

Valgrind fix experiment follow-up

Author: Tomislav Plavcic
Revision Date: 2014-06-23 09:07:32 UTC

Fixed server suffix

Author: Tomislav Plavcic
Revision Date: 2014-06-18 08:40:24 UTC

Added libperconaserverclient to deb and links to libmysqlclient18.1

Author: Tomislav Plavcic
Revision Date: 2014-06-16 11:16:28 UTC

Added dependency for dpatch

Author: Laurynas Biveinis
Revision Date: 2014-06-10 08:56:30 UTC

Sparse bitmap file size experiment

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

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

Author: Alexey Bychko
Revision Date: 2014-05-22 10:05:02 UTC

merged latest lp:percona-pam-for-mysql by requiest from Sergei G

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

Merge with the latest Percona Server 5.5

Author: Fred
Revision Date: 2014-05-09 19:19:27 UTC

back-port of audit plugin + cvs output format supported and used
as default

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: Tomislav Plavcic
Revision Date: 2014-04-27 21:56:12 UTC

Updated logic for showing tokudb plugin install info

Author: Vlad Lesin
Revision Date: 2014-04-22 12:37:15 UTC

Add mysqldump support for logical read ahead

Summary:
Adds options to mysqldump:
 --lra-size=X
 --lra-sleep=X
 --lra-n-node-recs-before-sleep=X

These just inject SET statements to set these session variables.

The original implementation is here:
https://github.com/facebook/mysql-5.6/commit/f69a4ea522bce24e4cdcc7696d5fad29587cf87a

Author: Vlad Lesin
Revision Date: 2014-04-22 10:04:46 UTC

When the session variable innodb_lra_size is set to N, we issue async
read requests for the next M logical pages where the total size of the M
pages on disk is N megabytes. The max allowed value of innodb_lra_size
is is 16384 which corresponds to prefetching 16GB of data. We may choose
to use smaller values in production.

The original implementation can be found here:
https://github.com/facebook/mysql-5.6/commit/f8e361952612d00979f7cf744f487e48b15cb5a6

This implementation does not contain code for flashcahe.

Author: Sergei Glushchenko
Revision Date: 2014-04-21 12:11:22 UTC

Merge audit log plugin from 5.5

Author: Laurynas Biveinis
Revision Date: 2014-03-26 10:55:26 UTC

Cherry-pick merge commit 568 of preliminary lp:~laurynas-biveinis/percona-server/tokudb-clustering-query-opt

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

Author: Laurynas Biveinis
Revision Date: 2014-03-20 14:43:34 UTC

Experimental Spider merge

Author: Sergei Glushchenko
Revision Date: 2014-03-19 09:33:43 UTC

Merge plugin for scalability metrics from 5.5 series

Author: Sergei Glushchenko
Revision Date: 2014-03-16 07:21:40 UTC

Merge test case for bug 1289754 from 5.5

Author: Sergei Glushchenko
Revision Date: 2014-03-15 16:58:09 UTC

Bug 1289754: table_id is defined differently in sql/table.h vs sql/log_event.h
Straightforward backport from MySQL 5.6

Author: Alexey Bychko
Revision Date: 2014-03-01 05:09:22 UTC

[*] alpha release
[*] fixed debian gcc version
[*] fixed debian rules for skipping valgrind build
[*] renamed tokudb install file (Debian)
[*] fixed tokudb build in RH spec
[*] fixed specs after merge
[|] merge [percona-tokutek] ps-patched-tokudb branch updated with 5.6.16 and selected patches from mysql56
[+] added -DPURIFY for Valgrind builds
[+] added compilation comment if tokudb
[*] adjusted defines for tokudb
[+] added arch build to the spec
[*] fixed build directory path
[+] added tokudb version and conditional build to the RPM spec
[*] skipping makefile processing on binary build
[*] fixed build-binary for tokudb build

Author: Laurynas Biveinis
Revision Date: 2014-02-21 15:13:23 UTC

SAlexey's age-based flush list flusher trunk merge draft

Author: Laurynas Biveinis
Revision Date: 2014-02-10 11:17:44 UTC

Add LRU_OLD_BEHAVIOR define that restores the 5.6.15- algorithm for the LRU flushing

Author: Sergei Glushchenko
Revision Date: 2014-02-09 18:50:28 UTC

Plugin for scalability metrics.
This is an audit plugin which provides following status variables
once loaded and enabled:
- scalability_metrics_elapsedtime - total time elapsed since starting point
- scalability_metrics_queries - number of completed queries since starting point
- scalability_metrics_concurrency - number of queries currently executed
- scalability_metrics_totaltime - total execution time of all queries
- scalability_metrics_busytime - server's total busy time
time is counted in microseconds.
There is also the global control variable named scalability_metrics_control
with possible values ON, OFF, RESET.
Setting the value to ON enables counting of metrics. Setting it to OFF disables
counting. By setting the value to RESET one can reset counters (status
variables) while continuing to count metrics.

Notes on implementation.
Three types of notifications are used to count these metrics (all three are of
MYSQL_AUDIT_GENERAL_CLASS class).
MYSQL_AUDIT_GENERAL_LOG with command 'Query' and 'Execute' is considered a
query start event
MYSQL_AUDIT_GENERAL_RESULT and MYSQL_AUDIT_GENERAL_ERROR are considered a
query end event
Statistics calculated for each THD and stored in data structure
associated with THD. The only synchronization point is the atomic
variable used to track number of currently running queries. It is
used for the purpose of calculating server busy time. Once
variable becomes non-zero we start tracking busy time, once it
becomes zero, we stop doing it.

Author: Sergei Glushchenko
Revision Date: 2014-02-09 14:20:31 UTC

fix some more warnings

Author: Alexey Bychko
Revision Date: 2014-02-04 12:52:18 UTC

[-] cleaned commented code produced output garbage
[-] cleaned nonexisting cmake variables in debian/rules
[-] LINUX_NATIVE_AIO is removed from debian/rules, because it set automatically in ./storage/innobase/CMakeLists.txt:29
[+] added cmake policy definition to fix not-useful warnings about INTERFACE_LINK_LIBRARIES policy. upstream fix is incorrect, it doesn't work with Ubuntu saucy version set to 2.6.11.1
[+] added VERBOSE=1 to make command
[-] removed static mysqld build and related cmake option
[-] | server | removed mysqld directory from /var/run (lintian)
[+] | server | added /etc/mysql/conf.d directory to the package
[*] fixed percona-server-server-5.6.postinst: line 220: unexpected EOF while looking for matching ``'
[*] fixed debian-maint user creation
[+] added dh_lintian build step
[*] fixed reasonable lintian warnings and errors
[*] fixed indentation for debian/rules, converted to <TAB>s, as per debian spec