The MySQL error log has received some attention in MySQL 5.7,
with a new setting called log_error_verbosity.
There are three possible values, as documented in the manual:
| Verbosity Value | Message Types Logged |
| 1 | Errors only |
| 2 | Errors and warnings |
| 3 | Errors, warnings, and notes (default) |
As Giuseppe has written about previously, writing notes or “informational events” can create debugging problems because they reduce the …
[Read more]
The MySQL error log has received some attention in MySQL 5.7,
with a new setting called log_error_verbosity.
There are three possible values, as documented in the manual:
| Verbosity Value | Message Types Logged |
| 1 | Errors only |
| 2 | Errors and warnings |
| 3 | Errors, warnings, and notes (default) |
As Giuseppe has written about previously, writing notes or “informational events” can create debugging problems because they reduce the …
[Read more]This is both hilarious and sad. The new MySQL 5.7 milestone release presents a new feature — replication filters are now dynamic. This is a great and long awaited feature, no doubt about it.
In short, for years MySQL slaves could filter the incoming stream
of replication events based on the database or table name these
events were applicable to. These filters were configured using
the my.cnf file (or command-line), in
particular with the following variables:
replicate_do_db replicate_ignore_db replicate_do_table replicate_ignore_table replicate_wild_do_table replicate_wild_ignore_table
Naturally, users wanted to be able to change the values of these options without having to restart the server. And eventually Davi Arnaut implemented it. MariaDB got it as a contribution back in version …
[Read more]This week we discuss fine-tuning Galera Cluster. In this week's ear candy we talk about recent changes to mysqldump and locking; At the Movies presents "Using Amazon Web Services for MySQL at Scale".
Events
DB Hangops -
every other Wednesay at noon Pacific time
FOSDEM 2014
- Sat February 1 - Sun February 2 in Brussels, Belgium.
Upcoming MySQL events
Training
SkySQL Trainings
In some application scenarios (e.g. PHP applications) client connections have very short durations, maybe only executing a single query. This means that the time spent processing connects and disconnects can have a large impact on the overall performance.
In MySQL 5.6 we started working on optimizing the code handling connects and disconnects. And this work has accelerated in MySQL 5.7. In this blog post I will first show the results we have achieved and then describe what we have done to get them.
The results
The graph below shows a comparison of the most recent 5.5 and 5.6 releases as well as the 5.7.2 and 5.7.3 milestones. We measured the number of queries per second (QPS) where each client executes a single query (point select) before disconnecting. For each server version we also tested with both Performance Schema disabled and enabled. Details about server hardware and configuration settings used, …
[Read more]MariaDB CONNECT Storage Engine allows to access heterogeneous datasourses. This includes various file formats. But this also includes ODBC accessible datasources The CONNECT Storage Engine ODBC table type allows to access SQLite, Excel, SQL Server or Oracle databases. Some nice features of the ODBC CONNECT table type are: - Auto discovery of table structure. This [...]
MySQL DBA skills are highly sought after in the market place. The MySQL for Database Administrators course is a highly popular course created by the MySQL experts to give you hands-on experience with tasks ranging from installing MySQL to investigating different replication scenarios and planning for disaster recovery.
You can take this 5-day instructor-led course as a:
|
… |
The USA's health care exchange site, healthcare.gov, has had well-publicized initial woes.
The New York Times has said one of the problems was the government's choice of DBMS, namely MarkLogic. A MarkLogic employee has said that "If the exact same processes and analysis were applied to a LAMP stack or an Oracle Exa-stack, the results would have likely been the same."
I don't know why he picked Exastack for comparison, but I too have wondered whether things would have been different if the American government had chosen a LAMP component (MySQL or MariaDB) as a DBMS, instead of MarkLogic.
What is MarkLogic?
The company is a software firm founded in 2001 based in San Carlos California. It has …
[Read more]The call for participation at Percona Live MySQL Conference and Expo 2014 is now closed. There have been more than 320 submissions, and this will keep the review committee busy for a while.
One important point for everyone who has submitted: if you have submitted a proposal but haven’t included a bio in your account, do it now. If you don’t, your chances of being taken seriously are greatly reduced. To add a bio, go to your account page and fill in the Biography field. Including a picture is not mandatory, but it will be definitely appreciated.
Although the CfP is closed for tutorials and regular sessions, your chances of becoming a celebrity are not over yet. The CfP is still …
[Read more]Because most MySQL production systems probably run on Linux, I’ve decided to place the most important Linux tuning tips that will help improve MySQL performance. There is nothing new here, most of them are well known, however, I’ve decided to collect those Linux configuration tips into 1 blog post.
Filesystem
# echo deadline >/sys/block/sda/queue/scheduler add "elevator=deadline" to grub.conf
(For more info see Linux Schedulers in TPCC like benchmark)
Memory
# echo 0 > /proc/sys/vm/swappiness add "vm.swappiness = 0" to /etc/sysctl.conf
numactl …[Read more]