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.
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
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 due to
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 tables
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 tables
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 Temporary Tables
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) and