The InnoDB plugin keeps on looking better.
Paul and I spent a few weeks working on bug 46459. After fixing it I found out that this was already fixed in the InnoDB plugin as part of the change to enable group commit and fix bug 13669. This change can make InnoDB much faster for workloads that do a lot of inserts into tables with an auto increment column when autocommit statements are used.
…
[Read more]Oracle is keeping MySQL. Yahoo is selling Zimbra. Linus is feeling bloated. And more.
Follow 451 CAOS Links live @caostheory on Twitter and
Identi.ca
“Tracking the open source news wires, so you don’t have
to.”
# Larry Ellison reportedly said Oracle has no intention of spinning off MySQL.
# Yahoo is trying to sell Zimbra, according to All Things D.
# Linus Torvalds said Linux is “bloated and huge”.
# GroundWork Open Source released GroundWork Monitor 6.0.
# Zend launched Simple API for Cloud Application …
[Read more]
I have somehow managed to weasel been selected to speak at a few
of the upcoming conferences this October. I will be
presenting at the various conferences either on Performance
tuning the MySQL server or on using EXPLAIN. I know... I
know - they must be crazy to have picked me, but I am not crazy
enough to turn down the opportunity.
I will be speaking at Codeworks -Miami (Sept 30 - Oct 1), the Zend PHP Conference (Oct 19 - 22) and the Florida Linux Show (Oct 24) so if you are attending or just in the area - be sure to find me for a chat. If you are at the Florida Linux Show I will be in the MySQL booth and should also have some goodies to hand out as well - thanks to …
[Read more]
I've managed to find a way to connect MySQL directly to Google
Spreadsheets and although that its not yet perfect, it does show
a lot of potential.
You will have a MySQL table directly fed into Google
Spreadsheets. From there, you could do some charts, highlights
some trends or simply share the data as is with our people in our
out of your organization is a secure way.
The end result should look something like
this:
What you will need:A Linux
Server with Apache and MySQLA Google Apps Premier
accountGoogle Secure Data Connector installed on your
Linux server
SDCInstalling the SDC is a bit tricky but not too
difficult and there is a lot of documentation as to how to do it.
A lot of it is giving things the right permissions and
configuring 2-3 XML files.
You can read more about how SDC works, but …
Image by Snooch2TheNooch via Flickr
I was speaking with Michael Stonebraker this morning. I mentioned that lately many have been referencing comments he has made over the last couple of years. And I also mentioned that many had interpreted them as he was implying the RDBMS is “doomed”. Mike has been saying the same thing for years, but the current NoSQL movement seems to have picked up on this and highlighting one of the RDBMS's own pioneers is predicting its …
[Read more]What is the peak QPS for a MySQL server? I don't know so I created a very artificial benchmark to find out. I then ran that benchmark for MySQL 5.0.84 and 5.1.38 using several storage engines. I was able to exceed 100,000 QPS for the HEAP and InnoDB storage engines. It would be nice if I could get that on a production server.
The benchmark was run on an 8-core x86 server. Clients and mysqld ran on the same server. The clients used mysqlslap and mysqld versions 5.0.84 and 5.1.38 were used. For MySQL 5.1.38, the built-in and plug-in versions of InnoDB were used. The input to mysqlslap was a file with 1M identical SELECT statements and it was run using 1, 2, 4, 8 and 16 concurrent sessions. The test was run in 3 modes:
I've just spent an hour of my spare time watching an exceptional
UC Berkeley Lecture by Arun Sarin, former Vodafone's CEO. He
shared his thoughts on leadership, focusing on four major topics
that a leader should always keep in mind. I'll try to summarize
some points that I intend to keep in mind.
Strategy
Always look at the big picture, keep an eye on what will be your
company in 5,10, 15 years. Try to understand the world and
anticipate trends. Comunicate clearly through mission and vision
and make sure that every step is in the right direction.
Operations
While a good leader should be strategic, never underestimate the
daily operations. Make sure that your customers have a good
experience with the company. Be sure that they have the needed
attention if an issue arises.
People
Be an overall nice person to work with. Choose the right
people in the right …
The next meeting of the North Texas MySQL Users Group is next Monday and the presentation will be on designing database tables. This is part of a series for novices with MySQL and/or databases. Too often novices commit obvious sins like BIGINTs for any numeric storage field or indexing every column. EXPLAIN is a valuable tool in optimizing SELECT statements but too many DBAs do not discover it until well after they are stuck with a small, unruly group of badly designed tables.
Using EXPLAIN is seen as a 'dark art' by too many and hopefully we can get the novices in North Texas off on the right foot. The meeting is free and starts at 7:00 PM in the Sun Offices, Suite 700, 16000 Dallas Tollway, in Dallas. All are welcome and please try to be a bit early as the …
[Read more]
The present in my RSS feed this morning was an article by Peter
Zaitsev on :
http://www.mysqlperformanceblog.com/2009/09/20/guidance-for-mysql-optimizer-developers/
One of the changes made recently to Drizzle, is a redesign of our executioner.
This was done by Padraig. MySQL inherited a design where the parser
uses one Global Lex Structure to fill in the members of the query
for later use. This structure has members in it for every form of
query that can be executed. The structure is also assigned an
ENUM that will be used later for determining if the query is a
SELECT, INSERT, etc... via a switch/case dispatcher.
This of course creates a number of limitations in the design,
especially for Drizzle …
Many people noticed my tweet just over a week ago that I tendered my
resignation at Sun Microsystems. Many people asked me "what
next?". Here is my What Next:
Today is the first day of my new job at Gear6, as the Director
of Community Development.
In part, this means that I will be doing for Gear6 what Jay and then Dups used to do for
MySQL.
I'm the face of my company into the Memcached / Gearman / Drizzle
/ etc communities, and just as importantly, I'm the face of those
open source communities into my company.
I was very positively impressed with the people at Gear6 when we
were interviewing each other. I truly believe that they want to
do The Right …
