…). Parallel applying would fail in case mixed CHAR and VARCHAR columns would be used in foreign key definitions. Bug fixed #1100496… SST filter, this caused the SST failure due to insufficient privileges. Fixed by excluding lost+found folder if found. Bug fixed…
Post: Query_cache and column level privileges
August 6, 2007 By 5 Comments
… know which columns are accessed. Looking into source code I found out that in the case when table has column level privileges – function…. So initial assumtion was that query against table with defined column privilege is just not cached, though it is not reflected in… the initial assumption – the query that includes tables with defined column level privileges can’t be cached – but actually even more – the…
Post: How To Test Your Upgrades - pt-upgrade
December 29, 2011 By 7 Comments
…) to all objects within the database server and has all privileges to the specified –temp-database from #1. pt-upgrade is… 0 _______________________________ # Found 441 differences in 510 samples: # checksums 0 # column counts 0 # column types 0 # query times 441 # row counts 0 # warning…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…’; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) Populate the… the sysbench above is running. If you look at Cur column under Session, you can see, that c1 has 2 threads… you are using HaProxy for MySQL you can break the privilege system’s host part, because MySQL will think that the…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
… changes in versions. We also ran mysql_fix_privilege_tables to ensure all new privileges are added, which is something I frequently…, and only one of them into table with AUTO_INCREMENT column (and so affected by this bug). It was easy enough… in the tables. It turned out one of the float columns stored “-0″ in MySQL 5.0 but it was displayed…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…Query | +———-+————-+————————————————————-+ | 1 | 46.78110075 | ALTER TABLE test add column c char(32) default ‘dummy_text’ | …| checking query cache for query | 0.000007 | | checking privileges on cached | 0.000003 | | checking permissions | 0….
Post: Knowing what pt-online-schema-change will do
November 1, 2012 By 1 Comment
… signals that the tool has done something wrong. Are all columns selected? Hopefully the tool will never make such a grievous… on never knows. Are the columns used correctly given their data types and definitions? If a column is defined as “NOT NULL… any bugs in the tool, problems with the MySQL server (privileges, etc.), or other oddities, there is a good likelihood that…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… Com_show_charsetsblogpercona.commanual Com_show_collationsblogpercona.commanual Com_show_column_typesblogpercona.commanual Com_show_contributorsblogpercona.commanual Com_show_create_dbblogpercona…
Post: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
….) are not always properly quoted, so authorized users that have privileges to modify a table (any non-temporary table) can inject… #1039536 (Alexey Kopytov). In cases where indexes with AUTO_INCREMENT columns where correctly detected, mysqldump prevented all such keys from optimization…
Post: Announcing Percona Server 5.5.28-29.3
January 8, 2013 By 2 Comments
….) are not always properly quoted, so authorized users that have privileges to modify a table (any non-temporary table) can inject… if the optimization is applicable with respect to AUTO_INCREMENT columns. Bug fixed #1039536 (Alexey Kopytov). Upstream bug #67606 would cause… Ormond Lorch III). In cases where indexes with AUTO_INCREMENT columns where correctly detected, mysqldump prevented all such keys from optimization…
