mysql memory

[Oba22]

Kubuntu 16.04 with latest updates. The situation is that apache and mysql have been launched on the desktop. The C+++ program reverts to mysql data. Most of the queries select a few. Apache is held to test the web and phpmyadmin. It's 4gb PHS, x84. 4 basic databases with minimum fields and tables. But mysql eats between 500mb and 1gb of operational memory. How can this consumption be reduced? My.conf is standard, bringing it:

    #
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
# 
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

* IMPORTANT: Additional settings that can override those from this file!
The files must end with '.cnf', otherwise they'll be ignored.

!includedir /etc/mysql/conf.d/

!includedir /etc/mysql/mysql.conf.d/

Conclusion:

$ sudo ls /etc/mysql/conf.d

mysql.cnf  mysqldump.cnf

$ sudo ls /etc/mysql/mysql.conf.d

mysqld.cnf  mysqld_safe_syslog.cnf

Write all the rest straight, if you need it, write it.

[Bogopo]

It was a bug. https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1576930 ♪ The decision was as follows: Write these lines up.

innodb-read-io-threads=1
innodb-write-io-threads=1