--- Username size limitations
hey dudes, i'd really need some insight on this. Does anyone have any idea about this ? TIA heya, I have a quick and painless (i hope :) )question.. Do you know how the username length is limited under MySQL. There is no mention of this in the manual or books. I figured the username length was dynamically limited by the length of the User field in the mysql.user table. But i have users with Username longer than 32 characters and those get an Access denied error. And, say the username is supercalifragilistixexpicalidocious (36 characters) it tells that user [EMAIL PROTECTED] can't login. I have then changed the user field length in the mysql.user table to 128. But still, can't login. I've looked into the code. First thing, the username is cropped at 32 characters in the error message itself. Indeed, in errmsg.txt, the access denied error format string is : Access denied for user: '[EMAIL PROTECTED]' to database '%-.64s' I haven't tried recompiling with a longer username string conversion, but if you guys tell me MySQL is not cropping the username before matching it against the privilege table, i will to be sure. I have looked at the user authentication code and haven't found anything that would seem to crop at 32 characters even though i have found a constant name USERNAME_LENGTH fixed at 16 characters..which would have been coherent if it was fixed at 32 .. so i don'treally know what to believe. Can anyone tell me exactly what happens ? Is mysql really hard limiting the username to 32 characters ? I don't think i have a hostname issue since from a same machine, another login with the exact same user privilege except the username length works.. If mysql crops the username, is there a patch against it ? If someone can point me where in the code this is handled i could do the patch myself, just need a hint as to where to find the stuff :) I have merely overlooked the code to find obvious proff mysql was doing this but didn't. any insight would be greatly appreciated. Thank guys -- Chand Speed is good but stability is god. (c) Joel, 2003 - 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: --- Username size limitations
At 14:35 +0100 3/10/03, Chand wrote: hey dudes, i'd really need some insight on this. Does anyone have any idea about this ? TIA heya, I have a quick and painless (i hope :) )question.. Do you know how the username length is limited under MySQL. There is no mention of this in the manual or books. I figured the username length was dynamically limited by the length of the User field in the mysql.user table. The length is described in the manual in this section: http://www.mysql.com/doc/en/Privileges.html It indicates that usernames are stored in a 16-character column. You can also issue a DESCRIBE mysql.user statement to find out. But i have users with Username longer than 32 characters and those get an Access denied error. And, say the username is supercalifragilistixexpicalidocious (36 characters) it tells that user [EMAIL PROTECTED] can't login. I have then changed the user field length in the mysql.user table to 128. But still, can't login. I've looked into the code. First thing, the username is cropped at 32 characters in the error message itself. Indeed, in errmsg.txt, the access denied error format string is : Access denied for user: '[EMAIL PROTECTED]' to database '%-.64s' I haven't tried recompiling with a longer username string conversion, but if you guys tell me MySQL is not cropping the username before matching it against the privilege table, i will to be sure. I have looked at the user authentication code and haven't found anything that would seem to crop at 32 characters even though i have found a constant name USERNAME_LENGTH fixed at 16 characters..which would have been coherent if it was fixed at 32 .. so i don'treally know what to believe. Can anyone tell me exactly what happens ? Is mysql really hard limiting the username to 32 characters ? I don't think i have a hostname issue since from a same machine, another login with the exact same user privilege except the username length works.. If mysql crops the username, is there a patch against it ? If someone can point me where in the code this is handled i could do the patch myself, just need a hint as to where to find the stuff :) I have merely overlooked the code to find obvious proff mysql was doing this but didn't. any insight would be greatly appreciated. Thank guys -- Chand - 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: --- Username size limitations
On Mon, 10 Mar 2003 10:41:15 -0600 Paul DuBois [EMAIL PROTECTED] wrote: At 14:35 +0100 3/10/03, Chand wrote: hey dudes, i'd really need some insight on this. Does anyone have any idea about this ? TIA heya, I have a quick and painless (i hope :) )question.. Do you know how the username length is limited under MySQL. There is no mention of this in the manual or books. I figured the username length was dynamically limited by the length of the User field in the mysql.user table. The length is described in the manual in this section: http://www.mysql.com/doc/en/Privileges.html It indicates that usernames are stored in a 16-character column. You can also issue a DESCRIBE mysql.user statement to find out. heya, thanks for the answer although i know how to get that info. But that's not very accurate, for example i could do an alter table and make the User field be 80 characters. It still wouldn't change the fact that Mysql Hard limits in the code the Login size to 16 which in my mind seems pretty harsh. I've patched it roughly for my needs by defining USERNAME_LENGTH to 80 in include/mysql_com.h but it doesn't really fit me cause next time i'll upgrade mysql, I'll have to patch it again. Don't you guys see the disadvantage of hard limiting so badly the Daemon ? Is there any plan to change this in the future ? Just my 2 cents. -- Chand Speed is good but stability is god. (c) Joel, 2003 En réalité, nous sommes tous morts... Mais c'est camouflé par la vie (c) Lewis, 2002 - 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
Username size limitations
heya, I have a quick and painless (i hope :) )question.. Do you know how the username length is limited under MySQL. There is no mention of this in the manual or books. I figured the username length was dynamically limited by the length of the User field in the mysql.user table. But i have users with Username longer than 32 characters and those get an Access denied error. And, say the username is supercalifragilistixexpicalidocious (36 characters) it tells that user [EMAIL PROTECTED] can't login. I have then changed the user field length in the mysql.user table to 128. But still, can't login. I've looked into the code. First thing, the username is cropped at 32 characters in the error message itself. Indeed, in errmsg.txt, the access denied error format string is : Access denied for user: '[EMAIL PROTECTED]' to database '%-.64s' I haven't tried recompiling with a longer username string conversion, but if you guys tell me MySQL is not cropping the username before matching it against the privilege table, i will to be sure. I have looked at the user authentication code and haven't found anything that would seem to crop at 32 characters even though i have found a constant name USERNAME_LENGTH fixed at 16 characters..which would have been coherent if it was fixed at 32 .. so i don'treally know what to believe. Can anyone tell me exactly what happens ? Is mysql really hard limiting the username to 32 characters ? I don't think i have a hostname issue since from a same machine, another login with the exact same user privilege except the username length works.. If mysql crops the username, is there a patch against it ? If someone can point me where in the code this is handled i could do the patch myself, just need a hint as to where to find the stuff :) I have merely overlooked the code to find obvious proff mysql was doing this but didn't. any insight would be greatly appreciated. Thank guys -- Chand Speed is good but stability is god. (c) Joel, 2003 - 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
Size Limitations
Is there a database size limitation with MySQl in the Windows NT and Windows 2000 enviroment? Like some databases have size limitation of 2GB. - 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: Size Limitations
At 09:49 AM 1/30/2002 -0500, Hashim Ismail wrote: Is there a database size limitation with MySQl in the Windows NT and Windows 2000 enviroment? Like some databases have size limitation of 2GB. Yes. Read the manual. In a Windows environment, table sizes are limited to 2 gigabytes if memory serves, it is all in the manual, though. You can, of course, have more than one table in your database. - 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: Size Limitations
The manual doesn't specify the Windows limit - only the Linux value of 2 gb. -Original Message- From: Christopher Thompson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 9:57 AM To: Hashim Ismail; [EMAIL PROTECTED] Subject: Re: Size Limitations At 09:49 AM 1/30/2002 -0500, Hashim Ismail wrote: Is there a database size limitation with MySQl in the Windows NT and Windows 2000 enviroment? Like some databases have size limitation of 2GB. Yes. Read the manual. In a Windows environment, table sizes are limited to 2 gigabytes if memory serves, it is all in the manual, though. You can, of course, have more than one table in your database. - 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: Size Limitations
The Linux version no longer has 2 GB limit. It is now whatever your disk capacity is. -Original Message- From: Steve Kramer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 11:34 AM To: Christopher Thompson Cc: MySQL Subject: RE: Size Limitations The manual doesn't specify the Windows limit - only the Linux value of 2 gb. -Original Message- From: Christopher Thompson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 9:57 AM To: Hashim Ismail; [EMAIL PROTECTED] Subject: Re: Size Limitations At 09:49 AM 1/30/2002 -0500, Hashim Ismail wrote: Is there a database size limitation with MySQl in the Windows NT and Windows 2000 enviroment? Like some databases have size limitation of 2GB. Yes. Read the manual. In a Windows environment, table sizes are limited to 2 gigabytes if memory serves, it is all in the manual, though. You can, of course, have more than one table in your database. - 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
RE: Size Limitations
On Wed, 30 Jan 2002, Rick Emery wrote: The Linux version no longer has 2 GB limit. It is now whatever your disk capacity is. The no longer, however, is a function of later Linux kernels and filesystems. Linux 2.2 kernels with the ext2 filesystem (probably still the most common setup) have a 2GB file size limitation, which is the cause of the MySQL table size limitation. MyISAM tables, at least on 3.23, have a 4GB limitation unless you specifially configure it otherwise, even if the OS allows larger files. Given all of the possible combinations, if you're going to be pushing the limits of table sizes, it's best to simply test and find out what your particular config will allow you do to. james montebello - 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
Table size limitations: Error Handling and Raid 0
My question is two-fold, first regarding error handing of table size limitations, and secondly performance and other implications of raid striping. I'm building a system with an integrated MySQL database and there is a potential for filling up tables to the maximum file size for the OS I'm using (linux 2.2.x kernel, ext2 fs, 2gb max file size). I'd like to provide users with a graceful error-handling mechanism, essentially telling them: The database is full. You must remove stuff before you can add more. Along with that, a % used number would be nice. Is there a method (through a mysql query) of determining how much space the database is taking up? It seems like the alternative is looking directly at the file system's record. Secondly, to get past the 2gb limit I'm considering using Raid Striping on a single partition. I'm curious if people have done this and what the performance implications are (how much worse is 2, 3, 10, 20 files than one file), and does doing this successfully avoid the 2gb limit (or is there some other limiting factor?) What is the next limiting factor beyond the file system's 2gb limit given unlimited storage? [that one is just curiosity] Thanks, Eric Mayers Software Engineer Captus Networks - 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
Table size limitations...
I have a table that holds a lot of information. I tried to INSERT something into it, and received... DBD::mysql::st execute failed: The table 'fancy_big_table' is full at ./tom_to_mutt.pl line 156. The table is 4G is size. The table's Max_data_length = 4294967295 (4G) I'm running the MySQL server on a FreeBSD system, and this is not a file system limitation. I am using MyISAM tables. So, I'm not sure what to do. I could easily double the size of that table in the next few months. After reading the CREATE TABLE page in the manual, I thought that increasing the AVG_ROW_LENGTH would help since it says that... MySQL uses the product of max_rows * avg_row_length to decide how big the resulting table will be I ran ALTER TABLE fancy_big_table AVG_ROW_LENGTH = 9482; and after a long time, it finished without error, but inspecting the Avg_row_length and the Max_data_length afterwards showed no change. Maybe this is a red herring, and totally down the wrong path. I'm not sure. So, if one of you could help me figure out how to cram more crap into my table, I'd be awefully appreciative. Thanks, Nathan Hendler Tucson, AZ USA http://retards.org/ - 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: Table size limitations...
I'm not an SQL expert but if FreeBSD supports 4GB files than you should check your MAX_DATA_LENGTH properties on the table you're using. You can do this by running SHOW TABLE STATUS on the table. I believe you can use ALTER (or on create table statements) to change this value. Hope this helps, here's a pointer to more information on this: http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html# Table_size - Trevor -Original Message- From: Nathanial Hendler [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 10:20 AM To: MySQL Subject: Table size limitations... I have a table that holds a lot of information. I tried to INSERT something into it, and received... DBD::mysql::st execute failed: The table 'fancy_big_table' is full at ./tom_to_mutt.pl line 156. The table is 4G is size. The table's Max_data_length = 4294967295 (4G) I'm running the MySQL server on a FreeBSD system, and this is not a file system limitation. I am using MyISAM tables. So, I'm not sure what to do. I could easily double the size of that table in the next few months. After reading the CREATE TABLE page in the manual, I thought that increasing the AVG_ROW_LENGTH would help since it says that... MySQL uses the product of max_rows * avg_row_length to decide how big the resulting table will be I ran ALTER TABLE fancy_big_table AVG_ROW_LENGTH = 9482; and after a long time, it finished without error, but inspecting the Avg_row_length and the Max_data_length afterwards showed no change. Maybe this is a red herring, and totally down the wrong path. I'm not sure. So, if one of you could help me figure out how to cram more crap into my table, I'd be awefully appreciative. Thanks, Nathan Hendler Tucson, AZ USA http://retards.org/ - 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: Table size limitations...
Look into MAX_ROWS... ie: alter table mytable max_rows = 1 ryan - Original Message - From: Nathanial Hendler [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Wednesday, August 15, 2001 12:19 PM Subject: Table size limitations... I have a table that holds a lot of information. I tried to INSERT something into it, and received... DBD::mysql::st execute failed: The table 'fancy_big_table' is full at ./tom_to_mutt.pl line 156. The table is 4G is size. The table's Max_data_length = 4294967295 (4G) I'm running the MySQL server on a FreeBSD system, and this is not a file system limitation. I am using MyISAM tables. So, I'm not sure what to do. I could easily double the size of that table in the next few months. After reading the CREATE TABLE page in the manual, I thought that increasing the AVG_ROW_LENGTH would help since it says that... MySQL uses the product of max_rows * avg_row_length to decide how big the resulting table will be I ran ALTER TABLE fancy_big_table AVG_ROW_LENGTH = 9482; and after a long time, it finished without error, but inspecting the Avg_row_length and the Max_data_length afterwards showed no change. Maybe this is a red herring, and totally down the wrong path. I'm not sure. So, if one of you could help me figure out how to cram more crap into my table, I'd be awefully appreciative. Thanks, Nathan Hendler Tucson, AZ USA http://retards.org/ - 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: Table size limitations...
In the last episode (Aug 15), Nathanial Hendler said: I have a table that holds a lot of information. I tried to INSERT something into it, and received... DBD::mysql::st execute failed: The table 'fancy_big_table' is full at ./tom_to_mutt.pl line 156. The table is 4G is size. The table's Max_data_length = 4294967295 (4G) I'm running the MySQL server on a FreeBSD system, and this is not a file system limitation. I am using MyISAM tables. I wonder if there is still a 4gb limit on dynamic MYISAM tables? Is there a 4-byte offset used as the pointer in indexes for this table type? I checked some of my databases and all the dynamic tables have 4294967295 as their max length, where the fixed tables vary; one has 115964116991. The docs do mention MAX_ROWS and AVG_ROW_LENGTH together; maybe you need to specify both of them for mysql to bump your table limits above 4gb. If that doesn't work, and you can spare the wasted space, try converting your table to fixed-length rows (convert all varchars to chars). -- Dan Nelson [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: Table size limitations...
On Wednesday 15 August 2001 11:30, Dan Nelson wrote: In the last episode (Aug 15), Nathanial Hendler said: I have a table that holds a lot of information. I tried to INSERT something into it, and received... DBD::mysql::st execute failed: The table 'fancy_big_table' is full at ./tom_to_mutt.pl line 156. The table is 4G is size. The table's Max_data_length = 4294967295 (4G) I'm running the MySQL server on a FreeBSD system, and this is not a file system limitation. I am using MyISAM tables. I wonder if there is still a 4gb limit on dynamic MYISAM tables? Is there a 4-byte offset used as the pointer in indexes for this table type? I checked some of my databases and all the dynamic tables have 4294967295 as their max length, where the fixed tables vary; one has 115964116991. The docs do mention MAX_ROWS and AVG_ROW_LENGTH together; maybe you need to specify both of them for mysql to bump your table limits above 4gb. If that doesn't work, and you can spare the wasted space, try converting your table to fixed-length rows (convert all varchars to chars). I had a similar thought regarding the dynamic tables, since I saw the same numbers. I can spare the wasted space, but the column making it dynamic is of the type text, so I can't just make it fixed-length (right?). Any ideas? I'm trying ALTER TABLE resumes MAX_ROWS = 1; right now (sugggested by ryan) I hope that works. thanks, Nathan Hendler Tucson, AZ USA http://retards.org/ - 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: Mysql Quota Support/DB Size Limitations
In the last episode (May 10), Nathan Boley said: Hi, I was interested in implementing size limitations on specific databases. I've searched the mysql docs for an mention of quota support, but I am not able to find any. I found that by chown the individual database directories and their files and then chmod them to be world readable I can access the database. My assumption (as of yet untested) is that given the databases group read permission would give me similar results. Then, I can make use of Linux's quota system. The problem arises with the creation of new tables; mysql creates all new tables as the user mysql. It doesn't seem as if it For mysql to create files with different userids, it would have to run as root and link its user.db to your /etc/passwd file. There's an easier way to to it, though. If you chgrp each database directory to a different group and also set the suid-group bit (chmod g+s), then any file created in the subdirectories will inherit the group id of the parent directory (most other Unixes don't need the setuid-group bit set, but it doesn't hurt). Then you can set group quotas and enforce space restrictions that way. -- Dan Nelson [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
Mysql Quota Support/DB Size Limitations
Hi, I was interested in implementing size limitations on specific databases. I've searched the mysql docs for an mention of quota support, but I am not able to find any. I found that by chown the individual database directories and their files and then chmod them to be world readable I can access the database. My assumption (as of yet untested) is that given the databases group read permission would give me similar results. Then, I can make use of Linux's quota system. The problem arises with the creation of new tables; mysql creates all new tables as the user mysql. It doesn't seem as if it would be too large a chore to change the source code so that the physical files are created in the user connected to the database through (surprise!) a mysql database. However, I don't know where I would begin such an endeavor (any responses suggesting I start in the source code will be duly ignored). My question is whether anyone has encountered a similar situation and, if so, how he/she worked around/fixed it or, barring that, where I would insert code to dynamically change the files' ownership. Thanks - 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: Mysql Quota Support/DB Size Limitations
At 10:23 PM -0700 5/10/01, Nathan Boley wrote: Hi, I was interested in implementing size limitations on specific databases. I've searched the mysql docs for an mention of quota support, but I am not able to find any. I found that by chown the individual database directories and their files and then chmod them to be world readable I can access the database. My assumption (as of yet untested) is that given the databases group read permission would give me similar results. Then, I can make use of Linux's quota system. The problem arises with the creation of new tables; mysql creates all new tables as the user mysql. It doesn't seem as if it would be too large a chore to change the source code so that the physical files are created in the user connected to the database through (surprise!) a mysql database. However, I don't know where I would begin such an endeavor (any responses suggesting I start in the source code will be duly ignored). My question is whether anyone has encountered a similar situation and, if so, how he/she worked around/fixed it or, barring that, where I would insert code to dynamically change the files' ownership. In order to make this work, you'd have to have the server run as root so that it could chown files to different owners. That's a huge security risk. Thanks -- Paul DuBois, [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