- 16 Oct, 2003 3 commits
-
-
unknown authored
sql/sql_select.cc: back to the bug #1274: the following query EXPLAIN SELECT SQL_CALC_FOUND_ROWS race_name FROM races WHERE race_name LIKE '%Madison%' ORDER BY race_date DESC LIMIT 0,100 +-------+------+---------------+------+---------+------+--------+-----------------------------+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-------+------+---------------+------+---------+------+--------+-----------------------------+ | races | ALL | NULL | NULL | NULL | NULL | 505821 | Using where; Using filesort | +-------+------+---------------+------+---------+------+--------+-----------------------------+ The query returns no rows. There are two problems with it: - wrong access plan is chosed (sequential index scan in reverse order, which is VERY SLOW in case of MyISAM table + packed keys) It's wrong, because it doesn't take into account that SQL_CALC_FOUND_ROWS is present, in other words, is based on assumtion that LIMIT clause decrease number of rows to access significantly, which is not true as all rows are accessed. - the access plan is not shown in the EXPLAIN (bug #1560). I'm not fixing it here
-
unknown authored
into mashka.mysql.fi:/home/my/mysql-4.0
-
unknown authored
-
- 15 Oct, 2003 7 commits
-
-
unknown authored
NetWare platform, so changes are visible in the tree but cannot affect other platforms.
-
unknown authored
into mashka.mysql.fi:/home/my/mysql-4.0
-
unknown authored
Fixed chsize() problem on windows Extend default timeout on windows clients to 1 year (to avoid timeout problems) include/mysql.h: Added client timeouts (for TCP/IP) libmysql/libmysql.c: Added client timeouts (for TCP/IP) mysql-test/r/create.result: More tests for CREATE TABLE IF NOT EXISTS ... SELECT mysql-test/t/create.test: More tests for CREATE TABLE IF NOT EXISTS ... SELECT mysys/my_chsize.c: Fix for windows sql/handler.h: Remove not used field 'if_not_exists' Ordered fields to be more optimized for new CPU's Added field 'table_existed' sql/slave.cc: Cleanup temporary tables when slave ends sql/sql_class.h: Remove not used 'do_not_drop' field sql/sql_insert.cc: Better fix for CREATE TABLE IF NOT EXISTS ... SELECT sql/sql_table.cc: Better fix for CREATE TABLE IF NOT EXISTS ... SELECT
-
unknown authored
-
unknown authored
mysys/queues.c: Comments for new functions (no code change) mysys/thr_alarm.c: Updated comment
-
unknown authored
into mashka.mysql.fi:/home/my/mysql-4.0 sql/mysqld.cc: Auto merged sql/set_var.cc: Auto merged sql/sql_class.h: Auto merged sql/sql_parse.cc: Auto merged
-
unknown authored
sql/sql_test.cc: Add more information about memory usage
-
- 14 Oct, 2003 3 commits
-
-
unknown authored
existed, causing problems on non-case-sensitive OSes. Deleted conflicting file. BitKeeper/deleted/.del-MYSQL.ICO~d93519b5f0d6ee1: Delete: VC++Files/mysqlshutdown/MYSQL.ICO
-
unknown authored
BitKeeper/etc/ignore: added scripts/make_sharedlib_distribution mysql-test/r/variables.result: Add test for enum_system_variable=NULL mysql-test/t/variables.test: Add test for enum_system_variable=NULL sql/set_var.cc: Fixed bug in SET enum_system_variable=NULL Moved some array elements to get result sorted
-
unknown authored
make LOCK TABLES to work when Lock_tables_priv is granted on the DB level and Select_priv is granted on the table level.
-
- 13 Oct, 2003 1 commit
-
-
unknown authored
into serg.mylan:/usr/home/serg/Abk/mysql-4.0 sql/slave.cc: Auto merged
-
- 11 Oct, 2003 1 commit
-
-
unknown authored
query_alloc_block_size, query_prealloc_size, range_alloc_block_size,transaction_alloc_block_size and transaction_prealloc_size Add more checks for "out of memory" detection in range optimization configure.in: Added detection of mallinfo mysql-test/r/variables.result: Test of new variables mysql-test/t/variables.test: Test of new variables sql/ha_berkeley.cc: Use init_sql_alloc instead of init_alloc_root for better OOM detection sql/log_event.cc: Add new user variables for tuning memory usage sql/mysql_priv.h: Add new user variables for tuning memory usage sql/mysqld.cc: Add new user variables for tuning memory usage sql/opt_ft.cc: Add new user variables for tuning memory usage sql/opt_ft.h: Add new user variables for tuning memory usage sql/opt_range.cc: Add new user variables for tuning memory usage Add more checks for out of memory conditions sql/opt_range.h: Add new user variables for tuning memory usage sql/set_var.cc: Add new user variables for tuning memory usage sql/sql_acl.cc: Add new user variables for tuning memory usage sql/sql_class.h: Add new user variables for tuning memory usage sql/sql_delete.cc: Add new user variables for tuning memory usage sql/sql_parse.cc: Add new user variables for tuning memory usage sql/sql_select.cc: Add new user variables for tuning memory usage sql/sql_test.cc: Add information about memory useage if system supports mallinfo() sql/sql_udf.cc: Add new user variables for tuning memory usage sql/sql_update.cc: Add new user variables for tuning memory usage sql/table.cc: Add new user variables for tuning memory usage
-
- 10 Oct, 2003 1 commit
-
-
unknown authored
into eagle.mysql.r18.ru:/home/vva/work/mysql.orig/test/mysql-4.0
-
- 09 Oct, 2003 2 commits
-
-
unknown authored
into mysql.com:/home/mysql_src/mysql-4.0
-
unknown authored
a Format_description_log_event (or maybe it will be named Description_log_event) which is not recognized by 4.0, so a 4.0 can't be a slave of 5.0. We detect it early to produce a helpful message instead of "corrupted relay log" later. sql/slave.cc: Make the slave die if master is 5.0.
-
- 08 Oct, 2003 5 commits
-
-
unknown authored
-
unknown authored
into mashka.mysql.fi:/home/my/mysql-4.0
-
unknown authored
scripts/Makefile.am: SCCS merged
-
unknown authored
-
unknown authored
Changed --remote to --read-from-remote-server (mysqlbinlog) client/mysqlbinlog.cc: Changed --remote to --read-from-remote-server to make option more understandable mysql-test/t/mysqlbinlog.test: Fixed test case that --remote broke
-
- 07 Oct, 2003 7 commits
-
-
unknown authored
into narttu.mysql.fi:/my/mysql-4.0
-
unknown authored
client/mysqlbinlog.cc: Fix for option 'R' (connect to remote server)
-
unknown authored
mysql-test/r/create.result: Auto merged sql/slave.cc: Auto merged sql/sql_parse.cc: Auto merged
-
unknown authored
as the test is meaningful only if the slave supports transactions, we require this. As in 4.0 the slave runs with --skip-innodb, we test for BDB.
-
unknown authored
into narttu.mysql.fi:/my/mysql-4.0
-
unknown authored
into eagle.mysql.r18.ru:/home/vva/work/BUG_1323/mysql-4.0
-
unknown authored
client/mysqlbinlog.cc: Add default handling to mysqlbinlog mysql-test/mysql-test-run.sh: Cleanup of mysqldump/mysqlbinlog argument handling scripts/Makefile.am: Remove duplicate scripts/mysql_install_db.sh: Change -eq to =
-
- 06 Oct, 2003 10 commits
-
-
unknown authored
extra/resolveip.c: After merge fix mysql-test/mysql-test-run.sh: Fixed comment mysql-test/r/rpl_trunc_binlog.result: Updated results sql/log_event.cc: Better (shorter) error message
-
unknown authored
BitKeeper/etc/logging_ok: auto-union mytest-old.c: Merge rename: VC++Files/libmysqltest/mytest.c -> mytest-old.c BitKeeper/deleted/.del-mysqlshutdown.c: Delete: VC++Files/mysqlshutdown/mysqlshutdown.c BitKeeper/deleted/.del-mysqlshutdown.rc: Delete: VC++Files/mysqlshutdown/mysqlshutdown.rc BitKeeper/deleted/.del-mysqlwatch.c: Delete: VC++Files/mysqlwatch/mysqlwatch.c BitKeeper/deleted/.del-thr_test.c: Delete: VC++Files/thr_test/thr_test.c BitKeeper/deleted/.del-make_win_src_distribution.sh: Delete: scripts/make_win_src_distribution.sh BitKeeper/deleted/.del-.fgl~cac6624e1ac6ee1d: Auto merged BitKeeper/deleted/.del-Build.tsb~f3be7d512e6d5b74: Auto merged BitKeeper/deleted/.del-Clients and Tools.fgl~826a8e3f651af365: Auto merged BitKeeper/deleted/.del-Default.cdf~1da6505528200d5e: Auto merged BitKeeper/deleted/.del-Default.fdf~466762fdf65e1477: Auto merged BitKeeper/deleted/.del-Default.fgl~45b9e847fa4da131: Auto merged BitKeeper/deleted/.del-Default.fgl~a86ce70180b5aba4: Auto merged BitKeeper/deleted/.del-Default.rge~2218627c2a901409: Auto merged BitKeeper/deleted/.del-Default.shl~a02a9093c2b6b0d9: Auto merged BitKeeper/deleted/.del-Default.shl~e18d3f10bef97a28: Auto merged BitKeeper/deleted/.del-Development.fgl~ca1458874a3fef81: Auto merged BitKeeper/deleted/.del-Grant Tables.fgl~31e527d126c42d90: Auto merged BitKeeper/deleted/.del-MySQL 3.23.com.ipr~eb817edea43c6e6e: Auto merged BitKeeper/deleted/.del-SETUP.BMP~77e20d86bceb4903: Auto merged BitKeeper/deleted/.del-Servers.fgl~36147accb82f759: Auto merged BitKeeper/deleted/.del-Setup.dbg~688e9d3ec362ec34: Auto merged BitKeeper/deleted/.del-Setup.ino~85f07a856a69a722: Auto merged BitKeeper/deleted/.del-Setup.ins~ab68efc133d8411e: Auto merged BitKeeper/deleted/.del-Setup.obs~2f09140119879bc6: Auto merged BitKeeper/deleted/.del-Setup.rul~14510a994d515f19: Auto merged BitKeeper/deleted/.del-Setup.tsb~e74dbc7688d4019a: Auto merged BitKeeper/deleted/.del-infolist.txt~58b203247936d266: Auto merged BitKeeper/deleted/.del-infolist.txt~ee370f4771c83a97: Auto merged BitKeeper/deleted/.del-value.shl~718b5b291d5ff04d: Auto merged BitKeeper/deleted/.del-value.shl~98c2851db96b919e: Auto merged BitKeeper/deleted/.del-Documentation.fgl~cf0ac866737a5c7d: Auto merged configure.in: Merge with 3.23.58 (Keep old code) sql/slave.cc: Merge with 3.23.58 (Keep old code) sql/sql_parse.cc: Merge with 3.23.58 (Keep old code)
-
unknown authored
-
unknown authored
-
unknown authored
-
unknown authored
include/queues.h: resize_queue() include/thr_alarm.h: resize_thr_alarm() to resize alarm_queue mysys/queues.c: resize_queue() mysys/thr_alarm.c: resize_thr_alarm() to resize alarm_queue
-
unknown authored
-
unknown authored
Remove unintentional changes in previous push innobase/row/row0mysql.c: Remove unintentional changes in previous push
-
unknown authored
Fix bug: if one used the rename trick of ibman section 15.1 to recover a temp table, InnoDB asserted because it tried to lock the data dictionary twice innobase/row/row0mysql.c: Fix bug: if one used the rename trick of ibman section 15.1 to recover a temp table, InnoDB asserted because it tried to lock the data dictionary twice
-
unknown authored
into serg.mylan:/usr/home/serg/Abk/mysql-4.0 scripts/mysql_config.sh: Auto merged sql/mysqld.cc: Auto merged
-