Category Archives: Routines

OurSQL Episode 136: Digging for Information

We discuss INFORMATION_SCHEMA with plenty of examples on useful queries. In this week’s Ear Candy, we talk about resident versus virtual memory on Linux, and in At the Movies has a video about MongoDB.
Events
DB Hangops in May will be Wed May 8th and 2… Continue reading

Posted in Learning, Performance, Podcasts, Routines, Server Tuning | Comments Off

OurSQL Episode 119: I Do DECLARE

This week we talk more about stored routines, including the several different DECLARE statements. Ear Candy is about ssh hacks to make logging into multiple servers easy, and At the Movies is “Everything You Ever Wanted to Know About Deployment But Wer… Continue reading

Posted in Learning, Podcasts, Routines | Comments Off

OurSQL Episode 118: Not Our Usual Routine

This week we go over stored routine basics. Ear Candy is linux.die.net, online man pages for Linux, and At the Movies is key things that DBA need to know.
News
Open Source DBA’s Holiday Gifts for MySQL DBAs – check out the CafePress link, many are posi… Continue reading

Posted in Podcasts, Routines | Comments Off

OurSQL Episode 57: Eventual Discovery part 2

This week we have feedback about Gazzang – Gazzang is using encryptfs for their encryption. According to their launchpad project page at https://launchpad.net/ecryptfs, “eCryptfs is a POSIX-compliant enterprise-class stacked cryptographic filesystem f… Continue reading

Posted in Learning, Podcasts, Routines | Comments Off

OurSQL Episode 57: Eventual Discovery part 2

This week we continue our series on events. We talk about events and logging, event timing, privileges and runtime behavior.
Feedback
Gazzang is using encryptfs for their encryption. According to their launchpad project page at https://launchpad.net/e… Continue reading

Posted in Learning, Podcasts, Routines | Comments Off

OurSQL Episode 56: Eventual Discovery part 1

This week is all about events – events in MySQL, and calls for papers for 2012 conferences.
Percona Live MySQL Conference & Expo call for papers opens soon. http://www.percona.com/live/mysql-conference-2012/
A session matrix for all of the MySQL s… Continue reading

Posted in Learning, Podcasts, Routines | Comments Off

OurSQL Episode 56: Eventual Discovery part 1

This week is all about events – events in MySQL, and calls for papers for 2012 conferences.
Percona Live MySQL Conference & Expo call for papers opens soon. http://www.percona.com/live/mysql-conference-2012/
A session matrix for all of the MySQL s… Continue reading

Posted in Learning, Podcasts, Routines | Comments Off