Re: Use Samba Share For Data Directory

Michael Stearne schrieb: We have 5.0.27 installed on a CentOS machine that doesn't have a ton of disk space. Is it possible to point the data directory to lie on a samba connected share? The samba share does not support Unix file permissions so it is not possible to set mysql as the owner of

Re: Innodb, why not?

Hi, According to the manuel, Falcon is not yet optimized for performances, so benchmarking it would not be fair. And I do not recommand using the binary alpha release in production, you could corrupt badly your database (some bugs has only been fixed a few days ago concerning this

How to log on the server refused connections?

Hi, I'm experiencing some sporadic connection refused from mysql-max server. I'd like to keep track of these events, so is there a way to log on the server these 3 items? - date and time - ip of the client - reason of the refusal Thanks, Nico -- Email.it, the professional e-mail, gratis

Max number of 64 indices per table?

Hi everyone, the number of incices per table seems to be restricted to 64. Any way to change that? I'm using MySQL 5.0.27 . Thanks in advance Horst -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

InnoDB Deadlock Prevention

Hi, I am experiencing deadlocks using InnoDB row level locking. I would like to prevent these deadlocks by accessing the rows in the affected table in a fixed order, as suggested in the MySQL manual http://dev.mysql.com/doc/refman/5.1/en/innodb-deadlocks.html. Unfortunately, I could not find

Re: Use Samba Share For Data Directory

On 1/26/07, Dominik Klein [EMAIL PROTECTED] wrote: Michael Stearne schrieb: We have 5.0.27 installed on a CentOS machine that doesn't have a ton of disk space. Is it possible to point the data directory to lie on a samba connected share? The samba share does not support Unix file

RE: Unable to put data on a different computer from mysql - I'm responding to Felix

Can't seem to figure out how to respond to a thread...Do I simply repost again? Anyway, Thanks for the info Felix...I tried it and get the same result. Works locally on a different drive, but not over our network. Is the problem to do with windows file sharing? Not sure what else to try...

Re: Max number of 64 indices per table?

Horst Jäger ha scritto: Hi everyone, the number of incices per table seems to be restricted to 64. Any way to change that? recompile with configure --with-max-indexes=128 I'm using MySQL 5.0.27 . -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Array property of object from Resource

Hello, folks -- lurking for a while, first post -- I'm relatively new to PHP but doing database design work for nearly 20 years. I've RTFM'ed (+ books + other resources) a bunch of times but I have a mental block around doing this: I want to have an multidimensional array as a property

Re: Array property of object from Resource

oops, Sorry: I meant to post this to the PHP group. On Jan 26, 2007, at 2:06 PM, phphelp -- kbk wrote: Hello, folks -- lurking for a while, first post -- I'm relatively new to PHP but doing database design work for nearly 20 years. I've RTFM'ed (+ books + other resources) a bunch of

Re: Array property of object from Resource

On Jan 26, 2007, at 2:33 PM, Brent Baisley wrote: while ( $row = mysql_fetch_array($result,MYSQL_ASSOC) ) { $this-result_List[] = $row; } That produces an array like this: [0]= [WHAM_ID]=15, [NAME]=Fred, [AMOUNT]=99 That is getting me close to what I am looking for, I just would

help to build a query for simple bulletin board

hi, I'm trying to build a simple bulletin board, just topics and posts. created following tables: CREATE TABLE `topics` ( `topic_id` int(8) NOT NULL auto_increment, `author_id` int(8) unsigned NOT NULL, `topic_title` varchar(255) collate utf8_unicode_ci default NULL, `topic_date_entered`