As a part database administration, DBA has to take care of sub-components of database like server logs and has to plan for maintenance activity for these components regularly.

MySQL has various types of log i.e binary log, error log, slow query log, general log for different purposes. And after certain time these logs will grow and you will start seeing issues like low disk space, a large number of logs etc.

MySQL allows you to flush logs using flush logs command, next “How to rotate and clean up old MySQL logs? ”

Linux has a utility called “logrotate” , using logrotate we can implement log rotation for MySQL server logs.

Binary logs: This one is critical if you have replication setup, By enabling  expire_logs_days mysql variable you can manage …

This blog we describe an issue with MySQL 5.7’s super_read_only feature when used alongside with GTID in chained slave instances.

Background

In MySQL 5.7.5 and onward introduced the gtid_executed table in the MySQL database to store every GTID. This allows slave instances to use the GTID feature regardless whether the binlog option is set or not. Here is an example of the rows in the gtid_executed table:

mysql> SELECT * FROM mysql.gtid_executed;
+--------------------------------------+----------------+--------------+
| source_uuid                          | interval_start | interval_end | …

There are several advantages to keeping up to date with the latest major versions of MySQL. To provide a short example using MySQL 5.7:

• Let application developers benefit from new functionality, e.g. JSON in 5.7
• Use your hardware infrastructure more efficiently with parallel slaves in 5.7
• Improve monitoring or management for DevOps with more performance schema instrumentation in 5.7
• Improve security by using features like  transparent data encryption, firewall, auditing, and sha256 authentication in 5.7
• Keep within the EOL window for access to maintenance releases and support

This blog post explains general activities in an upgrade project and what to look out for prior to an upgrade between major MySQL Server releases.…

MySQL 5.7 introduced the LOGICAL_CLOCK type of multi-threaded slave (MTS).  When using this type of parallel replication (and when slave_parallel_workers is greater than zero), slaves use information from the binary logs (written by the master) to run transactions in parallel.  However, enabling parallel replication on slaves might not be enough to get a higher replication throughput (VividCortex

If you’ve been reading enough database related forums, mailing lists or blogs you probably heard complains about MySQL being unable to handle more than 1.000.000 (or select any other number) rows by some of the users. On other hand it is well known with customers like Google, Yahoo, Live Journal, Technocarati MySQL has installations with many billions of rows and delivers great performance. What could be the reason?

The reason is normally table design and understanding inner works of MySQL. If you design your data wisely considering what MySQL can do and what it can’t you will get great performance if not, you might become upset and become one of those bloggers.

Note – Any database management system is different in some respect and what works well for Oracle, MS SQL, and PostgreSQL may not work well for MySQL and other way around. Even storage engines have very important differences which can …

Be involved with MySQL Performance in some way is to ask them what should be tuned in MySQL Server straight after installation, assuming it was installed with default settings.

Even though you can tune quite a lot of variables in MySQL Servers only few of them are really important for most common workload. After you get these settings right other changes will most commonly offer only incremental performance improvements.

key_buffer_size – Very important if you use MyISAM tables. Set up to 30-40% of available memory if you use MyISAM tables exclusively. Right size depends on amount of indexes, data size and workload – remember MyISAM uses OS cache to cache the data so you need to leave memory for it as well, and data can be much larger than indexes in many cases. Check however if all of key_buffer is used over time – it is not rare to see key_buffer being set to 4G while combined size of …

Here, I gave the list of variables to be tune for MySQL optimization. And give the value for each variable belongs to your system configuration.

The MySQL server

#mysqld

max_connections

max_user_connections

key_buffer_size

myisam_sort_buffer_size

bulk_insert_buffer_size

join_buffer_size

read_buffer_size

sort_buffer_size

table_cache

table_open_cache

thread_cache_size

max_heap_table_size

tmp_table_size  

interactive_timeout

wait_timeout

connect_timeout

max_allowed_packet

max_connect_errors

query_cache_limit

query_cache_size

query_cache_type

log_slow_queries

long_query_time 

#InnoDB tables

innodb_log_buffer_size

…

OS Level Security:--à Never run the MySQL server as the linux ‘root’ user.Always create the seprate   

        user for MySQL and start/stop MySQL server with it.

--à If the data directories are located under $mysql home/data dir then make   

        sure that directory and all subdirectories should have only read and write   

        privileges for the mysql user.

---à Always secure MySQL log files like binary log,query log,error.log etc.Because

         through that anyone can get the information about data,tables etc.

--à Always secure MySQL configuration files.i.e my.cnf.If possible than keep it in

        different …

Contents

Overview.. 1

Setup.. 1

Fixing the Warnings. 5

Summary. 6

Overview

This document is intended to help insert a CSV file into a Database.  The CSV files that are exported into Excel Spreadsheet can generally have garbage characters and special characters that should be filtered in Excel, like & , “ ‘ etc.  Then there are hidden characters and International …

The MySQL developer tools team announces 6.3.9 as our GA release for MySQL Workbench 6.3.

For the full list of changes in this revision, visit
http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-3.html

For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/index.php?152

Download MySQL Workbench 6.3.9 GA now, for Windows, Mac OS X 10.10+,
Oracle Linux 7, Fedora 24 and 25, Ubuntu 16.04 and 16.10 or sources, from:

http://dev.mysql.com/downloads/tools/workbench/

Enjoy!