On 20.12.2008 00:51 CE(S)T, Steve Holmes wrote:
2008/12/19 Menachem Bazian gro...@bcconsultingservices.com
Does anyone have an inno setup script so I can automatically install MySQL
with an application?
http://lists.mysql.com/mysql?unsub=sholme...@gmail.com
I don't know about anyone else,
Hi All,
I'm using mysql-cluster-gpl-6.2.15 for create DB cluster in our server
machines,
currently I'm using 2 data nodes, 2 management nodes and two mysqld server
nodes which were combine with same data directory in SAN.
SAN for the collect binary logs only.
What need to know are,
1. Is it
Hi
I am trying to get to grips with understanding mysql performance.
I have the following query:
select sql_no_cache count(*), date_format(calldate, '%y-%m-%d') as m
from cdr_warehouse group by m;
This gives me:
115 rows in set (59.52 sec)
mysql explain select count(*),
I few random things come to mind...
1) Try the query with IGNORE INDEX calldate_idx ... I can't see how
this could possibly be faster, but I always like to check anyway. In
your case this should result in a full table scan, given the
information you've given us.
2) If the performance problem
In the last episode (Dec 27), Chris Picton said:
I am trying to get to grips with understanding mysql performance.
I have the following query:
select sql_no_cache count(*), date_format(calldate, '%y-%m-%d') as m from
cdr_warehouse group by m;
This gives me:
115 rows in set (59.52 sec)
Hi,
On Sat, Dec 27, 2008 at 6:15 PM, Chris Picton ch...@ecntelecoms.com wrote:
Hi
I am trying to get to grips with understanding mysql performance.
I have the following query:
select sql_no_cache count(*), date_format(calldate, '%y-%m-%d') as m from
cdr_warehouse group by m;
This gives
Mmm I just tested this and it does indeed work (although i tested with
slightly less rows :o) )
explain select count(*) , date_format(calldate, '%y-%m-%d') as m from
cdr_warehouse group by m \G
*** 1. row ***
id: 1
select_type: SIMPLE