ALL POSTS

MySQL Sandbox: Easily Using Multiple Database Servers in Isolation

Why the sandbox? To be able to set up 1 server in under 10 seconds. And to be able to set up multiple MySQL instances very quickly, and to use them quickly. The sandbox untars in seconds, for installing alternative servers, not main instance, it creates a separated environment (datadir, port, sockets) — for groups of related or unrelated servers. Really good for testing out new server versions. Save yourself some time and read this post to find out how to automate MySQL Sandbox!

Arrived at COLLABORATE 08

I’m at Collaborate 08 in Denver right now.My presentation, Oracle 11g New Features Out of the Box, was originally scheduled on Thursday at 9:45 AM but due to participation in the speaker panel ,”To RAC or Not To RAC: What’s Best for HA?”, it was rescheduled to today, Wednesday, at 4:30 PM. I’m off to the Carol Dacko’s presentation about DBMS_XPLAN now and looking forward to show up at the RAC SIG Birds of a Feather later today. Stay tuned – more to come…

SQL Server Procedure Cache: More Relief on the Way

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”

First Impressions at the MySQL Users Conference 2008

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.

SQL Server Query Processing Puzzle: LIKE vs ?

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 [ @ pythian.com]. Make sure to include an explanation of why it works, as well as your mailing address. The best two solutions/explanations win a free copy of Expert SQL Server 2005 Development, a wonderful feeling of accomplishment, plus eternal fame and glory when I reveal your solutions here on the blog.

MySQL Plug-in for Oracle Grid Control Announced, Released

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.

Recent Spike Report from v$active_session_history (ASH)

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.

Page 215 of 278« First...102030...213214215216217...220230240...Last »