On Sun, April 29, 2007 05:28, Jeff Pang wrote:
> Hello list,
>
> I want to get the counter for db-items by each day,so I wrote this sql:
>
> select count(*) as dd from items group by updatetime;
>
> But sorry "updatetime" is "datetime" type,not "date" type.Then I can't get
> the correct result.
>
Hello list,
I want to get the counter for db-items by each day,so I wrote this sql:
select count(*) as dd from items group by updatetime;
But sorry "updatetime" is "datetime" type,not "date" type.Then I can't get the
correct result.
How can I do this?Thanks.
50 AMAZON-Einkaufsgutschein bei
Is there a way to monitor SQL query response times?
Mysqlperformanceblog has patches for higher granularity query log:
http://www.mysqlperformanceblog.com/2006/09/06/slow-query-log-analyzes-tools/
You could always just wrap the query calls in between some time registration
of your own.
--
Is there a way to monitor SQL query response times?
Here's my current my.cnf relating to logs, but I only see response
times in the slow query log, and even then, the response time is
rounded to the nearest second.
log=/logs/mysql.log
log-error=/logs/mysql-error.log
log-slow-queries=/logs/mysql-
Thank you. It's working now.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Ok, on my linux (slackware 10) /var/www is owner by root.root with
permissions rwxr-xr-x (755). Say you want mysql to put your data
in a subdirectory under /var/www named data.
As root, do:
mkdir /var/www/data
chgrp mysql /var/www/data
chmod 775 /var/www/data
Now mysql has write permissions to /
Hello list!
I've noticed in MySQL 5.0 partial keys on character fields aren't always
used. In 4.1 they were.
They seem not to be used when using inequality comparison.
I'm not sure whether this is a bug or intended (in the latter case I have to
work around it to get the speed I got with 4.1 ba
I don't have enough MySQL knowledge to contribute much to this mailing
list, but as a 23 year veteran teacher, I have some expertise when it
comes to developing methods of instruction (especially
self-instruction). While studying for the MySQl CMDEV exam, I created a
method for MySQL skill-
Hello,
I'm trying to install mysql 4.1
After the installation, I launch the script for the post-installation,
in scripts/mysql_install_db
I get this error :
Could not find help file 'fill_help_tables.sql' in ./support-files or
inside ..
When I try to go on phpmyadmin, it doesn't work...
Than
> -Original Message-
> From: Pete Harlan [mailto:[EMAIL PROTECTED]
> Sent: Friday, April 27, 2007 5:15 PM
> To: Tim Lucia
> Cc: mysql@lists.mysql.com
> Subject: Re: My bin.log directory is getting full
>
> Perhaps the "expire_logs_days" variable does what you're looking for.
If you googl
This one time, at band camp, "Peter M. Groen" <[EMAIL PROTECTED]> wrote:
> > Any thoughts? Any desires to contribute?
>
> Hi Keith,
>
> Great Idea!
> I volunteer for the developer side (Mysql and C++)
I have written for php|mag previously, I'll put my hand up for PHP/MySQL
Kevin
--
"Democr
On Friday 27 April 2007, B. Keith Murphy wrote:
> Hey everyone,
>
> I have been considering putting together a e-zine for MySQL as my way to
> give back to the community. I was curious as to what type of interest
> there would be in this. I am thinking something quarterly to start with
> and prob
12 matches
Mail list logo
