Re: why can not pass constant to stored procedure?

2012-03-10 Thread Antony T Curtis
the argument directly as long as it is not an INOUT parameter. Antony T Curtis atcur...@gmail.com 0523 C487 9187 6972 6894 AEC7 3087 F819 B477 B687

Re: ::1 root entry in mysql.user

2011-12-18 Thread Antony T Curtis
::1 is the IPv6 address for localhost. On 18 Dec 2011, at 09:17, lourenstcc wrote: Hi, I installed mysql for mac os x. Now I am inspecting mysql.user and I see entries for root which I am not to confident with. On a debian installation there is no host=::1 entry Can you explain this entry?

Re: large temp files created by mysql

2011-10-24 Thread Antony T Curtis
Something you're doing is creating a very large temporary table as part of handling it's query. Usual culprit would be something doing a full table join combined with an order by or group by which would typically cause MySQL to need to create a temp table. You should do EXPLAINs on your

Re: Slower performance with LOCK TABLES

2011-09-22 Thread Antony T Curtis
down when I use LOCK TABLES versus running the same queries without it. I'm just trying to find a reason why that might be the case. -Hank On Thu, Sep 22, 2011 at 12:42 AM, Antony T Curtis antonycur...@verizon.net wrote: LOCK TABLES...WRITE is very likely to reduce performance if you

Re: Slower performance with LOCK TABLES

2011-09-21 Thread Antony T Curtis
LOCK TABLES...WRITE is very likely to reduce performance if you are using a transactional storage engine, such as InnoDB/XtraDB or PBXT. The reason is that only one connection is holding the write lock and no other concurrent operation may occur on the table. LOCK TABLES is only really

Re: Binary builds for AIX

2011-09-10 Thread Antony T Curtis
Alas, I mothballed my old RS/6000 AIX machine a few years ago. It was getting quite old and only ran AIX 4.3 I had toyed with the idea of getting a more modern machine from ebay but to be honest, I haven't had much time recently. On 9 Sep 2011, at 08:22, Peter Gershkovich wrote: I

Re: non-relational engine for mySQL?

2009-02-07 Thread Antony T Curtis
I believe such things already exist, for example the Nitro storage engine. There is a presentation about it at the coming MySQL conference... http://en.oreilly.com/mysql2009/public/schedule/detail/6984 Regards, Antony On 6 Feb 2009, at 14:50, Daevid Vincent wrote: When our database

Re: trigger that calls a webservice??

2008-06-20 Thread Antony T Curtis
On 20 Jun 2008, at 06:43, James wrote: On Fri, June 20, 2008 9:12 am, robert rottermann wrote: Hi there, is it possible to define an update trigger that calls a webservice (or just some external method that would do it). we have a web frontent, that does the indexing of data in its own

Re: JAVA UDF HOW

2008-06-05 Thread Antony T Curtis
hope we include this support in coming future. Also, there is not enough documentation for the project mentioned: http://forge.mysql.com/wiki/ProjectPage_External_Language_Stored_Procedures Thanks again !! Abhay Grewal On Thu, Jun 5, 2008 at 11:04 AM, Antony T Curtis [EMAIL PROTECTED] wrote

Re: JAVA UDF HOW

2008-06-04 Thread Antony T Curtis
Hi, Check out this link for Java stored procedures with MySQL http://forge.mysql.com/wiki/ProjectPage_External_Language_Stored_Procedures It is probably what you are looking for. I have some more info on my blog at http://antbits.blogspot.com/ For more information, you can email Eric

Re: FreeBSD MySQL Performance Tunning suggestions???

2008-06-04 Thread Antony T Curtis
Hi, FreeBSD 7 should offer much better performance for MySQL. The FreeBSD kernel developers have found ways to relieve some of the kernel bottlenecks which permit multithreaded applications to operate much better. Regards, Antony. On 3 Jun 2008, at 03:43, VeeJay wrote: Hi Guys I need

Re: Debug Stored Proc

2008-05-06 Thread Antony T Curtis
Hi, Currently there is no way but there is a WorkLog for implementing such a feature, It may be possible to encourage someone to implement such a feature request. Regards, Antony. On 6 May 2008, at 14:58, Bryan Cantwell wrote: Is there no way to step thru a stored proc in order to

Re: MySQL 6.0.4 Alpha has been released ! (part 1 of 2)

2008-03-10 Thread Antony T Curtis
Missing feature not mentioned... Falcon works on PowerPC and UltraSparc. Regards, Antony On 10 Mar, 2008, at 11:53, Joerg Bruehe wrote: Dear MySQL users, MySQL 6.0.4-alpha, a new version of the MySQL database system including the Falcon transactional storage engine (now at beta stage),