问题:创建多个表空间添加记录数据会添加到哪个表空间中
答:后一个
drwx------ 2 mysql mysql 4.0K Apr 26 08:04 demo
-rw-rw---- 1 mysql mysql 18M Apr 26 09:52 ibdata1
-rw-rw---- 1 mysql mysql 10M Apr 26 09:23 ibdata2
-rw-rw---- 1 mysql mysql 5.0M Apr 26 09:52 ib_logfile0
-rw-rw---- 1 mysql mysql 5.0M Apr 26 09:52 ib_logfile1
-rw-rw---- 1 mysql root 20K Apr 26 09:23 james.err
-rw-rw---- 1 mysql mysql 5 Apr 26 09:23 james.pid
drwx------ 2 mysql root 4.0K Apr 26 05:40 mysql
-rw-rw---- 1 mysql mysql 28K Apr 26 05:40 mysql-bin.000001
-rw-rw---- 1 mysql mysql 974K Apr 26 05:40 mysql-bin.000002
-rw-rw---- 1 mysql mysql 264 Apr 26 05:56 mysql-bin.000003
-rw-rw---- 1 mysql mysql 126 Apr 26 05:59 mysql-bin.000004
-rw-rw---- 1 mysql mysql 931 Apr 26 08:10 mysql-bin.000005
-rw-rw---- 1 mysql mysql 126 Apr 26 08:24 mysql-bin.000006
-rw-rw---- 1 mysql mysql 126 Apr 26 08:32 mysql-bin.000007
-rw-rw---- 1 mysql mysql 126 Apr 26 08:34 mysql-bin.000008
-rw-rw---- 1 mysql mysql 126 Apr 26 09:17 mysql-bin.000009
-rw-rw---- 1 mysql mysql 30M Apr 26 09:52 mysql-bin.000010
-rw-rw---- 1 mysql mysql 190 Apr 26 09:23 mysql-bin.index
drwx------ 2 mysql mysql 4.0K Apr 26 05:40 performance_schema
drwx------ 2 mysql root 4.0K Apr 26 05:40 test
添加了100w条记录以后发现
ibdata2 10M-->50M
mysql-bin.000010 30M->170M
drwx------ 2 mysql mysql 4.0K Apr 26 08:04 demo
-rw-rw---- 1 mysql mysql 18M Apr 26 09:56 ibdata1
-rw-rw---- 1 mysql mysql 50M Apr 26 09:56 ibdata2
-rw-rw---- 1 mysql mysql 5.0M Apr 26 09:56 ib_logfile0
-rw-rw---- 1 mysql mysql 5.0M Apr 26 09:56 ib_logfile1
-rw-rw---- 1 mysql root 20K Apr 26 09:23 james.err
-rw-rw---- 1 mysql mysql 5 Apr 26 09:23 james.pid
drwx------ 2 mysql root 4.0K Apr 26 05:40 mysql
-rw-rw---- 1 mysql mysql 28K Apr 26 05:40 mysql-bin.000001
-rw-rw---- 1 mysql mysql 974K Apr 26 05:40 mysql-bin.000002
-rw-rw---- 1 mysql mysql 264 Apr 26 05:56 mysql-bin.000003
-rw-rw---- 1 mysql mysql 126 Apr 26 05:59 mysql-bin.000004
-rw-rw---- 1 mysql mysql 931 Apr 26 08:10 mysql-bin.000005
-rw-rw---- 1 mysql mysql 126 Apr 26 08:24 mysql-bin.000006
-rw-rw---- 1 mysql mysql 126 Apr 26 08:32 mysql-bin.000007
-rw-rw---- 1 mysql mysql 126 Apr 26 08:34 mysql-bin.000008
-rw-rw---- 1 mysql mysql 126 Apr 26 09:17 mysql-bin.000009
-rw-rw---- 1 mysql mysql 178M Apr 26 09:56 mysql-bin.000010
-rw-rw---- 1 mysql mysql 190 Apr 26 09:23 mysql-bin.index
drwx------ 2 mysql mysql 4.0K Apr 26 05:40 performance_schema
drwx------ 2 mysql root 4.0K Apr 26 05:40 test