Tag Archives: procedures

DBAs of all countries, unite!

Posted on 2009/07/29 by

I’m observing the process of most awesome SHOW commands being abolished, destroyed and some weird information_schema tables are introduced instead. Say, even though you can select configuration variables using @@syntax, you can’t do same for much more interesting to DBAs … Continue reading →

Posted in mysql | Tagged , | 5 Comments

ip address searches in mysql

Posted on 2005/12/11 by

MySQL does not provide special datatype or operators for IP addresses, but has two functions, that convert IP addresses to and from integers. In order to lookup addresses in a subnet, an efficient index range scan queries could be used. Continue reading →

Posted in mysql | Tagged , , | 1 Comment