- Original Message -
From: Adarsh Sharma adarsh.sha...@orkash.com
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
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 character string. An
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 arrays at all in
- Original Message -
From: Halász Sándor h...@tbbs.net
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
On Fri, August 26, 2011 00:44, Johan De Meersman wrote:
- Original Message -
From: Adarsh Sharma adarsh.sha...@orkash.com
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
Thanks guys for the help. but my problem seems to stand unsolved.
From: Johan De Meersman vegiv...@tuxera.be
To: Halász Sándor h...@tbbs.net
Cc: mysql@lists.mysql.com
Sent: Friday, August 26, 2011 7:04 PM
Subject: Re: Arrays
- Original Message -
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
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
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
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 infinite
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
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
- from
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
14 matches
Mail list logo