Re: MySQL e-zine

2007-04-28 Thread Peter M. Groen
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 probably

Re: MySQL e-zine

2007-04-28 Thread Kevin Waterson
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 -- Democracy is two

RE: My bin.log directory is getting full

2007-04-28 Thread Tim Lucia
-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 google for

error with the script mysql_install_db

2007-04-28 Thread Thibaud Hulin
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...

Giving Back...Well, Maybe

2007-04-28 Thread John Kebbel
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

Partial char key not used in conjuction with inequality comparison (MySQL5)

2007-04-28 Thread Thomas van Gulick
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

RE: Permissions and Into Outfile

2007-04-28 Thread Mogens Melander
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

RE: Permissions and Into Outfile

2007-04-28 Thread John Kebbel
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]

monitoring SQL query response times

2007-04-28 Thread Masao Kitamura
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

Re: monitoring SQL query response times

2007-04-28 Thread Thomas van Gulick
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. --

how to query this sql?

2007-04-28 Thread Jeff Pang
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