summaryrefslogtreecommitdiff
path: root/mysql-test/r/statistics.result
Commit message (Collapse)AuthorAgeFilesLines
* MDEV#7383: engine-independent-stats column_stats has limited values for ↵Sergei Petrunia2015-11-091-0/+19
| | | | | | | | | | max/min values Patch from Daniel Black: - Change the charset of mysql.column_stats.{min_value, max_value} from utf8_bin varchar to varbinary - Adjust the code that saves/reads the data accordingly. - Also provide upgrade statement in mysql_system_tables_fix.sql
* Change the order of parameters in DECODE_HISTOGRAM to match the order of ↵Sergey Petrunya2014-03-281-4/+4
| | | | | | fields in mysql.column_stats.
* MDEV-4360: ANALYZE shows "Table is already up to date" while updating statsSergey Petrunya2014-03-281-0/+24
| | | | | - Show a line with "Engine-independent statistics collected" when ANALYZE command caused EITS statistics to be recollected.
* 10.0-monty mergeSergei Golubchik2013-07-211-9/+19
|\ | | | | | | | | | | | | | | includes: * remove some remnants of "Bug#14521864: MYSQL 5.1 TO 5.5 BUGS PARTITIONING" * introduce LOCK_share, now LOCK_ha_data is strictly for engines * rea_create_table() always creates .par file (even in "frm-only" mode) * fix a 5.6 bug, temp file leak on dummy ALTER TABLE
| * MDEV-4758 10.0-monty tree: ALTER TABLE CHANGE COLUMN doesn't drop EITS statsSergei Golubchik2013-07-091-9/+19
| | | | | | | | | | add missing rename_column_in_stat_tables(), delete_statistics_for_column(), delete_statistics_for_index(), rename_table_in_stat_tables() calls.
* | Adding support for MySQL-5.6 temporal column types:Alexander Barkov2013-07-101-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | TIME, DATETIME, TIMESTAMP added: mysql-test/r/type_temporal_mysql56.result mysql-test/std_data/mysql56datetime.MYD mysql-test/std_data/mysql56datetime.MYI mysql-test/std_data/mysql56datetime.frm mysql-test/std_data/mysql56time.MYD mysql-test/std_data/mysql56time.MYI mysql-test/std_data/mysql56time.frm mysql-test/std_data/mysql56timestamp.MYD mysql-test/std_data/mysql56timestamp.MYI mysql-test/std_data/mysql56timestamp.frm mysql-test/suite/rpl/r/rpl_temporal_mysql56.result mysql-test/suite/rpl/t/rpl_temporal_mysql56.test mysql-test/t/type_temporal_mysql56.test sql/compat56.cc sql/compat56.h modified: client/mysqlbinlog.cc include/my_time.h include/mysql.h.pp include/mysql_com.h mysql-test/r/statistics.result mysql-test/r/strict.result mysql-test/suite/binlog/r/binlog_mysqlbinlog_row_innodb.result mysql-test/suite/binlog/r/binlog_mysqlbinlog_row_myisam.result sql-common/my_time.c sql/CMakeLists.txt sql/field.cc sql/field.h sql/item.cc sql/item_strfunc.cc sql/item_sum.cc sql/item_timefunc.cc sql/log_event.cc sql/opt_range.cc sql/opt_table_elimination.cc sql/protocol.cc sql/rpl_utility.cc sql/rpl_utility.h sql/sql_partition.cc sql/sql_prepare.cc sql/sql_select.cc sql/sql_table.cc sql/table.cc storage/perfschema/pfs_engine_table.cc
* | Make test working on case insensitive file systemunknown2013-04-221-56/+9
| |
* | Removed comparison of table names.unknown2013-04-221-2/+26
| |
* | decode_histogram fixed to show delta of the last value with maximum.unknown2013-04-211-2/+2
| |
* | Fix of the test suite.unknown2013-04-211-0/+1
| |
* | Changed a test case.Igor Babaev2013-04-201-3/+3
| |
* | MDEV-4402 A function to visualize histograms data.unknown2013-04-201-0/+59
| |
* | Fixed bug mdev-4369.Igor Babaev2013-04-061-0/+39
| | | | | | | | | | | | | | | | | | | | | | The function was adjusted to be able to aggregate the counters of the merged elements. Before this change it was not possible to guarantee the correctness of the counters passed to the the call-back parameter walk_action. As a result, when some elements of a Unique object were flushed into disk the function passed to merge_walk() as the call-back parameter could return wrong counters of elements. This could lead to building wrong histograms.
* | Fixed bugs mdev-4357 and mdev-4359.Igor Babaev2013-04-051-16/+60
| | | | | | | | | | | | The values of the column HIST_TYPE from the statistical table mysql.column_stats were stored in the table and read from the table incorrectly.
* | Added the type of histogram for mwl #253.Igor Babaev2013-03-301-223/+242
| | | | | | | | Introduced double precision height-balanced histograms.
* | Added histogams for table columns.Igor Babaev2013-03-251-223/+245
|/
* Addressed the following issue from the review of the patch forIgor Babaev2012-12-081-34/+171
| | | | | | | | | | | | | engine-independent statistics. When the primary key was dropped or changed statistics on secondary indexes for the prefixes that included components of the primary key was not removed from the table mysql.index_stats. Also fixed: in the some cases when a column was changed statistics on the indexes that included this column was not removed from the table mysql.index_stats. Also disabled the test mdev-504 for --ps-protocol.
* Addressed the following issues from the review of the patch:Igor Babaev2012-12-051-1/+63
| | | | | | | | | | 1. The PERSISTENT FOR clause of the ANALYZE command overrides the setting of the system variable use_stat_tables: with this clause ANALYZE unconditionally collects persistent statistics. 2. ANALYZE collects persistent statistics only for tables of the USER category. So it never collects persistent statistics for system tables.
* Changed the names of the system tables for statistical data:Igor Babaev2012-12-051-114/+114
| | | | | | | | | table_stat -> table_stats column_stat -> column_stats index_stat -> index_stats to be in line with the names of innodb statistical tables from mysql-5.6: innodb_table_stats and innodb_index_stats.
* Fixed the following problem: the syntax of the ANALYZE command did notIgor Babaev2012-08-181-0/+19
| | | | | returned an error if the list of the specified index names contained the name 'primary'.
* Made the output of the newly added test cases from statistics.testIgor Babaev2012-07-101-35/+45
| | | | | | platform independent. Adjusted results of funcs_1.is_columns_mysql_embedded.
* Added procedures to delete records by keys from statistical tables.Igor Babaev2012-07-101-7/+698
| | | | | | | | | | | | | | | | | | | Now when a table is dropped the statistics on the table is removed from the statistical tables. If the table is altered in such a way that a column is dropped or the type of the column is changed then statistics on the column is removed from the table column_stat. It also triggers removal of the statistics on the indexes who use this column as its component. Added procedures that changes the names of the tables or columns in the statistical tables for. These procedures are used when tables/columns are renamed. Also partly re-factored the code that introduced the persistent statistical tables. Added test cases into statistics.test to cover the new code.
* Changed the type of all double columns in the system statistical tablesIgor Babaev2012-06-251-48/+32
| | | | | | mysql.column_stat, mysql.table_stat for the type DECIMAL(12,4). When cached the values from these columns are multiplied by factor 10^5 and stored as ulong numbers now.
* Removed the server option --stat-tables.Igor Babaev2012-06-021-7/+7
| | | | | | | | | | Renamed the system variable optimizer_use_stat_tables to use_stat_tables. This variable now has only 3 possible values: 'never', 'complementary', 'preferably'. If the server has been launched with --use-stat-tables='complementary'|'preferably' then the statictics tables can be employed by the optimizer and by the ANALYZE command.
* Support of the extended syntax for ANALYZE.Igor Babaev2012-05-221-0/+59
|
* Made statistics.test platform independent.Igor Babaev2012-01-071-81/+91
|
* In statistics.test:Igor Babaev2012-01-041-0/+2
| | | | | Saved at the very beginning and restored at the very end the value of optimizer_use_stat_tables.
* The main patch for the MWL#248 back-ported from Igor Babaev2012-01-041-0/+455
lp:~igorb-seattle/mysql-server/mysql-azalea-wl4777.
View Lorry Controller Status