With MySQL 5.1 you can store the general query log in a table. But what if you don't want to log every single statement but only the users logging in and the hosts they're coming from? There exists in fact a very simple solution that even works with MySQL 5.0 and (with some changes) with earlier versions.
The idea is to use the init_connect server variable as a hook to install a logging
routine. The init_connect variable holds SQL
statements to be executed for each client that connects (except
for SUPER users).
We need to create a database and a table first to hold our
connection log. I don't really recommend to use the
mysql database for this as we don't know what might
be added in there by future …
I have a new web site. I registered the datacharmer.org and
datacharmer.com domains, which are now jointly my
main page. (Both addresses point to the same page)
Another change involves the MySQL General Purpose Stored Routines Library,
which has evolved to version 1.0 (not alpha anymore). Its home is
now at SourceForge.
What is your role?
My title is Director of Architecture, and in MySQL's history that
has meant I have done everything from write code, assign bugs,
handle operations for engineering, talk to customers, speak at
conferences, and once help peel potatoes for dinner. Today I
handle technical direction for MySQL, lead architects/senior
engineers, and study how are market is evolving. I also still
write code from time to time.
What is your computer setup?
I use a 15in PPC Apple Laptop.
What desktop software applications do you use daily?
When browsing I use Safari, but today I read far more RSS then I
read web pages. For RSS I use an application called NewsFire. It
allows me to scan all of my RSS headlines and select what I want
to read. For some feeds I just use the spacebar to tab through
all of the articles in the feed. All of my appointments go into
iCal, and all addresses go into Addressbook. …
A few weeks back Jay and I hooked up with Tom Parish over at DBAZine for the DBAZine podcast. Was a lot of fun to talk with Tom and get a chance to answer questions about open source, MySQL, blogging and a host of other things. The teaser goes something like:
The new book is ProMySQL, covering all of the newest MySQL 5 features, the MySQL server architecture, storage engines, transaction processing, benchmarking, and advanced SQL scenarios. And the authors, Jay Pipes and Michael Kruckenberg, are not too shy to open up about a big range of big topics, including whether open source software will ever displace those legacy apps (and why CIOs who insist it won't should take a closer look at what?s running in their enterprise). They also give their views on what they see as the biggest challenge to open source as …
[Read more]
Hi,
I decided to start blogging about MySQL stuff in the different
blog http://www.mysqlperformanceblog.com This will give
me more control allowing to publish files on the same web site as
well as track visitors stuff. I will be still updating this one
every so often with my personal records.
For LiveJournal users - I've created syndication account "mysqlperf" which syndicates my new blog, so you
can just add it to your friends list if you want to follow new
blog.
PlanetMySQL.org is not updated yet to include new blog. I hope
this will happen soon.
Lets hope I'll have time to update my new blog more frequently.
And your comments surely would be good motivator :)
There is a new entry in the developer notes series, available at
This one covers managing hierarchies using stored procedures and the nested set model.
Ronald
recently asked to provide a list of Open Source software that I
have used or recommend. Here's a list that I compiled in one
sitting. Since I have been working with OSS for quite sometime
now, this list is just a sample. As time permits, I will add more
to this list.
1. Typo
(RoR) [some issues with RoR 1.1]
2. phpMyAdmin
3. OSCommerce [Recommended if you're ready to make a
lot of customizations]
4. Interchange (Perl) [Overkill for small projects
but ideal for large scale ones. At one point, Google used to use
Interchange to power their online store. Now they use
OSCommerce.]
5. …
I have been receiving a lot of requests from all over the US
regarding DBA jobs. If you are currently looking for some hot
jobs, drop me an email by writing to softwareengineer99 at yahoo
dot com. Some of the jobs are offering as much as 150K.
I would also be interested in hearing from you if you have a
position open in your company.
Is there any site that helps connect MySQL DBAs with the open
jobs worldwide?
Farhan / Frank
I am moderating the panel "Stories from the Front Line : Open Source solutions: Show me the Money" at TIECon tomorrow at 12 Noon featuring these fine fellows:
Richard Gorman, Venture Partner Bay Partners
Michael Olson, Vice President Oracle
Zack Urlocker, Executive Vice President, Products MySQL AB
Peter Yared, Founder and CEO ActiveGrid
Come and say hi and tell me you read this blog post so I know that Matt and aren't just writing to each other.