Sun's billing data yields a wealth of information READ MORE

A lot of people are wondering whether SSDs make sense with MySQL.  I think that there are cases where they will make sense, and others where they will not.  Here is one test that I came across in a blog entry where the user was excited about SSD performance:

http://labs.cybozu.co.jp/blog/kazuhoatwork/2008/10/benchmarking_ssd_for_mysql.php 

Moving forward, I'm sure that we'll see much more data on this subject and be able to draw more concise lines on when to recommend SSD.

After a few days at home in Munich, I was fortunate enough to fly to the Southern Hemisphere again. This time, I’m in Argentina, planning to visit also Uruguay and Chile.

I plan to meet with many Sun customers and MySQL users, and talk about Open Source. All Libre, some of it even Gratuita. The sign on the right is from Jardin Botánico in Buenos Aires, where I had some time off today. I’m posting some of the more private observations on blogs.arno.fi/isit so as not to spam this list with observations of Jacaranda trees. (Note: At the time of writing, not many of my South American observations are yet live.)

Ever wondered what your PHP application and MySQL actually do? An experimental mysqlnd branch will give you full access to the network communication stream. Using a custom PHP stream filter you can then intercept the communication ... but let's start at the beginning:

When talking about mysqlnd - the mysql native driver for PHP - we always mention the fact it's native in a way that we're, when possible, using PHP infrastructure. The most common example here is the memory management. By directly using PHP's memory we can avoid unnecessary copies of data from the MySQL Client Library's memory into PHP memory.

<?php
$mysqli = mysqli_connect("localhost", "root", "", "test");
$stream = mysqli_conn_to_stream($mysqli);
…

I was asked the question last week of how to tell whether a MySQL installation is 64-bit or 32-bit. Often, MySQL is pre-installed or installed via a package and it is forgotten when and how it was installed. I scratched my head for a little while and just run

/usr/sbin/mysqld --verbose --help
/usr/local/mysql/libexec/mysqld Ver 5.1.25-rc-debug for suse-linux-gnu on i686
(Source distribution)
...

This is somewhat telling and I can tell from having used MySQL that this is 32-bit. However, there's nothing that sticks out like a sore thumb that says one way or the other that is is 64 or 32 bit (ok, maybe "i686" (?))

I was working outside, which seems to be where I become inspired and had a "DUH" moment. The command "file" is the key for this:

32-bit linux:

patg@ishvara:~> file /usr/local/mysql/libexec/mysqld
/usr/local/mysql/libexec/mysqld: ELF …

Update: Sun has expanded its Cloud Computing portfolio with the recent acquisition of Qlayer, a cloud computing company that automates the deployment and management of both public and private clouds.  The Q-layer organization, based in Belgium, is now part of Sun's Cloud Computing business unit which develops and integrates cloud computing technologies, architectures and services.

Cloud computing is about managing petascale data. Sun's server and storage systems can radically improve the data-intensive computing emerging in the cloud. Some clouds are closed platforms that lock you in. Sun's open source philosophy and Java principles form the core of a strategy that provides interoperability for large-scale computing resources. Sun's virtualization solutions for advanced …

The Information Technology Certification Council is a new organization you are going to hear a lot about in the next year. The membership list is a who's who of the computer certification world and their main focus is increasing the value of computer certifications.

Their most visible project to the public will be marketing materials on certifications. The general public does not know a CCIE from a MSCE or CMDBA. Why is this education valuable?

Several years ago I was employed by an on-line recruiting firm and hiring managers asked why they could not find programmers with twenty plus years of Java programming experience. Java was under ten years old at the time and even James Gosling did not have twenty years of Java experience. Twenty plus years of programming experience with a recent emphasis on Java was not what they wanted. They knew exactly what they wanted and would not accept a substitute. Even if what they …

Today we released Jet Profiler for MySQL for beta testing!

Jet Profiler for MySQL is a query profiling tool, focusing on running queries and processes. It can provide top lists of the most frequent queries, tables, schemas, users and more. Such top lists help you identify bottlenecks and fix the worst performing parts of your application.

We are looking for 20 people who would like to beta test it and give us feedback. If you like profiling MySQL databases, or are curious to know what bottlenecks your site might have, please go to our beta page to receive download links and key. Use the following promotion code:

I LIKE MYSQL


2 Comments

A few days ago I was describing a common grievance when using partitions.
When you care at a table, like the following

CREATE TABLE t1 ( d DATE ) 
PARTITION by range (to_days(d))
(
  partition p001 VALUES LESS THAN (to_days('2001-01-01')) 
, partition p002 VALUES LESS THAN (to_days('2001-02-01')) 
, partition p003 VALUES LESS THAN (to_days('2001-03-01'))
);

Then you have the problem of finding out the original values. SHOW CREATE TABLE doesn't help.
show create table t1\G
*************************** 1. row ***************************
Table: t1
Create Table: CREATE TABLE `t1` (
`d` date DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (to_days(d)) (PARTITION p001 VALUES LESS THAN (730851) ENGINE = MyISAM, PARTITION p002 VALUES LESS THAN (730882) ENGINE = MyISAM, PARTITION p003 VALUES LESS …

just did some benchmarking on multi-threaded ndbd (binary called ndbmtd)
that is in the coming 6.4 release.

quite happy with results

--- results

[jonas@n1 run]$ flexAsynch -ndbrecord -temp -t 8 -p 512 -r 5 -a 2
insert average: 374200/s min: 374200/s max: 374200/s stddev: 0%
update average: 370947/s min: 370947/s max: 370947/s stddev: 0%
delete average: 395061/s min: 395061/s max: 395061/s stddev: 0%
read average: 537178/s min: 531948/s max: 543092/s stddev: 0%

---

this flexAsynch command will run with
- 8 threads
- 512 parallel transactions per thread
- 8 byte records.

note: during the reads, the datanode was *not* maxed out.

---

this was run on two identical computers,
2-socket, 4 cores per socket Intel(R) Xeon(R) CPU X5355 @ 2.66GHz

…