Re: unable to create function in MySQL 5.0

2006-12-01 Thread Jacques Marneweck
146 (42S02): Table '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/ #in

Re: mysql_pconnect() made things worse

2006-12-01 Thread Jacques Marneweck
SHOW VARIABLES LIKE '%connections%'; 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/ #incl

MySQL 5.0.27

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

Re: MySQL 5.1

2006-10-20 Thread Jacques Marneweck
rchives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Jacques Marneweck http://www.powertrip.co.za/ http://www.powertrip.co.za/blog/ #include -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Which to download

2006-10-19 Thread Jacques Marneweck
, Ratheesh Bhat K J -- Jacques Marneweck http://www.powertrip.co.za/ http://www.powertrip.co.za/blog/ #include -- 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?

2006-10-09 Thread Jacques Marneweck
0 sec) >> >> Sorry for misspell of gid. It is uuid of the flow. I think I should >> redesign the table. But how to solve the huge one-multiple >> relationship. >> >> The flow table is the only largest table in the database, the others >> are relative small just like the owner table size. >> >> >> I have a design. Create an additinal field in owner table to store the >> pk(or uuid) of flows owned by this user. Than use a store procedure to >> update this field called by changing to the flow table. But I think it >> is a bad design, right ? And also mysql 4.1.x do 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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

2006-10-03 Thread Jacques Marneweck
Thanks for your help, Stephane Hi 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

Stored Procedure issues

2006-09-19 Thread Jacques Marneweck
N '-1'; END IF; INSERT 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 $$ DELIMIT

Re: MySQL 5.1

2006-08-29 Thread Jacques Marneweck
8 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- -- Jacques Marn

Stability of MySQL 5.1.11

2006-08-06 Thread Jacques Marneweck
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 -- MySQL General Mailing Lis

Re: Runing MySQL on boot

2005-11-18 Thread Jacques Marneweck
lowing line: mysql_enable="YES" Which 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 unsu

Re: Should I buy commercial license?

2005-10-21 Thread Jacques Marneweck
al-license.html 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

2004-05-26 Thread Jacques Marneweck
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 BU

Counting values from two different tables:

2004-02-19 Thread Jacques Marneweck
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 I'm