The MySQL n00b

Monday, October 31, 2016

MyRocks: migrating a large MySQL dataset from InnoDB to RocksDB to reduce footprint

›
I have been following Facebook ' s MyRocks project ( and Mark Callaghan ' s blog ) for a long time . The idea of a...
18 comments:
Tuesday, September 27, 2016

If enforcing data retention via DROP PARTITION, better watch your auto_increment counter

›
One of the main tasks that any DBA has to deal with is certainly data retention. Especially when your developers like to store logging and t...
Monday, September 26, 2016

SHOW WARNINGS can stall your MySQL server if compressed protocol is used

›
If there is something that I love about information technology is the incredible amount of unpredictable ways that bugs can bite you where a...
2 comments:
Sunday, September 25, 2016

Introducing BakaSQL, the MySQL web-based sandbox for query execution

›
BakaSQL: a bit of history When I joined this new company I was already aware there was a lot of work to do. There was no DBA Team to speak...
‹
›
Home
View web version

About Me

My photo
Rick Pizzi
I have been always interested in MySQL since the early days of v3.23. After spending 20+ years in the IT field mostly as a system administrator, In the last few years I decided to focus on MySQL and have been working as full time DBA since. You can check my resume on LinkedIN
View my complete profile
Powered by Blogger.