Mysql
Killing my softly with QUERY
The MySQL KILL command as the name suggests kills queries that are running. After identifying the Id using the SHOW PROCESSLIST command, the User of the connection/thread or a database user with SUPER privileges can execute KILL [id]; to remove the connection/thread.
Read morePercona Performance Conference Talk
My final presentation during the 2009 MySQL Conference and Expo week was with the Percona Performance Conference on the topic of The Ideal Performance Architecture. My talk included discussions on Technology, Disk, Memory, Indexes, SQL and Data.
Read moreExtending the MySQL Data Landscape
Learn how to extend your existing MySQL based website to leverage the power of MySQL variants, AWS cloud based MySQL deployments and RDBMS alternatives. Evaluate how to integrate and use these different various technologies such as MySQL based variations KickFire, a column based optimization and InfoBright, a data warehousing solution.
Read moreA 5.1 QEP nicety – Using join buffer
I was surprised to find yesterday when using MySQL 5.1.26-rc with a client I’m recommending 5.1 to, some information not seen in the EXPLAIN plan before while reviewing SQL Statements.
Read moreMySQL Monitoring 101 – Graph your results
The problem Hands up those that don’t monitor their production MySQL web server. I’m a little surprised by this, but I’ve visited several clients that have absolutely no monitoring other then “the customers will tell us when something is wrong”.
Read moreUltimateLAMP
This product is no longer available. This was created over 6 years ago and software is too out of date. As I discussed earlier in [A picture can tell a thousand words][1], I outlined briefly what the intention of **UltimateLAMP** was for.
Read more