mysql process 99.9 percent
hi do you have any idea why the mysql process is 99.9 percent? when i click one hyperlink it takes more than 1 minute to load the page. thank you very much. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.6/111 - Release Date: 9/23/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
clean uninstall mysql-standard-4.1.13-pc-linux-gnu-i686.tar.gz
hi how can i clean uninstall mysql-standard-4.1.13-pc-linux-gnu-i686.tar.gz i would like to install mysql-4.1.14.tar.gz i tried make clean, make distclean etc. only error encountered. thank you very much. rgds, Joeffrey -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.3/106 - Release Date: 9/19/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
user can post item while others cannot?
hello i installed mysql-standard-4.1.13-pc-linux-gnu-i686.tar.gz, i followed the instruction on the INSTALL-BINARY file. after that i installed httpd-2.0.54.tar.gz followed the instruction on the INSTALL file. also installed php-5.0.4.tar.gz followed the install intruction in the INSTALL file. CentOS release 4.0 (Final) is the linux distribution. some user when trying to post an item cannot post an item. they are being redirected to the welcome page. once they click the post item button. while other user can post an item succesfully. i been looking at the apache access and error logs and /var/log/messages no luck. what log files should i be looking for. did i miss anything while installing on the ./configure [options] mysql, apache, php etc. on our old server the version of apache-2.0.47, mysql-4.0.15a-log, php-4.3.3 the OS is RH9 before our only problem is too many connections error when they browse our website. is this a apache, MySQL, PHP etc. problem. i just would like to know. any help would be appreciated. thank you very much. rgds, Joeffrey -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.3/106 - Release Date: 9/19/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
uninstall mysql-standard-4.1.13-pc-linux-gnu-i686.tar.gz
hi how can i uninstall mysql-standard-4.1.13-pc-linux-gnu-i686.tar.gz i would like to install mysql-4.1.14.tar.gz thank you very much. rgds, Joeffrey -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.1/104 - Release Date: 9/16/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
perl run-all-test error
hello i just installed mysql-standard-4.1.13-pc-linux-gnu-i686.tar.gz then try typing the command perl run-all-test when this is error message came up. below is the error message. install_driver(mysql) failed: Can't load '/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/auto/DBD/mysql/mys ql.so' for module DBD::mysql: libmysqlclient.so.14: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230. at (eval 51) line 3 Compilation failed in require at (eval 51) line 3. Perhaps a required shared library or dll isn't installed where expected at /usr/src/webserver/mysql-standard-4.1.13-pc-linux-gnu-i686/sql-bench/server- cfg line 247 what library i'm missing. also can you give me the URL address. rgds, Joeffrey -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
too many connections
hello i just installed mysql-standard-4.1.13-pc-linux-gnu-i686.tar.gz, httpd-2.0.54.tar.gz, php-5.0.4.tar.gz etc. on a Intel(R) Pentium(R) 4 CPU 2.40GHz with 1GB RAM this is just a temporary until we buy a new high end server. my-large.cnf is the configuration in the /etc/my.cnf CentOS release 4.0 (Final) is the linux distribution. what is the ideal configuration so that 20,000 user does not encounter the too many connections error when they browse our website. thank you very much. rgds, Joeffrey -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
all user command
hello what command should i type to see all the user connected to the database. thank you very much. rgds, Joeffrey -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]