Category: Servers of Databases: Mysql MariaDB Percona

[root@server ~]# mysql -u root -pXXXXX -e 'select table_schema,table_name,engine from tables' information_schema
+--------------------+---------------------------------------+--------+
| table_schema       | table_name                            | engine |
+--------------------+---------------------------------------+--------+
| information_schema | CHARACTER_SETS                        | MEMORY |
| information_schema | COLLATIONS                            | MEMORY |
| information_schema | COLLATION_CHARACTER_SET_APPLICABILITY | MEMORY |
| information_schema | COLUMNS                               | MyISAM |
....

So. As it is known, mysqld it “one process – is a lot of threads”.In approached enough understanding thread it when process copies itself, and parental process transfers to threads what that a task for the decision.

Creation thread differs from usual fork () basically that fork generates +1 process whereas division on threads uses other, more productive technology of branching without cloning of the data in memory.

At each connection of the client, mysql creates thread which this connection processes.

“Optimization and tuning of the threads in MYSQL.”Continue reading

MySQL root privileges user is “root”, I always remove “root” userid once I got MySQL installed, mainly for security purpose, secondly I do not want stupid thing happened like someone able to brute force into MySQL database.

“Create root privilege user on MySQL server.”Continue reading

As a general rule, however, do not copy the mysql system schema from one server to another. As a consequence, and as far as I know, there is no “standard” way of copying users and user privileges from one server to another.

“Migrate mysql users to another server”Continue reading