The VividCortex brainiacs continue taking strides toward better database monitoring, one feature at a time. See our 2015 highlights here and contact us to see how we can improve your IT efficiency.

Restore hackmysql.com/case1: Indexing Basic MySQL Queries.

This is a new release with some new features and many bugfixes and enhancements.

Get it from the download page.



Changelog:
* New feature: Add support for JSON grid export
* New feature: Add support for Markdown Here grid export
* New feature: Support new command line parameter "n", or "nettype", which takes an integer, representing the protocol number (0=mysql tcpip, ...).
* New feature: Add support for connecting to Microsoft Azure Servers
* New feature: Add edit box + updown buttons for limiting the size of exported INSERT queries in bytes.
* New feature: Display creation time, last alter time, comment and start time of scheduled events.
* New feature: Online help document …

This is a new release with some new features and many bugfixes and enhancements.

Get it from the download page.



Changelog:
* New feature: Add support for JSON grid export
* New feature: Add support for Markdown Here grid export
* New feature: Support new command line parameter "n", or "nettype", which takes an integer, representing the protocol number (0=mysql tcpip, ...).
* New feature: Add support for connecting to Microsoft Azure Servers
* New feature: Add edit box + updown buttons for limiting the size of exported INSERT queries in bytes.
* New feature: Display creation time, last alter time, comment and start time of scheduled events.
* New feature: Online help document …

Is It Supported for MAC Versions??

I used this technique to remove strings from bash history file containing passwords and other sensitive data on a Mac OS X shell.

Wonder how MySQL Slave server will act, when disk full condition occurs? Before in our articles we use only single MySQL server. Now think about replication topology, where slave server has problem with full partition. Firstly we will enable Binary Log/GTID on Slave side and will ensure that the changes also applied to binary log on Slave side:

      # BINARY LOGGING # 
      server_id = 2 
      log_bin = /opt/mysql/datadir/mysql-bin 
      log_bin_index = /opt/mysql/datadir/mysql-bin 
      expire_logs_days = 14 
      sync_binlog = 1 
      binlog_format = row 
      relay_log = /opt/mysql/datadir/mysql-relay-bin 
      log_slave_updates = 1 
      read_only = 1 
      gtid-mode = on 
      enforce-gtid-consistency = true 
      master-info-repository = TABLE 
      relay-log-info-repository = TABLE 
      slave-parallel-workers = 15 
      binlog-checksum = CRC32 
      master-verify-checksum = 1 
      slave-sql-verify-checksum = 1 …

An idea for a benchmark based on the “arrival request” rate that I wrote about in a post headlined “Introducing new type of benchmark” back in 2012 was implemented in Sysbench. However, Sysbench provides only a simple workload, so to be able to compare InnoDB with TokuDB, and later MongoDB with Percona TokuMX, I wanted to use more complicated scenarios. (Both TokuDB and TokuMX are part of Percona’s product line, in the case you missed Tokutek now part of the Percona family.)

Thanks to Facebook – they provide LinkBench, a benchmark that emulates the social graph …

Download MariaDB 5.5.43

Release Notes Changelog What is MariaDB 5.5?

MariaDB APT and YUM Repository Configuration Generator

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.43. This is a Stable (GA) release.

See the Release Notes and …

This article is a part of our Rockstar DBA initiative, a platform for thought leaders to share their knowledge and make a positive contribution towards the database management community.

Manojit Paul, with more than 19 years of professional DBA experience in enterprise database solutions, especially Sybase product set and database infrastructure is our first Rockstar DBA.

Let’s hear from Manojit about how he manages MySQL databases, why he loves MONyog, his advice to young DBA’s and more.

How do you manage your MySQL databases?
We presently have 9 MySQL servers in production trading environment, all being managed via a host of automated scripts which I’ve created and manual intervention when issues are reported. We deploy MONyog for managing 5 of these critical MySQL instances. …