Percona announces the GA release of Percona Server for MySQL 5.7.22-22 on on May 31, 2018. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository.
Based on MySQL 5.7.22, including all the bug fixes in it, Percona Server for MySQL 5.7.22-22 is the current GA release in the Percona Server for MySQL 5.7 series. Percona …
[Read more]The schema changes in production can cause lock at time and makes the slave to lag. It is more tedious and troublesome with PXC ( Galera ) cluster which can be made smoother with Percona online schema change.
Image Courtesy : Photo by Andrew Ruiz on Unsplash
We have seen with most of the consulting projects where the customer might be having a dedicated DB (MySQL) server ,but running with a default configuration, without any optimisation for underlying hardware, “An idle hardware is similar to idle money will give you no returns”.
Well again if you are from a non-DBA background and you have chosen InnoDB as your engine of choice. The next question will be, what are the major variable that needs to be tuned for the available hardware? here is the answer for you
In this post, We are going to detail about the variable innodb_dedicated_server in MySQL 8.0.11. This variable solves our above …
[Read more]
MySQL has multiple timeout variables these slides helps to give
an overview of the different timeout variables and their
purposes briefly.
Generally TPC-C benchmark workload is considered as one of the #1 references for Database OLTP Performance. On the same time, for MySQL users it's often not something which is seen as "the most compelling" for performance evaluations.. -- well, when you're still fighting to scale with your own very simple queries, any good result on something more complex may only look as "fake" ;-)) So, since a long time Sysbench workloads remained (and will remain) as the main #1 "entry ticket" for MySQL evaluation -- the most simple to install, to use, and to point on some sensible issues (if any). Specially that since new Sysbench version 1.0 a lot of improvements were made in Sysbench code itself, it really scales now, has the lowest ever overhead, and also allowing you to add your own test scenario via extended LUA scripts (and again, with lowest ever overhead) -- so, anyone can easily add …
[Read more]This post is about a very simple approach / step-by-step InnoDB log (aka transaction logs)resize, We don’t do this activity regularly but when we have to resize InnoDB log files, there will be a MySQL downtime. This post will be a like a checklist for anyone who want to resize InnoDB log files without any mistakes, We made this task in multiple steps so that you can follow much better:
Step 1 – Check existing logs and their size:
[root@localhost ~]# lsof -c mysqld | grep ib_logfile mysqld 1018 mysql 5uW REG 253,0 50331648 180228 /var/lib/mysql/ib_logfile0 mysqld 1018 mysql 11uW REG 253,0 50331648 180229 /var/lib/mysql/ib_logfile1
Step 2 – Shutdown MySQL
[root@localhost ~]# systemctl stop mysqld [root@localhost ~]# systemctl status mysqld ● mysqld.service - MySQL Server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; …[Read more]
Historically, Random I/O Reads were always a major PITA
for any OLTP workload.. If Random I/O Writes you could yet
"delay" via controller's caches (or any kind of other
battery-protected caches -- specially if Writes are coming in
bursts), there is no way to "predict" I/O Reads if they are fully
Random (so you cannot "cache" or "prefetch" them ahead and have
to deliver the data directly from storage, read by read.. --
which is hitting a huge "rotation penalty" on HDD).
Indeed, things changed dramatically since arriving of Flash
Storage. You don't need to spend any particular attention if your
I/O Reads are Random or Sequential. However, you still need to
keep in mind to not hit the overall throughout limit of your
Flash Device. As the result, reading by smaller I/O blocks
allowing you to do more I/O operations/sec than with bigger
blocks. And what about InnoDB ? -- InnoDB is using by default
16KB page size (so by default all Random I/O …
Encryption is a very important form of security and It’s becoming a standard from a compliance perspective to ensure PCI, PII and HIPPA compliances. Encryption needs to be performed for Data at Rest, Data over Wire.
Data At Rest:
Instant DDL has been one of the most requested InnoDB features for a very long time. With ever larger and rapidly growing datasets the ability to do DDL instantly is a must have feature in any web scale database. Developers constantly need to add new columns to meet the constantly changing business requirements. …
In the previous article I've intentionally
skipped the topic related to Binlog impact on MySQL 8.0
Performance, because it's not a short story, nor a simple
one..
In fact, for most of people Binlog in MySQL is generally
representing and additional overhead, and historically it was
true. Since MySQL 5.6 there is Binlog Group Commit (BGC) feature
available, and it was rather doing well, decreasing the gap between "binlog=OFF" and
"binlog=ON sync_bin=1". However, storage vendors are making flash
drives more and more better from year to year.. And when we
delivered MySQL 5.7 the scope of Binlog impact moved with code
and flash improvements -- the main impact was no more coming from
the I/O operations …