Ok, so this doesn't work on all Linux systems. This because many
don't ship with LinuxThreads libraries any more. While that's
nice in theory, reality is that NPTL threading does not always
work well, in particular MySQL server on 64-bit machines can
experience trouble. Other apps don't see the problems because
they don't use that many threads.
If a threading hacker with spare time were to care about
looking over the NPTL code to make it work well with hundreds (up
to a few thousand) threads, that would be grand.
In the meantime, you may find the below patch useful: it modifies
mysqld_safe so you don't need to keep tweaking it when you
upgrade your MySQL version. See the inline comments for further
details.
--- mysql-5.1/scripts/mysqld_safe.sh 2007-01-29
10:26:34.000000000 +1000
+++ mysqld_safe.sh 2007-01-30 10:39:12.000000000 +1000
@@ -33,6 +33,7 @@
--ledir=DIRECTORY …
The latest from the MySQL community
Ideas, releases, practical guides, and perspectives from the people building with MySQL.
MySQL AB today unveiled a simpler way for large and growing organizations to acquire and adopt enterprise software. Designed with a customer?s perspective in mind, a one-year MySQL Enterprise Unlimited subscription offers a company-wide enterprise site agreement at the unprecedented low price of $40,000 (EUR 32,000, GBP 24,000).
I just noticed that the schedules for the Sessions and Tutorials of our upcoming MySQL Conference &
Expo (which takes place on April 23rd-26th in Santa Clara,
California) is now online. The program looks very promising and I
am particularly excited that some of the sessions that I have
helped to arrange made it into the final program:
- openBC / Xing: Growing Pains by Michael Otto and Erick Dennis from ePublica
- PrimeBase XT: Design and Implementation of a …
MySQL's FEDERATED storage engine is a fascinating
example of the flexibility gained by abstracting the storage
engine layer away from the rest of the server.
FEDERATED tables allow you to access a table on
another server as though it exists on the local server. However,
the manual doesn't say much about how it really works. This
article peeks under the hood of the FEDERATED
storage engine.
I recently went to linux.conf.au in Sydney, and attended the
MySQL Miniconf (mysql.conf.au). I thought I would recap on some
highlights:
-
- I leaned EXPLAIN EXTENDED [query] from Guy Harrison (can't believe i didn't know that one).
- I listened to Laura Thompson talk about the "update user set
last_login = NOW()" problem that every social networking site
seems to encounter. Her "proposed" solutions were roughly:
-
- Use a different set of database systems to manage these
"last logins" (often called "partition your application by
function")
- Lie, and give estimates ;-)
-
While I am a big fan of lying, I …
I (like several other of my co-workers) have over the past few days (since about Thursday/Friday IIRC) spent quite a few hours testing exam questions for the upcoming MySQL Cluster Certification exam.
Currently, I hold the record for the most correct answers (and number of questions that have been commented on). Yes, this is a direct challenge to other MySQLers to try and beat me.
For MySQL certifications, there is a giant pool of questions, a selection of which are selected for a particular candidate. So those brave few who go and test every single question spend a lot of time doing so to make sure the end exam is the best possible.
I’ve really grown to repsect the MySQL certs even more than I did before after being involved in creating one… we really try to make sure that to pass these you have to know and understand what you’re doing… no superficial stuff …
[Read more]
I recently spent a week in Nelson, New Zealand helping couchsurfing.com scale their database a little
better. This was the first major LAMP project I've touched in a
while, and it just happened to coincide with my one year
anniversary working for MySQL.
When I arrived some things really scared me; They'd discovered
that mysqldump would "lock" the entire database for the duration
of it's execution, but if you dump the tables individually, they
are only locked individually. Note: There is a reason
mysql does this, it's called a consistent backup[1]!
I was in good company for the week though with Kasper
& Joe. One of my
best memories was the three of us pair programming through a
shared screen (gnuscreen - we were multitasking). We had quite a …