= 2010-08-21
/etc/my.cnf:
open-files-limit = 1600 ## increased from 800 2010-08-21
in /etc/my.cnf, comment out
socket = /var/lib/mysql/mysql.sock ## this in PLACE of the ln -s command
skip-innodb
to install vim, FIRST install curses:
ftp://ftp.gnu.org/gnu/ncurses/
$ ./configure —with-shared —with-normal —without-debug \
—enable-overwrite —prefix=/home/myusername
$ make
$ make install
then vim:
cat vim-6.3.tar.bz2.2 | bunzip2 | tar -xvf – ./configure —prefix=/home/phonemeanalysis/bin/vim/vim63
make
make install
===========================5/17/2006==
bind -v ; ## show all editing commands (and a few others)
[phonemeanalysis][~]$ cat .bashrc
echo ‘setting your login parameters!’;
set -o vi;
export HISTSIZE=20000;
export EDITOR=vi;
export VISUAL=vi;
mysql issue: optimize table tableName ; explain select * from tableName ; benchmark ( 10000, 10+10) ; ## run this command 10000 times
note that shieldhost cp2 has vim6.3.82 webhost has vim6.0.152============================= 5/16/2006
Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)
solution:
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
in /etc/my.cnf
comment out the skip-innodb line
to restart the vps server:
site-management—>site—parameters, hit the restart VPS button
