Fast Database App = Hybrid Database App
Ok, so you're trying to figure out which transactional general
purpose
database engine is the fastest to build/deploy your app
with?
Now, since all engines (in the last 10 years) are MVCC, ARIES,
ACID... it's
going to be hard to find a database (or database storage engine)
that is a head
and shoulder above the rest... You can find, perhaps up to a 2:1
ratio, for a
specialized situation.
Remember now, TPC benchmarking was invented to standardiz e the
test, while
factoring in the cost of hardware — which levels the playing
field of
specialized hardware vs. unusual performance.
On the other hand, you might find a database, that outperforms in
a particular
niche table design due to a specialized indexing mechanism.
What does all this specialized hardware, indexing or such buy
you? …
Jim Starkey, who joined MySQL in January as part of our acquisition of his company Netfrastructure, will be speaking at the MySQL Users Conference on April 27 in Santa Clara on the new transactional storage engine that he's developed. Jim is a veteran of the database industry for more than 30 years. He pretty much invented some of the most significant innovations in the industry including blobs, event alerters, multi-version concurrency control and more. He's also an avid boater, pilot and all 'round nice guy despite his reputation for being a "big bad wolf" in the open source world.
We'll have sessions on many storage engines including MyISAM, InnoDB and others. Last year we had 1300 attendees at the conference and many tutorials sold out. We're on track to surpass last year's attendance and the exhibits area is virtually …
[Read more]The Boston MySQL meetup this past week was well attended. At one point I counted just over 50 folks. Thanks to MIT for the space and MySQL for the food.
The presentation was excellent, but longer than my tape so to see the full deal you'll have to catch up with Jay's presentation at MySQL UC in April or OSCON in July. There are sections where questions are asked that are hard to hear because of the lapel mic we're using. It makes for much better audio from the speaker, but it's not so good for interactivity. At one point I unplugged the lapel mic to capture interaction at the chalkboard. I suppose if we got really serious we'd have a mixer with an audience mic and a speaker mic. Probably not going to happen. Maybe next time I'll try to unplug the lapel mic every time there is a question from the audience.
The video is on Google . For those …
[Read more]
Today we completed the newest beta version of XAMPP for Linux and
Windows. New in this version are PHP 5.1.2 and 4.4.2, MySQL
5.0.20, eAccelerator 0.9.4, and phpMyAdmin 2.8.0.3. If beta
testing is successful, the "final" version will be released in
one to two weeks.
Beta releases are only for testing purposes. We would very much
appreciate it if you could test this release and let us know if
you run into any problems.
Follow me to the XAMPP BETA area
Today we completed the newest beta version of XAMPP for Linux and
Windows. New in this version are PHP 5.1.2 and 4.4.2, MySQL
5.0.20, eAccelerator 0.9.4, and phpMyAdmin 2.8.0.3. If beta
testing is successful, the "final" version will be released in
one to two weeks.
Beta releases are only for testing purposes. We would very much
appreciate it if you could test this release and let us know if
you run into any problems.
Follow me to the XAMPP BETA area
Are you a MySQL user? Have you tried 5.0? Did you notice that SHOW STATUS was giving you strange results?
Here’s the skinny: The SHOW STATUS command, which has been in MySQL, well forever, has had a long-standing feature request; to have the ability to report its metrics per-session. That functionality was added in MySQL 5.0, in the form of two new syntaxes: SHOW SESSION STATUS and SHOW GLOBAL STATUS to give the per-session and server-wide statistics, respectively. It’s great, and I’m happy to see it.
The problem comes in because of the default behaviour that was chosen for the basic SHOW STATUS with no SESSION or GLOBAL keyword—that is, the command that every MySQL DBA has been using for years—now defaults to per-session statistics.
Every tool, program, monitoring script, performance graph, etc., that uses SHOW STATUS (which is pretty much all of them) is broken in 5.0. Why? Well, for no reason, …
[Read more]
We all deal with queries that return more rows than what our
screen will let us view, wouldn’t it be nice to be able paginate
the results ?
Rather than having to scroll back, and scan the rows, you can use
the built in pager. I didn’t know about this, until Will from
freenode mentioned it in #mysql. Long story short..
mysql> \P less
mysql> PAGER set to less
mysql> select foo,bar from table
The format is much more readable than usual. Some of you may have already known about this, but I didn’t. So I hope it’s helpful.
Tags: mysql, tips_and_tricks
Odd characters can sometimes cause problems with character data in MySQL. These characters are easy to accidentally import from a CSV file or other data source, but hard to detect because they don’t always display correctly. In this article I’ll tell you which characters are bad, how you can get them in your database, how to avoid getting them, how to detect them when you have them, and how to get rid of them.
Today we completed the newest beta version of XAMPP for Linux and Windows. New in this version are PHP 5.1.2 and 4.4.2, MySQL 5.0.20, eAccelerator 0.9.4, and phpMyAdmin 2.8.0.3. If beta testing is successful, the "final" version will be released in one to two weeks.
Beta releases are only for testing purposes. We would very much appreciate it if you could test this release and let us know if you run into any problems.
Well, after consulting with licensing guru Zak Greant and talking to one of the official powers that be at MySQL, I now have a name and a license for the new sample database.
The name? Sakila. Yup, no issues with using the name I have been using so far, which is a good thing.
The license? The new BSD license. This should make it as easy as possible for authors to use it in their books and articles without any licensing concerns at all.
I’m trying to clean up a bug I found and flesh out the docs a bit more, I hope to post what could be considered a release candidate tomorrow.
And remember, come to the session on Sakila at the MySQL UC.