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!

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 …