I went to Microsoft with Arjen the other day. We talked with Eric Lippert about some new features of C# 3.0 and how MySQL might integrate itself more deeply into the Microsoft Development Environment.
More details if anyone makes noise about being interested.
© cjcollier for C.J.'s WordPress of studlyness, 2006. | Permalink | 5 comments
Add to del.icio.us
Search blogs linking this post with …
[Read more]SHOW ENGINE INNODB STATUS shows current InnoDB status, including deadlocks. I was thinking a while back it would be nice to have a log of all deadlocks. Well, I got my answer:
http://dev.mysql.com/doc/refman/5.0/en/innodb-monitor.html
To cause the standard InnoDB Monitor to write to the
standard output of mysqld, use the following SQL
statement:
CREATE TABLE innodb_monitor (a INT) ENGINE=INNODB;
The monitor can be stopped by issuing the following statement:
DROP TABLE innodb_monitor;
The ever cryptic Mr. Love posted a screenshot of a very funny NetworkManager easter egg with a checkbox for “sniff key and login automatically” when configuring the connection to wireless network. I wonder if we should make a GUI in the same spirit for setting up new MySQL replication slaves, with some kind of option “crack password and copy all data automatically”.
[Read more]
Recently I joined a networking group, and I received a
spreadsheet containing their membership rolls. Of course the
first thing I wanted to do was import it into MySQL. Then someone
in the forums asked about the very same thing, so I thought I'd
document this process here.
The first challenge was the fact that the membership list was on
three separate worksheets, and each had a different column
layout. I saved the worksheets into text files and imported them
into Microsoft Access since it has the facility to create tables
using columns derived from text in the first row of the file. I
then imported these tables into a MySQL database.
From there I was able to juxtapose the columns correctly and
merge these tables into one, with the addition of a new column
indicating which worksheet each row originally came from. Then
the fun began. There were two columns, one for current employer
and another with a list of past …
OK, back from the Users Conference, which was an absolute blast (will write about my thoughts on that a little later today). I've finally gotten around to cleaning up two slide decks for my Index Tuning and Coding Techniques for Optimal Performance and Performance Tuning Best Practices. I exported the slides to PDF format so that there were no cross platform issues. Cheers!
By tim
Once Greg Linden had pinged me about BigTable (leading to yesterday's entry), it occurred to me to ask Greg for his own war stories, both at Findory and Amazon. We hear a recurrent theme: the use of flat files and custom file systems. Despite the furor that ensued in the comments when Mark Fletcher and Gabe Rivera noted that they didn't use traditional SQL databases, Web 2.0 applications really do seem to have different demands, especially once they get to scale. But history shows us that custom, home-grown solutions created by alpha geeks point the way to new entrepreneurial opportunities... Greg wrote: There are a couple stories I could tell, one about the early systems at Amazon, one about the database setup at Findory.
On Findory, our traffic and crawl is much …
[Read more]
Finally back home after some R&R at Yosemite before leaving
the US. In conclusion, to sum up my experience of the 4th Annual
MySQL Users
Conference “Excellent”.
Here’s my take. Friends, Functionality & New
Features, the Future.
Friends
I’ve used MySQL now for over 6 years, and full time for a number of years, yet I’ve only become active in the MySQL community, particularly Planet MySQL in the past 6 months. Over that time, I’ve read a lot from members, and heard from many people. It was great at the conference to meet many of these people for the first time. The list includes: Community Members - Frank Mash, …
[Read more]MySQL AB :: MySQL: The World’s Most Popular Open Source Database
The cool thing is I wasn’t the one who noticed it. A holler goes out to Timmeah!
Julian Cash has been taking very cool shots of various people (attendees and employees) at the MySQL Users Conference - check them out!
I totally broke MySQL 5.0.21 :(
Also broke the LSI megaraid driver (this was what all my megaraid
whining was about).
and uh, broke eAccelerator, but not as much. Someone else is on
the track to fixing it.
It's been a great month for open source software! MySQL is
disappointing though. If you open a MyISAM table via an INSERT,
there's a high chance the thread will deadlock and die forever
(probably only on x86_64 64-bit builds though.). I have a
poorly worded bug report up. I'll also be
officially filing a kernel bugzilla report for the megaraid
problem once I confirm that 2.6.17-rc3 and 2.6.17-rc3-mm1 don't
fix the issue.
On the plus side all of my MySQL 5.0 master-master clusters are
going up regardless of that bug.
Boring huh?
Next week I'm going to be dorking around with initramfs to …
