mysql> delete from studentwhere1=1; Query OK,1row affected (0.01sec)#(危险)truncate table student; drop table student 4.使用update代替delete 1)添加状态字段 mysql> alter table student add statusenum('1','0')default1;QueryOK, 0rowsaffected(0.08sec)Records: 0Duplicates: 0Warnings: 0 mys...
#执行InnoDB的碎片回收mysql> alter table user engine=InnoDB;Query OK, 0 rows affected (9.00 sec)Records: 0 Duplicates: 0 Warnings: 0##执行完之后，数据文件大小从14MB降低到10M。# ls -lh /data2/mysql/test/user1.ibd -rw-r--- 1 mysql mysql 10M Nov 6 16:18 /data2/mysql/test/user...
first_level=true) at /home/Code/GitHub/stonedb/sql/sql_parse.cc:3645#6 0x00000000023d175d in mysql_parse(thd=0x7fdcec000bc0,parser_state=0x7fe0c81cae70) at /home/Code/GitHub/stonedb/sql/sql_parse.cc:5655#7 0x00000000023c68b8 in dispatch_command(thd=0x7fdcec000bc0,com_dat...
mysql>insertintotest_del(name)values('xuhao'),('fdsa'),('fddsf'); Query OK,3rows affected Records:3Duplicates:0Warnings:0mysql>insertintotest_truc(name)values('xuhao'),('fdsa'),('fddsf'); Query OK,3rows affected Records:3Duplicates:0Warnings:0mysql>select*fromtest_del;+---+---+...
mysql> delete from emp where e_id=1002; Query OK, 1 row affected (0.02 sec) mysql> select * from emp; +---+---+---+---+---+---+---+ | e_id | e_name | gender | jobtime | salary | phone | dept_id | +---+---+...
mysql> CREATE TABLE t1 (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, c1 INT NOT NULL); Query OK, 0 rows affected (0.11 sec) mysql> INSERT INTO t1 (c1) VALUES (1),(2),(3),(4),(5); Query OK, 5 rows affected (0.03 sec) Records: 5 Duplicates: 0 Warnings: 0 mysql> SELECT *...
Query OK, 2500000 rows affected (5 min 22.32 sec) Records: 2500000 Duplicates: 0 Warnings: 0 最后表的数据量: +---+ | count(*) | +---+ | 10000000| +---+ 1. 2. 3. 4. 5. 从上面结果来看,数据量增加会对插入性能有一定影响。不过,整体速度还是非常面议。一天不到时间,就可以完成4亿数...
-- 准备测试表 CREATE TABLE for_delete ( id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(20) ); Query OK, 0 rows affected (0.16 sec) -- 插入测试数据 INSERT INTO for_delete (name) VALUES ('A'), ('B'), ('C'); Query OK, 3 rows affected (1.05 sec) Records: 3 Duplicates: 0 ...
-rw-rw--- 1 mysql mysql 98304 Nov 22 09:55 test_tru.ibd那么delete的表怎么释放哪些空间呢,可以考虑重置存储引擎。 > alter table test_del engine=innodb; Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0整个过程非常快,而操作之后查看文件,大小已经收缩了。 -...
mysql> 2.插入测试数据 mysql> insert into t1 (name,sex,address)values('daiiy','m','guangzhou'); Query OK, 1 row affected (0.01 sec) mysql> insert into t1 (name,sex,address)values('tom','f','shanghai'); Query OK, 1 row affected (0.00 sec) ...