Introduction to mysqlslap tool
[edit] Introduction to mysqlslap tool
- Date: 2007-09-06
- Presenter: Brian Acker
- Scribe: Peter Lavin
[edit] Presentation
[edit] Questions
Question: Where is the source?
- Answer: It's in /client.
Question: Is --pre-query pre-test, before the whole test?
- Answer: Yes exactly. And it is run for each iteration and it cleans up everything before every run.
Question: Is most of the data in the cache?
- Answer: No. Drop schema flushes everything.
Question: Does the version number of slap identify the server number?
- Answer:Yes
Question: Is the number of iterations shown in the csv file?
- Answer: No. That needs to be fixed. (This was fixed the next day)
Question: Does mysqlslap need cygwin on Windows?
- Answer: No.
Question: Does a pre-query run before --create?
- Answer: Yes.
Question: Can you test replication?
- Answer: Yes.
Question: What about your own file queries?
- Answer: Yes, you can test those too.
Question: Can you use it for recovery -- does slap see where the query was killed? So that we know where recovery can begin.
- Answer: Try adding a mid-system call like pre and post.
Question: Can we log the session in the iterations?
- Answer: All of the data is available, but it is currently not provided (no interface).
Question: Could you use proxy to determine this?
- Answer: Yes.
Question: Can we do a printout of the actual runs?
- Answer: No.