#DBHangOps 9/4/13 — Data dictionary corruption, MySQL Utilities, Benchmarking, and MySQLConnect!
Check out the video!
Hey there everybody!
Coming up this Wednesday, September 4th, 2013 at 12:00pm pacific (19:00 GMT) take part in #DBHangOps to discuss:
- Data Dictionary Corruption
- What is it?
- How does it happen?
- How did you fix it?
- What about FRM file corruption?
- MySQL Utilities (requested by Sheeri Cabral!)
- mysqlfrm — http://dev.mysql.com/doc/workbench/en/mysqlfrm.html
- Read about it at Chuck Bell’s blog http://drcharlesbell.blogspot.com/2013/04/mysql-utilities-new-frm-reader-utility.html
- mysqldiff — Can be used to identify difference between database objects! http://dev.mysql.com/doc/workbench/en/mysqldiff.html
- mysqlfrm — http://dev.mysql.com/doc/workbench/en/mysqlfrm.html
- Benchmarking! (requested by Tim Callaghan)
- What software do you use to benchmark?
- See http://dev.mysql.com/downloads/benchmarks.html for more information about MySQL benchmarks.
- pt-log-player to replay “live” traffic against the server to measure it under different levels of concurrency
- YCSB — Yahoo! Cloud Serving Benchmark https://github.com/brianfrankcooper/YCSB/wiki
- DBT2 — http://sourceforge.net/apps/mediawiki/osdldbt/index.php?title=Main_Page
- How do you verify proper configuration of your benchmark machines?
- How do you ensure you’re getting your money’s worth on new hardware?
- What software do you use to benchmark?
- MySQL Connect — What are you excited for?
As always, check out the the #DBHangops twitter search, the DBHangops Twitter Feed, or come right back to this blog post to get a link for the google hangout on Wednesday!
Can’t wait to see all of you for the conversation tomorrow!
These days you should use percona-playback instead of pt-log-player.