Re: Website site Database (Project)
What do you mean? On Sun, 10 Oct 2004 23:07:59 -0700 (PDT), John [EMAIL PROTECTED] wrote: I wanted to know if this is a good place to post for a project I needed done, If not can someone direct me to a better place to 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 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: lock tables
You only need to lock whene you are going to run a query that contains a series of actions and they all have to happen at the same time. As for single queries, they are already atomic, so you don't need to put and locks around them. On Mon, 11 Oct 2004 11:14:36 +0100, Melanie Courtot [EMAIL PROTECTED] wrote: Hi, I'm a bit confused by the lock mechanism under mysql. When user A does an update on table 1, the table is automatically locked by mysql?that means at the same time user B won't be able to modify the same row? Or do I have to 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://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: How Do I Determine the Server's Version on Old Server?
mysqladmin version On Mon, 11 Oct 2004 10:36:54 -0400, Michael Stassen [EMAIL PROTECTED] wrote: You should keep threads on the list. That way, more people can help, and more can benefit from the answers. I've not looked at the code behind mysql_get_server_info(), but every version of mysql I've seen has 3 parts to the version number. It seems clear that the mysql version numbering scheme is release.version, where release is 3.23, 4.0, 4.1, or 5.0, and version is sequential. Assuming you'll always get a 3 part version seems safe to me. Michael Matthew Boehm wrote: Will mysql_get_server_info() give you what you need? http://dev.mysql.com/doc/mysql/en/mysql_get_server_info.html I guess I could use that and parse out on the . separator. 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: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
rpm -qa | grep -i mysql On Mon, 11 Oct 2004 09:12:54 -0400, Ferguson, Michael [EMAIL PROTECTED] wrote: G'Day All, I successfully installed RedHat ES 3.0 and would like to get MySQL installed on it. After reading the online manual at 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 wishes. Ferg. -- 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: Read-Only DB User
Run SELECT * FROM user; in the mysql database. All of the options are obvious. On Mon, 11 Oct 2004 19:28:49 +0530, Anil Doppalapudi [EMAIL PROTECTED] wrote: First connect to mysql as root user and issue the following command grant select on databasename.* to username@ipaddress identified by 'passwd'; flush privileges; it will grant only select privilege to the newly created user on database and he can only connect from the ipaddress specified in command Anil DBA -Original Message- From: Lee Zelyck [mailto:[EMAIL PROTECTED] Sent: Monday, October 11, 2004 7:30 AM To: [EMAIL PROTECTED] Subject: Read-Only DB User Hi All, I'm sorry to access such a basic question, but I couldn't find a specific answer to it in the mysql manual pages. The question is, how would someone create a basic read-only user for a single db? I just intend for it to be used by a script to validate data in the db itself. Anyway, if anyone can provide a lean and concise statement that will provide this, it would be very much appreciated. Thanks! Lee __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.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
Yup. On Mon, 11 Oct 2004 11:33:50 -0400, Ferguson, Michael [EMAIL PROTECTED] wrote: Thanks. Here is what it got after I ran your command. It seems that mysql and php is already installed. Right??? [EMAIL PROTECTED] root]# rpm -qa | grep -i mysql libdbi-dbd-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: Monday, October 11, 2004 11:29 AM To: Ferguson, Michael Cc: [EMAIL PROTECTED] Subject: Re: MySQL on RedHat ES 3.0 rpm -qa | grep -i mysql On Mon, 11 Oct 2004 09:12:54 -0400, Ferguson, Michael [EMAIL PROTECTED] wrote: G'Day All, I successfully installed RedHat ES 3.0 and would like to get MySQL installed on it. After reading the online manual at 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 wishes. Ferg. -- Benjamin Arai http://www.cs.ucr.edu/~barai [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: Re[2]: Diffrences in table types
Here is another question. Can you achieve the same performance having to different kinds of databases as though you were only using one? I am assuming that you are going to run into problems because you cannot set both types of databases to have a lot of memory allocated to them. Right? On Mon, 11 Oct 2004 09:23:18 -0700, John McCaskey [EMAIL PROTECTED] wrote: As far as I know memory usage between the two table types is roughly the same. The way memory is setup/used is somewhat different however. For myisam the primary memoy buffer to accelerate queries is the key_buffer which caches data for keys. In innodb you have more options to set with the main one being the innodb_buffer_pool_size which is used for caching keys and data, you want to set this as large as possible. You also have several other adjustable buffers inlcuing an 'additonal_mem_pool' which I'm not quite sure what it is used for, and the log_buffer which is used for transaction related memory I believe. So, if you are going to be using both MyISAM and InnoDB you will need seperate buffers, which will of course increase total memory usage, or leave a smaller size for both. But if you switch completely to InnoDB you can drop the MyISAM buffers down to almost nothing (still need them as the mysql table with user data etc uses them, but say 8megs would be plenty). John On Sun, 2004-10-10 at 10:51 +0200, Jacques Jocelyn wrote: Hello John, Interesting post, quite useful, Question about performance with InnoDB ? say you have a hosting server with 256 Mb of ram, would you know if that will make a difference if the major database is converted from MyIsam to InnoDb ? Although, InnoDB is not a requirement, just luxury, but I would love to enjoy foreign keys and transactions Please advise, Thanks Sunday, October 10, 2004, 8:39:15 AM, you wrote: JM I meant 'No transaction support', which is you can't use JM begin work; ... ; commit; etc to perform transactions, each query JM takes effect immeiately and is visible to all other JM threads/clients immediately. ... JM Concurrency refers to multiple seperate connections (threads) JM trying to read/write to/from the same table at the same time. JM Imagine you have 100 different connections to the 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 execute at once (if they are not JM modifying the same rows), and it will be very fast. Best regards, Jacques Jocelyn -- 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: backup
Don't use rsync. Try rdiff-backup, its much more reliable and offers rolling restoration. On Sat, 2004-04-10 at 02:08, Matt W wrote: Hi Steve, You might want to look at FLUSH TABLES WITH READ LOCK. That's a query to run from mysql, but I'm sure you can get it to work in your shell script (you need to maintain the MySQL connection while doing the backup). I don't know much about that, though. I think you just run UNLOCK TABLES when you're finished. Matt - Original Message - From: Steve Sills Sent: Tuesday, April 06, 2004 8:17 PM Subject: backup I want to use rsync to backup my db server, how do i lock all the tables for all the db's to read only so i cando my backup, then unlock them again. It needs to be done from 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 this. Thanks in advance. Steve Sills Platnum Computers, President http://www.platnum.com [EMAIL PROTECTED] Benjamin Arai Araisoft Email: [EMAIL PROTECTED] Website: http://www.araisoft.com
Re: MySQL on Linux
Just to be complete, linux does have limitations depending upon limitations of the file-system, and the kernel. All modern filesystems (XFS, EXT3, ...) all allow files over a terabyte is size. On Tue, 2004-04-06 at 13:39, Ronan Lucio wrote: Uhm, what are you talking about?!? When I put our site on a Linux system, apache stop working when it´s logfile get major than 2 Gb. I was afraid of it´d happen with MySQL, too. Linux has no such limitation. you can grow files as large as you like. right now I have an InnoDB 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
I do this all the time at my work for really large tables. Just scp, ftp the entire data directory over to the linux box and restart the MySQL service. The only addition thing you might want to do is compress the file before sending them just so you have some way to check them and tables usually compress very well. On Tue, 2003-11-04 at 11:21, Matt Babineau wrote: Well, he could do that but being inexperienced with Linux, I figured it would be more beneficial to use a familiar WYSIWYG so he doesn't blow and hour playing the with CLI like I did :) On Tue, 2003-11-04 at 16:58, Big Brother wrote: err why not do a mysqldump then just import that? --- Quoting Matt Babineau [EMAIL PROTECTED]: Check out SQLYog, could can connect and copy databases...pretty much like MSSQL Enterprise manager. They have a trial version on their site: http://www.webyog.com/sqlyog On Mon, 2003-11-03 at 19:51, Matt Fletcher wrote: Hi there, I have taken the plunge and dropped windows in favour of linux. My question is what is the best way to get the data from my windows mysql databases into linux? Can I just copy some files from one partition to another or what? 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
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 Zawodny wrote: On Fri, Jan 11, 2002 at 08:51:33AM +0100, Dr. Frank Ullrich wrote: Benjamin, can you also grow MyISAM tables to such sizes? You can. that implies that MySQL itself (and all its tools) is able to handle files bigger than 2 GB? Is that the case with MySQL on Solaris8 also? Regards, Frank. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 8 days, processed 229,155,814 queries (294/sec. avg) - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- -- 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Redhat 7.2 Linux Maximum Database/Table Size
You don't understand. You need to use a operating system which has a filesystem which lifts the 2 GB limit. By default from every Linux distrobtion I have used, if the OS has lifted the limit then they usually fix all the programs to uses the new file size capabilities. Raid doesn't help at all for the limit because the physical limit by the OS is a file size limit and not a partition or drive limit. Increase the max rows as you see appropriate but that is almost never the problem in terms of file size issues like you are having. Raids don't really help Table performance 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. Benjamin Arai [EMAIL PROTECTED] On Mon, 14 Jan 2002, Geoffrey Soh wrote: On Fri, Jan 11, 2002 at 08:51:33AM +0100, Dr. Frank Ullrich wrote: Benjamin, can you also grow MyISAM tables to such sizes? You can. I understand that the RAID option can help break the 2GB/4GB barrier, esp. on Linux machines. But how do you surpass the Max_data_length restriction of 4294967295 bytes on a RAIDED table? do you increase max_rows on such a table? if so, would this affect the performance of a large table e.g. above 50GB? Without changing max_rows it seems that MySQL will still restrict the table size to 4GB, even with raid_chunks and raid_chunksize set to e.g. 50 and 256? Anyone out there tweaked these settings before and what was the outcome? Thanks. Cheers, Geoffrey __ Geoffrey Soh, Software Architect Ufinity - http://www.ufinity.com Leading Enterprise Access Management Software! 9 Scotts Road, Pacific Plaza, #06-01, Singapore 228210 Tel : +65 830-0341 Fax : +65 737-0213 __ - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- -- 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Redhat 7.2 Linux Maximum Database/Table Size
Oh, I don't know how well that would work. But I do know you will still run into limitations of 2 GB, so if you had 2 drives raided then you now have a 4 GB limit which doesn't help to much. I would think the best solution would be to re-compile your kernel to include large file support 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 MySQL that lets you create tables with the RAID_TYPE RAID_CHUNKS RAID_CHUNKSIZE options, allowing tables to span across multiple data files, each file having a size below the OS limit. Thanks for the response. Cheers, Geoffrey __ Geoffrey Soh, Software Architect Ufinity - http://www.ufinity.com Leading Enterprise Access Management Software! 9 Scotts Road, Pacific Plaza, #06-01, Singapore 228210 Tel : +65 830-0341 Fax : +65 737-0213 __ -Original Message- From: Benjamin Arai [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 1:52 AM To: Geoffrey Soh Cc: [EMAIL PROTECTED] Subject: RE: Redhat 7.2 Linux Maximum Database/Table Size You don't understand. You need to use a operating system which has a filesystem which lifts the 2 GB limit. By default from every Linux distrobtion I have used, if the OS has lifted the limit then they usually fix all the programs to uses the new file size capabilities. Raid doesn't help at all for the limit because the physical limit by the OS is a file size limit and not a partition or drive limit. Increase the max rows as you see appropriate but that is almost never the problem in terms of file size issues like you are having. Raids don't really help Table performance 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. Benjamin Arai [EMAIL PROTECTED] On Mon, 14 Jan 2002, Geoffrey Soh wrote: On Fri, Jan 11, 2002 at 08:51:33AM +0100, Dr. Frank Ullrich wrote: Benjamin, can you also grow MyISAM tables to such sizes? You can. I understand that the RAID option can help break the 2GB/4GB barrier, esp. on Linux machines. But how do you surpass the Max_data_length restriction of 4294967295 bytes on a RAIDED table? do you increase max_rows on such a table? if so, would this affect the performance of a large table e.g. above 50GB? Without changing max_rows it seems that MySQL will still restrict the table size to 4GB, even with raid_chunks and raid_chunksize set to e.g. 50 and 256? Anyone out there tweaked these settings before and what was the outcome? Thanks. Cheers, Geoffrey __ Geoffrey Soh, Software Architect Ufinity - http://www.ufinity.com Leading Enterprise Access Management Software! 9 Scotts Road, Pacific Plaza, #06-01, Singapore 228210 Tel : +65 830-0341 Fax : +65 737-0213 __ - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- -- Benjamin Arai [EMAIL PROTECTED] -- -- -- 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Database Size Limit
The size limitation is becauseof the operating system parameters. In order to use tables larger then 3 GB, use either Redhat 7.2 or Solaris 8. These operating systems allow file sizes greater then 2 GB. For the most part I achievedtables sizes using these operating system of greater the 50 GB. 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 very big hard drive, how many partitions at 2GB each could I allocate? As many as my hard drive can handle? I also have questions with regards, to a table size. In my case it will be (4GB)/36 bytes per table? Is it distributed uniformly, or some tables can grow bigger on the expense of the others (if some only have limited data, and others keep having new data inserted into them). Sincerely, Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Database Size Limit
I disagree. The 4GB slowdown is usualy caused by indexing problems associated with the OS having increased overhead when looking up and inserting data. I have eliminated this slowdown in Solaris and Linux be re-indexing the entire database once it becomes larger then 4GB. This fixes the 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 Jan 2002, James Montebello wrote: This is speculation: They're slower because many operations have to be done using 64 bit values rather than 32 bit values. You set the flag by setting the max data size when creating the table. You can also alter this after the table is created with ALTER TABLE. The doc suggests you're setting the actual maximum size, but if you set the size to even 1 byte past 4GB (at least on Solaris), it immediately flips to a value way above 4GB, which is probably the Solaris limit (may be 2TB, I forget). Not sure what it does on Linux. We saw a significant performance decrease on Solaris when we tried to use max table sizes above 4GB, and assume it's because of an internal switch from 32-bit pointers to 64-bit pointers. May not make nearly as much of a performance difference on a real 64-bit processor and OS. james montebello On Fri, 11 Jan 2002, Aaron Brick wrote: Yes and no. With 3.23, the MyISAM format will, by default, have a 4GB limit (32 bits). You can set flags on the table to allow a 64-bit table, and you'll generally hit an OS or physical limitation long before you run out of space. The downside of the 64-bit version is it's considerably slower. Better to split large datasets up into sub-4GB units. why are operations on the 4GB tables slower? and, incidentally, where is that flag set? thanks, aaron brick. /\ | Aaron Brick (415) 206 - 4685 | | [EMAIL PROTECTED] Room 3501C, SFGH | Programmer Analyst, Functional Genomics Core Sandler Center for Basic Research in Asthma Lung Biology Center, Department of Medicine San Francisco General Hospital University of California, San Francisco - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Redhat 7.2 Linux Maximum Database/Table Size
I have been testing Redhat 7.2 Linux for about 3 month's. I few notes regarding the installation which might be helpful for MySQL Admins. - Maximum Table Size: Limited online by disk space. (I have tested tables upto 50 gigs) - Maximum Records Per Table: Limited only by available disk space. (I have tested tables upto 50 gigs) Note: Redhat 7.2 uses ext3 filesystem and must be modified after installation for best performance. ext3 must be set to minimal journaling or none at all. This doesn't effect max table size. From a stock install of Redhat 7.2 tables can reach 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Max table size in MySQL on Redhat 7.0 be default
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) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php