I have been experiencing problems with memory shortages... and I'm having trouble determining the cause because I moved to a new dedicated server, upgraded to Links SQL 2 and started using speedy cgi. I also don't know much (if anything) about this.
Can speedy_cgi cause memory problems? ..or is it most likely because I just need more memory to run my database? I already have 512 MB. Maybe someone can help by seeing a sample of my top processes listed by memory usage:
13208 kB /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user ...
(THERE ARE 10 INSTANCES OF THIS--all 13208 kB each)
8076 kB /usr/bin/speedy_backend search.cgi
8036 kB /usr/bin/speedy_backend search.cgi
7296 kB /usr/bin/speedy_backend rate.cgi
6884 kB /usr/bin/speedy_backend nph-build.cgi
6408 kB /usr/bin/speedy_backend nph-index.cgi
6356 kB /usr/bin/speedy_backend jump.cgi
6096 kB /usr/bin/speedy_backend db.cgi
6064 kB /usr/bin/speedy_backend setup.cgi
5864 kB /usr/bin/speedy_backend admin.cgi
I notice that nph-index and nph-build are listed, but I am not indexing or building right now....
Does anyone have any ideas or advice? Your help is appreciated :) Thanks.
Can speedy_cgi cause memory problems? ..or is it most likely because I just need more memory to run my database? I already have 512 MB. Maybe someone can help by seeing a sample of my top processes listed by memory usage:
13208 kB /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user ...
(THERE ARE 10 INSTANCES OF THIS--all 13208 kB each)
8076 kB /usr/bin/speedy_backend search.cgi
8036 kB /usr/bin/speedy_backend search.cgi
7296 kB /usr/bin/speedy_backend rate.cgi
6884 kB /usr/bin/speedy_backend nph-build.cgi
6408 kB /usr/bin/speedy_backend nph-index.cgi
6356 kB /usr/bin/speedy_backend jump.cgi
6096 kB /usr/bin/speedy_backend db.cgi
6064 kB /usr/bin/speedy_backend setup.cgi
5864 kB /usr/bin/speedy_backend admin.cgi
I notice that nph-index and nph-build are listed, but I am not indexing or building right now....
Does anyone have any ideas or advice? Your help is appreciated :) Thanks.