Feature:
Things to Avoid in Queries
Subqueries and Correlated subqueries
http://dev.mysql.com/doc/refman/4.1/en/correlated-subqueries.html
Jan Kneschke’s post on Groupwise Maximum:
http://jan.kneschke.de/projects/mysql/groupwise-max
Calculated comparisons do not use indexes
INSERT IGNORE
REPLACE
INSERT…ON DUPLICATE KEY
Feedback:
Email podcast@technocation.org
call the comment line at +1 617-674-2369
use Odeo to leave a voice mail through your computer:
http://odeo.com/sendmeamessage/Sheeri
or use the Technocation forums:
http://technocation.org/forum
Direct play this episode at:
http://technocation.org/content/oursql-episode-22%3A-things-avoid-mysql-queries
Feature:
Things to Avoid in Queries
Subqueries and Correlated subqueries
http://dev.mysql.com/doc/refman/4.1/en/correlated-subqueries.html
Jan Kneschke’s post on Groupwise Maximum:
http://jan.kneschke.de/projects/mysql/groupwise-max
Calculated comparisons do not use indexes
INSERT IGNORE
REPLACE
INSERT…ON DUPLICATE KEY
Feedback:
Email podcast@technocation.org
call the comment line at +1 617-674-2369
use Odeo to leave a voice mail through your computer:
http://odeo.com/sendmeamessage/Sheeri
or use the Technocation forums:
http://technocation.org/forum
Direct play this episode at:
http://technocation.org/content/oursql-episode-22%3A-things-avoid-mysql-queries
Direct play this episode at:
http://technocation.org/content/oursql-episode-21%3A-rise-mysql-dba-1
Paul Vallee is back for this non-technical podcast about the special creature that is the MySQL DBA.
News:
October 2006 Enterprise/Community Split announcement
http://www.planetmysql.org/entry.php?id=4393
Current clarification of Enterprise/Community split
http://www.planetmysql.org/kaj/?p=123
Dorsal Source, a community-focused website whose goal is to provide builds of MySQL and related products.
http://www.dorsalsource.org
Learning Resource:
MySQL Camp II, August 23-24 2007, Brooklyn NYhttp://www.mysqlcamp.org
http://www.poly.edu
Feature:
The Pythian Group’s Paul Vallee
http://www.pythian.com
Feedback:
Email podcast@technocation.org
call the comment line at +1 617-674-2369
use Odeo to leave a voice mail through your computer:
http://odeo.com/sendmeamessage/Sheeri
or use the Technocation forums:
http://technocation.org/forum
Direct play this episode at:
http://technocation.org/content/oursql-episode-21%3A-rise-mysql-dba-1
Paul Vallee is back for this non-technical podcast about the special creature that is the MySQL DBA.
News:
October 2006 Enterprise/Community Split announcement
http://www.planetmysql.org/entry.php?id=4393
Current clarification of Enterprise/Community split
http://www.planetmysql.org/kaj/?p=123
Dorsal Source, a community-focused website whose goal is to provide builds of MySQL and related products.
http://www.dorsalsource.org
Learning Resource:
MySQL Camp II, August 23-24 2007, Brooklyn NYhttp://www.mysqlcamp.org
http://www.poly.edu
Feature:
The Pythian Group’s Paul Vallee
http://www.pythian.com
Feedback:
Email podcast@technocation.org
call the comment line at +1 617-674-2369
use Odeo to leave a voice mail through your computer:
http://odeo.com/sendmeamessage/Sheeri
or use the Technocation forums:
http://technocation.org/forum
In this less technical episode we interview Paul Vallee, where he explains in depth about the Pythian Group.
Special thanks to folks who have linked to the podcast:
WebDevRadio
http://www.webdevradio.com
Episode 34, July 9th, in which Michael mentions OurSQL and hopes I haven’t “gone dark”. Nope! http://www.webdevradio.com/index.php?id=50
Kristina Hadges, a web designer, linked to the podcast
http://www.nineofnine.com/resources
Feature:
The Pythian Group
http://www.pythian.com
Feedback:
Direct play this episode at:
http://technocation.org/content/oursql-episode-20%3A-pythian-group
Feedback:
Email podcast@technocation.org
call the comment line at +1 617-674-2369
use Odeo to leave a voice mail through your computer:
http://odeo.com/sendmeamessage/Sheeri
Or use the Technocation forums:
http://technocation.org/forum
In this less technical episode we interview Paul Vallee, where he explains in depth about the Pythian Group.
Special thanks to folks who have linked to the podcast:
WebDevRadio
http://www.webdevradio.com
Episode 34, July 9th, in which Michael mentions OurSQL and hopes I haven’t “gone dark”. Nope! http://www.webdevradio.com/index.php?id=50
Kristina Hadges, a web designer, linked to the podcast
http://www.nineofnine.com/resources
Feature:
The Pythian Group
http://www.pythian.com
Feedback:
Direct play this episode at:
http://technocation.org/content/oursql-episode-20%3A-pythian-group
Feedback:
Email podcast@technocation.org
call the comment line at +1 617-674-2369
use Odeo to leave a voice mail through your computer:
http://odeo.com/sendmeamessage/Sheeri
Or use the Technocation forums:
http://technocation.org/forum
In this episode we tackle what a hash looks like in terms of a data structure, in preparation for next episode’s discussion on the difference between hashes and btree indexes, and what kind of indexes are good for what kind of optimizations.
Show Notes:
Direct play this episode at:
http://technocation.org/content/oursql-episode-17%3A-hashing-it-out-0
Download all podcasts at:
http://technocation.org/podcasts/oursql/
Subscribe to the podcast at:
http://feeds.feedburner.com/oursql
News:
MySQL Connector/NET 5.1.1 released:
http://tinyurl.com/23a9ax
Download the new Connector/NET version:
http://dev.mysql.com/downloads/connector/net/5.1.html
MySQL 5.0.x security vulnerability:
http://bugs.mysql.com/bug.php?id=27513
Solution: upgrade to 5.0.40. This bug is not known to affect major versions 3 or 4.
Learning Resource:
http://onlinesolutionsmysql.blogspot.com/
The dates for the all the sessions:
* 27th March: Part 1 – High Availability and Scalability Architectures
* 19th April: Part 2 – Advanced Scalability Solutions
* 2nd May: Part 3 – MySQL Enterprise To Control Mission Critical Online Services
* 23rd May: Part 4 – 99.999% High Availability solutions
* 13th June: Part 5 – MySQL Enterprise performance and benchmarking
* 27th June: Part 6 – Advanced HA solutions
Find all the material and documentation for past webinars at:
http://onlinesolutionsmysql.blogspot.com/2007/03/links-to-material-and-documentation.html
Feature: Hash tables explained.
http://www.sparknotes.com/cs/searching/hashtables/section1.html
http://www.cs.sunysb.edu/~algorith/lectures-good/node7.html (search for “Hash Tables” on the page)
Feedback:
Email podcast@technocation.org
call the comment line at +1 617-674-2369
use Odeo to leave a voice mail through your computer:
http://odeo.com/sendmeamessage/Sheeri
Or use the Technocation forums:
http://technocation.org/forum
In this episode we tackle what a hash looks like in terms of a data structure, in preparation for next episode’s discussion on the difference between hashes and btree indexes, and what kind of indexes are good for what kind of optimizations.
Show Notes:
Direct play this episode at:
http://technocation.org/content/oursql-episode-17%3A-hashing-it-out-0
Download all podcasts at:
http://technocation.org/podcasts/oursql/
Subscribe to the podcast at:
http://feeds.feedburner.com/oursql
News:
MySQL Connector/NET 5.1.1 released:
http://tinyurl.com/23a9ax
Download the new Connector/NET version:
http://dev.mysql.com/downloads/connector/net/5.1.html
MySQL 5.0.x security vulnerability:
http://bugs.mysql.com/bug.php?id=27513
Solution: upgrade to 5.0.40. This bug is not known to affect major versions 3 or 4.
Learning Resource:
http://onlinesolutionsmysql.blogspot.com/
The dates for the all the sessions:
* 27th March: Part 1 – High Availability and Scalability Architectures
* 19th April: Part 2 – Advanced Scalability Solutions
* 2nd May: Part 3 – MySQL Enterprise To Control Mission Critical Online Services
* 23rd May: Part 4 – 99.999% High Availability solutions
* 13th June: Part 5 – MySQL Enterprise performance and benchmarking
* 27th June: Part 6 – Advanced HA solutions
Find all the material and documentation for past webinars at:
http://onlinesolutionsmysql.blogspot.com/2007/03/links-to-material-and-documentation.html
Feature: Hash tables explained.
http://www.sparknotes.com/cs/searching/hashtables/section1.html
http://www.cs.sunysb.edu/~algorith/lectures-good/node7.html (search for “Hash Tables” on the page)
Feedback:
Email podcast@technocation.org
call the comment line at +1 617-674-2369
use Odeo to leave a voice mail through your computer:
http://odeo.com/sendmeamessage/Sheeri
Or use the Technocation forums:
http://technocation.org/forum
Mehlam Shakir, CTO of RippleTech, discusses a practical approach for auditing MySQL databases to meet security and compliance regulations. Hear real-world cases and see a live demonstration of how RippleTech’s Informant solution compliments MySQL by adding a security layer without any performance impact.
For more information on RippleTech’s INFORMANT, visit http://www.rippletech.com/
I have to say, I was a bit worried this would be a typical vendor presentation where every other word is marketing speak for how great the product is. It actually just ended up being “here’s how Informant works, and here’s how auditing, security and compliance needs can be met,” presented in a way that’s useful and valuable to anyone who is interested in auditing or security.
Rippletech’s Informant is not only interesting because it’s currently the only software that audits MySQL, but it’s impressive in its simplicity and flexibility. I think my favorite surprise about Informant was that it has the ability to store a user session as just that.
Download the video of the presentation at:
http://technocation.org/movies/mysql/AuditingRippleTech2007MayUGbig.wmv”>http://technocation.org/movies/mysql/AuditingRippleTech2007MayUGbig.wmv
http://technocation.org/movies/mysql/AuditingRippleTech2007MayUGbig.wmv (446 Mb)
Mehlam Shakir, CTO of RippleTech, discusses a practical approach for auditing MySQL databases to meet security and compliance regulations. Hear real-world cases and see a live demonstration of how RippleTech’s Informant solution compliments MySQL by adding a security layer without any performance impact.
For more information on RippleTech’s INFORMANT, visit http://www.rippletech.com/
I have to say, I was a bit worried this would be a typical vendor presentation where every other word is marketing speak for how great the product is. It actually just ended up being “here’s how Informant works, and here’s how auditing, security and compliance needs can be met,” presented in a way that’s useful and valuable to anyone who is interested in auditing or security.
Rippletech’s Informant is not only interesting because it’s currently the only software that audits MySQL, but it’s impressive in its simplicity and flexibility. I think my favorite surprise about Informant was that it has the ability to store a user session as just that.
Download the video of the presentation at:
http://technocation.org/movies/mysql/AuditingRippleTech2007MayUGbig.wmv”>http://technocation.org/movies/mysql/AuditingRippleTech2007MayUGbig.wmv
http://technocation.org/movies/mysql/AuditingRippleTech2007MayUGbig.wmv (446 Mb)
I take the easy way out again this week by sharing Guy Kawasaki (of the How To Change the World blog) and his irreverent and truthful keynote at the 2007 MySQL Users Conference.
Kawasaki will challenge your thoughts about being an entrepreneur in the technology industry.
The big news is that soon I’ll be able to announce that the videos from the conference sessions are up….stay tuned!
Show Notes:
Guy Kawasaki’s Blog: How to Change the World
http://blog.guykawasaki.com/
Direct play this episode at:
http://technocation.org/content/oursql-episode-16%3A-art-innovation%2C-guy-kawasaki
Download all podcasts at:
http://technocation.org/podcasts/oursql/
Subscribe to the podcast at:
http://feeds.feedburner.com/oursql
Feedback:
Email podcast@technocation.org
call the comment line at +1 617-674-2369
use Odeo to leave a voice mail through your computer:
http://odeo.com/sendmeamessage/Sheeri
Or use the Technocation forums:
http://technocation.org/forum
I take the easy way out again this week by sharing Guy Kawasaki (of the How To Change the World blog) and his irreverent and truthful keynote at the 2007 MySQL Users Conference.
Kawasaki will challenge your thoughts about being an entrepreneur in the technology industry.
The big news is that soon I’ll be able to announce that the videos from the conference sessions are up….stay tuned!
Show Notes:
Guy Kawasaki’s Blog: How to Change the World
http://blog.guykawasaki.com/
Direct play this episode at:
http://technocation.org/content/oursql-episode-16%3A-art-innovation%2C-guy-kawasaki
Download all podcasts at:
http://technocation.org/podcasts/oursql/
Subscribe to the podcast at:
http://feeds.feedburner.com/oursql
Feedback:
Email podcast@technocation.org
call the comment line at +1 617-674-2369
use Odeo to leave a voice mail through your computer:
http://odeo.com/sendmeamessage/Sheeri
Or use the Technocation forums:
http://technocation.org/forum
Eben Moglen, director of the Software Freedom Law Center, discusses why Free Beer isn't so good if your data are getting drunk! The keynote looks at how "Free as in Freedom" businesses help prevent the ultimate privacy catastrophe.
This speech is not to be missed!
Direct play this episode at:
Eben Moglen, director of the Software Freedom Law Center, discusses why Free Beer isn't so good if your data are getting drunk! The keynote looks at how "Free as in Freedom" businesses help prevent the ultimate privacy catastrophe.
This speech is not to be missed!
Direct play this episode at:
If you can find me today during the MySQL Conference & Expo, I have a limited amount of DVD’s that contain all 15 podcasts on them. If you have been thinking you wanted to listen to the podcast but haven’t gotten around to downloading the episodes yet, here’s your chance! Just find me — Today I’m in a red top and black skirt….
If you can find me today during the MySQL Conference & Expo, I have a limited amount of DVD’s that contain all 15 podcasts on them. If you have been thinking you wanted to listen to the podcast but haven’t gotten around to downloading the episodes yet, here’s your chance! Just find me — Today I’m in a red top and black skirt….