Re: mysql_pconnect() made things worse

%'; And checking status: SHOW STATUS LIKE '%connections%'; Will tell you how many connections you've used simultaneously. Regards --jm -- Jacques Marneweck http://www.powertrip.co.za/ http://www.powertrip.co.za/blog/ #include std/disclaimer.h -- MySQL General Mailing List For list archives: http

Re: unable to create function in MySQL 5.0

'mysql.proc' doesn't exist It's a known MySQL bug - http://bugs.mysql.com/bug.php?id=24750 Use the schema mentioned there to recreate the mysql proc table. Regards --jm -- Jacques Marneweck http://www.powertrip.co.za/ http://www.powertrip.co.za/blog/ #include std/disclaimer.h -- MySQL General

MySQL 5.0.27

functionality which was broken by the MySQL ABI? Regards --jm -- Jacques Marneweck http://www.powertrip.co.za/ http://www.powertrip.co.za/blog/ #include std/disclaimer.h -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: MySQL 5.1

: http://lists.mysql.com/[EMAIL PROTECTED] -- Jacques Marneweck http://www.powertrip.co.za/ http://www.powertrip.co.za/blog/ #include std/disclaimer.h -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Which to download

, Ratheesh Bhat K J -- Jacques Marneweck http://www.powertrip.co.za/ http://www.powertrip.co.za/blog/ #include std/disclaimer.h -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to speed up query of indexed column with 5M rows?

not support store procedure. I do not want to migrate the whole database, and I am sure there are some incompatible. Thanks... -- Jacques Marneweck http://www.powertrip.co.za/ http://www.powertrip.co.za/blog/ #include std/disclaimer.h -- MySQL General Mailing List For list archives: http

Re: Can I set many IP address with bind-address ? If not, how can do same thing ?

Stephane, You can only specify one IP address to bind to. Regards --jm -- Jacques Marneweck http://www.powertrip.co.za/ http://www.powertrip.co.za/blog/ #include std/disclaimer.h -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Stored Procedure issues

INTO packages (package_id, client_id, package_name) VALUES (SUBSTRING(application from 8 for 2), 0, ''); SELECT package_id INTO number_id FROM packages WHERE package_id=SUBSTRING(application from 8 for 2); RETURN number_id; END $$ DELIMITER ; Regards --jm -- Jacques Marneweck http

Re: MySQL 5.1

*_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- -- Jacques Marneweck

Stability of MySQL 5.1.11

Hi, I'm wondering what the status of MySQL 5.1.11 is regarding the roadmap for 5.1 changing from beta to generally available? Regards --jm -- Jacques Marneweck http://www.powertrip.co.za/ http://www.powertrip.co.za/blog/ #include std/disclaimer.h -- MySQL General Mailing List For list

Re: Runing MySQL on boot

basically tells the script that MySQL should be started when the server boots up. Regards --jm -- Jacques Marneweck http://www.powertrip.co.za/blog/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Should I buy commercial license?

Thanks, hirohama -- Jacques Marneweck http://www.powertrip.co.za/blog/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MySQL Server - automatic shutdown

Hi Sheni, I would start by running MySQL 3.23.58 which is the latest released version of the MySQL 3.23 branch. Also running MySQL on FreeBSD with linuxthreads enabled. If you cvsup your ports collection doing something like: cd /usr/ports/databases/mysql323-server make WITH_LINUXTHREADS=yes

Counting values from two different tables:

Hi all, I'm basically trying to get a count of banner ad impresssions and banner ad click-thrus from phpAdsNew into a simple report on another site to figure out how to accurately get the stats to pass onto php and smarty to output onto a webpage for a user to see their stats on an application