I am a member of the monday morning murder association. I murdered bugs. As said earlier, the modification of PDO_MYSQL to support both the MySQL native driver for PHP (mysqlnd) and the MySQL Client Library (AKA libmysql) is progressing. A good number of known and unknown bugs has been killed. But some new have been found as well - an overview.
(...)
Read the rest of PDO_MYSQLND: Monday morning murders (754 words)
I am a member of the monday morning murder association. I murdered bugs. As said earlier, the modification of PDO_MYSQL to support both the MySQL native driver for PHP (mysqlnd) and the MySQL Client Library (AKA libmysql) is progressing. A good number of known and unknown bugs has been killed. But some new have been found as well - an overview.
(...)
Read the rest of PDO_MYSQLND: Monday morning murders (754 words)
I teach the exact differences and use of the different join types and keywords in my courses (specifically the Optimisation by Design day). A few tidbits:
But the point of this post... when looking at apps, I often see
LEFT JOINs abused. That is, the query does not actually require a
left join. The result might be ok, but that entirely depends on
the data contained in the tables; no guarantee.
Apart from understanding joins, I've found that there's a very
simple but effective test for whether or not to use a left
join.... "if you can't think of a specific reason, you
don't" ;-)
I am a member of the monday morning murder association. I murdered bugs. As said earlier, the modification of PDO_MYSQL to support both the MySQL native driver for PHP (mysqlnd) and the MySQL Client Library (AKA libmysql) is progressing. A good number of known and unknown bugs has been killed. But some new have been found as well - an overview.
Please note that the status information is based on Linux 32bit and Linux 64bit testing only. We still have not done cross-platform testing recently. I spend too much time with blogging Also, I have not included some PDO_MYSQL feature requests such as the support of cursor attributes. Technically it should be possible to implement but we will focus on making "release ready" what we have today before we consider adding new features.
The following list is not ordered. Bugs have not been assigned a priority and/or severity. Its a “status quo” description that needs to be read with care. …
[Read more]I'm back from my week of vacation and am ready to pick up where I left off with the interviews I conducted at the Red Hat Summit/FUDCon last month. After today's, I will have three left: Dennis Gilmore, Max Spevack and Chander Kant of Zmanda.
The Honourable James Zemlin
On the first day of the Summit I was able to grab my buddy Jim Zemlin, the Executive Director of the Linux Foundation for a spirited discussion about the Foundation, Linux and a bunch more.
My interview with Jim (15:55) Listen ( …
[Read more]I'm back from my week of vacation and am ready to pick up where I left off with the interviews I conducted at the Red Hat Summit/FUDCon last month. After today's, I will have three left: Dennis Gilmore, Max Spevack and Chander Kant of Zmanda.
The Honourable James Zemlin
On the first day of the Summit I was able to grab my buddy Jim Zemlin, the Executive Director of the Linux Foundation for a spirited discussion about the Foundation, Linux and a bunch more.
My interview with Jim (15:55) Listen ( …
[Read more]
In almost all application development situations, one needs to
log debug information now and then. In almost all production
systems, one needs to log serious error events somewhere
too.
So, what can you do? Create a log table? Sprinkle your code with
SELECT 'Debug: ...' statements?
At the UDF
Repository for MySQL, we now have a solution to log messages
to the MySQL error log: a user-defined function called log_error().
Currently it is all very crude: the log_error
function takes one argument and writes it to the mysql_error log,
appending a line …
It's finished. After the usual two-week beta period, we can announce the new "final" XAMPP version available for public download.
In this version we updated: Apache (2.2.9), MySQL (5.0.51b), PHP (5.2.6), phpMyAdmin (2.11.7), mod_perl (2.0.4), OpenSSL (0.9.8h), and eAccelerator (0.9.5.3).
Get the downloads and more details on the specific platforms XAMPP project page.
The other day I was watching a Memcached Webinar (”Memcached for MySQL: Advanced Use Cases”) sponsored by MySQL, and it got me thinking about memcached from an operational perspective. It seems to me that the implementation patterns for memcached are fairly well codified in the standard body of knowledge. What does NOT appear to be [...]
It looks like I never blogged about it but I'm going to be speaking on OSCON 2008. Similar to the last year presentation I'll do overview of MySQL Open Source storage engines. I'll do brief overview of different storage engines available out there as well as share benchmark results for some of them.
Entry posted by peter | One comment
[Read more]