About mysql query time-out

Hello,everyone,here is my question: Q1--- in this function (mysql_options() ),the desc of MYSQL_OPT_READ_TIMEOUT in the Reference Manual 5.0 is as follows:The timeout in seconds for attempts to read from the serverMy question is how should I understand this word read,does it means access

Table Consistency/analize/check/repair

Hello, I had an issue yesterday, where one of my tables ended up being closed improperly, and needed to be repaired. This isn't really an issue in itself, but I didn't know about it until 2 hours after it happened, and a script was trying to write to that table, and it failed, which caused a

Re: Table Consistency/analize/check/repair

this built in command is probably a good start: http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Table Consistency/analize/check/repair

might be this will help you. http://adminlinux.blogspot.com/2010/05/mysql-checking-and-reparing-tables.html On Fri, Jun 18, 2010 at 6:59 PM, a.sm...@ukgrid.net wrote: this built in command is probably a good start: http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html -- MySQL

AFTER Delete Trigger question

Hi,Is there a way to update the same table on a delete trigger ?I need to call an UPDATE statement when a delete occurs.Best regards --Kevin Labecot,Innovanticwww.innovantic.frTél. : 05.56.45.60.54

Re: AFTER Delete Trigger question

As far as I know, you can´t change data on the same table in triggers. Kevin Labecot ke...@labecot.fr escreveu na mensagem news:4d2ce38b-d169-478b-aebf-c19f20dce...@labecot.fr... Hi, Is there a way to update the same table on a delete trigger ? I need to call an UPDATE statement when a

Re: opening a server to generalized queries but not too far

Raj Shekhar writes: One option here might be to use mysql proxy as a man-in-the-middle and filter out unwanted queries... This seems more or less the same as what I'm doing now with php. The same question applies there - what would you look for in your filter? -- MySQL General Mailing List

CFP for Surge Scalability Conference 2010

We're excited to announce Surge, the Scalability and Performance Conference, to be held in Baltimore on Sept 30 and Oct 1, 2010. The event focuses on case studies that demonstrate successes (and failures) in Web applications and Internet architectures. Our Keynote speakers include John Allspaw

analyze table issue

Ok, I know I am an idiot sometimes, and I think this falls into that category. I use SQLYog as my MySQL front end editor. I was looking to do some things, and was going to run a check table command, and clicked the analyze button, and didn't realize that all the tables in the database were

RE: analyze table issue

Nevermind, it just finished... holy uggh! Steven Staples -Original Message- From: Steven Staples [mailto:sstap...@mnsi.net] Sent: June 18, 2010 2:31 PM To: mysql@lists.mysql.com Subject: analyze table issue Ok, I know I am an idiot sometimes, and I think this falls into that

Re: [PHP] newbie sequel question: how do we search for multiple things on 1 field like:

On Fri, Jun 18, 2010 at 16:30, Dave deal...@gmail.com wrote: SELECT * FROM contacts WHERE state = 'CA' and   name = 'bob' or name = 'sam' or name = 'sara' We begin by asking on the right list (mysql@lists.mysql.com, CC'd by courtesy). You're on the right track though. Try a