Some years ago I posted an article about the code size in the
MySQL Workbench project and talked a bit about the different
subprojects and modules. At that time the project consisted of
~400K LOC (including third-party code) and already then the
parser was the second biggest part with nearly a forth of the
size of the entire project. This parser project back then used
the yacc grammar from the MySQL server codebase and was our base
for all parsing tasks in the product. Well, things have changed a
lot since these days and this blog post discusses the current
parsing infrastructure in MySQL Workbench.
We started looking into a more flexible way of
creating our parser infrastructure. Especially the generation of
lexer and parser from the grammar was a long …
Fri, 2015-08-14 09:34geoff_montee_g
Conservative in-order parallel replication is
a great feature in MariaDB 10.0 that improves replication
performance by using knowledge of group commit on the master to
commit transactions in parallel on a slave. If slave_parallel_threads is greater
than 0, then the SQL thread will instruct multiple worker threads
to concurrently apply transactions that were committed in the
same group commit on the master.
Conservative in-order parallel replication is a good alternative to out-of-order parallel replication …
[Read more]
Introduction: where we standPrevious episodes:
MySQL replication in action - Part 1: GTID &
Co
In the latest releases of MySQL and MariaDB we have seen several
replication improvements. One of the most exciting additions is
the ability to enhance basic replication with multiple sources.
Those who have used replication for a while should remember that
one of the tenets of the “old” replication was that a slave
couldn’t have more than one master. This was The Law and
there was no escape ... until now. The only way to work around
that prohibition was to use circular replication, also
known as …
Leif Walsh will talk about the language of compression at Percona Live Amsterdam
Storage. Everyone needs it. Whether your data is in MySQL, a NoSQL, or somewhere in the cloud, with ever-growing data volumes – along with the need for SSDs to cut latency and replication to provide insurance – an organization’s storage footprint is an important place to look for savings. That’s where compression comes in (squeeze!) to save disk space.
Two Sigma software engineer Leif Walsh speaks the language of compression. Fluently. In fact, he’ll be speaking on
that exact subject September 22 during the Percona Live conference in …
[Read more]Welcome to the final – but most important – episode in the MySQL QA Series.
In it, I present my vision for all MySQL Quality Assurance – for all distributions – worldwide.
Episode 13: A Better Approach to all MySQL Regression, Stress & Feature Testing: Random Coverage Testing & SQL Interleaving
1. pquery Review
2. Random Coverage Testing
3. SQL Interleaving
4. The past & the future
Presented by Roel Van de Paar. Full-screen viewing @ 720p resolution recommended
Interested in the full MySQL QA Series?
The post MySQL Quality Assurance: A Vision for the Future by Roel Van de Paar (Final Episode 13) appeared first on MySQL Performance Blog.
Dear MySQL users,
MySQL Connector/Net 6.7.8, 6.8.6, and 6.9.7 are maintenance releases for the series of the .NET driver for MySQL. They can be used for production environments.
They are appropriate for use with MySQL server versions 5.5-5.7.
They are now available in source and binary form from http://dev.mysql.com/downloads/connector/net/
(note that not all mirror sites may be up to date at this
point-if you can’t find this version on some mirror, please try
again later or choose another download site.)
Changes in MySQL Connector/Net 6.8.8
- Connections to MySQL server 5.7 now default to using SSL.
Changes in MySQL Connector/Net 6.8.6
- Connections to MySQL server 5.7 now default to using SSL.
Changes in MySQL Connector/Net 6.9.7
- The selection of a …
TokuFT (now called PerconaFT) is the write optimized storage component used by
TokuDB for MySQL and TokuMX for MongoDB. Since TokuFT is its
own component, TokuFT can be tested independently of TokuDB and
TokuMX. Some of the TokuFT tests use valgrind's memcheck,
helgrind, and DRD tools to identify bugs.
Helgrind and DRD find data races in multi-threaded programs at
runtime rather than at compile time. In my experience with
these …
What is MySQL Package Verification? Package verification (Pkgver for short) refers to black box testing of MySQL packages across all supported platforms and across different MySQL versions. In Pkgver, packages are tested in order to ensure that the basic user experience is as it should be, focusing on installation, initial startup and rudimentary functionality. When […]
Not sure if my comment mad it…
What about connection attributes in performance_schema? There is
an _pid attribute.
This should also be in sys.processlist if you have a recent sys
version
MySQL Cluster Manager 1.3.6 is available for download from My Oracle Support.
More details are available in the the MCM 1.3.6 Release Notes.
Updated documentation is available here.…