summaryrefslogtreecommitdiff
path: root/mysql-test/r/mysqlslap.result
Commit message (Collapse)AuthorAgeFilesLines
* Create 'main' test directory and move 't' and 'r' thereMichael Widenius2018-03-291-257/+0
|
* merge 5.5 -> 10.0-baseunknown2013-09-251-0/+4
|\
| * MDEV-4684 - Enhancement request: --init-command support for mysqlslapSergey Vojtovich2013-09-171-0/+4
| | | | | | | | | | | | Added --init-command argument to mysqlslap: SQL Command to execute when connecting to MySQL server. Will automatically be re-executed when reconnecting.
* | find_files(): don't sort files in my_dir(), sort table namesSergei Golubchik2013-04-071-1/+1
|/ | | | | | | | | after all engines have discovered their tables side effect: correct alphabetical sorting as in ORDER BY ... COLLATE utf8_bin, information_schema is no longer the first after find_files(), tables like #mysql50#zzz are sorted first (as per table name), not last (as per file name zzz).
* cSergei Golubchik2012-05-211-0/+10
|\
| * Merged from 5.1 to 5.5Venkata Sidagam2012-04-091-0/+10
| |\
| | * Bug #11766072 59107: MYSQLSLAP CRASHES IF STARTED WITH NO ARGUMENTS ON WINDOWSVenkata Sidagam2012-04-091-0/+10
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This bug is a duplicate of Bug #31173, which was pushed to the mysql-trunk 5.6 on 4th Aug, 2010. This is just a back-port of the fix mysql-test/r/mysqlslap.result: A test added as part of the fix for Bug #59107 mysql-test/t/mysqlslap.test: A test added as part of the fix for Bug #59107
* | | 5.5-mergeSergei Golubchik2011-07-021-0/+22
|\ \ \ | |/ /
| * | Adjusting test result for bug#11765157.Nirbhay Choubey2011-04-081-0/+2
| |/
| * Bug#11765157 - 58090: mysqlslap drops schema specified inNirbhay Choubey2011-04-081-0/+20
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | create_schema if auto-generate-sql also set. mysqlslap uses a schema to run its tests on and later drops it if auto-generate-sql is used. This can be a problem, if the schema is an already existing one. If create-schema is used with auto-generate-sql option, mysqlslap while performing the cleanup, drops the specified database. Fixed by introducing an option --no-drop, which, if used, will prevent the dropping of schema at the end of the test. client/client_priv.h: Bug#11765157 - 58090: mysqlslap drops schema specified in create_schema if auto-generate-sql also set. Added an option. client/mysqlslap.c: Bug#11765157 - 58090: mysqlslap drops schema specified in create_schema if auto-generate-sql also set. Introduced an option 'no-drop' to forbid the removal of schema even if 'create' or 'auto-generate-sql' options are used. mysql-test/r/mysqlslap.result: Added a testcase for Bug#11765157. mysql-test/t/mysqlslap.test: Added a testcase for Bug#11765157.
* | Fix some test failures found during RPM package building:unknown2009-09-251-12/+6
|/ | | | | | | | | | | | | - mysqlslap result file update after merge. - Fix skipping certain tests when running test suite as root, got broken somehow. mysql-test/mysql-test-run.pl: Somehow skipping tests when running as root got broken. The mysqltest if() no longer seems to accept YES as a true value, so use 1 for true value instead. mysql-test/r/mysqlslap.result: Result file update after change in engine behaviour of mysqlslap. mysql-test/t/mysqld_option_err.test: This test does not work when run as root.
* Merge baker@bk-internal.mysql.com:/home/bk/mysql-5.1-archunknown2007-12-201-0/+8
|\ | | | | | | | | | | | | | | | | | | | | | | into zim.(none):/home/bk/mysql-5.1-arch client/client_priv.h: Auto merged client/mysqlslap.c: Auto merged mysql-test/r/mysqlslap.result: Auto merged
| * Fix for bug#31704unknown2007-10-181-0/+8
| | | | | | | | | | | | | | | | | | | | Just had to put in the removal of the autocommit, and make sure the commit occurred at the propper time. client/mysqlslap.c: Fix for auto-connect on counter. Relabeled variable which was misnamed. mysql-test/r/mysqlslap.result: Updated result file
* | mysqlslap.result, mysqlslap.test:unknown2007-09-271-0/+1
| | | | | | | | | | | | | | | | | | | | Post-commit fix. mysql-test/t/mysqlslap.test: Post-commit fix. mysql-test/r/mysqlslap.result: Post-commit fix.
* | Fixed bug #29985.unknown2007-09-171-0/+5
|/ | | | | | | | | | | | | | | | | | | Multiple-result processing is required during the execution of CALL statements for stored procedures, however the mysqlslap client lacked that processing. client/mysqlslap.c: Fixed bug #29985. 1. Connection flags have been changed: the CLIENT_MULTI_STATEMENTS flag has been added. 2. The run_task function has been modified to process multiple result sets. mysql-test/t/mysqlslap.test: Added test case for bug #29985. mysql-test/r/mysqlslap.result: Added test case for bug #29985.
* Two bugs in one! The count call was duplicating internally the counts for ↵unknown2007-08-091-2/+2
| | | | | | | | | | | | | loaded tests (not autosql tests, just loaded). This could manifest itself by executing by file, or by executing a pre statement. BUG#29803 client/mysqlslap.c: 1) Declared VOID on pre/post statement return values (we were not using the return value and I prefer to see this declared explicitly) 2) Removed extra count call which was causing duplication of rows with parsed files examples. mysql-test/r/mysqlslap.result: The additional selects come from fixing the pre return count call. Dropping the final select is a result of fixing the true count.
* Added a test for pre-statement call, and fixed connection/deconnect code so ↵unknown2007-06-151-0/+44
| | | | | | | | | | | | | that the rest of bbench can be ran by others. client/client_priv.h: Clean up of options. client/mysqlslap.c: Cleanup of the connection and reconnect code. mysql-test/r/mysqlslap.result: Add of new test. mysql-test/t/mysqlslap.test: Additional test.
* Added pre and post option to test run (allows me to adjust an engine once ↵unknown2007-03-261-0/+24
| | | | | | | | | | | | | | | | all of the data has been loaded). Kinda obvious that this was going to come up ;) client/client_priv.h: New options client/mysqlslap.c: Added option for pre/post run mysql-test/r/mysqlslap.result: Updated tests mysql-test/t/mysqlslap.test: Updated test
* Extended mysqlslap.c for auto tests (see the comment on the mysqlslap.c ↵unknown2007-01-291-0/+2
| | | | | | | | | | | | | | | file). I also fixed a bug where limit was not being reached. client/client_priv.h: More options client/mysqlslap.c: Extended the auto-sql in the following ways: 1) You can now specify a load type of either "mixed", "read", or "write". Not great, but a definite improvement. 2) A new option allows you to specify how many rows are inserted for the "read" load. I also fixed a bug where limit was not being reached by running threads. mysql-test/r/mysqlslap.result: Updated results
* Bug#18012 mysqlslap fails if querystring starts with delimiterunknown2006-04-111-2/+0
| | | | | | | | | | - Terminate loop not only when the limit is met, but alse when there is no more stmts client/mysqlslap.c: Terminate loop not only when the limit is met, but alse when there is no more stmts mysql-test/r/mysqlslap.result: Remove the extra statmemnt
* Fixed bug #16167unknown2006-01-121-1075/+0
| | | | | | | | | | | | | | | Added --use-threads option for porting to Windows. client/mysqlslap.c: Addinng thread option for porting to windows (second piece of code) Also added flush call to fix one bug mysql-test/r/mysqlslap.result: New results mysql-test/t/disabled.def: Bug 16167 should not be fixed mysql-test/t/mysqlslap.test: Added test for new use-threads option
* Now uses a single pass testing loop. Dual pass made no sense.unknown2006-01-011-1701/+221
| | | | | | | | | | | | | | | | | | | Now does averaging when running iterations. Realligned a bunch of code and continued to remove global variables. Added CSV output along with printable. Structures are now provided for print options so adding XML, HTML, ... should now be trivial. client/client_priv.h: Simplified options client/mysqlslap.c: Giant cleanup. We now do single pass testing, not dual pass. The dual pass made no sense really especially when you started adding in more stats. Modified the testing loop so that it should not be possible to have both a fork() and thread version (which will make it easier to port to windows should someone want to). mysql-test/r/mysqlslap.result: New results mysql-test/t/mysqlslap.test: Adjusting for new options, and removed "archive" from the tests just in case archive is not compiled.
* New option to run multiple engines through the same test:unknown2005-12-251-433/+2560
| | | | | | | | | | | | | | | | | | | | | --engine="myisam,archive" --number-of-rows has been removed for the time being and replaced with option to allow you to just repeat multiple time all of the inserts you specifed with data. When number-of-rows-returns it will be instead used for averaging rows while growing concurrency. Returned stats now has accurent row and query counts since it includes a multiple for the rows and queries added. Parser is now a touch smarter and understands end of file issues if you have a delimiter at the end of the file. client/client_priv.h: New options client/mysqlslap.c: Modifications for doing repeated tests. mysql-test/r/mysqlslap.result: New result file mysql-test/t/mysqlslap.test: Changes in tests to make sure concurrency failures would not occur.
* See message in mysqlslap.c, but basically unknown2005-12-241-1/+573
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 1) Parsing now works 2) Options are safer, aka it doesn't kill the machine and it cleans up after itself 3) Option of --only-print added so that you can see what it does. 4) Tiny cleanup of the auto generate sql. A lot more needs to be done with this, for it to be very valuable. I suspect it doesn't work all that well. 5) Delimeter is now a single character. No good escaping going on. 6) You can now change which schema it is runninng against. Now I think I can go make use of it! Though I need to add support for a "only run this many inserts, divide by the number of clients connecting, to really test scaling" client/client_priv.h: Added new options for mysqlslap client/mysqlslap.c: Lots of cleanup. Highlights: 1) Parsing now works much better, though I suspect escaping issues still exist. All strings are parsed into a typedef called statement. This is a linked structure with each statement held in it. I added options for length so that when the time comes to fix this for binary data the guts of the main executing loop will not need to be changed 2) Cleaned up options so that it will not destroy data by default and will clean up itself by default. So no leaving around of gobs of data. 3) Added option of --only-print to see the SQL it would have executed 4) Parsing handles whitespace trick (which will come back to bite someone I expect) 5) Delimeter is now a single character 6) All memory allocated should now be freed. 7) Set defaults so that only a single run will occur if none are given. 8) You can now change the schema that it runs against. mysql-test/r/information_schema.result: Fix for Antony's merge mysql-test/r/mysqlslap.result: New result set More testing mysql-test/t/mysqlslap.test: More testing
* WORKLOG #2983 Removed --help from test. (did so already, don't know whyunknown2005-12-051-67/+1
| | | | | | | | | | push didn't push that previous changeset!) mysql-test/r/mysqlslap.result: WORKLOG #2983 removed --help results mysql-test/t/mysqlslap.test: WORKLOG #2983 removed --help from test
* WORKLOG #2983 Post review fixesunknown2005-12-021-6/+5
| | | | | | | client/mysqlslap.c: WORKLOG #2983 - post review fixes mysql-test/r/mysqlslap.result: WORKLOG #2983 Post review new results due to changes in help text
* Worklog #2983 Mysqlslap load emulator tool and accompanied test, resultsunknown2005-11-291-0/+68
and modifications to mysql-test-run(.pl/.sh) client/Makefile.am: Worklog #2983, added mysqlslap to Makefile.am client/client_priv.h: Worklog #2983 Added OPT_CREATE_SLAP_SCHEMA mysql-test/mysql-test-run.pl: Worklog #2983 Added mysqlslap test binary to test script mysql-test/mysql-test-run.sh: Worklog #2983 Added mysqlslap binary def to test script client/mysqlslap.c: Worklog #2983 mysqlslap.c, new utility for running load simulation. mysql-test/r/mysqlslap.result: Worklog #2983 Mysqlslap test results mysql-test/t/mysqlslap.test: Worklog #2983 Mysqlslap test
View Lorry Controller Status