diff options
author | adam <adam> | 2012-04-14 12:10:05 +0000 |
---|---|---|
committer | adam <adam> | 2012-04-14 12:10:05 +0000 |
commit | f0dc2b803d8d3176314576e293bcb5406a542363 (patch) | |
tree | 8c1b8ee305b04032a1f25978d800d0f2091cad33 | |
parent | 5735f83c9e17105c699f5bdacf0a2eeef1dc8461 (diff) | |
download | pkgsrc-f0dc2b803d8d3176314576e293bcb5406a542363.tar.gz |
Changes 5.5.23:
Bugs Fixed
* Security Fix: Bug 59533 was fixed.
* Performance: Partitioning: InnoDB Storage Engine: The statistics used by the
optimizer for queries against partitioned InnoDB tables were based only on the
first partition of each such table, leading to use of the wrong execution
plan.
* References: This bug was introduced by Bug 11756867.
* Performance: InnoDB Storage Engine: Improved the performance of the DROP TABLE
statement for InnoDB tables, especially on systems with a large buffer pool.
The fix speeds up the processing for freeing entries in the adaptive hash
index.
* InnoDB Storage Engine: Deleting a huge amount of data from InnoDB tables
within a short time could cause the purge operation that flushes data from the
buffer pool to stall. If this issue occurs, restart the server to work around
it. This issue is only likely to occur on 32-bit platforms.
* InnoDB Storage Engine: If the server crashed during a TRUNCATE TABLE or CREATE
INDEX statement for an InnoDB table, or a DROP DATABASE statement for
a database containing InnoDB tables, an index could be corrupted, causing an
error message when accessing the table after restart:
InnoDB: Error: trying to load index index_name for table table_name
InnoDB: but the index tree has been freed!
In MySQL 5.1, this fix applies to the InnoDB Plugin, but not the built-in
InnoDB storage engine.
* InnoDB Storage Engine: When data was removed from an InnoDB table, newly
inserted data might not reuse the freed disk blocks, leading to an unexpected
size increase for the system tablespace or .ibd file (depending on the
setting of innodb_file_per_table. The OPTIMIZE TABLE could compact a .ibd file
in some cases but not others. The freed disk blocks would eventually be
reused as additional data was inserted.
More...
-rw-r--r-- | databases/mysql55-client/Makefile.common | 4 | ||||
-rw-r--r-- | databases/mysql55-client/distinfo | 8 | ||||
-rw-r--r-- | databases/mysql55-server/PLIST | 16 |
3 files changed, 19 insertions, 9 deletions
diff --git a/databases/mysql55-client/Makefile.common b/databases/mysql55-client/Makefile.common index 1c892972281..bfdc6f5d82d 100644 --- a/databases/mysql55-client/Makefile.common +++ b/databases/mysql55-client/Makefile.common @@ -1,9 +1,9 @@ -# $NetBSD: Makefile.common,v 1.16 2012/04/08 18:30:27 adam Exp $ +# $NetBSD: Makefile.common,v 1.17 2012/04/14 12:10:05 adam Exp $ # # used by databases/mysql55-client/Makefile # used by databases/mysql55-server/Makefile -DISTNAME= mysql-5.5.22 +DISTNAME= mysql-5.5.23 CATEGORIES= databases MASTER_SITES= ${MASTER_SITE_MYSQL:=MySQL-5.5/} diff --git a/databases/mysql55-client/distinfo b/databases/mysql55-client/distinfo index 227eb415657..0c73151f441 100644 --- a/databases/mysql55-client/distinfo +++ b/databases/mysql55-client/distinfo @@ -1,8 +1,8 @@ -$NetBSD: distinfo,v 1.13 2012/04/08 18:30:27 adam Exp $ +$NetBSD: distinfo,v 1.14 2012/04/14 12:10:05 adam Exp $ -SHA1 (mysql-5.5.22.tar.gz) = 31d232dd72279ae69cd192a5355a8599b55944c7 -RMD160 (mysql-5.5.22.tar.gz) = 1404660a07a9eac4f6a4f25d7e8836edcaaee70e -Size (mysql-5.5.22.tar.gz) = 24475686 bytes +SHA1 (mysql-5.5.23.tar.gz) = 4948239625f0c23f033cadce7f41c31a5725ca12 +RMD160 (mysql-5.5.23.tar.gz) = 1c5b086be0b8f5e1f3128c160e1e4814f68dac95 +Size (mysql-5.5.23.tar.gz) = 24485979 bytes SHA1 (patch-BUILD_compile-pentium-gcov) = a1ac666efa953a98455a726e5db359c903d699b6 SHA1 (patch-CMakeLists.txt) = 5e990e40e1e8a5d558315a38b6596c8fa4227e7b SHA1 (patch-client_completion_hash.cc) = b86ec80beac624b2aa21c7587e351ff126400ecb diff --git a/databases/mysql55-server/PLIST b/databases/mysql55-server/PLIST index 761fc13f49b..e64de442476 100644 --- a/databases/mysql55-server/PLIST +++ b/databases/mysql55-server/PLIST @@ -1,4 +1,4 @@ -@comment $NetBSD: PLIST,v 1.14 2012/04/08 18:30:27 adam Exp $ +@comment $NetBSD: PLIST,v 1.15 2012/04/14 12:10:05 adam Exp $ bin/innochecksum bin/my_print_defaults bin/myisam_ftdump @@ -558,6 +558,7 @@ share/mysql/test/include/show_msg.inc share/mysql/test/include/show_msg80.inc share/mysql/test/include/show_relaylog_events.inc share/mysql/test/include/show_rpl_debug_info.inc +share/mysql/test/include/show_slave_hosts.inc share/mysql/test/include/show_slave_status.inc share/mysql/test/include/sp-vars.inc share/mysql/test/include/start_slave.inc @@ -1085,6 +1086,7 @@ share/mysql/test/r/partition_binlog.result share/mysql/test/r/partition_binlog_stmt.result share/mysql/test/r/partition_blackhole.result share/mysql/test/r/partition_bug18198.result +share/mysql/test/r/partition_cache.result share/mysql/test/r/partition_charset.result share/mysql/test/r/partition_column.result share/mysql/test/r/partition_column_prune.result @@ -2882,7 +2884,6 @@ share/mysql/test/suite/funcs_2/t/innodb_charset.test share/mysql/test/suite/funcs_2/t/memory_charset.test share/mysql/test/suite/funcs_2/t/myisam_charset.test share/mysql/test/suite/funcs_2/t/suite.opt -share/mysql/test/suite/innodb/include/innodb-index.inc share/mysql/test/suite/innodb/r/innodb-analyze.result share/mysql/test/suite/innodb/r/innodb-autoinc-18274.result share/mysql/test/suite/innodb/r/innodb-autoinc-44030.result @@ -2905,6 +2906,7 @@ share/mysql/test/suite/innodb/r/innodb-zip.result share/mysql/test/suite/innodb/r/innodb.result share/mysql/test/suite/innodb/r/innodb_autoinc_lock_mode_zero.result share/mysql/test/suite/innodb/r/innodb_bug11754376.result +share/mysql/test/suite/innodb/r/innodb_bug11766634.result share/mysql/test/suite/innodb/r/innodb_bug12400341.result share/mysql/test/suite/innodb/r/innodb_bug12661768.result share/mysql/test/suite/innodb/r/innodb_bug13510739.result @@ -3010,6 +3012,8 @@ share/mysql/test/suite/innodb/t/innodb.test share/mysql/test/suite/innodb/t/innodb_autoinc_lock_mode_zero-master.opt share/mysql/test/suite/innodb/t/innodb_autoinc_lock_mode_zero.test share/mysql/test/suite/innodb/t/innodb_bug11754376.test +share/mysql/test/suite/innodb/t/innodb_bug11766634-master.opt +share/mysql/test/suite/innodb/t/innodb_bug11766634.test share/mysql/test/suite/innodb/t/innodb_bug12400341-master.opt share/mysql/test/suite/innodb/t/innodb_bug12400341.test share/mysql/test/suite/innodb/t/innodb_bug12661768.test @@ -3947,6 +3951,7 @@ share/mysql/test/suite/rpl/r/rpl_relayspace.result share/mysql/test/suite/rpl/r/rpl_replicate_do.result share/mysql/test/suite/rpl/r/rpl_replicate_ignore_db.result share/mysql/test/suite/rpl/r/rpl_report.result +share/mysql/test/suite/rpl/r/rpl_report_port.result share/mysql/test/suite/rpl/r/rpl_rewrt_db.result share/mysql/test/suite/rpl/r/rpl_rotate_logs.result share/mysql/test/suite/rpl/r/rpl_rotate_purge_deadlock.result @@ -4064,6 +4069,7 @@ share/mysql/test/suite/rpl/r/rpl_stm_mix_show_relaylog_events.result share/mysql/test/suite/rpl/r/rpl_stm_mixing_engines.result share/mysql/test/suite/rpl/r/rpl_stm_multi_query.result share/mysql/test/suite/rpl/r/rpl_stm_no_op.result +share/mysql/test/suite/rpl/r/rpl_stm_relay_ign_space.result share/mysql/test/suite/rpl/r/rpl_stm_reset_slave.result share/mysql/test/suite/rpl/r/rpl_stm_sql_mode.result share/mysql/test/suite/rpl/r/rpl_stm_start_stop_slave.result @@ -4312,6 +4318,8 @@ share/mysql/test/suite/rpl/t/rpl_replicate_ignore_db-slave.opt share/mysql/test/suite/rpl/t/rpl_replicate_ignore_db.test share/mysql/test/suite/rpl/t/rpl_report-slave.opt share/mysql/test/suite/rpl/t/rpl_report.test +share/mysql/test/suite/rpl/t/rpl_report_port-slave.opt +share/mysql/test/suite/rpl/t/rpl_report_port.test share/mysql/test/suite/rpl/t/rpl_rewrt_db-slave.opt share/mysql/test/suite/rpl/t/rpl_rewrt_db.test share/mysql/test/suite/rpl/t/rpl_rotate_logs.cnf @@ -4459,6 +4467,8 @@ share/mysql/test/suite/rpl/t/rpl_stm_mix_show_relaylog_events.test share/mysql/test/suite/rpl/t/rpl_stm_mixing_engines.test share/mysql/test/suite/rpl/t/rpl_stm_multi_query.test share/mysql/test/suite/rpl/t/rpl_stm_no_op.test +share/mysql/test/suite/rpl/t/rpl_stm_relay_ign_space-slave.opt +share/mysql/test/suite/rpl/t/rpl_stm_relay_ign_space.test share/mysql/test/suite/rpl/t/rpl_stm_reset_slave.test share/mysql/test/suite/rpl/t/rpl_stm_sql_mode.test share/mysql/test/suite/rpl/t/rpl_stm_start_stop_slave.test @@ -5557,7 +5567,6 @@ share/mysql/test/t/bug47671.test share/mysql/test/t/bug58669-master.opt share/mysql/test/t/bug58669.test share/mysql/test/t/bulk_replace.test -share/mysql/test/t/cache_innodb-master.opt share/mysql/test/t/cache_innodb.test share/mysql/test/t/case.test share/mysql/test/t/cast.test @@ -5972,6 +5981,7 @@ share/mysql/test/t/partition_binlog.test share/mysql/test/t/partition_binlog_stmt.test share/mysql/test/t/partition_blackhole.test share/mysql/test/t/partition_bug18198.test +share/mysql/test/t/partition_cache.test share/mysql/test/t/partition_charset.test share/mysql/test/t/partition_column.test share/mysql/test/t/partition_column_prune.test |