- Original Message -
> From: "Alexandr Normuradov"
>
> so far I could not find any answer on how to abort queries that
> exceed certain size of internal temporary tables.
I'm not sure there is.
> On certain quite often scenarios these internal tables are being
> converted to Myisam on d
- Original Message -
> From: "Adarsh Sharma"
>
> This Link gives the capitals of all countries but I need the states
> and their capitals in all these countries too..
> But I think this is not possible because very few countries are
> divided into states and some into cantons, county etc
Hello List,
so far I could not find any answer on how to abort queries that exceed
certain size of internal temporary tables.
On certain quite often scenarios these internal tables are being
converted to Myisam on disk tables. And that creates a high IO
depending on situation.
Putting tmpdir in
This Link gives the capitals of all countries but I need the states and
their capitals in all these countries too..
But I think this is not possible because very few countries are divided
into states and some into cantons, county etc.
Thanks
planas wrote:
On Tue, 2011-09-27 at 12:18 +0530, A
2011/09/27 05:32 -0700, supr_star
Here's a simple query: select name,status,min(dt), max(dt),count(*) from
mytable group by name I need an efficient way to get this data, along with the
status of the row with the max(dt). 'status' is not in the group by, so I get
apparently random sta
Just to clarify, here is some more info:
Here is what the query looks like:
SELECT DISTINCT `entries`.id FROM `entries` LEFT OUTER JOIN `entries_tags`
ON `entries_tags`.entry_id = `entries`.id LEFT OUTER JOIN `tags` ON
`tags`.id = `entries_tags`.tag_id WHERE (`entries_tags`.tag_id IN (5,6));
So
Hi,
I have a query where I'm using a left outer join to connect two tables,
entries and entries_tags, where entries_tags is a join table between entries
and another table, tags. In my query I am selecting values from the entries
table where the entries have any of the provided tags - WHERE
entrie
Here's a simple query:
select name,status,min(dt), max(dt),count(*)
from mytable
group by name
I need an efficient way to get this data, along with the status of the row with
the max(dt). Â 'status' is not in the group by, so I get apparently random
statuses. Â Is there any way to do this witho
> I got a request from a client for the rights to kill his queries if
> something goes wrong. Long story short, he doesn't want to have to phone.
>
> I see via the MySQL documentation, that the client would need PROCESS and
> SUPER privileges. Im not happy with that.
>
> Would know of an alternat
Hiya
I got a request from a client for the rights to kill his queries if something
goes wrong. Long story short, he doesn't want to have to phone.
I see via the MySQL documentation, that the client would need PROCESS and SUPER
privileges. Im not happy with that.
Would know of an alternative s
10 matches
Mail list logo
