MySQL
MySQL NY Meetup – Part 2 in our series
Last night at the MySQL NY Meetup we continued on from a very successful July presentation on “Practical Performance Tips & Tricks”. I must admit after speaking and standing all day for the MySQL DBA Bootcamp for the Oracle DBA it was a stretch, and we didn’t cover all material as expected, but the evening was still very productive to everybody.
Read moreLearning MySQL as an Oracle DBA
Updated I have an entire section now devoted to various MySQL for the Oracle DBA Resources . You will find additional information here. This week I presented two one day free seminars, “MySQL DBA Bootcamp for the Oracle DBA ” in New York and San Francisco.
Read moreLet’s improve MySQL security
We have all done it in the past, and probably most people that read this (will admit| or lie) to still doing it, but everybody must start making an effort to improving MySQL security in the usage on your MySQL Installation, including just on your laptop, and in presentations that people read.
Read more5.1.20 Gotcha – The MySQL Error Log
While using the latest MySQL 5.1.20 yesterday I came across another situation that was not expected as with previous editions of MySQL. The background is experimenting with DRBD. When I configured MySQL to startup with a /etc/my.
Read moreMySQL 5.1.20 Installation
MySQL recently released 5.1.20 beta . I just ran into another gotcha, which prompted me to post this draft I’ve had for a while. rbradford@newyork:/opt/mysql51$ scripts/mysql_install_db Installing MySQL system tables... 070709 23:24:08 [Note] Plugin 'InnoDB' disabled by command line option OK Filling help tables.
Read moreOS Freedom
I’m at some internal MySQL training today at our US HQ. In a room of 11 people we are all using our laptops for access to additional machines. The beauty of this is we have Linux (Ubuntu 5.
Read moreMySQL NY Meetup Presentation
Tonight I spoke at the NY MySQL Meetup . The topic “Practical Performance Tips & Tricks” was a full packed 1 hour session, with 4 x 15 minute sections on Beginner, Intermediate, Advanced and MySQL Proxy.
Read moreMySQL Proxy. Playing with the tutorials
I was playing with the 5 sample tutorial Lua scripts available here with the MySQL Proxy , but I was doing something a little inefficiently. I started mysqld, then I started the MySQL Proxy with the lua script, then connected to MySQL via the proxy.
Read moreWhat’s your disk I/O thoughtput?
MySQL uses disk. Ok, so everybody knew that. MySQL uses disk in two primary ways. Random I/O (Reading & Writing Data/Index blocks) Sequential I/O (Binary Log, InnoDB Redo Log) Historically it’s been best practice to separate these onto different spindles, and also separating the OS and tmp space onto a third spindle.
Read moreTop 5 Best Practices for MySQL
We had the Top 5 wishes for MySQL started by Jay recently. So in true chain letter fashion I’m starting a new one this week. “The top 5 Best Practices for MySQL”.
Read moreGot MySQL Proxy yet!
If you haven’t got MySQL Proxy yet, then stop and get it now. Jan announced the release a few days ago of this new product offering from MySQL . I first heard about MySQL Proxy at the recent MySQL Conference 2007 and actually used it a few weeks later to help address slow running queries during benchmarking with a granularity of milliseconds — Wow.
Read moreQuery Cache is deterministic
I was reading some points on a Blog post today here . I didn’t see it via Planet MySQL but via a Google Alert. The post has several good beginner points on MySQL Performance, but included the point “Literal current date is better than using the CURRENT_DATE() function because literals will use the query cache but functions won’t.
Read moreMy ‘Hourly’ MySQL Monitor Script Version 0.05
I’ve been able to steal some more time to work on my script following My ‘hourly’ MySQL monitor script Version 0.03 almost a month ago. The purpose of this script is simple.
Read moreWatching for Disk Based Tables being created
I didn’t know you could actually do this before addressing this problem in a benchmark using 5.0.36. MySQL allows you to update two tables with a single UPDATE statement. I knew you could reference two tables in an UPDATE statement but not update both.
Read more