Many of the prominent folks on Planet MySQL have encountered issues with mysql and linux going into swap (example 1,2,3).  None of the easy solutions (sysctl -w swappiness=0, innodb_flush_method       =O_DIRECT) have solved this problem for our configuration and I just deal by using a smaller innodb buffer pool than I’d like, and then occasionally using swapoff/swapon to temporarily bring things back to balance.

I did make one observation though, which may be a red herring but still interesting to me.  In one particular case I am using nested replication in …

Imagine eating meze in Ankara with a Turkish Member of the Parliament, and member of the Turkish EU Harmonisation Committee. That’s not the basic reason I joined MySQL AB back in 2001, but it’s one of the most interesting outcomes of my decision. Bottom line: The honourable Mr Osman Co

Lately planetmysql.com has shown an increasing amount of commercial promotion for Sun products. Many recent articles included in this supposedly MySQL-related feed aggregator have nothing to do with MySQL.Now I see an article included in the feed from ComputerWorld, about database researcher David Dewitt getting a job at Microsoft. Not only is this non-MySQL-related content, but more than half

I am hoping I can get some feedback from you all.  I have been excited about the support for completion in the NetBeans PHP editor (and other editors to follow).  The response to my quick little blog about this has been pretty positive.

To refresh, here's an example of what it would look like:



But I have also gotten some feedback from more than one source that this may not actually be as valuable as it may first appear.  The reason is that, and this makes sense, the actual work flow when building SQL for your application is as follows:

• Open SQL tool and write your query
• Execute, evaluate results, modify, repeat
• Copy and paste final SQL into your editor
…

Scaling MySQL on a 256-way T5440 server using Solaris ZFS and Java 1.7

*cough*

(and then wipe coffee off the computer)

of course the real aim should be to scale with one instance on the machine as scaling with multiple instances on the one machine isn’t scaling at all - it’s scale out, but with more problems (now when one machine goes down, so do 1110202434 database instances).

The MySQL database server can display a lot of performance statistics. However, most of them relate to general server parameters, such as buffer sizes and query cache settings. Of course, such settings are important to get right, and can make a huge difference in performance. Once you've tuned them however, you need to start looking at the tables and queries. When a single bad query can cost 90 - 99% of the total performance, server tuning doesn't fix the problem. But obtaining query profiling information from MySQL can be tricky. Here are some of the options:Slow query logYou can use the built-in slow_query_log from within the server. It will show you queries that take more than a second. Such queries typically don't use indices properly and are important to address. But only slow queries end up there, and many performance problems aren't caused by slow queries, but by queries that are run very often (for example, for-loops in the code …

Can you develop a business model that works for the community and for paying customers? READ MORE

Kaj Arnö is coming to Moscow on 1-3 of December.

There will be a Moscow MySQL User Group meeting with Kaj in High School of Economics:

Date: Monday, 1st of December
Time: 19-00
Topic: Sun and MySQL: what's happening
Location: Myasnitskaya 20, room 124

Everybody is welcome to join. To come, you need to register (there is security at the entrance
to the building, and it needs a list of names, usual stuff), there is no url for a registration
form yet ;), you could just leave a comment on this entry, I'll add you to the list.

One of the first things we had to do here at OlinData is set up a testing environment. Many customers have many different OS environments and we want to be able to accomodate all of them. With the setup described here, we will be able to easily set up many different OS’s, regardless of the [...]

cmon 0.11 which you can get from www.severalnines.com/cmon corrects the following bugs:

• Graphs wrap half ways - https://bugs.launchpad.net/cmon/+bug/300222
• Memory leaks (missed a couple of mysql_free_resultset) https://bugs.launchpad.net/cmon/+bug/300225
  

There are also some code cleanups.
To upgrade from earlier version:

• start a mysql client on the mysql server(s) having the cmon database
• use cmon
• drop mysql_statistics table
• drop mysql_variables table
• start cmon which will then recreate those tables

The above is particularly important if you move from MySQL Cluster 6.3.17 or earlier to 6.3.18 (or later) because the number of statistic counters and variables has increased between the versions. cmon will build up the mysql_statistics …