$ history |wc -l
82230
This is just from my work machine (~4 years old), my history is not centralized but after seeing all this I think I'm going to work it into my centralized dotfiles system.
Also, I can confirm that gigantic bash histories don't affect the speed of anything.
Super useful/essential tweaks -
export HISTCONTROL=erasedups
export HISTSIZE="NOTHING"
export HISTFILESIZE="NOTHING"`
shopt -s histappend
export PROMPT_COMMAND='history -a;echo'
erasedups will erase any earlier instance of an indentical command, keeping your history file lean. Setting HISTSIZE and HISTFILESIZE to something nonnumeric makes for no limits. histappend appends to the HISTFILE when the shell session exits. And my prompt command appends each executed command to HISTFILE immediately after it's executed. With histappend, this may be redundant. (The prompt command also gives me a blank line after each command finishes.)
That mysql setup is pretty cool too, it's a rich man's
$ history | awk '{print $2}' | sort | uniq -c | sort -rn | head -10
14365 vi
11006 sudo
6976 ls
6898 svn
5322 cd
3869 cdb
2809 svnvimdiff
1846 ggrep
1474 git
1285 ssh