RE: size limitation

2001-03-26 Thread Pascal THIVENT
11 > À: Pascal THIVENT > Cc: [EMAIL PROTECTED] > Objet: Re: size limitation > > > On Fri, Mar 23, 2001 at 11:33:42AM +0100, Pascal THIVENT wrote: > > > > I've got to manage one database. > > This database is made of one table. > > This table w

RE: size limitation

2001-03-26 Thread Pascal THIVENT
Hi, the database I would like to managed is constitued by one table. This table is made of 3 columns, with no primary key mysql> CREATE TABLE test ( id1 int(8) unsigned, id2 int(4) unsigned, id3 int(4) unsigned ); mysql> CREATE INDEX idx

RE: Compiling MySQL on Solaris with -static: Impossible? Why??

2001-03-23 Thread Pascal THIVENT
Sinisa Milivojevic explained me that : "Unfortunately you can not build static programs on Solaris, as Sun has not provided static versions for many of it's libraries." Regards, -- Pascal Thivent > -Message d'origine- > De: Johan Andersson [mailto:[EMAIL PR

size limitation

2001-03-23 Thread Pascal THIVENT
disk too (using symbolic links). I would like to know what are the requirement to store so much records. Does anyome have reference of site that manage a table bigger than 1 tera ? Did someone try that ? I hope it's possible. Otherwise, i'll to choose Oracle :( and Oracle is not c

HOWTO move the Index on another partition.

2001-03-23 Thread Pascal THIVENT
Hi, I've created a database whith one table. This table has 3 columns and use an index. I would like to move the file that stands for the index on another partition. What file does store the indexes ? Does a symbolincd link be enough to move the index on another disk ? Thanks -- P

mysql-3.23.35 installation under solaris 7

2001-03-19 Thread Pascal THIVENT
ake: *** [all-recursive-am] Error 2 Does this speak to someone ? Thanks -- Pascal Thivent - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archi

How to load a database in memory

2001-03-19 Thread Pascal THIVENT
tables!". INNOBASE table seems to be safer. Does this table type permit to load data in memory ? What type should i better use ? Is it recommanded to compile MySQL with the two table types (in ordrer to be very performant ?) Could someone give me a little more details ? Thanks a lot.

table + index repartition

2001-03-15 Thread Pascal THIVENT
Hi, I have to mananage a very big table (about 20 Go) A database correspond to a directory. A table correspond to a file. Is it possible to distribute the table on several physical partition (like with Oracle that can use several table space to store one table) ? Thanks, -- Pascal Thivent

WebLogic 6.0 + MySQL

2001-01-17 Thread Pascal THIVENT
7;s very urgent ! Thanks, -- Pascal Thivent - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTEC

RE: Install Mysql3.22.32 in Solaris7

2001-01-16 Thread Pascal THIVENT
What is the strange exe attached whith those mails ? > -Message d'origine- > De: funky gao [mailto:[EMAIL PROTECTED]] > Date: mardi 16 janvier 2001 12:42 > À: [EMAIL PROTECTED] > Objet: Install Mysql3.22.32 in Solaris7 > > > Dear Sir, >I try to install Mysql3.22.32 in the Solaris7 O

RE: Install Mysql3.22.32 in Solaris7

2001-01-16 Thread Pascal THIVENT
what is the stange exe attached with your mail ? > -Message d'origine- > De: funky gao [mailto:[EMAIL PROTECTED]] > Date: mardi 16 janvier 2001 12:42 > À: [EMAIL PROTECTED] > Objet: Install Mysql3.22.32 in Solaris7 > > > Dear Sir, >I try to install Mysql3.22.32 in the Solaris7 OS. B