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 fan
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
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
Sent: 09 December 2009 21:16
To: mysql@lists.mysql.com
Subject: Missing Entries
I was che
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:
mysq
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 r
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 datab
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, bu
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 Agg
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: Jo
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:ht
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. If
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' GR
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 pyt
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 wrote:
> > Is this possible to do? To make a connection, i
> 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:
http://dev.mysql.com/doc/refman/5.0/en/federated
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
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 LIM
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 event.tim
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 s
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 i
20 matches
Mail list logo
