I’m going to be at my first MySQL Meetup tomorrow. Its at the Mercat Cross, 456 Queen St at 7pm. This is quite near Melbourne Central, and definitely has a good view of the Vic Market night market. I hear (from AdamF) that there’s lots of beer on tap, if that catches your fancy.
We can talk about all things MySQL, and get more users into MySQL 5.1. Hello event scheduling! Hello partitioning! Hello tables in information_schema!
Monday, March 13th is the next MySQL meetup in Boston. I've volunteered to speak, giving a talk called "An Introduction to MySQL Cluster", a presentation that details getting a cluster installed, configured, and running. This will be a shortened version of the PHP Quebec talk.
If you're in town, please stop by. The meetup is now convening at MIT.
Will be carving out some time in the next few days to dig through the latest changes in the cluster and iron out the details of the presentation.
Possibly Ubuntu’s fault too for shipping the not-latest un-bugfixed release. But either way, it’s really annoying seeing the “Document Recovery” screen more than the edit text widget.
Copy and Paste slides in Impress is not flakey - it’s damn right crushed to pieces. Occationally it does something useful - like paste and not crash.
update: yes, i am just using it to put together presentations for our upcoming devconf - as well as the user conference. Why these things are so hard to do is beyond me. A simple app that didn’t crash *cough* magicpoint *cough* is looking rather superior at the moment.
update part 2: yes, the title changed. arguably i like this one better. although adding “right under the fingernail” is tempting
While reading planetmysql.org I ran across this Tune a MySQL server in 5 minutes.. I think that entry is really missing a lot in terms of actual tuning for the real world. Also I thought max_user_connections is number of connections per hour. Since I only have 3 minutes I can’t look it up! You probably don’t want to set this with apache.
So here in three minutes are the four variables you really need and some generic guidlines for setting them. This assumes that MySQL is running on it’s own server and has one apache server connecting to it.
max_connections - set to the same (or a little bigger than) as MaxChildren from apache if you’re only using one mysql connection per request (this is most common) key_buffer_size - Set to roughly half your available ram. Remember this is a quick and dirty tuning. We only have 3 minutes! …[Read more]
Yesterday, I finally installed the MySQL 5.1.7 beta. It took some
help from Markus to get it up and running, and this morning,
I made a start to update the MySQL information schema diagram
that I've been maintaing since june 2005.
To begin with, I just added the new information_schema tables to
the original visio diagram. I also reworked the layout to put the
tables that are in the same functional category near to each
other. (In the previous version, the privilege tables were
scattered throughout the diagram).
I put the EVENTS table in same category as TRIGGERS and the
ROUTINES, because these all represent MySQL Programmability. I
put the PARTITIONS, the ENGINES and the FILES table in a new
category, because these all have to do with physical storage of
data.
I still need more info on the PLUGINS table to decide where I
should put it (it seems …
Everybody who can tune a MySQL server in 5 minutes please raise your hands !
yes that's just a ridiculus blog title to attract traffic ... Rudd-O tells us about 5 variables that might have impact on the performance of your database , but really how long does it take you to do a real analysis of where the problems are lying , and how to fix it.. I bet it's more than 5 minutes.
I just got a Google News Alert that contained the URLs of two great articles on the issue of software patents: one by eWeek’s Steven Vaughan-Nichols and another one on Computerworld.com by Martin Goetz, who in 1968 received the first US software patent ever. Both articles appeared on the occasion of the settlement of the patent dispute over BlackBerry, which I mentioned in my first blog entry here.
There have been plenty of columns on US Web sites that talked about the negative implications of software patents. However, a mistake made by most US columnists (as well as some over here in Europe) is that they falsely believe one could …
[Read more]Hello -
Many of you have requested that MySQL offer multi-source replication and/or provide built-in replication conflict resolution. I’m happy to tell you that our engineering team is underway with this effort. Our replication leads have asked for customer input on their proposal, and so I would like to solicit your help in reviewing the plan. Please feel free to look at just the broad plan or dive deep into the details. Shoot me a mail at rschumacher@mysql.com, and I’ll forward along their proposal.
Again, it’s through your input and help that we ensure the features we implement meet the needs you have in your daily use of MySQL - thanks for taking the time to assist!
Whenever we poll our users, the topic of performance tuning and optimization always scores the highest interest level. So at the MySQL Users Conference, we have a full track devoted to performance tuning. (Hey, we're not dummies. Everyone wants a little extra performance!) This includes best practices presentations by some of the elite performance gurus from inside MySQL and among our top users and partners. This includes talks by people like performance engineer Peter Zaitsev (pictured above), community guy Jay Pipes, Optimization wizard Timour …
[Read more]Alfredo announced the availability of version 1.0.5 beta of the MySQL Workbench, the latest product in the MySQL GUI tools family (also check out the Administrator, Query Browser and the Migration Toolkit).
I downloaded the RPM for SUSE Linux 9.3, which installed flawlessly on my SUSE 10.0 system. To test the reverse engineering capabilities, I installed the latest version of the Sakila …
[Read more]