BTW, the query on the database with the added index doesn't take
forever, it takes a mere 51 minutes (vs. instantaneous).
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
BTW, the query on the database with the added index doesn't take
forever, it takes a mere 51 minutes (vs. instantaneous).
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
>
>
>Can you post the EXPLAIN EXTENDED output for your before and after queries?
>also, have you recently run an ANALYZE TABLE on the tables?
// before
mysql> explain extended select
p1.player_name,g.score1,g.time1,g.color1,p2.player_name,g.score2,g.time2,g.color2,g.gamename,gmtdate
-> f
The only solution you have:
let your server-side procedure populate a temporary table and select from
that when the procedure is complete. Depending on the thresholds you set in
your mysql configuration, that memory table might very well reside in RAM
anyhow. I doubt that speed will be an issue.
In the last episode (Aug 26), Dave Dyer said:
> This is a cautionary tale - adding indexes is not always helpful or
> harmless. I recently added an index to the "players" table to optimize a
> common query, and as a consequence this other query flipped from innocuous
> to something that takes infi
This is a cautionary tale - adding indexes is not always helpful or harmless.
I recently added an index to the "players" table to optimize a common query,
and as a consequence this other query flipped from innocuous to something that
takes infinite time.
select
p1.player_name,g.score1,g.tim
Why would using UNION cause the subqueries to be de-optimized?
explain
(SELECT count(gamename) as gname ,variation from zertz_gamerecord
where (gmtdate > date_sub(current_timestamp(),interval 90 day)) and
(player1='13213' or player2='13213' ) group by variation limit 3)
shows using index on
Thank you in advance ...
(I have paid support with Confluence and I have also posted my question with
them.)
Our installation will run for hours or days without issues, and then CPU usage
quickly spikes to nearly 100%, with mysqld taking 90% or more of the CPU.
Bouncing Confluence and Mysql f
 Thanks guys for the help. but my problem seems to stand unsolved.
From: Johan De Meersman
To: Halász Sándor
Cc: mysql@lists.mysql.com
Sent: Friday, August 26, 2011 7:04 PM
Subject: Re: Arrays
- Original Message -
> From: "Halász Sándor"
>
> Hi
On Fri, August 26, 2011 00:44, Johan De Meersman wrote:
> - Original Message -
>> From: "Adarsh Sharma"
>>
>> Today by chance I am checking the space in mysql data directories.
>
> By chance? That should be automated, as should a million other standard
> checks. Install Nagios.
>
>> When
- Original Message -
> From: "Halász Sándor"
>
> Hi, I would like to create a function in Mysql that returns an Array
> of Numbers. I am trying to run a big amount of stream of data on
> Mysql and I can't afford the time to store the data into a table and
> retrieve it later.
>
2011/08/24 02:05 -0700, javad bakhshi
Hi, I would like to create a function in Mysql that returns an Array of
Numbers. I am trying to run a big amount of stream of data on Mysql and I can't
afford the time to store the data into a table and retrieve it later.
Are there any arra
2011/08/18 18:30 +0300, Marius Feraru
Thanks for your time reading my message, but I don't understand what
is the "result context" that you are talking about. Could you please
elaborate?
Well, if an expression is an argument to, say, "CONCAT", the expression s
result is characte
- Original Message -
> From: "Adarsh Sharma"
>
> Today by chance I am checking the space in mysql data directories.
By chance? That should be automated, as should a million other standard checks.
Install Nagios.
> When it becomes full, I am sure my server down. Can anyone Please let
>
14 matches
Mail list logo
