Tags » Mysql
Using the word 'function' in a comment in a MySQL stored procedure causes the RESTORE command to fail
Recently our support team had a call from a customer who suspected that their nightly MySQL backup/restore job wasn’t working.
At most of our customer sites, once the nightly backup has been run, there is a job to restore the backup to a read-only copy of the live database that is used for reports. 543 more words
Ever wanted to just look at QPS in real time while logged into your server?
Well here’s a little command line hackery to do it quick and dirty. 89 more words
This only works if you’re using innodb_file_per_table.
Purpose: import this csv quickly into google sheets (or other spreadsheet) and compare MySQL’s internal data size to the container size on disk to determine tables needing to be optimized (or “null altered”) to reclaim disk space and maybe increase performance due to defragmentation. 134 more words