mysql memory



  • 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.



  • 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
    



Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2