Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered free as an open source solution, Percona …[Read more]
10 Older Entries »
Dear MySQL Users,
A new GA (general availability) version of MySQL Connector/C has
made available: MySQL Connector/C 6.1.11 GA. The MySQL Connector/C 6.1
implements the MySQL C API for connecting client applications to the
MySQL Server 5.5 or newer.
You can download the production release at:
MySQL Connector C (Commercial) will be available for download on
Oracle Support (MOS) website. This release will be available on
eDelivery (OSDC) in next month’s upload cycle.
Please see the documentation and the README file in the source
for a detailed description of bugs that have been fixed.
Changes in MySQL Connector/C 6.1.11 (2017-07-24)
* The linked …[Read more]
MySQL Connector/ODBC 5.3.9, a new version of the ODBC driver
the MySQL database management system, has been released.
The available downloads include both a Unicode driver and an
driver based on the same modern codebase. Please select the driver type
you need based on the type of your application – Unicode or ANSI.
Server-side prepared statements are enabled by default. It is suitable
for use with any MySQL version from 5.5.
This is the fourth release of the MySQL ODBC driver conforming to
ODBC 3.8 specification. It contains implementations of key 3.8 features,
including self-identification as a ODBC 3.8 driver, streaming of output
parameters (supported for binary types only), and support of the
SQL_ATTR_RESET_CONNECTION connection attribute (for the Unicode driver
Also, Connector/ODBC 5.3 introduces a GTK+-based setup …[Read more]
Pimcore is an open source enterprise content management system (CMS) written in PHP, It uses MySQL as database backend. In this tutorial, we will install Pimcore CMS on CentOS 7 server.
MySQL theoretical limits are known and they can be found in the manual, they include:
MyISAM permits data and index files to grow up to 256 TiB by default, but this limit can be changed up to the maximum permissible size of 65,536 TiB (256^7 − 1 bytes). The maximum tablespace size depends on the InnoDB page size: 64 TiB for 16 KiB pages.(The maximum tablespace size is also the maximum size for a
Last time I had to use gdb to check what's going on in
MySQL server and found something useful with it to share in the
blog post it was April 2017, and I miss this
kind of experience already. So, today I decided to try it again
in a hope to get some insights in cases when other tools may not
apply or may not be as helpful as one could expect. Here is the
long enough story, based on recent customer issue I worked on
* * * Had you seen anything like this output of SHOW PROCESSLIST statement:
Id User Host db Command Time State[Read more]
28 someuser01 xx.xx.xx.xx:39644 somedb001 Sleep 247
29 someuser01 xx.xx.xx.yy:44100 somedb001 Query 276
Waiting for table level lock DELETE FROM t1 WHERE (some_id = 'NNNNN') AND ... 0.000 …
Dear MySQL Users,
MySQL Connector/J 5.1.43, a maintenance release of the production 5.1 branch has been released. Connector/J is the Type-IV pure-Java JDBC driver for MySQL.
MySQL Connector Java is available in source and binary form from
the Connector/J download pages at
http://dev.mysql.com/downloads/connector/j/5.1.html and mirror
MySQL Connector Java (Commercial) is already available for
download on the My Oracle Support (MOS) website. This release
will be available on eDelivery
(OSDC) in next month’s upload cycle.
As always, we recommend that you check the “CHANGES” file in the download archive to be aware of changes in behavior that might affect your application.
MySQL Connector/J 5.1.43 includes the following general bug fixes
and improvements, also available in more detail on
nges in MySQL Connector/J …
This Log Buffer Edition covers Oracle, SQL Server and MySQL.
Protecting Financial Data with Oracle WebCenter and Adobe LiveCycle
Oracle Forms 12c oracle.security.jps.JpsException Error after Database change
The Future of Content Management: Oracle Content & Experience Cloud
Today Oracle released a very large „monster“ Upgrade. This July 2017 Update includes the first time the new RU „Release …[Read more]
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
Starting in version 5.7.17-29.20 of Percona XtraDB Cluster significantly improved performance. Depending on the workload, the increase in throughput is in the range of 3-10x. (More details here). These optimization fixes also helped improve IST (Incremental State Transfer) performance. This blog is aimed at studying the IST impact.
IST stands for incremental state transfer. When a node of the cluster leaves the cluster for a short period of time and then rejoins the cluster it needs to catch-up with cluster state. As part of this sync …[Read more]
More than 3 months after 5.7.18 we' ve got MySQL 5.7.19 released
recently. This is my quick review of the release notes with interesting fixed bug
(reported in public) highlighted in the areas I am usually
Let's start with InnoDB. The following bug fixes attracted my attention:
- Bug #85043 is still private. You know how much I hate those. At least we can see it was about the fact that "The server allocated memory unnecessarily for an operation that rebuilt the table." Let's hope this is no longer the case.
- Bug …
10 Older Entries »