Just a warning to everyone that I will not be posting many blog entries from the UC today, my laptop is suffering from an unknown issue that I need to diagnose and repair before I can do any work from it.
On the bright side there is a great blogger contingent here this year and there is plenty of content to go around.
Session attendees: I will get content online as soon as I can.
short and simple: ?embedding mysql? and ?practical i18n with php and mysql.?
the i18n talk seemed to go over pretty well, and i only ran a few
minutes short. the embedding talk is yet to come, and will run
really, really short.
i would recommend the scale out panel instead.
Listening to Stewart Smith presenting details at MySQL UC 2006 about what's new in MySQL Cluster version 5.1. Stewart has a great personality for presentations, entertaining at the same time he covers the technical details. Reminds me a bit of Damian Conway (the Perl guru), and not just because they're both from Australia.
What was new in 5.0?
New in 5.1 Cluster
So, I attended the first day of the MySQL user's conference yesterday, which was the tutorial day. Overall I was fairly impressed. Registration was easy, the actual rooms presentations are given in are comfortable, the PA system seemed to work after some initial problems in the morning tutorial I attended.
The conference center seems to be big on retirees hanging around, which I thought was weird. Each room comes with a little old lady, whose job appears to be to read a fiction novel at the door. I really have no idea what else they were achieving. They seemed to be having fun though. I did find it a bit odd that the only drinks provided by the catering staff during the day were acidic, and most of them caffinated. For example, we had choices between coffee, tea, soda water, coke, diet coke, pepsi and diet pepsi. Some fruit juice or even plain water would have been a nice change by the end of the day.
…
[Read more]So, I attended the first day of the MySQL user's conference yesterday, which was the tutorial day. Overall I was fairly impressed. Registration was easy, the actual rooms presentations are given in are comfortable, the PA system seemed to work after some initial problems in the morning tutorial I attended.
The conference center seems to be big on retirees hanging around, which I thought was weird. Each room comes with a little old lady, whose job appears to be to read a fiction novel at the door. I really have no idea what else they were achieving. They seemed to be having fun though. I did find it a bit odd that the only drinks provided by the catering staff during the day were acidic, and most of them caffinated. For example, we had choices between coffee, tea, soda water, coke, diet coke, pepsi and diet pepsi. Some fruit juice or even plain water would have been a nice change by the end of the day.
…
[Read more]MySQL Performance Tuning with Jay Pipes (MySQL Users Conference Workshop).
Standing room only — who’dve thunk performance tuning was so important!?!?!? (< / sarcasm>). Seriously though, there was a lot of typing happening.
Benchmark:
Get a baseline
Give yourself a target (”what’s good enough?”)
Change one thing at a time
Record everything (even the ‘trivial’ stuff)
Disable the query cache.
Profiling:
Profiling a currently running system (vs. benchmarking, on
test)
EXPLAIN SELECT
slow query logs (mysqldumpslow)
low hanging fruit (you figure out what they are, if you’re a DBA
it might be putting an index, if you’re a developer maybe it’s
changing a query) and diminishing returns
mytop to catch …
MySQL.com has a press release publishing news about some performance tests they've run on an 8-way Sun Fire V40z that indicate MySQL runs much faster on Solaris 10 than it does on Linux:
The primary difference between the two servers was in the underlying operating system, keeping the hardware configuration and database properties the same. During the read/write test, both systems reached their saturation point at eight CUC, at which point the the server running the Solaris 10 OS was 30 percent faster. Additionally, the Sun Fire V40z server running the Solaris 10 OS was running database queries at a 64 percent better rate on average, when compared to the server running Linux.
The Solaris advantage was magnified during the read-only test, where performance exceeded the Linux test case by 91 percent. Remarkably, in this …
[Read more]
Laura
Thompson, author of several books and director of OmniTI, today
presented a session about PHP5 Upgrade: Why and How at MySQL Users
Conferece.
Mike
Hillyer provides us a thorough summary of the session at his blog.
Kristian
Kohntopp wrote another summary post about how and why to upgrade to PHP5.
Thanks to Laura for putting the …
The talk, and the demo are both very cool.
Tags for this post: mysql
mysqluc php
open source conference
Related posts: Links from Rasmus' PHP talk; Thoughts on the first day of the MySQL user's …
The talk, and the demo are both very cool.
Tags for this post: mysql
conference mysqluc2006 php
open source conference sre
Related posts: …