Knowing the total size of all your indexes is helpful when setting your key_cache size. This one-liner gives you that number in bytes.
find /var/lib/mysql/ -name "*.MYI" -printf "%s\n" | awk '{ s += $1}; END { print s }'
2.05.2010
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment