|
|
|
|
544
résultats
parmi
4
sites
|
|
bad idea..
tmpdir..
..on tmpfs
upgrade..
..to 5.5
default engine..
..innodb
create..
..temp tables statements
optimizing my.cnf...
..io_direct sounds good..
tmpfs..
..and io_direct
do not..
..pl ...
|
|
|
|
Webcast: Thursday 3/1/12 @ 10 am PT/ 1 pm ETWebcast: Tuesday 3/6/12 @ 15:00 CET/14:00 GMTLearn how the next version of Tungsten Enterprise will help you push the envelope in multi-master, multi-site M ...
|
|
|
|
In this post, I'll cover the new MySQL monitoring plugins we created for Nagios, and explain their features and intended purpose. I want to add a little context. What problem were we trying to solve w ...
|
|
|
|
|
It seems that whenever I have a cross-continent flight, Mondriangets a new feature. This particular flight was from Florida back hometo California, and this particular feature is a time-dimensiongener ...
|
|
|
|
I've followed with interest on Baron's Why don't our new Nagios plugins use caching? and Sheeri's Caching for Monitoring: Timing is Everything. I wish to present my take on this, from mycheckpoint's p ...
|
|
|
|
I have been at Mozilla nearly three months, and I used to blog a lot more than I currently do. A lot of the content I used to blog about I end up blogging and talking about in OurSQL: The MySQL Databa ...
|
|
|
|
Splitmytab.net is finally for the public to check out. Splitmytab is a bill splitting and IOU system for friends. It uses facebook's login, so you won't need to put in anyone's emails, names, or get p ...
|
|
|
|
Oracle is pleased to be a Bronze Sponsor of DrupalCon Denver. DrupalCon will be held the Colorado Convention Center in Denver on March 19-23, 2012. There are community events scheduled throughout the ...
|
|
|
|
Last weekend Vadim from Percona published his MariaDB 5.3.4 benchmark results. As the new benchmark guy at Monty Program I take this oportunity to add some more results of my own.
One question in the ...
|
|
|
|
|
I found Baron's reasoning on why the Percona Nagios plugins do not use caching interesting. On the surface, the logic is sound - you do not want to cache when you want real-time monitoring.
I have not ...
|
|
|
|
|
DBD::mysql 4.014 breaks pt-table-checksum 2.0. The cause is unknown, but the effect is a lot of errors like: DBD::mysql::st execute failed: called with 2 bind variables when 6 are needed [for Statemen ...
|
|
|
|
I am a minimalist at heart, and I love command line interfaces and text files.
However, I'm also pragmatic, and so for a long time my blog has been powered by Wordpress, which made it relatively easy ...
|
|
|
|
Changes (as compared to 9.51) include:
Features:
* When performing CREATE/ALTER TABLE operation from inside the Schema Designer now a dialog with a tabbed interface similar to the CREATE/ALTER TABLE t ...
|
|
|
|
We have been testiing the MySQL RDS Service from Amazon here at RF, and so far it looks good for what we use MySQL for. We don't have that much data left in MySQL though, but some of the services are ...
|
|
|
|
So there I was, gesticulating in front of the chalkboard, lecturing to 120 students. Topic: the beauty of advanced data structures. The door opens and the department chair walks up the aisle onto the ...
|
|
|
|
I see that MySQL 5.5.21 has just been released. This sounds interesting. I'm mainly running 5.5.16 which has been broadly stable, but I have been caught by a few important issues which 5.5.21 fixes ac ...
|
|
|
|
In a previous post, I demonstrated a simple Python database API with a syntax similar to jQuery. The goal was to provide a simple API that would allow Python programmers to use a database without havi ...
|
|
|
|
|
Baron Schwartz from Percona has just re-invented the SQLyog Query Profiler.
Refer: http://www.mysqlperformanceblog.com/2012/02/20/how-to-convert-show-profiles-into-a-real-profile/
The SQLyog Query Pro ...
|
|
|
|
|
As always, I am a little late, but I want to jump on the bandwagon and mention the recent MySQL Cluster milestone of passing 1 billion queries per minute. Apart from echoing the arbitrarily large rans ...
|
|
|
|
|
In this previous Blog I described an example on how to build a Custom Object in MONyog. But there is one problem you may encounter and that is, that when querying Information_Schema and Performance_Sc ...
|
|
|
|
I recently received a question asking about InnoDB and the ability to autoextend the ibdata files.The question was basically this:If the database has 1 ibdata file that is using autoextend but also ha ...
|
|
|
|
|
A quick reminder. I'm speaking on two MySQL meetups in North Carolina this week. Tuesday,Feb 21 on Raleigh MySQL/PHP Meetup and when Wednesday, Feb 22 on Charlotte Queen City PHP Note the last meetup ...
|
|
|
|
|
SHOW PROFILES shows how much time MySQL spends in various phases of query execution, but it isn't a full-featured profile. By that, I mean that it doesn't show similar phases aggregated together, does ...
|
|
|
|
In my previous post I explained how it could be possible to recover, on some specific cases, a single table from a full backup in order to save time and make the recovery process more straightforward. ...
|
|
|
|
"Legacy MySQL does not scale well on a single node, which forces granular sharding and explicit application code changes to make them sharding-aware and results in low utilization of severs"- Dr. John ...
|
|
|
|
SkySQL recently
|
|
|
|
|
In response to the release of our new MySQL monitoring plugins on Friday, one commenter asked why the new Nagios plugins don't use caching. It's worth answering in a post rather than a comment, becaus ...
|
|
|
|
Helsinki, Finland, Uster, Switzerland - February 18, 2012 - Codership, the provider of Galera Cluster for MySQL, and FromDual, a MySQL consulting company, today announced collaboration to offer Galera ...
|
|
|
|
I was getting inconsistent performance results while running sysbench to generate a workload of point-updates and point-lookups. The rate of rows updated per second would vary between 200 and 600 and ...
|
|
|
|
|
MySQL Settings (also known as Server Variables) have interesting property. When you set variable in running server this change is not persisted in any way and server will be back to old value upon res ...
|
|
|
|
