On 09/12/2009, at 5:10 PM, Jeetendra Ranjan wrote:
Hi,
After analysing slow query log i found that some queries are not
using index and so i used the force index command in query and test
it and now it starts using index properly.Accordingly i implemented
the same query with force index
On 09/12/2009, at 6:56 PM, machiel.richards wrote:
Good day guys (and girls if any)
I am constantly in a position where variables on a
production mysql database needs to be changed.
The database runs a 24/7 system and thus to reboot
is not
preffered and
I have 2 tables:
1) Event Data
2) Mappings
The query should return something like this:
Hits IP Country Code
20213.136.52.29 SE
I am trying this:
SELECT COUNT(event.src_ip) AS count, INET_NTOA(event.src_ip),
mappings.cc FROM event, mappings WHERE
Paul:
SELECT COUNT(event.src_ip) AS count, INET_NTOA(event.src_ip),
mappings.cc FROM event, mappings WHERE event.timestamp BETWEEN
'2009-12-06 20:00' and '2009-12-07 20:00:00' AND event.src_ip BETWEEN
'mappings.start_ip' AND 'mappings.end_ip' GROUP BY event.src_ip ORDER
BY count DESC LIMIT
Ok, I feel silly for asking this, but I am going to do it anyway.
I have a huge stored procedure that does quite a bit of logic, and
gathering/splitting of data. I currently have our customer database on one
server, and our logging on another. What i need to do, is to pull the
customer id from
Is this possible to do? To make a connection, inside the
stored procedure
to a completely different machine and access the mysql there?
The only way I know to access tables from different servers
from a single connection is federated tables:
Posted this before, but beware: federated tables do NOT use indices. Every
select is a full table scan, and if you're talking about a logging table
that could become very expensive very fast.
On Wed, Dec 9, 2009 at 4:13 PM, Neil Aggarwal n...@jammconsulting.comwrote:
Is this possible to do?
If I can login from a shell, what could stop a script from login?
I'm following a newbie tutorial for django, a web content mgt. system.
The following user and password are good if I use them fromthe same shell the
script launches from.
Here's the error message from a django script using a
Hi everybody!
Neil Aggarwal wrote:
Paul:
SELECT COUNT(event.src_ip) AS count, INET_NTOA(event.src_ip),
mappings.cc FROM event, mappings WHERE event.timestamp BETWEEN
'2009-12-06 20:00' and '2009-12-07 20:00:00' AND event.src_ip BETWEEN
'mappings.start_ip' AND 'mappings.end_ip' GROUP BY
Hello Johan,
On Dec 9, 2009, at 11:22 AM, Johan De Meersman wrote:
Posted this before, but beware: federated tables do NOT use indices.
Every
select is a full table scan, and if you're talking about a logging
table
that could become very expensive very fast.
This is not entirely true.
John Griessen wrote:
If I can login from a shell, what could stop a script from login?
privileges were stopping it and at first, maybe a mistake in GRANT setup of a
new user.
Nevermind
JG
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Access Denied means you're using an incorrect username and password
combination. Test your credentials using the mysql cli. You can log in as
root to mysql to make changes as necessary, or supply the correct user/pass
from your script.
Regards,
Gavin Towey
-Original Message-
From:
Joerg:
A matching column is called an equijoin
However, that is not mandatory / the only form.
As long as the problem can be solved using ranges (or multiple ranges)
which do not overlap, the join should solve it.
I just learned something. Thanks for the info!
Neil
--
Neil
So what I am reading, I guess it would be safer to just do it how I am
currently doing it, as it really isn't that slow... it's just duplicating
the data elsewhere (I suppose maybe making this a slave table to the other
server... nah... lots of work there :P)
Thanks, and I did search it before,
Steve:
I suppose maybe making this a slave table
to the other
server... nah... lots of work there
Setting your local server to be a slave of the
remote server is not too hard and would
be a MUCH better solution.
The steps are fairly staightforward:
1. Add a slave user to the remote
I have a stored proc I need to call from yet another stored proc, which
then needs to use the results from the called proc ... I could probably
use temp table but really dont want to do that unless absolutely
required. I cant use OUT parameters, because the called stored proc
returns multiple
I was checking my fresh install of MySQL and noticed I had empt spaces
or missing entries in some sections when I did a search for users on
the 'mysql' database. I checked the MySQL FAQ's and Google and nothing
gave me what I am looking for. I can't understand what this entries
are blank for:
I'm on my mobile so can't give you a link but you should read the reference
manual section on
'post-installation setup and testing'.
Regards
John Daisley.
-Original Message-
From: Carlos Williams carlosw...@gmail.com
Sent: 09 December 2009 21:16
To: mysql@lists.mysql.com
Subject:
Carlos:
I was checking my fresh install of MySQL and noticed I had empt spaces
or missing entries in some sections when I did a search for users on
the 'mysql' database.
According to this page:
http://dev.mysql.com/doc/mysql-security-excerpt/5.4/en/default-privileges.ht
ml
If you want to
Hi Baron,
I'm the primary author of Maatkit.
Awkward... :-)
What can I say -- you could go buy a commercial off-the-shelf tool
and believe the song and dance they feed you about the tool
being perfect.
There's not a single commercial software solution in our toolbox. We're
big fans
20 matches
Mail list logo