mysql - 从 ubuntu 机器移动 mysql 成功，但内存消耗来自旧目录

Question

我在我的 ubuntu 机器上安装了 apache、mysql、phpmyadmin。我有一个大型数据库要存储在 mysql 中，因此将 mysql 从 root 移动到/mnt0 目录。但看起来 mnt0 的内 stub 本没有消耗，而是根目录的内存被消耗。这意味着移动 mysql 可能不成功。下面是我机器的内存使用情况(当我启动root目录时，它有6.3G可用内存。使用数据库一段时间后，root中的可用内存是5.1G，mnt0看起来一样，我的意思是没有内存使用)

Filesystem      Size  Used Avail Use% Mounted on
/dev/xvda1      7.8G  2.4G  5.1G  32% /
none            4.0K     0  4.0K   0% /sys/fs/cgroup
udev            3.7G  8.0K  3.7G   1% /dev
tmpfs           752M  212K  752M   1% /run
none            5.0M     0  5.0M   0% /run/lock
none            3.7G     0  3.7G   0% /run/shm
none            100M     0  100M   0% /run/user
/dev/xvdb       414G  485M  392G   1% /mnt0

这是我将 mysql 移至的位置 Buntu@ip-xx-xxx-xxx-xxx:/mnt0$ ls -l drwx------ 2 root root 16384 二月 6 00:17 丢失+找到 drwx------ 8 mysql mysql 4096 2月21日19:37 mysql

我已将此文件/etc/apparmor.d/usr.sbin.mysql 更改为新的数据目录。 /mnt0$ cat/etc/apparmor.d/usr.sbin.mysqld

# vim:syntax=apparmor
# Last Modified: Tue Jun 19 17:37:30 2007
#include <tunables/global>

/usr/sbin/mysqld {
  #include <abstractions/base>
  #include <abstractions/nameservice>
  #include <abstractions/user-tmp>
  #include <abstractions/mysql>
  #include <abstractions/winbind>

  capability dac_override,
  capability sys_resource,
  capability setgid,
  capability setuid,

  network tcp,

  /etc/hosts.allow r,
  /etc/hosts.deny r,

  /etc/mysql/*.pem r,
  /etc/mysql/conf.d/ r,
  /etc/mysql/conf.d/* r,
  /etc/mysql/*.cnf r,
  /usr/lib/mysql/plugin/ r,
  /usr/lib/mysql/plugin/*.so* mr,
  /usr/sbin/mysqld mr,
  /usr/share/mysql/** r,
  /var/log/mysql.log rw,
  /var/log/mysql.err rw,

  /mnt0/mysql/ r,
  /mnt0/mysql/** rwk,

  /var/log/mysql/ r,
  /var/log/mysql/* rw,
  /var/run/mysqld/mysqld.pid rw,
  /var/run/mysqld/mysqld.sock w,
  /run/mysqld/mysqld.pid rw,
  /run/mysqld/mysqld.sock w,

  /sys/devices/system/cpu/ r,

  # Site-specific additions and overrides. See local/README for details.
  #include <local/usr.sbin.mysqld>
}

编辑:添加了/mnt0 的 du -kh 和 ls -lha/mnt0/mysql

root@ip-xx-xxx-xxx-xxx:/mnt0# du -kh
204K    ./mysql-crapy/mysql/phpmyadmin
4.0K    ./mysql-crapy/mysql/test
212K    ./mysql-crapy/mysql/performance_schema
1.1M    ./mysql-crapy/mysql/mysql
30M ./mysql-crapy/mysql
30M ./mysql-crapy
16K ./lost+found
40K ./api.Kavitha.com
32K ./mysql/DB
224K    ./mysql/phpmyadmin
4.0K    ./mysql/test
212K    ./mysql/performance_schema
1.1M    ./mysql/mysql
20K ./mysql/KavithaDataBase
110M    ./mysql
96K ./CoreUtils/cli/fb
952K    ./CoreUtils/cli
44K ./CoreUtils/addrstd
43M ./CoreUtils/db
12K ./CoreUtils/etc-conf
16K ./CoreUtils/feeds
16K ./CoreUtils/api/
68K ./CoreUtils/api
104M    ./CoreUtils/dict
16K ./CoreUtils/core/sendgrid/sendgrid-php/Test/Mock
28K ./CoreUtils/core/sendgrid/sendgrid-php/Test/SendGrid
56K ./CoreUtils/core/sendgrid/sendgrid-php/Test
20K ./CoreUtils/core/sendgrid/sendgrid-php/lib/swift/classes/Swift/CharacterReader
8.0K    ./CoreUtils/core/sendgrid/sendgrid-php/lib/swift/classes/Swift/CharacterReaderFactory
20K ./CoreUtils/core/sendgrid/sendgrid-php/lib/
36K ./CoreUtils/core/sendgrid/sendgrid-php/lib/
12K ./CoreUtils/core/sendgrid/sendgrid-php/lib/
12K ./CoreUtils/core/sendgrid/sendgrid-php/lib/swift/classes/Swift/Plugins/Reporters
8.0K    ./CoreUtils/core/sendgrid/sendgrid-php/lib/swift/classes/Swift/Plugins/Decorator
12K ./CoreUtils/core/sendgrid/sendgrid-php/lib/swift/classes/Swift/Plugins/Loggers
12K ./CoreUtils/core/sendgrid/sendgrid-php/lib/swift/classes/Swift/Plugins/Pop
112K    ./CoreUtils/core/sendgrid/sendgrid-php/lib/swift/classes/Swift/Plugins
20K ./CoreUtils/core/sendgrid/sendgrid-php/lib/swift/classes/Swift/StreamFilters
20K ./CoreUtils/core/sendgrid/sendgrid-php/lib/swift/classes/Swift/CharacterStream
16K ./CoreUtils/core/sendgrid/sendgrid-php/lib/swift/classes/Swift/Transport/Esmtp/Auth
32K ./CoreUtils/core/sendgrid/sendgrid-php/lib/swift/classes/Swift/Transport/Esmtp
124K    ./CoreUtils/core/sendgrid/sendgrid-php/lib/swift/classes/Swift/Transport
52K ./CoreUtils/core/sendgrid/sendgrid-php/lib/swift/classes/Swift/Mime/Headers
12K ./CoreUtils/core/sendgrid/sendgrid-php/lib/swift/classes/Swift/Mime/HeaderEncoder
16K ./CoreUtils/core/sendgrid/sendgrid-php/lib/swift/classes/Swift/Mime/ContentEncoder
212K    ./CoreUtils/core/sendgrid/sendgrid-php/lib/swift/classes/Swift/Mime
68K ./CoreUtils/core/sendgrid/sendgrid-php/lib/swift/classes/Swift/Events
24K ./CoreUtils/core/sendgrid/sendgrid-php/lib/swift/classes/Swift/Encoder
844K    ./CoreUtils/core/sendgrid/sendgrid-php/lib/swift/classes/Swift
852K    ./CoreUtils/core/sendgrid/sendgrid-php/lib/swift/classes
20K ./CoreUtils/core/sendgrid/sendgrid-php/lib/swift/dependency_maps
896K    ./CoreUtils/core/sendgrid/sendgrid-php/lib/swift
900K    ./CoreUtils/core/sendgrid/sendgrid-php/lib
40K ./CoreUtils/core/sendgrid/sendgrid-php/SendGrid
1008K   ./CoreUtils/core/sendgrid/sendgrid-php
1016K   ./CoreUtils/core/sendgrid
1.6M    ./CoreUtils/core
20K ./CoreUtils/
149M    ./CoreUtils
316M    .



/mnt0# ls -lha /mnt0/mysql

total 109M

drwx------ 8 mysql mysql 4.0K Feb 21 20:31 .
drwxrwxrwx 7 root  root  4.0K Feb 21 20:19 ..
drwx------ 2 mysql mysql 4.0K Feb 12 00:22 Db
-rw-r--r-- 1 root  root     0 Feb 11 19:38 debian-5.5.flag
-rw-rw---- 1 mysql mysql  98M Feb 24 18:12 ibdata1
-rw-rw---- 1 mysql mysql 5.0M Feb 24 18:12 ib_logfile0
-rw-rw---- 1 mysql mysql 5.0M Feb 24 18:12 ib_logfile1
drwx------ 2 mysql root  4.0K Feb 11 19:39 mysql
-rw-rw---- 1 root  root     6 Feb 11 19:39 mysql_upgrade_info
drwx------ 2 mysql mysql 4.0K Feb 11 19:39 performance_schema
drwx------ 2 mysql mysql 4.0K Feb 11 19:45 phpmyadmin
drwx------ 2 mysql root  4.0K Feb 11 19:38 test
drwx------ 2 mysql mysql 4.0K Feb 12 20:39 KavithaDataBase

Answer 1

您期望数据库很大吗？这看起来正确且正常，如果数据库不是那么大，则其他分区上 1.2GB 的虚拟已用空间可以由某些非 MySQL 进程来解释。

这段有用的代码我 found应显示您的大约数据库大小:

SELECT table_schema "Data Base Name", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB"FROM information_schema.TABLES GROUP BY table_schema ; 

我建议从 phpMyAdmin 的 SQL 选项卡运行它并查看结果。如果将它们全部加在一起，大约应为 110MB。这样你就可以大概知道此时数据是否真的在MySQL中了。