mysql process 99.9 percent

2005-09-26 Thread Joeffrey Betita
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

2005-09-20 Thread Joeffrey Betita
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?

2005-09-20 Thread Joeffrey Betita
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

2005-09-18 Thread Joeffrey Betita
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

2005-08-17 Thread Joeffrey Betita
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

2005-08-11 Thread Joeffrey Betita
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

2005-07-26 Thread Joeffrey Betita
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]