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 the files. Is this possible at all? If you use proper mount-options, you can set the owner of the files. mount -t smbfs -o uid=mysql $SHARE $DESTINATION In general: This should not be a problem, but it will be slow as the network is propably slower than your local disc. Guess you knew that. Regards Dominik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 corruption). Regards, Jocelyn Fournier www.mesdiscussions.net mos a écrit : At 03:54 PM 1/25/2007, you wrote: Another thing to consider is: heh, silly mail client :). Another thing to consider is this: http://dev.mysql.com/doc/falcon/en/index.html Though it's Not recommended for production use, I've heard people still use it in production environments. -- Chris, Falcon doesn't currently support RI. And like Innodb, it requires its own table space so it too may get fragmented. http://dev.mysql.com/doc/falcon/en/se-falcon-createdb.html and will likely require packing (sweeping?) from time to time. It would be nice to see some benchmarks compared to InnoDb and MyISAM. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 per te: http://www.email.it/f Sponsor: Crea il tuo sito web dinamico con ASP e ACCESS - VideoCorso professionale direttamente nel tuo computer. Trucchi e segreti Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=5143d=26-1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 how to ensure that rows are accessed in a specific order. Any help on how to achieve this is greatly appreciated. Thanks in advance, Stephan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 permissions so it is not possible to set mysql as the owner of the files. Is this possible at all? If you use proper mount-options, you can set the owner of the files. mount -t smbfs -o uid=mysql $SHARE $DESTINATION In general: This should not be a problem, but it will be slow as the network is propably slower than your local disc. Guess you knew that. Yep. I'll try this . Thanks a lot! Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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... Kelly -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 of an object.
Example:
MySQL SQL Resource:
WHAM_ID NAME AMOUNT
5 Fred 99
9 Albert 345
23 Mary 5
(etc...)
Inside the function which builds the instance of the object, I have
language like:
while ($line = mysql_fetch_array($result_set,MYSQL_ASSOC))
{
$this-foom_array = array(MyKey.$line[wham_id]=array($line).,;
}
This isn't even close. g
Any examples, or a well-written resource to help me do this?
TIA
Ken
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 times but I
have a mental block around doing this:
I want to have an multidimensional array as a property of an object.
Example:
MySQL SQL Resource:
WHAM_ID NAME AMOUNT
5 Fred 99
9 Albert 345
23 Mary 5
(etc...)
Inside the function which builds the instance of the object, I have
language like:
while ($line = mysql_fetch_array($result_set,MYSQL_ASSOC))
{
$this-foom_array = array(MyKey.$line[wham_id]=array
($line).,;
}
This isn't even close. g
Any examples, or a well-written resource to help me do this?
TIA
Ken
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 like
to create a more meaningful outer array key -- thank you (even if I
posted to the wrong list!)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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` datetime default NULL,
`topic_status` enum('live','hidden','locked') collate utf8_unicode_ci
NOT NULL default 'live',
PRIMARY KEY (`topic_id`),
KEY `topic_author` (`topic_author`),
KEY `topic_date_entered` (`topic_date_entered`),
KEY `topic_status` (`topic_status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
AUTO_INCREMENT=3041 ;
CREATE TABLE `posts` (
`post_id` int(4) unsigned NOT NULL auto_increment,
`topic_id` varchar(255) NOT NULL,
`author_id` int(8) unsigned NOT NULL,
`post_date` datetime NOT NULL,
`content` text,
PRIMARY KEY (`post_id`),
KEY `topic_id` (`topic_id`),
KEY `post_date` (`post_date`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3417 ;
CREATE TABLE `authors` (
`author_id` int(8) unsigned NOT NULL auto_increment,
`Username` varchar(20) NOT NULL default '',
`Password` varchar(20) NOT NULL default '',
`Name` varchar(30) NOT NULL default '',
`Date_Reg` varchar(30) NOT NULL default '',
PRIMARY KEY `Username` (`Username`),
KEY `Username` (`Salesperson_No`),
KEY `Password` (`Password`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
I was trying to create the query but wasn't successful.
only thinig I did for now is
$query = mysql_query(
SELECT t.topic_id, t.topic_title, t.author_id,
t.topic_date_entered, a.Name
FROM topics as t
LEFT JOIN authors as a ON (t.author_id=a.author_id)
WHERE t.topic_status = 'live'
ORDER BY t.topic_id DESC
LIMIT 25);
while($result = mysql_fetch_array($query))
{
$query2 = mysql_query(
SELECT COUNT(*) AS counter, MAX(post_date) as post_date,
MAX(post_id) as post_id, author_id
FROM posts
WHERE topic_id = $result['topic_id']
GROUP BY topic_id);
while($result2 = mysql_fetch_array($query2))
{
echo 'b'.$result['topic_title'].'/b by
'.$result['Name'].' '.$result2['counter'].'
'.$result2['post_date'].'br'; # shortened version
}
}
and, of course, it's wrong.
want to have on topics listing: topic's title | author's name | no. of
replies | last post date | last post autor's name.
Thanks for any help.
-afan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
