I’ll present a session on the innotop MySQL and InnoDB monitoring tool at 2007 MySQL Conference and Expo in a couple of weeks. The innotop session will focus on using innotop’s basic and intermediate-level features. I’ll demonstrate how to install it and get the initial configuration set up. I’ll show you what innotop is good at doing, and how to do some of the things I do frequently, such as watch queries, check replication status, and look at what transactions are currently open.
As you probably have noticed my blog has been a bit quiet lately.
I've
been very busy with some very interesting developments. I've
been
working very hard on benchmarking of MySQL Cluster together
with
Dolphin and Intel. There will be a lot of material coming out
from this
the next couple of weeks. I've prepared a couple of white papers
on
how MySQL Cluster can scale to new heights.
I'll have a presentation at the MySQL Users Conference
http://www.mysqlconf.com
where I'll describe all the interesting tidbits of how to tune
MySQL
Cluster performance. This will include both choice of HW, use
of
configuration parameters, which particular new features to
especially
look out for and so forth.
If you want to prepare for this then download the white papers
that
will be available from MySQL and from Dolphin
http://dev.mysql.com
…
In about two weeks, I'll by flying to Santa Clara to attend the MySQL Conference. While this is pretty cool by itself, there's more. I won the trip and all expenses are covered by the cool guys at Proven Scaling!
A few weeks ago, they came out with the offer to send three people from around the world to the conference. All you had to do was to describe why you want to go, why they should pick you and what you do. I did that and here I go :-)
Congratulations to Sean Walberg and Carlos Proal Aguilar, the other two winners. See you in California!
This will be my first trip to the West Coast and I'm really looking forward to see how things are in Silicon Valley. Jeremey from Proven Scaling was kind enough to schedule my flights so I could stay a few more days in Santa …
[Read more]My project has been linked to Digg.
I'm putting together a page of projects which use MySQLdb. If your project is not
on this list, leave a comment, with a URL and brief description,
and I'll check it out.
Frameworks/Libraries
- …
OK, so I apologize for the obviously attention-grabbing title of this blog. If you're still with me, give me a chance to explain why we can ALL get drunk with Eben at the conference in the spirit of true open source bazaar participation.
Eben Moglen, who is the Director of the Software Freedom Law Center, will be opening up our Wednesday morning keynote extravaganza with a talk entitled "Freedom Businesses Protect Privacy". When I first received a title from Eben, he had proposed the following title (snipped from my email from him):
"Why Free Beer Isn't So Good if your Data are Getting Drunk: How
Free as in Freedom Businesses Help Prevent the Ultimate Privacy
Catastrophe"
The …
Track: Security and Database Administration
Date: Tuesday, April 24
Time: 7:30pm - 8:30pm
Location: San Thomas, Santa Clara Convention Center
</p>
Do you have more MySQL daemons than you can keep track of? Do you learn when one goes down only after things have hit the fan? Would you like some advanced or at least timely warning?
Do you use SNMP and a management station to monitor the health and availablity of your switches and routers, and possibly your hosts. Would you like to manage your MySQL servers the same way, using the same tools? Come learn how you can.
There's a RDBMS-MIB. And now there's an AgentX subagent for it.
Come learn how it will make your life a little less stressful.
Hi!
Version 0.6 has been released, the big news is:
Discovery Support was added
Implemented row level locks
Fixed bug in deletion of keys
Fixed duplicate key bug
Updated stats for server status
Fixed issues in update for replacement of primary key.
What is discovery mode? It means that a table found by one MySQL
server can be found by another who has access to the memcache
cluster. This works because on CREATE TABLE a copy of the
definition of the table is placed inside of the memcache cluster
for other MySQL servers to find. This is not perfect yet and it
will need a bit more code to really scale (aka it needs resource
counting). This version has gotten quite a bit more outside
testing then previous versions so I expect quite a few SQL errors
are now gone.
You can find the announcement here:
…
I've been linked to DZone.com. DZone appears to be like furl and digg, where people submit links and other readers vote them up or down.
Mark has released his S3 engine:
http://fallenpegasus.livejournal.com/579770.html
S3 is the Amazon storage system. Personally I am very interested
to see how user's can put this to use. Being able to take data
and store it in a remote service has a lot of really interesting
possibilities (off lining OLTP, of site backups, simple ability
to push objects to S3...)
He is also speaking on it at the MySQL User's Conference:
http://www.mysqlconf.com/cs/mysqluc2007/view/e_sess/10822
He also has a BOF on his SNMP plugin (which I would think would
really shake people's worlds):
http://www.mysqlconf.com/cs/mysqluc2007/view/e_sess/14285
…