test-data-dictionary-via-randgen
Create more tests for data_dictionary tables to be used with the randgen.
Specifically, we are interested in higher-concurrency situations where multiple users are looking at the data_dictionary tables and situations where there is background activity (SELECT, UPDATE, INSERT, etc) and concurrent data_dictionary queries.
Blueprint information
- Status:
- Complete
- Approver:
- Patrick Crews
- Priority:
- Medium
- Drafter:
- Patrick Crews
- Direction:
- Approved
- Assignee:
- Patrick Crews
- Definition:
- Approved
- Series goal:
- None
- Implementation:
- Implemented
- Milestone target:
- 2010-09-27
- Started by
- Patrick Crews
- Completed by
- Patrick Crews
Related branches
Related bugs
Sprints
Whiteboard
Started hacking on randgen grammars.
Created data_dict_
This initial grammar is the first step - checking concurrency against *just* the data_dictionary tables. It should be noted that Drizzle passes with flying colors here - running with --queries=100K --threads=100 = no crashes.
Running with another grammar in the background = crashes that have been linked to the blueprint.
Detected an additional crash by modifying optimizer_
We have implemented several new grammars designed to stress / test the data dictionary in concurrent situations.
outer_join_
optimizer_
proclist_drizzle.yy - generates only SHOW commands + SELECT queries against data_dictionary tables. Suitable for either stand-alone use or with another randgen process running a separate grammar in the background.
proclist_
data_dict_
All tests have been added to drizzle-