Re: slow mysql response

[uzwa ulhaque]

show index from Outlet_Information;
+--------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+--------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Outlet_Information | 0 | PRIMARY | 1 | Outlet_id | A | 6 | NULL | NULL | | BTREE | |
+--------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
1 row in set (0.00 sec)

***************************************************************

mysql> show index from Detail_Table;
+--------------+------------+-------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+--------------+------------+-------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+
| Detail_Table | 1 | FK_Detail_Table_1 | 1 | Customer_id | A | 20028 | NULL | NULL | | BTREE | |
| Detail_Table | 1 | index_uzwa_all | 1 | category_id | A | 80 | NULL | NULL | | BTREE | |
| Detail_Table | 1 | index_uzwa_all | 2 | Category_detail_id | A | 198 | NULL | NULL | | BTREE | |
| Detail_Table | 1 | index_uzwa_all | 3 | Qty | A | 1112 | NULL | NULL | | BTREE | |
| Detail_Table | 1 | index_uzwa_all | 4 | Customer_id | A | 40057 | NULL | NULL | | BTREE | |
| Detail_Table | 1 | index_uzwa_all | 5 | user_id | A | 40057 | NULL | NULL | | BTREE | |
| Detail_Table | 1 | index_uzwa_all | 6 | id | A | 40057 | NULL | NULL | | BTREE | |
+--------------+------------+-------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+
7 rows in set (0.00 sec)

****************************************************************
mysql> show index from Outlet_Information;
+--------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+--------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Outlet_Information | 0 | PRIMARY | 1 | Outlet_id | A | 6 | NULL | NULL | | BTREE | |
+--------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
1 row in set (0.00 sec)

****************************************************************

mysql> show index from Detail_Table;
+--------------+------------+-------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+--------------+------------+-------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+
| Detail_Table | 1 | FK_Detail_Table_1 | 1 | Customer_id | A | 20028 | NULL | NULL | | BTREE | |
| Detail_Table | 1 | index_uzwa_all | 1 | category_id | A | 80 | NULL | NULL | | BTREE | |
| Detail_Table | 1 | index_uzwa_all | 2 | Category_detail_id | A | 198 | NULL | NULL | | BTREE | |
| Detail_Table | 1 | index_uzwa_all | 3 | Qty | A | 1112 | NULL | NULL | | BTREE | |
| Detail_Table | 1 | index_uzwa_all | 4 | Customer_id | A | 40057 | NULL | NULL | | BTREE | |
| Detail_Table | 1 | index_uzwa_all | 5 | user_id | A | 40057 | NULL | NULL | | BTREE | |
| Detail_Table | 1 | index_uzwa_all | 6 | id | A | 40057 | NULL | NULL | | BTREE | |
+--------------+------------+-------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+
7 rows in set (0.00 sec)


***************************************************************

mysql> show index from Category;
+----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Category | 0 | PRIMARY | 1 | category_id | A | 10 | NULL | NULL | | BTREE | |
+----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
1 row in set (0.01 sec)

***************************************************************
mysql> show index from Category_Detail;
+-----------------+------------+----------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+-----------------+------------+----------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+
| Category_Detail | 0 | PRIMARY | 1 | Category_detail_id | A | 99 | NULL | NULL | | BTREE | |
+-----------------+------------+----------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+
1 row in set (0.01 sec)

**************************************************************

mysql> show index from Order_Status;
+--------------+------------+-------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+--------------+------------+-------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Order_Status | 1 | FK_Order_Status_2 | 1 | Outlet_id | A | 13 | NULL | NULL | | BTREE | |
| Order_Status | 1 | FK_Order_Status_3 | 1 | User_id | A | 23 | NULL | NULL | | BTREE | |
+--------------+------------+-------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
2 rows in set (0.03 sec)

**************************************************************
mysql> show index from Detail_Table;
+--------------+------------+-------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+--------------+------------+-------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+
| Detail_Table | 1 | FK_Detail_Table_1 | 1 | Customer_id | A | 19640 | NULL | NULL | | BTREE | |
| Detail_Table | 1 | index_uzwa_all | 1 | category_id | A | 79 | NULL | NULL | | BTREE | |
| Detail_Table | 1 | index_uzwa_all | 2 | Category_detail_id | A | 194 | NULL | NULL | | BTREE | |
| Detail_Table | 1 | index_uzwa_all | 3 | Qty | A | 1091 | NULL | NULL | | BTREE | |
| Detail_Table | 1 | index_uzwa_all | 4 | Customer_id | A | 39281 | NULL | NULL | | BTREE | |
| Detail_Table | 1 | index_uzwa_all | 5 | user_id | A | 39281 | NULL | NULL | | BTREE | |
| Detail_Table | 1 | index_uzwa_all | 6 | id | A | 39281 | NULL | NULL | | BTREE | |
+--------------+------------+-------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+
7 rows in set (0.02 sec)