Yesterday I presented “Best Practices for Database Administrators” at the MySQL User Conference and Expo. There are links to the slides and video in this post.
Jonathan Schwartz’s Keynote at the 2008 MySQL Conference can be played from the embedded video at the bottom of this post or directly at YouTube (follow the link in this post)
SQL Server 2005 brought some relief in the form of the Forced Parameterization database option, and SP2 took things one step further with better throttling of the cache… but it’s still not enough. We want a knob! The bad news: We’re not getting quite the knob I was hoping for. The good news: SQL Server 2008 will include an sp_configure option called “optimize for ad hoc workloads”
I arrived at Santa Clara yesterday, just in time for the MySQL Community dinner (check this post on Arjen’s blog). It was a lot of fun, not to mention the opportunity to talk to developers and other folks from MySQL/Sun. I’ve been to a bunch of great presentations and sessions so far, have a look at my post to find out more and stay tuned for updates.
How creative are you with manipulating your queries to produce more efficient plans? Try the following puzzle and e-mail your solution to me at [
I recently implemented OID/SSO with E-Business Suite 11.5.10 CU2, and experienced some issues after the entire setup went smoothly. I hope this note might help others troubleshoot, as it took me a while to figure out the root cause of the problem.
Reading PlanetMySQL today, I discovered that Alex Gorbachev’s announcement that he has released the first public beta of his Oracle Grid Control plugin for MySQL was not aggregated! Knowing that my feed is aggregated, and not willing to let this news and this amazing work go unnoticed by the MySQL community during the conference (I am at MySQLConf listening to Amazon.com’s CTO speak right now!) you can access the update here.
sec p, dsk p, gets p, rows p, cpu p — these are average statistics for the query being executed. This should give you a quick overview of whether the query is a big query, a small query, a CPU-intensive or a disk I/O-intensive query. Be careful: since the query was introduced to the shared pool, those columns are averages, and therefore could be misleading. These are all per execution stats, so sec p represents the number of seconds on average it took to execute the query.
has finally happened! The first public release of the MySQL plug-in for Oracle Enterprise Manager 10g Grid Control is out. In the last few months, more and more people showed interest in the potential plug-in, and even few guys from Oracle contacted me independently of each other with their own reasons to have a MySQL plug-in available. This interest accelerated the fermentation of thoughts in my brain, and I got down to work. Pythian generously sponsored my development time. Here are the details. The first release version is 0.42 because that’s obviously the perfect number to start something good.
I am finally able to announce when and where the Pythian BoF session has been scheduled! It will be in the Alameda room, 7:30-8:30pm on Tuesday, April 15th. The session, titled “Ask the Pythian Maestro”, will be attended by myself and our two MySQL team leads, Sheeri K. Cabral and Augusto Bott.