Hi All,
Tried the following three statements and they are wither too slow or do not
give me what I want. Basically what I want is to search for records for a
whole month and display totals for that month for each individual day. The
date field is indexed.
Tried..
select count(num) as mycoun
Thanks Tom,
That has worked an absolute treat.
thank you very much
Leon.
-Original Message-
From: Haapanen, Tom [mailto:[EMAIL PROTECTED]]
Sent: 23 October 2001 10:54
To: 'Leon Noble'
Cc: [EMAIL PROTECTED]
Subject: RE: Very untidy
select hour(ts), count(ts) from dundeefw
Hi all,
can someone look at my very untidy code and maybe give me some pointers.
Searching for values by the hour.
etc
for ($i = 0; $i <= 23; $i++)
{
$query = "select count(num) as mycount from dundeefw where date=$date
and action=1 and time=hour($i)";
// Execute query
$result = m
Hi,
Just stopped and started mysql with the -O max_binlog_cache_size=100,
but still this bin.001 file is increasing way over this limit, so it may not
be this:(
I didn't think it was due to replication as we do not have any replication
setup.
Also check the contents of the file.
?bin(iI;E
I found a MySQL system variable
max_binlog_cache_size| 4294967295
would caching have anything to do with it rather than replication?
thanks
Leon.
-Original Message-
From: SAE's System Administrator [mailto:[EMAIL PROTECTED]]
Sent: 18 October 2001 15:22
To: Leon Nob
/manual_MySQL_Optimization
.html#MySQL_indexes
cheers
Leon
-Original Message-
From: Chris Blessing [mailto:[EMAIL PROTECTED]]
Sent: 18 October 2001 15:20
To: Leon Noble
Subject: RE: general sql question
Leon-
Thank you very much for your help. I tried what you stated below and I
think the
Hi All,
A quick query, in the directory /usr/local/mysql/var there are
machinename-bin.001, 002, 003 etc files that are being created. What are
these files and what do they do. Can I get rid of them as they are taking up
massive amounts of space.
Any help greatly appreciated.
thanks
Leon.
--
