MySQL Performance Blog
Par example, on vais creater une table pour noter le traffic de l'Internet, il y a une table avec le traffic et le numero de package de le port et l'IP de address.
la table comme:
Create Table: CREATE TABLE `ipstat` (
`ip` int(10) unsigned NOT NULL,
`hits` int(10) unsigned NOT NULL,
`last_hit` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
INSERT
INTO ipstat
VALUES
(inet_aton
(
'192.168.0.1'
),
1,now
(
)
)
ON duplicate
KEY
UPDATE hits=hits+
1;
+------------+------+---------------------+
| ip | hits | last_hit |
+------------+------+---------------------+
| 3232235521 | 1 | 2009-02-27 10:56:49 |
+------------+------+---------------------+
inet_aton
pour convertir l'IP de 15 bytes a 4 bytes. Tu peux changer le format de la table ipstat
mysql> alter table ipstat modify ip int(15);
mysql> select * from ipstat;
+-------------+------+---------------------+
| ip | hits | last_hit |
+-------------+------+---------------------+
| 2147483647 | 2 | 2009-02-27 10:57:15 |
| 192168 | 2 | 2009-02-27 11:31:13 |
| 192.168.0.1 | 2 | 2009-02-27 11:32:03 |
+-------------+------+---------------------+
转载于:https://www.cnblogs.com/buro79xxd/archive/2009/10/16/1682558.html
