Feed on

Tag Archive 'mysql'

I was excited to see that rrdtool 1.4 was finally released (in October), and with it rrdcached support finally in a main release.  After updating rrdtool packages on a couple of my systems I sat out to make things start using the new caching daemon. Cacti was my first to play around with since it […]

Read Full Post »

IPv6, really big numbers, MySQL

For lovers of storing IP addresses as integers in MySQL tables, there’s a snag when doing this for IPv6 addresses. A 128-bit number is too big to stuff into a BIGINT type. All Fs integer equivalent is 340,282,366,920,938,463,463,374,607,431,768,211,455. An unsigned BIGINT tops out at 18,446,744,073,709,551,615. These are your options: Store it as a VARCHAR(39) in […]

Read Full Post »