Last night I prepared a Debian package of MySQL
Proxy. It still lacks an init script and a manpage, but
beside that it works fine. I plan to finish and upload the
package to unstable within the next days.
For details about using MySQL Proxy read Getting Started with MySQL Proxy by Giuseppe
Maxia.
The latest from the MySQL community
Ideas, releases, practical guides, and perspectives from the people building with MySQL.
So, at midnight I got a call from customer service saying our site was slow. I narrowed it down to one of our auxiliary databases, that seems to have gotten wedged just about midnight. Normal queries that took less than 4 seconds started taking longer and longer, moving up to 5 seconds and past 30 seconds in the span of a minute or so.
In the moment, I thought killing off all the queries would be a good move. My kill script, which consists of:
for i in `/usr/bin/mysql -u user -pPass -e ’show full
processlist’ | grep appuser | cut -f1`
do
mysql -u user -pPass -e “kill $i”
done
This will attempt to kill any mysql connection owned by the appuser. I used it a few times, and it didn’t work. So I used a trick I learned when we bring our site down — sometimes there are straggling connections to mysql, so what I do is change the app user’s password by direct …
[Read more]As I wrote a few days ago, I’m writing the replication chapter for the second edition of High Performance MySQL. I’m writing about replication filtering rules right now, and I thought it would be good to get input on this. If you have favorite replication filtering tricks you’d like to share, or tasks that always frustrate and/or confuse you, please post them in the comments. I’m making a section that shows how to accomplish common filtering and rewriting needs, such as preventing GRANT statements from replicating to the replicas.
Yesterday I visited the MySQL Customer Conference in Munich. First of all, GDL sucks. But the locomotive driver strike was the only negative issue on that day, the conference itself was quite good, especially Jan Kneschke's talk about MySQL performance tuning (which was mostly about combining MySQL Cluster and MySQL Proxy) and the panel discussion about storage engines with Ralf Gebhardt, Jan Kneschke and Kai Voigt as vocal and Kaj Arnö as moderator. All in all a great (but quite long and exhausting) day.
Beta or not, here we come. Yea, you'd think I'd learn to check out the known bugs list before letting developers/qa have at the new database servers running in the lab with MySQL 5.1.21-b . I mean, how bad could beta really be?Well, as we should all know, beta is called beta for a reason, but sometimes we open source fanatics tend to jump on board, dealing with issues along the way. This
OK... This is my second entry on this blog. And it is about something I want every mysql/php newbie to know at the starting gate:
DON'T USE CHAR(15) FOR IP Address fields in mysql!
Well... what about the periods in ip addresses, you say?
Well... mysql has a FANTASTIC way of solving this issue! Convert the standard ip address into an unsigned integer!
ok... at first it sounds a little
Hello everyone, I think this will be a great log buffer. Dave has been sick these past two days and as a result, we do not have a comprehensive log buffer ready the way we or a volunteer usually do. This was bound to happen to log buffer at some point and today it has happened. So I [...]
How fast do you want your installation? Check this.
$ time ./express_install.pl ~/downloads/mysql-5.0.45-osx10.4-i686.tar.gz --no_confirm unpacking /Users/gmax/downloads/mysql-5.0.45-osx10.4-i686.tar.gz Executing ./install.pl --basedir=/Users/gmax/downloads/5.0.45 \ [...] Installing MySQL system tables... OK Filling help tables... OK [...] loading grants sandbox server started installation options saved to current_options.conf. To repeat this installation with the same options, use ./install.pl --conf_file=current_options.conf ---------------------------------------- Your sandbox server was installed in /Users/gmax/msb_5_0_45 real 0m6.773s user 0m0.245s sys 0m0.235s
Old times
MySQL has a long established rule of going from downloading to up and running in less than 15 minutes, as stated in various sources, like this interview …
[Read more]Local MySQL offices have hosted country-specific user or customer conferences in a number of countries this autumn:
- MySQL K.K. in Tokyo, Japan: MySQL Users Conference Japan 2007, 11-12.9.2007 at the Miraikan
- Linux Data Services in Seoul, Korea: MySQL Users Conference Korea 2007, 14.9.2007
- London, UK: MySQL Northern Europe Customer Conference, 16.10.2007 at the Cavendish Conference Centre
- Munich, Germany: …
Could Microsoft acquire an open source software vendor? Yes, is the answer, according to Steve Ballmer’s comments from the Web 2.0 Summit. However, I think there’s some reading between the lines to be done here. Microsoft could certainly buy an open source user, but at this stage an open source software vendor might be a step too far.
Here’s what Ballmer had to say, according to CNET:
“We will buy smaller companies. We will buy smaller companies that make some use of open source software,” he said. “We don’t want to discourage people who would talk with us just because they do some open source.”
It’s worth considering that Ballmer was speaking at a Web 2.0 event. As CRN points out, his comment is “a tacit acknowledgment of how thoroughly open-source …
[Read more]