Re: Re[2]: Diffrences in table types

2004-10-11 Thread Benjamin Arai
database all > > JM> trying to write to the same table. With MyISAM each one will lock > > JM> the entire table, and only one will execute at a time, making it > > JM> very slow. In InnoDB each one will only lock the rows it is > > JM> modifying and they can all

Re: MySQL on RedHat ES 3.0

2004-10-11 Thread Benjamin Arai
bd-mysql-0.6.5-5 > mysql-3.23.58-1 > perl-DBD-MySQL-2.1021-3 > mysql-devel-3.23.58-1 > mod_auth_mysql-20030510-1.ent > php-mysql-4.3.2-8.ent > MySQL-python-0.9.1-6 > > > > -Original Message- > From: Benjamin Arai [mailto:[EMAIL PROTECTED] > Sent: Mo

Re: Read-Only DB User

2004-10-11 Thread Benjamin Arai
ql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Benjamin Arai http://www.cs.ucr.edu/~barai [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL on RedHat ES 3.0

2004-10-11 Thread Benjamin Arai
dev.mysql.com/doc/mysql/en/Installation_layouts.html I am still a bit > unsure of my next move. > Can some please help me out with directions on how to check the system > to verify whether or not MySQL is installed, and how to download and > install MySQL on this server. > > Many thanks and best wishe

Re: How Do I Determine the Server's Version on Old Server?

2004-10-11 Thread Benjamin Arai
eparator. > > > > Will I always get a 3 . separated string? ie: X.XX.XX ? Or could I sometimes > > get X.XX? > > > > Thanks, > > Matthew > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:h

Re: lock tables

2004-10-11 Thread Benjamin Arai
specify the lock for each query? > And what about temporary tables? > If anybody has a simple explanation or a link on a doc > thanks, > Melanie > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http:

Re: Website site Database (Project)

2004-10-10 Thread Benjamin Arai
post it. > > Thanks > > ___ > Do you Yahoo!? > Declare Yourself - Register online to vote today! > http://vote.yahoo.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTE

Re: backup

2004-04-11 Thread Benjamin Arai
the command line, not the mysql > program. Anyone have any ideas? I have looked and couldn't find the > answer i was looking before. Its running from a shell script, from my > backup machine. Its currently setup to shut down the server, however i > don't want to have to do th

Re: MySQL on Linux

2004-04-07 Thread Benjamin Arai
nnoDB dbase with Mysql on a linux > > system and the file is over 60 GIGS in size! > > Great!!! So, I don“t need to worry about it... :-) > > Thanks Dan, > Ronan Benjamin Arai Araisoft Email: [EMAIL PROTECTED] Website: http://www.araisoft.com

Re: Windows to Linux

2003-11-06 Thread Benjamin Arai
> > > > > Thanks, > > > > > > > > Matt > > > > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > -- Benjamin Arai <[EMAIL PROTECTED]> Araisoft Corp.

RE: Redhat 7.2 Linux Maximum Database/Table Size

2002-01-14 Thread Benjamin Arai
upport and tweak you MySQL for limit-less records. That's what I do when I run into older distro's. Benjamin Arai [EMAIL PROTECTED] On Mon, 14 Jan 2002, Geoffrey Soh wrote: > Hi, > > Sorry for being unclear :) I was talking about the --with-raid compilation > option in M

RE: Redhat 7.2 Linux Maximum Database/Table Size

2002-01-14 Thread Benjamin Arai
ance because in almost all cases the bottlneck is caused by the drives access time. raiding drives doesn't increase the access time therefore, you are most likely not going to see and poerformance increases using a raid system unless you are change to drives to ones with lower access times.

Re: Redhat 7.2 Linux Maximum Database/Table Size

2002-01-14 Thread Benjamin Arai
Yes, all programs which don't have built in limits can go smoewhere in the range of I think 8 TB but I have only tested it to 50 GB with MySQL. As for Solaris this is also true. Benjamin Arai [EMAIL PROTECTED] On Mon, 14 Jan 2002, Dr. Frank Ullrich wrote: > Hi, > > Jeremy

Re: Database Size Limit

2002-01-12 Thread Benjamin Arai
problem from what I could tell. I would also like to note that if there was a pointer issue when switching to 64 bit pointers, it would only effect perfomance on computer with less then sufficent amounts of processing power to calculate the larger pointers. Benjamin Arai [EMAIL PROTECTED] On Fri, 11

Re: Database Size Limit

2002-01-12 Thread Benjamin Arai
. Benjamin Arai [EMAIL PROTECTED] On Fri, 11 Jan 2002, Demirchyan Oganes-AOD098 wrote: > Hello everyone, > > I guess I have the similar question, that has been brought up. > > I have 36 InnoDB tables, and I have allocated two 2GB partitions for my data. > > Provided I have ver

Redhat 7.2 Linux Maximum Database/Table Size

2002-01-10 Thread Benjamin Arai
h 50+ gigs. Benjamin Arai [EMAIL PROTECTED] - 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 P

Max table size in MySQL on Redhat 7.0 be default

2001-08-25 Thread Benjamin Arai
What is the maximum table size allowed by MySQL and Redhat 7.0 be default? Benjamin Arai - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive