MySQL Forums
Forum List  »  Performance

Re: Slow query
Posted by: Manu Swami
Date: April 25, 2015 02:31AM

As of now imsi_ne has very less data.

On old server:
==============
mysql> SHOW CREATE TABLE dn_imsi;
+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| dn_imsi | CREATE TABLE `dn_imsi` (
`dnId` char(9) character set latin1 collate latin1_bin NOT NULL,
`imsiId` char(9) character set latin1 collate latin1_bin NOT NULL,
PRIMARY KEY (`dnId`),
KEY `imsiId` (`imsiId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT |
+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql>


On new server:
==============
mysql> SHOW CREATE TABLE dn_imsi;
+---------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+---------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| dn_imsi | CREATE TABLE `dn_imsi` (
`dnId` char(9) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
`imsiId` char(9) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
PRIMARY KEY (`dnId`),
KEY `imsiId` (`imsiId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT |
+---------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql>


'\0\0\0\0hI' is hex code and in our C code also it is char(9) type.

Options: ReplyQuote


Subject
Views
Written By
Posted
1997
April 21, 2015 11:15AM
846
April 22, 2015 07:17AM
781
April 22, 2015 07:05PM
988
April 23, 2015 11:42PM
783
April 23, 2015 11:55PM
764
April 24, 2015 05:22PM
Re: Slow query
763
April 25, 2015 02:31AM
848
April 25, 2015 02:41AM
1472
April 25, 2015 05:22AM
817
April 25, 2015 10:42PM
794
May 13, 2015 03:30AM
872
April 28, 2015 03:40AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.