没有内存占用情况哎 mysql> status -------------- mysql Ver 14.14 Distrib 5.5.9, for Linux (i686) using readline 5.1Connection id: 1 Current database: Current user: cly@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server version: 5.5.9 MySQL Community Server (GPL) Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client characterset: utf8 Conn. characterset: utf8 UNIX socket: /var/lib/mysql/mysql.sock Uptime: 1 hour 52 min 26 secThreads: 1 Questions: 4 Slow queries: 0 Opens: 33 Flush tables: 1 Open tables: 26 Queries per second avg: 0.0
了MyISAM 存储引擎,这时候我们的整体内存该如何分配呢?
内存分配为如下几大部分:
a) 系统使用,假设预留800M;
b) 线程独享,约2GB = 500 * (1MB + 1MB + 1MB + 512KB + 512KB),组成大概如下:
sort_buffer_size:1MB
join_buffer_size:1MB
read_buffer_size:1MB
read_rnd_buffer_size:512KB
thread_statck:512KB
c) MyISAM Key Cache,假设大概为1.5GB;
d) Innodb Buffer Pool 最大可用量:8GB - 800MB - 2GB - 1.5GB = 3.7GB;
我指的mysql最大占用的资源大小
比如使用mysql里variable命令,里面可以查询一些缓冲区最大占用大小的信息
我想问的是有没有mysql的命令可以直接显示mysql进程最大占用的内存
里面提到一个mysql进程默认是最大可以有100个连接。
同学这里的线程又是什么意思呢?和进程有什么关系呢?
是说一个连接是一个线程吗?
没有内存占用情况哎
mysql> status
--------------
mysql Ver 14.14 Distrib 5.5.9, for Linux (i686) using readline 5.1Connection id: 1
Current database:
Current user: cly@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.9 MySQL Community Server (GPL)
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 1 hour 52 min 26 secThreads: 1 Questions: 4 Slow queries: 0 Opens: 33 Flush tables: 1 Open tables: 26 Queries per second avg: 0.0