Hi,
I have 2 mysql instances running on a server on different ports with
different datadirs and different .sock files.
I can connect locally via the sock with the -S flag to mysql but I
cannot connect locally via port (-P flag).
Does anyone know if there is a way to configure a mysql slave to
Ah. I have found that if you use 'localhost' to connect, you cannot
specify a port, it silently fails...
You can connect using a hostname (even though it's the same server),
specifying a port...
Andrew
-Original Message-
From: Andrew Braithwaite [mailto:andrew.braithwa...@lovefilm.com]
Hi guys I've been having some slow performance on queries that should
otherwise be pretty fast. I've checked my indexes etc. and cant see
what could cause it here is an example.
This one is taking long in the sending data step. although its running
on localhost so its not like its a network
It is slow probably because you are using
where user_id='1421767810'
and user_id is an integer. I think this is one of those d'uh moments. :-)
Mike
At 01:18 PM 8/11/2009, Tachu® wrote:
Hi guys I've been having some slow performance on queries that should
otherwise be pretty fast. I've
Hi Banyan,
I'm really just talking about basic optimization techniques:
1. Install lots of RAM
2. Convert all table to innodb
3. Allocate about 80% of memory to innodb_buffer_pool_size
If you haven't seen this script yet, I suggest you start here:
https://launchpad.net/mysql-tuning-primer
Andrew,
Yes it's true, because when you specify localhost, you're using the local
socket file. The port only has meaning for TCP connections.
Regards,
Gavin Towey
-Original Message-
From: Andrew Braithwaite [mailto:andrew.braithwa...@lovefilm.com]
Sent: Tuesday, August 11, 2009 8:38
In the last episode (Aug 11), Tachu(R) said:
Hi guys I've been having some slow performance on queries that should
otherwise be pretty fast. I've checked my indexes etc. and cant see what
could cause it here is an example. This one is taking long in the sending
data step. although its
I have about 120,000 organization names in table1 which I am trying to match
against 75,000 organization names in table2 and see if they are a perfect
match, a partial match or don't match at all.
I was looking at Natural Language Full Text Searches,
Have you tried removing the quotes from around the value in:
user_id='1421767810'
The column is defined as bigint. You're comparing it to a string. I just saw
a case where comparing a float value to a string column in a query caused it to
take a long time.
-Original Message-
From: