summaryrefslogtreecommitdiff
path: root/sql-bench
Commit message (Collapse)AuthorAgeFilesLines
* Fix spelling: occurred, execute, which etcOtto Kekäläinen2016-03-041-2/+2
|
* 5.5 mergeSergei Golubchik2015-01-211-1/+1
|\
| * MDEV-7226 sql-bench test-table-elimination does not executeSergei Golubchik2015-01-191-1/+1
| |
* | 5.5.39 mergeSergei Golubchik2014-08-071-0/+0
|\ \ | |/
| * mysql-5.5.39 mergeSergei Golubchik2014-08-027-687/+687
| |\ | | | | | | | | | | | | | | | | | | ~40% bugfixed(*) applied ~40$ bugfixed reverted (incorrect or we're not buggy) ~20% bugfixed applied, despite us being not buggy (*) only changes in the server code, e.g. not cmakefiles
| | * Bug#16395459 TEST AND RESULT FILES WITH EXECUTE BITTerje Rosten2014-06-257-687/+689
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Bug#16415173 CRLF INSTEAD OF LF IN SQL-BENCH SCRIPTS Correct perms and converts from Windows style to UNIX style line endings on some files. Fix perms on installed ini files. (MySQL 5.5 version)
* | | MDEV-4447 MariaDB sources should have unix-style line endings everywhereSergei Golubchik2014-02-277-1134/+1134
|/ /
* | remove PBXTSergei Golubchik2013-08-301-5/+0
| |
* | merge Percona-Server-5.5.32-rel31.0.tar.gzSergei Golubchik2013-07-161-0/+0
| |
* | mysql-5.5.32 mergeSergei Golubchik2013-07-164-19/+27
|\ \ | |/
| * Bug #13004581 BLACKHOLE BINARY LOG WITH ROW IGNORES UPDATE AND DELETE ↵Bill Qu2013-04-273-0/+0
| | | | | | | | | | | | | | | | | | | | | | | | | | STATEMENTS When logging to the binary log in row, updates and deletes to a BLACKHOLE engine table are skipped. It is impossible to log binary log in row format for updates and deletes to a BLACKHOLE engine table, as no row events can be generated in these cases. After fix, generate a warning for UPDATE/DELETE statements that modify a BLACKHOLE table, as row events are not logged in row format.
| * Bug#16395606 SCRIPTS MISSING EXECUTE BITTor Didriksen2013-04-101-19/+27
| | | | | | | | | | | | | | Add execute bit for scripts: - in build directory - in install directory
* | 5.3->5.5 mergeSergei Golubchik2012-11-221-4/+5
|\ \
| * | MDEV-772, MDEV-744: Fix test-table-elimination script to work. Sergey Petrunya2012-10-312-4/+7
| | |
| * | Merge with 5.2.Michael Widenius2011-12-1117-51/+68
| |\ \ | | | | | | | | | | | | no_error handling for select (used by INSERT ... SELECT) still needs to be fixed, but I will do that in a separate commit
| | * \ Merge with MariaDB 5.1Michael Widenius2011-11-2417-51/+68
| | |\ \
| | | * \ Initail merge with MySQL 5.1 (XtraDB still needs to be merged)Michael Widenius2011-11-2117-51/+68
| | | |\ \ | | | | | | | | | | | | | | | | | | Fixed up copyright messages.
| | | * | | Use three digits after the decimal point for better resolution and ↵Hakan Kuecuekyilmaz2010-11-291-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | comparability of results.
* | | | | | LPBUG#886526: Add propoer shebang to scriptsVladislav Vaintroub2011-12-271-0/+1
| | | | | |
* | | | | | 5.3->5.5 mergeSergei Golubchik2011-11-222-29/+43
|\ \ \ \ \ \ | |/ / / / /
| * | | | | Updated crash-me for 5.3Michael Widenius2011-08-292-29/+43
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | sql-bench/crash-me.sh: Test types with microseconds Fixed some warnings from perl Code cleanups Don't write comments to .cfg file if run with --noverbose
* | | | | | mysql-5.5.18 mergeSergei Golubchik2011-11-0317-51/+68
|\ \ \ \ \ \ | | |_|_|_|/ | |/| | | |
| * | | | | Updated/added copyright headersKent Boortz2011-06-3017-51/+68
| |\ \ \ \ \ | | | |_|_|/ | | |/| | |
| | * | | | Updated/added copyright headersKent Boortz2011-06-3017-51/+68
| | |\ \ \ \
| | | * | | | Updated/added copyright headersKent Boortz2011-06-3017-51/+68
| | | | | | |
* | | | | | | merge with 5.3Sergei Golubchik2011-10-193-1/+13
|\ \ \ \ \ \ \ | | |_|_|/ / / | |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | sql/sql_insert.cc: CREATE ... IF NOT EXISTS may do nothing, but it is still not a failure. don't forget to my_ok it. ****** CREATE ... IF NOT EXISTS may do nothing, but it is still not a failure. don't forget to my_ok it. sql/sql_table.cc: small cleanup ****** small cleanup
| * | | | | | Merge 5.3->main -> 5.3-mwl90Sergey Petrunya2011-05-291-0/+1
| |\ \ \ \ \ \ | | |_|_|_|/ / | |/| | | | |
| | * | | | | MWL#90: Subqueries: Inside-out execution for materialized non-sj subqueriesSergey Petrunya2010-12-091-0/+1
| | |\ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | - Merge into 5.3-main
| | | * | | | | MWL#90: Subqueries: Inside-out execution for non-semijoin materialized ↵Sergey Petrunya2010-05-251-0/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | subqueries that are AND-parts of the WHERE - Code cleanu. - Make MWL#90 code require @@optimizer_switch='semijoin=on' - Update test results with the above - Fork subselect_mat.test - we want to check both semi-join materialization, which now has broader scope and non-semijoin materialization.
| | * | | | | | Use three digits after the decimal point for better resolution and ↵Hakan Kuecuekyilmaz2010-11-291-1/+1
| | | |_|_|_|/ | | |/| | | | | | | | | | | | | | | | | | comparability of results.
| * | | | | | Enable PBXT to be a transactional engine for sql-bench.Hakan Kuecuekyilmaz2011-05-231-0/+11
| | | | | | | | | | | | | | | | | | | | | | | | | | | | HEAP is deprecated in favor of MEMORY.
| * | | | | | Use three digits after the decimal point for better resolution and ↵Hakan Kuecuekyilmaz2010-11-261-1/+1
| |/ / / / / | | | | | | | | | | | | | | | | | | comparability of results.
* | | | | | 5.5-mergeSergei Golubchik2011-07-022-88/+5
|\ \ \ \ \ \ | | |_|/ / / | |/| | | |
| * | | | | WL#5665: Removal of the autotools-based build systemDavi Arnaut2010-11-201-83/+0
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The autotools-based build system has been superseded and is being removed in order to ease the maintenance burden on developers tweaking and maintaining the build system. In order to support tools that need to extract the server version, a new file that (only) contains the server version, called VERSION, is introduced. The file contents are human and machine-readable. The format is: MYSQL_VERSION_MAJOR=5 MYSQL_VERSION_MINOR=5 MYSQL_VERSION_PATCH=8 MYSQL_VERSION_EXTRA=-rc The CMake based version extraction in cmake/mysql_version.cmake is changed to extract the version from this file. The configure to CMake wrapper is retained for backwards compatibility and to support the BUILD/ scripts. Also, a new a makefile target show-dist-name that prints the server version is introduced. VERSION: Add top-level version file. cmake/mysql_version.cmake: Get version information from the top-level VERSION file. Do not cache the version components (MAJOR_VERSION, etc). Add MYSQL_RPM_VERSION as a replacement for MYSQL_U_SCORE_VERSION.
| * | | | | add missing COMPONENT to all CMake INSTALL commandsVladislav Vaintroub2010-11-131-5/+5
| | | | | |
* | | | | | merge.Sergei Golubchik2010-11-2513-42/+442
|\ \ \ \ \ \ | |/ / / / / |/| / / / / | |/ / / / | | | | | | | | | | checkpoint. does not compile.
| * | | | Merge with MySQL 5.1.50Michael Widenius2010-08-271-3/+0
| |\ \ \ \ | | |/ / / | |/| / / | | |/ / | | | | | | | | | | | | | | | | | | | | | | | | - Changed to still use bcmp() in certain cases becasue - Faster for short unaligneed strings than memcmp() - Bettern when using valgrind - Changed to use my_sprintf() instead of sprintf() to get higher portability for old systems - Changed code to use MariaDB version of select->skip_record() - Removed -%::SCCS/s.% from Makefile.am:s to remove automake warnings
| * | | Added count of my_sync calls (to SHOW STATUS)Michael Widenius2010-03-091-3/+24
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | tmp_table_size can now be set to 0 (to disable in memory internal temp tables) Improved speed for internal Maria temp tables: - Don't use packed keys, except with long text fields. - Don't copy key all accessed pages during key search. Some new benchmark tests to sql-bench (for group by) BUILD/compile-pentium64-gcov: Update script to use same pentium_config flags as other tests BUILD/compile-pentium64-gprof: Update script to use same pentium_config flags as other tests include/my_sys.h: Added count of my_sync calls mysql-test/r/variables.result: tmp_table_size can now be set to 0 sql-bench/test-select.sh: Added some new test for GROUP BY on a not key field and group by with different order by sql/mysqld.cc: Added count of my_sync calls tmp_table_size can now be set to 0 (to disable in memory internal temp tables) sql/sql_select.cc: If tmp_table_size is 0, don't use in memory temp tables (good for benchmarking MyISAM/Maria temp tables) Don't pack keys for Maria tables; The 8K page size makes packed keys too slow for temp tables. storage/maria/ma_key_recover.h: Moved definition to maria_def.h storage/maria/ma_page.c: Moved code used to simplify comparing of identical Maria tables to own function (page_cleanup()) Fixed that one can read a page with a read lock. storage/maria/ma_rkey.c: For not exact key reads, cache the page where we found key (to speed up future read-next/read-prev calls) storage/maria/ma_search.c: Moved code to cache last key page to separate function. Instead of copying pages, only get a link to the page. This notable speeds up key searches on bigger tables. storage/maria/ma_write.c: Added comment storage/maria/maria_def.h: Moved page_cleanup() to separate function.
| * | | Increased loop counts of sql-bench tests to get run times aroundHakan Kuecuekyilmaz2010-02-177-8/+8
| | | | | | | | | | | | | | | | 5 minutes on current machines. Tested on a Xeon machine and a new dual core laptop.
| * | | Added option --temporary-tables to test speed of temporary tablesMichael Widenius2010-02-104-25/+77
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | mysql-test/suite/parts/t/partition_repair_myisam-master.opt: Added missing file from last push sql-bench/bench-init.pl.sh: Added options: --temporary-tables to test speed of temporary tables sql-bench/server-cfg.sh: Added limit for number of temporary tables one can create sql-bench/test-connect.sh: Skip test that doesn't work with temporary tables. sql-bench/test-create.sh: Added limit for number of temporary tables one can create
| * | | Added --connect-command="sql-string" to sql-bench test suite.Michael Widenius2010-02-092-2/+11
| | | | | | | | | | | | | | | | This allows one to send an extra command to the mysql server to setup the environment before starting tests.
| * | | Merge lp:maria -> lp:~maria-captains/maria/maria-5.1-mergeSergey Petrunya2009-09-151-0/+316
| |\ \ \
| | * | | MWL#17: Table eliminationSergey Petrunya2009-09-021-4/+0
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | - Address review feedback R4: better comments, formatting
| | * | | MWL#17: Table eliminationSergey Petrunia2009-06-241-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | - More testcases - Let add_ft_key() set keyuse->usable mysql-test/r/table_elim.result: MWL#17: Table elimination - More testcases mysql-test/t/table_elim.test: MWL#17: Table elimination - More testcases sql/sql_select.cc: MWL#17: Table elimination - Let add_ft_key() set keyuse->usable
| | * | | MWL#17: Table eliminationSergey Petrunia2009-06-161-0/+320
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | - Move eliminate_tables() to before constant table detection. - First code for benchmark sql-bench/test-table-elimination.sh: MWL#17: Table elimination - sql-bench "Benchmark", incomplete sql/sql_select.cc: MWL#17: Table elimination - Move eliminate_tables() to before constant table detection, this will allow to spare const table reads (at a cost of not being able to take advantage of tables that are constant because they have no records, but this case is of lesser importance)
| * | | | Merge MySQL->MariaDBSergey Petrunya2009-09-0824-23/+23
| |\ \ \ \ | | |/ / / | |/| / / | | |/ / | | | | | | | | | | | | * Finished Monty and Jani's merge * Some InnoDB tests still fail (because it's old xtradb code run against newer testsuite). They are expected to go after mergning with the latest xtradb.
| * | | merge of 5.1-main into 5.1-maria. MyISAM changes are propagated to Maria exceptGuilhem Bichot2009-04-012-22/+1
| |\ \ \ | | | | | | | | | | | | | | | those of davi.arnaut@sun.com-20090219210935-9vilvcisyyieffxl (TODO).
| * \ \ \ merge of 5.1-main into 5.1-maria; MyISAM changes are also ported to Maria.Guilhem Bichot2009-03-111-3/+8
| |\ \ \ \
| * | | | | Fix for BUG#36104 "INFORMATION_SCHEMA.TABLES shows TRANSACTIONAL=1 twice in ↵Guilhem Bichot2008-06-031-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | CREATE_OPTIONS" mysql-test/r/maria.result: result; before the bugfix it would be "TRANSACTIONAL=1 transactional=1" mysql-test/t/maria.test: test for BUG#36104 "INFORMATION_SCHEMA.TABLES shows TRANSACTIONAL=1 twice in CREATE_OPTIONS" sql-bench/example: doblewrite->doublewrite sql/mysqld.cc: fix of a wrong 5.1->maria merge of the past sql/sql_insert.cc: removing my old idea of disabling transactionality in CREATE SELECT: 1) it caused bugs because re-enabling (ha_enable_transaction()) causes implicit commit, so in complex cases like "CREATE SELECT some_func())", where some_func() would want to insert two rows in another table, and fail on the second row, the implicit commit would commit the inserted row, while it should roll back. 2) it's not needed anymore, because CREATE SELECT uses bulk insert, and Maria has transactionality disabled by bulk insert. sql/sql_show.cc: This was duplicate code, causing BUG#36104 "INFORMATION_SCHEMA.TABLES shows TRANSACTIONAL=1 twice in CREATE_OPTIONS"
| * | | | | Fixed problems with ma_test2 and mi_test2 on high-byte-first systemunknown2008-02-211-0/+3
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fixed bug in ma_test2 when last row in table is deleted Fixed that ma_test_recovery.pl works on Solaris (by using digest instead of md5sum) Fixed some compiler warnings generated by the Forte compiler dbug/dbug.c: Added cast to get rid of compiler warning mysys/lf_alloc-pin.c: Added cast to get rid of compiler warning mysys/my_bitmap.c: Removed impossible DBUG_ASSERT()'s to get rid of compiler warnings mysys/my_compress.c: Removed wrong cast to get rid of compiler warning storage/maria/lockman.c: Added cast to get rid of compiler warning storage/maria/ma_open.c: Added fix from MyISAM to allocate space in key buffer for nod pointer storage/maria/ma_recovery.c: Fixed initialization that caused compiler warning storage/maria/ma_rsame.c: More DBUG_PRINT storage/maria/ma_scan.c: Better comment storage/maria/ma_statrec.c: More DBUG_PRINT and comments Fixed indentation BitKeeper/etc/ignore: added storage/maria/unittest/tmp/* storage/maria/ma_test2.c: Fixed bug that caused maria_rsame() to fail if test removed last row Fixed wrong usage of longget(); Should be uint4korr() storage/maria/unittest/ma_test_recovery.pl: Use md5sum or digest to calculate md5. This allows this script to be run on Linux and Solaris storage/myisam/mi_test2.c: Fixed wrong usage of longget(); Should be uint4korr() strings/ctype.c: Added casts to get rid of compiler warnings sql-bench/myisam.cnf: New BitKeeper file ``sql-bench/myisam.cnf''
View Lorry Controller Status