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
::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?
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
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
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
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
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
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
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
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
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
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
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),
13 matches
Mail list logo