Archive for the ‘Random Tech’ Category

Installing HandlerSocket on RHEL 6 + Percona-Server 5.5 in Five(ish) Easy Steps

Сентябрь 29th, 2011
As a followup to my previous post on installing HandlerSocket on CentOS 5 + Percona-Server 5.1, I’ve been asked to provide an updated HOWTO for RHEL 6 + Percona-Server 5.5. Although very similar to the original steps, there are some new traps (RHEL 6 comes with SELinux enabled) and there are some new ec2 gotchas! [...]
PlanetMySQL Voting: Vote UP / Vote DOWN
 

Posted in handlersocket, mysql, MySQL Administration, performance, Random Tech

Комментарии отключены

 

Connecting to HandlerSocket with localhost vs. 127.0.0.1

Февраль 5th, 2011
Using Net::HandlerSocket, here are some fun numbers for a single connection (open & close). When connecting to “localhost”, here’s the strace: open("/etc/hosts", O_RDONLY) = 3 fcntl(3, F_GETFD) = 0 fcntl(3, F_SETFD, FD_CLOEXEC) = 0 fstat(3, {st_mode=S_IFREG|0644, st_size=187, ...}) = 0 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2b909a1a3000 read(3, "# Do not remove the following [...]
PlanetMySQL Voting: Vote UP / Vote DOWN
 

Posted in handlersocket, mysql performance, performance, Random Tech

Комментарии отключены