Author Archives: sheeri

OurSQL Episode 10: How About Some Cache?

Subscribe to the podcast by clicking:
http://phobos.apple.com/WebObjects/MZStore.woa/wa/viewPodcast?id=2068063…

You can Direct download all the oursql podcasts at:
http://technocation.org/podcasts/oursql/

Show notes:

Listener Feedback:
http://dev.mysql.com/doc/refman/4.1/en/mysql-commands.html

News:
Daylight Savings Time and how to check your system:
http://sheeri.net/archives/188

There’s not much more time left to register for the MySQL Users Conference & Expo before the $200 early bird discount disappears!
http://www.mysqlconf.com

Learning Resource:

Check out the 2006 MySQL conference presentation slides by the speakers! http://mysqlconf.com/pub/w/45/presentations.html

Continue reading

Posted in Podcasts | Comments Off on OurSQL Episode 10: How About Some Cache?

OurSQL Episode 9: Jay Speaks About the MySQL Conference

This week I spoke with Jay Pipes about the upcoming MySQL Conference, April 23-26 in Santa Clara, California, USA.
Subscribe to the podcast by clicking:
http://phobos.apple.com/WebObjects/MZStore.woa/wa/viewPodcast?id=2068063…
You can Direct download… Continue reading

Posted in Podcasts | Comments Off on OurSQL Episode 9: Jay Speaks About the MySQL Conference

OurSQL Episode 8: Basic MySQL Security

Listener feedback:
MySQL will go public. Would you buy stock if you had the money? Why or why not?
Call the comment line at +1 617-674-2369 (US phone number)
Use Odeo to leave a voice mail through your computer:
http://odeo.com/sendmeamessage/Sheeri
Le… Continue reading

Posted in Podcasts | Comments Off on OurSQL Episode 8: Basic MySQL Security

OurSQL Episode 7: What’s it Like To Be Normal?

In this episode, I go over database normalization in general and explain 1st Normal Form (1NF) in depth.
Direct play episode 7 at:
http://tinyurl.com/2fbhy2
Subscribe to the podcast by clicking:
http://phobos.apple.com/WebObjects/MZStore.woa/wa/viewPod… Continue reading

Posted in Podcasts | Comments Off on OurSQL Episode 7: What’s it Like To Be Normal?

OurSQL Episode 6: Falcon, Part 2

In this episode, the second part in a two-part series about Falcon, the new storage engine provided by MySQL, we talk about what happens when commit, going over and explaining the serial log and indexes.
Direct play episode 6 at:
http://tinyurl.com/yym… Continue reading

Posted in Podcasts | Comments Off on OurSQL Episode 6: Falcon, Part 2

OurSQL Episode 5: Falcon, Part 1

Finally, episode 5 is here. In this episode, the first part in a two-part series about Falcon, the new storage engine provided by MySQL, we talk about what happens when you query a Falcon table, going over and explaining MVCC and the record cache. Ne… Continue reading

Posted in Podcasts | Comments Off on OurSQL Episode 5: Falcon, Part 1

OurSQL Episode 4: Cluster From Down Under

This week’s podcast is an interview with MySQL’s Stewart Smith, software engineer for MySQL Cluster. Straight from the warm southern hemisphere, Stewart talks about Cluster. Because we gabbed on and on for 19 minutes, we’ve stripped the format do… Continue reading

Posted in Podcasts | Comments Off on OurSQL Episode 4: Cluster From Down Under

OurSQL Episode 3: Your Database on ACID

This week’s feature talks about ACID compliance, what it is, and how MySQL achieves it.

If folks have ideas or suggestions for content, please let me know by e-mailing podcast@sheeri.com or by leaving a comment.

You can Direct download all the oursql podcasts at:
http://technocation.org/podcasts/oursql/

Direct play this edition at:
http://tinyurl.com/yy7pgz

News
Download MySQL Turbo Manager Free Edition at: http://www.mentattech.com/themes/mentat/download.html

Wireless providers prefer MySQL over Oracle, Microsoft SQL Server over both:

http://www.crn.com/sections/breakingnews/breakingnews.jhtml?articleId=19…

read more

Continue reading

Posted in Podcasts | Comments Off on OurSQL Episode 3: Your Database on ACID

OurSQL Episode 2: Wild Performance Tips

Episode 2 of OurSQL: The MySQL Database Podcast is here! It’s a bit late due to a computer crash and the fact that I sprained my ankle, but I think it’s worth waiting for. Particularly since this week’s feature is everyone’s favorite — perfor… Continue reading

Posted in Podcasts | Comments Off on OurSQL Episode 2: Wild Performance Tips

OurSQL Episode 1: Backups, Backups Everywhere

We have done a series of podcasts on backups that cover the topic much more thoroughly:
Backup Series #1: Backup Glossary
Backup Series #2: Backup Tools You Already Have (mysqlhotcopy and mysqldump)
Backup Series #3: Looking Through the Lenz (snapshots… Continue reading

Posted in Podcasts | Comments Off on OurSQL Episode 1: Backups, Backups Everywhere