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!

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.10or sources, from:

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

Enjoy!

Dear MySQL users,

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/

Valeriy Kravchuk’s great recent post on using oprofile to profile MySQL mentioned how pt-stalk, the script from Percona Toolkit to capture diagnostics data based on a detected condition, currently does not support the new operf comand, and relies instead on the deprecated and soon to be removed, opcontrol.

Fortunately, in the Open Source world, we deal with these situations by contributing, and this seemed a simple enough change that I could get a PR ready quickly and reply …

I had great fun at my first Fosdem over the weekend with everybody that turned up to the http://www.mysqlandfriends.eu/ dev room. Kudos to the organizers there, @lefred, @gryp, @dim0, and all the others that helped behind the scenes.

Here’s my slides for my talk on instrumenting plugins within Performance Schema:

Fitting this in to a 20 minute slot was an interesting thing to do, so I couldn’t go in depth on the entire API, but hopefully I did have enough time to show just …

Some databases (in particular MySQL and T-SQL databases like SQL Server and Sybase) support a very nice feature: They allow for running a "batch" of statements in a single statement. For instance, in SQL Server, you can do something like this: -- Statement #1 DECLARE @table AS TABLE (id INT); -- Statement #2 SELECT * … Continue reading How to Execute SQL Batches With JDBC and jOOQ →

This procedure can be used to expand an LVM  database volume on Amazon AWS (but also apply to any storage area network environment equally). Let me start with this assumption: when you create volumes for database use in AWS using EBS, you stripe data across them in order to enhance performance.  If you aren't doing this... well, you should :-) Under this assumption, when you need to add more disk space to an existing database volume, you can't just add the disk(s) to the volume, as this would make the added space non striped, and would eventually create hotspots in the dataset. The correct approach in this situation is to create a number of new EBS disks enough to contain entire dataset plus the desired added space,so that you can grow the existing dataset while re-striping properly.
To make this clear, let's suppose you have a dataset volume of  3 TB,  made of 3 1TB EBS volumes which are striped across, but space is running …