MySQL索引性能測驗

2024-07-24 12:32:43

字體：大中小

來源：轉載

供稿：網友

很長一段時間沒學習MySQL了，一直致力于oracle的研究，最近得空了就再拾起MySQL看看吧，記得去年發布過的2篇MySQL文章：

今天我們就來看看mysql中索引的性能測試：
1 準備環境
1.1 在數據庫中創建測試表test1
[root@rhel6_lhr ~]# mysql -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or /g.

Your MySQL connection id is 14

Server version: 5.6.21-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial)

mysql> show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| db1                |

| db4                |

| lhr_test           |

| mysql              |

| opensource         |

| opesource          |

| performance_schema |

| test               |

| wyzc               |

+--------------------+

10 rows in set (0.00 sec)

mysql> use lhr_test;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

mysql> desc test1;

+-------+-------------+------+-----+---------+-------+

| Field | Type        | Null | Key | Default | Extra |

+-------+-------------+------+-----+---------+-------+

| id    | int(11)     | YES |     | NULL    |       |

| num   | int(11)     | YES |     | NULL    |       |

| pass | varchar(50) | YES |     | NULL    |       |

+-------+-------------+------+-----+---------+-------+

3 rows in set (0.00 sec)

mysql> create table test3(

    -> id int,

    -> num int,

    -> pass varchar(50)

    -> );

reset query cache;Query OK, 0 rows affected (0.09 sec)

（編輯：武林網）

上一篇：mytop安置，使用mytop監控MySQL性能

下一篇：MySQL數據類別DECIMAL用法