Part of updating the MySQL Certifications is trying out all the
new features that have appeared with 5.1 and 6.0. Currently I am
working with 5.1.24-rc on a Mac and 6.0 on Ubuntu and looking for
items to add to the exams. The Event Scheduler is sure to become
one of those Swiss Army Knife tools that we will wonder how we
ever accomplished anything without.
I usually experiment with very simple tasks.
CREATE EVENT x1_event ON SCHEDULE AT '2008-07-16 14:01:01' DO
INSERT INTO x1 VALUES (9,'nine');
SHOW EVENTS did exactly that. And just after 14:01, I found the
new row in my x1 table.
So now I am thinking of a dozen think I used to do with cron(1)
or at(1) that I could do with the event scheduler.
Warning: There are ramifications with backups and the event
scheduler that I will not go into details here. But for now do
not try to run your backups with event scheduler. The …
This is a request to all MySQL users to help mysql developers, by
providing information, so that we can help you, by providing a
more stable MySQL server for your needs.
As you may know, MySQL 5.1 has been in state of release candidate
(RC) for some time. The last RC was announced as the last RC and
is supposed to be followed by a GA release. The GA release is
planned to be the exact same code as the last GA, only with the
label changed.
The question we, who are developing and supporting the MYSQL
server have been asking ourselves is, "Are really now in shape to
do a proper GA release?".
We would like you as a MySQL User to help us out with deciding
this.
We don't want to repeat the mistake we did with MySQL 5.0 GA and
then again with MySQL 5.1 RC, by releasing a MySQL 5.1 GA too
early.
Our external criteria for General Availability (GA) or Production
release can be found …
We've been busy! Now that we're past version 1.0, we had a chance
to make some fundamental improvements to opentaps for a
long-term. We have begun to develop a new domain driven architecture for future versions
of opentaps. This object-oriented architecture will make it
easier for you to customize and extend opentaps or to combine it
with other applications. It will also make it easier for us to
develop opentaps and help it continue to grow.
opentaps Analytics is also coming along nicely.
You are now able to slice and dice customer, order, and return
data by over a dozen different ways, including by country, by
brand, by month of the year, and by category. You're also able to
look at the lifetime value of your customers from all these
different angles. …
In the Cleveland area? Tonight, 6pm, I'll be giving my "Join-Fu: The Art of SQL" talk at the inaugural MySQL meetup in Independence, Ohio. Come join me! Here is the address to the venue:
2 Summit Park Drive Suite 530 Independence, OH 44131 Get Google Directions
See you there!
There's been a lot of rumors floating around internally at Yahoo that it's best to turn off some of your CPU cores when using Innodb, especially if you have a machine with > 4 cores. At this point there's no question in my mind that Innodb doesn't perform much better when you double your cores from 4 to 8, but I really wanted to know if 8 actually performed worse.
To test, I used a Dell 2950 with 6 drives and a simple mysqlslap
test script. There's basically no I/O going on here, just a
small table in memory being queried a lot. To be fair, I
actually got this test from Venu. I used maxcpu=4 in my grub.conf to
limit the cpus (I also tested with tasksel and it seemed to have
the same effect as maxcpu).
There's been a lot of rumors floating around internally at Yahoo that it's best to turn off some of your CPU cores when using Innodb, especially if you have a machine with > 4 cores. At this point there's no question in my mind that Innodb doesn't perform much better when you double your cores from 4 to 8, but I really wanted to know if 8 actually performed worse.
To test, I used a Dell 2950 with 6 drives and a simple mysqlslap
test script. There's basically no I/O going on here, just a
small table in memory being queried a lot. To be fair, I
actually got this test from Venu. I used maxcpu=4 in my grub.conf to
limit the cpus (I also tested with tasksel and it seemed to have
the same effect as maxcpu).
How did two vulnerabilities in the widely used Spring Framework remain hidden for so long? And what are the security implications for single-vendor-driven open source projects? READ MORE
So… some colleagues have been experimenting with DTrace a bit, and I’ve been (for a while now) wanting to experiment with it.
The challenge now, instead of in the past, is that I’m setting up a Solaris based system - not getting one premade.
I chose OpenSolaris as I’d previously tried Solaris 10 and just sunk too much time trying to get updates and a development environment installed (another colleague could get the opposite to me going: he got devtools but no updates. at least mine was up to date and secure… but without a compiler).
So… OpenSolaris. It isn’t 100% open, there’s binary only drivers and such… but compared to previous Solaris, a whole lot better. Now, if only it was GPL licensed so we could have cross-pollination with Linux.
I grabbed the 2008.05 ISO as soon (in fact, slightly before) it was released and installed it in VirtualBox.
The installation was shiny …
[Read more]I am very thrilled to hear that SUN is evaluating joining the SQL standard process. I feel that Peter would be the perfect candidate for this job too, given that he knows the standard inside out. My hope would be that this way the OSDB consortium (yes, I still believe) will get a liason to the SQL standards body. Also this way the much more down to earth real world approach of OSS databases to finding new syntax to add to SQL now has a chance to find its way into newer versions of the standard. It seems things are too late to ensure that SQL2008 will follow the popular LIMIT syntax, but in a way its already a huge leap forward that SQL2008 defines a way …
[Read more]
Cool chair
Originally uploaded by Elliot Murphy
–
Elliot Murphy