mysql used too much memory

[shirakun]

hello
i from china i don't speak English
mysql used too much memory
700MB！

my log

Code: Select all

151211 19:46:52 [Note] /usr/sbin/mysqld: Normal shutdown

151211 19:46:52 [Note] Event Scheduler: Purging the queue. 0 events
151211 19:46:52  InnoDB: Starting shutdown...
151211 19:46:53  InnoDB: Waiting for 6 pages to be flushed
151211 19:46:53  InnoDB: Shutdown completed; log sequence number 4095464
151211 19:46:53 [Note] /usr/sbin/mysqld: Shutdown complete

151211 19:46:53 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
151211 19:46:54 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
151211 19:46:54 [Note] /usr/sbin/mysqld (mysqld 5.5.46-0+deb7u1) starting as process 22009 ...
151211 19:46:54 [Note] Plugin 'FEDERATED' is disabled.
151211 19:46:54 InnoDB: The InnoDB memory heap is disabled
151211 19:46:54 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151211 19:46:54 InnoDB: Compressed tables use zlib 1.2.7
151211 19:46:54 InnoDB: Using Linux native AIO
151211 19:46:55 InnoDB: Initializing buffer pool, size = 128.0M
151211 19:46:55 InnoDB: Completed initialization of buffer pool
151211 19:46:55 InnoDB: highest supported file format is Barracuda.
151211 19:46:55  InnoDB: Waiting for the background threads to start
151211 19:46:56 InnoDB: 5.5.46 started; log sequence number 4095464
151211 19:46:56 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
151211 19:46:56 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
151211 19:46:56 [Note] Server socket created on IP: '0.0.0.0'.
151211 19:46:56 [Note] Event Scheduler: Loaded 0 events
151211 19:46:56 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.46-0+deb7u1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Debian)

Configuration file

Code: Select all

[client]
port=3306
socket=/var/run/mysqld/mysqld.sock

[mysqld_safe]
socket=/var/run/mysqld/mysqld.sock

[mysqld]
user=mysql
pid-file=/var/run/mysqld/mysqld.pid
socket=/var/run/mysqld/mysqld.sock
port=3306
basedir=/usr
datadir=/var/lib/mysql
tmpdir=/tmp
lc-messages-dir=/usr/share/mysql
log_error=/var/log/mysql/error.log
default-storage-engine = MyISAM
symbolic-links=0

skip-external-locking
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 240K

#innodb_use_native_aio = 0
innodb_file_per_table

max_connections=30
max_user_connections=20
wait_timeout=10
interactive_timeout=50
long_query_time=5


!includedir /etc/mysql/conf.d/

[tjebbeke]

Do you have swap?

[shirakun]

Do you have swap?

But it's very small.

[skurudo]

Try to optimize your mylsq settings -> my.cnf
How much memory do you have on server?