Re: MySQL performance and limit

2001-10-05 Thread David Turner
No problem, MYSQL is great and I know far less about it than I do Oracle. Dave On Fri, Oct 05, 2001 at 06:08:07PM +0200, Tonu Samuel wrote: > On Fri, 2001-10-05 at 17:06, David Turner wrote: > > > > > > BTW, this is unique in MySQL - you can have tables mixed to be > > > transactional (InnoDB) a

Re: MySQL performance and limit

2001-10-05 Thread Tonu Samuel
On Fri, 2001-10-05 at 17:06, David Turner wrote: > > > > BTW, this is unique in MySQL - you can have tables mixed to be > > transactional (InnoDB) and nontransactional (MyISAM) and use them mixed > > in same query. All other SQL-s (as much I know) have transactions on > > Oracle's Global Tempora

Re: MySQL performance and limit

2001-10-05 Thread David Turner
> > BTW, this is unique in MySQL - you can have tables mixed to be > transactional (InnoDB) and nontransactional (MyISAM) and use them mixed > in same query. All other SQL-s (as much I know) have transactions on Oracle's Global Temporary Tables don't write to redo or rollback, and on normal tab

Re: MySQL performance and limit

2001-10-05 Thread Tonu Samuel
On Fri, 2001-10-05 at 12:13, Carl Troein wrote: > It seems to be pretty popular to have a large number of databases, > but I guess it's mostly due to having a large number of users. > In pthe project I'm working on now we have 3 databases, 2 of which > are mysql and test. However, some of our tab

Re: MySQL performance and limit

2001-10-05 Thread Carl Troein
Tonu Samuel writes: > > I want to setup a machine with 3000 databases, each database will have > > 41 tables. > This should be no problem for MySQL. Everything is depending how to you > use MySQL. It seems to be pretty popular to have a large number of databases, but I guess it's mostly du

Re: MySQL performance and limit

2001-10-05 Thread Tonu Samuel
On Fri, 2001-10-05 at 09:52, José León Serna wrote: > Hello: > I want to setup a machine with 3000 databases, each database will have > 41 tables. Does MySQL support this configuration? What machine do you think > will support this configuration? The purpose is to create a website with > PHP+M

MySQL performance and limit

2001-10-05 Thread José León Serna
Hello: I want to setup a machine with 3000 databases, each database will have 41 tables. Does MySQL support this configuration? What machine do you think will support this configuration? The purpose is to create a website with PHP+MySQL, is this possible? Best Regards. ---