Re: hardware & clusters

2007-09-08 Thread Jimmy Guerrero
Hello, If you have not already done so, check out the Cluster Eval Guide which has some tips which may assist you in your process. Much of the content was put together by the professional services group here at MySQL. http://www.mysql.com/why-mysql/white-papers/mysql_cluster_eval_guide.php Al

Re: MySQL 6.0.2-alpha and Falcon and possible bug/problem

2007-09-08 Thread Mariella Petrini
I don't think that is the problem. I have been able to create over a 1,000,000 of tables with MySQL 5.1.21 and different storage engines with the same environment (I had already ulimit set). Thanks, Mariella Mathieu Bruneau <[EMAIL PROTECTED]> wrote: I never tried the falcon engine, but coul

Re: MySQL 6.0.2-alpha and Falcon and possible bug/problem

2007-09-08 Thread 김재명(Jaemyung Kim)
If Debian is limited to create files over 8k, it can be the reason of the problem. Falcon seems not create data file for tables, but still create ".frm" files for each tables. -- Jaemyung Kim 2007/9/9, Mathieu Bruneau <[EMAIL PROTECTED]>: > > I never tried the falcon engine, but could it be that

Re: Master database server continues to crash

2007-09-08 Thread Mathieu Bruneau
Are you running on a 32 bits architecture ? I have seen case where 1.7G is way too much for the total space mysql is allowed to use, especially if you have innodb buffer set to bigger than default value(8MB). Also you should check that the user is really allowed that size (ulimit). The duplicat

Master database server continues to crash

2007-09-08 Thread Matt Juszczak
Hi all, We've been having our master database server continually crash about once or twice per week. The most recent output in the error log is contained at the bottom of this message. The funny part is, that not only is mysql crashing often, but we are also seeing some very weird errors in

Different max_packet_size sizes

2007-09-08 Thread Matt Juszczak
We've found recently that have a max packet size of 8 MB on our master and on our slaves causes problems. For some reason, slaves will error out during replication on packets that come from the master if they are very close to max_packet_size. The solution is to set the max_packet_size higher

Re: MySQL 6.0.2-alpha and Falcon and possible bug/problem

2007-09-08 Thread Mathieu Bruneau
I never tried the falcon engine, but could it be that mysql is running out of file descriptor ? I think debian is limited to something around 8k per user by default. Check your pam settings and your ulimit ... Database usually use a lot of file handle and it's generally safe to increase it. Do

Re: MySQL 6.0.2-alpha and Falcon and possible bug/problem

2007-09-08 Thread Mariella Petrini
I have re-run and job and I was able to repeat the problem. Find attached the mysql server error log with all the tarces. Could you please help ? Thanks, Mariella --- Mariella Petrini <[EMAIL PROTECTED]> wrote: > Hi All, > > > I have started using MySQL 6.0.2 with Falcon on > Linux > with

Re: seoparator help

2007-09-08 Thread coolcoder
Thanks for the help i have got it correct. -- View this message in context: http://www.nabble.com/seoparator-help-tf4316769.html#a12568601 Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubsc