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, …

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.

Follow me to the XAMPP BETA area

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.

(Click to be Controlled)

The hypnotoad commands you to attend my sessions at the MySQL User Conference. All Glory to the HypnoToad!

• Introduction to Database Normalization and Joins
• Managing Hierarchical Data in MySQL
• MySQL 5 Applied: The Sakila Sample Database

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\G



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.

the o?reilly open source conference 2006 schedule is out, and i?m not on it. (i got my rejection letter yesterday.) here?s the talk i had proposed:

?22 Small Features in MySQL?

Did you know the mysql command-line client could save you from accidently nuking whole tables with errant DELETE statements? What about how the ability to change data being loaded using the LODA DATA statement that was added in MySQL 5.0?

In this session, we'll look at these and twenty (or more) small features of MySQL and its supporting programs. Some are old classics, and some are new additions to MySQL that you might not have noticed behind all the big new features.

oh well. after the upcoming mysql users conference, i think i?m doing with conference speaking. i just don?t …