As of late I am really fed up with anecdotal information on
MySQL.
One of the one's I hear is "with many processors you need to
disable
Innodb's Adaptive Hash".
First things first, unless you roll up your sleeves and hack the
code
there is no way to turn it off. There is no user
configurable
variable, all there is is a single true/false boolean you can set
in
the code. As many times as I have heard "turn it off" I had
thought I
would discover that there was some setting I never knew about.
It
turns out that this is not the case.
What you see below is a with/without adaptive test. It was key
read
test, meaning that it just tested key reads and no writes. Users
who
are using 8way and beyond machines today (and the Intel was an 8
way,
while the Sun T1000 can be considered a 32way), are not guys
with
machine in their basement. Typically it is …
Steve Karam, The Oracle Alchemist, saved the skin of a harried LB administrator this week (that would be me), stepping up at the last moment to edit and publish the 60th edition of Log Buffer, the weekly review of database blogs. Thank you, Steve! Next week, Arnold Daniels does LB#61 on Arnold?s wor(l)ds. [...]
The Fake Larry Ellison blog cracks me up. It started off on the Fake Steve Jobs blog, but now it's spun out to get its own separate blog. Fake Larry Ellison is paranoid about open source and hangs out with Steve Jobs and Paris Hilton. I don't know if this is Dan Lyons or someone else behind this one, but it's quite funny. Maybe he'll be at Burning Man this weekend... Or is that Fake Burning …
[Read more]
My initial impressions are quite positive. The big win is that it
looks like the new version is a lot closer to being standards
compliant. My challenge to the web team is to finish the job.
There's only a few things to fix to pass the validator. Here's a
diff:
18c18
< <script language="javascript">
---
> <script language="javascript"
type="text/javascript">
263c263
< <li><a href="http://www.mysql.com/news-and-events/press-release/release_2007_30.html">JasperSoft
& MySQL Launch Major Upgrade to Business Intelligence Software
for the ISV/OEM Market</a></li>
---
> <li><a href=" …
As you may already have seen announcement by Baron we're working on major rewrite of High Performance MySQL book - the most famous book about MySQL Performance on the market... which is getting old though. We've been slowly working on the book for over half a year now and were later joined by Arjen Lentz and Baron
I think we make a great team and will be able to provide great in depth book on MySQL Performance topic to the market. Me and Vadim have great internals insight and a lot of practical experience in MySQL Scaling and Performance Tuning but our Russian-Ukranian English needs a lot of editing and we're far from experts writers plus we're quite busy doing …
[Read more]RPM packages for innotop, a flexible and powerful MySQL and InnoDB monitor I wrote, are now available through the openSUSE buildservice, which builds RPMS on several platforms. Thanks to Lenz Grimmer, SUSE Linux, and Dr. Peter Poeml for making this happen.
Even after working with MySQL for quite a long time, I sometimes
stumble over great things that I didn't know. It happened to me
again when I met Beat Vontobel (together with other MySQL folks
like Giuseppe, Roland, Lenz, Susanne) at the
FrosCon
Conference.
What I learned about was the init_connect system variable. It
allows to trigger a SQL statement (or Stored Procedure) whenever
a new user that doesn't have SUPER privileges connects to the
server. There's no need for me to explain this in large detail,
since Beat already did this in one of
his blog articles.
Why is it so …
One good news, one bad news - that’s the frank way we blog about mysqlnd. The last posting on significant memory savings (40%) and new tuning options was good news. The bad news: mysqlnd might have bugs. How to report and debug these bugs - using mysqli_debug() - is subject of this posting.
Where to send mysqlnd problem reports, how to contact
Due to a low feedback rate - which is disappointing in a certain way - we are in the comfortable situation that you may report issues or ask questions on pretty much every channel: on the mailing list php@lists.mysql.com, on http://bugs.mysql.com/, on http://bugs.php.net/, by private mail (georg/andrey/uwendel at mysql dot com) or even using a blog comment. Of course, …
[Read more]One good news, one bad news - that’s the frank way we blog about mysqlnd. The last posting on significant memory savings (40%) and new tuning options was good news. The bad news: mysqlnd might have bugs. How to report and debug these bugs - using mysqli_debug() - is subject of this posting.
Where to send mysqlnd problem reports, how to contact
Due to a low feedback rate - which is disappointing in a certain way - we are in the comfortable situation that you may report issues or ask questions on pretty much every channel: on the mailing list php@lists.mysql.com, on http://bugs.mysql.com/, on http://bugs.php.net/, by private mail (georg/andrey/uwendel at mysql dot com) or even using a blog comment. Of course, …
[Read more]I picked this story up from Kevin Burton's feedblog. It turns out that last week, Greg Stein, director of the Apache Foundation was mugged outside his home in Mountain View. Greg was already on crutches at the time so this is a double whammy. Kevin organized a paypal account to for donations raising more than $2500. That money will go towards getting Greg a little R&R in Tahoe or Big Sur. Nice work, Kevin. Greg, get well soon! We'll send over a MySQL care package or some meals or some tech support. Whatever helps you get back on your feet.... READ MORE