Upgrade/installation problem
Ok problem. Upgrade from 3.23.37 to 3.23.40 on linux readhat 7.0 - using rpm and after the uppdate I get : Cant find file ./mysql/host.frm (error: 13) so I copied the db and run mysql_install_db, still get the same msg, So I checked the error 13 = permission denined. So I doublecheck tthe permission, and even tried to give ugo=rwx on all the files, same error. So Just to se if it for some reason read from another datadit i removed the datadir, and I get Table mysql.host doesn't exists (= another error) wich tells me that it actualy is reading from the right datadir. So I tried to uninstall all the mysql rpm and installing it againg same error so what can be wrong Ran out of clues. The installation has been upgraded several times before with any problems. /roger
Re: --with-raid
> What does "--with-raid" mean ? It means that the mysqld has the ability to split the .MYD (datafile) intto several datafiles (in several sub directories). > > I am running MySQL on a RedHat Linux with raid disks. Should I then > use --with-raid when installing ? No you dont. If you have a the raid setup by other HW or SW you dont need to use the --with-raid. You can read more about it in the manual chapter 7 (I think) on CREATE TABLE (and some other places aswell) THis issue has been up several times before, so if you look into the archive about big tables you will find more info about it aswell. /Roger - 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: how to split database and index
> We have a database of size 10GB and its index is also > almost of the same size. Now we want this database in MYSQL. > Please let me know how we can slpit it across 3-4 hard > disks.We are using Linux 6.2 Hi there, My self I have a machine runnig RH Linux 6.0 with a 70Gb database. And it works just fine. What you need to do is to, recompile tha source using --with-raid or download the -max version of mysql Because what you should do is to use the raid option in create table. It will then create several subdirectorys in wich it puts the datafiles. (read more in the manual about this feature (on CREATE TABLE)). And then just mount diffrent HD/partitions to the diffrent subdirectoris (works fine for me) The problem you will have is the indexfile Because as far as I know no solution has been made to split the index file into smaler files. The ext2 has a max filesize about 2Gb so you will have a problem. So for your sake I hope this is not in one table. Otherwise, my recomendation is to try to split the table into several smaller tables and thus the indexfiles as well. - For me that was not possible, so I had to drop all indexed columns (exept my uniqe numric identifyer) in the main table, and create a kind of quick serach system (187 tables) of the rest of the data. (so insted of having 1 tabled of 70Gb and 1 index on 50Gb, I have 188 tables total 250Gb and 188 indexes on about 90Gb), but I have some desent speed in on everything. - /roger - 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
> > > Hi, > > > > > > I have a problem, my database has reached Linux Redhat 7.1 > > > max file size. (2147483647 Bytes). Does eny one know what i > > > can do to make a lager database. (lager > > > filesystem) > > > > > > Thanks > > > Erik Dhiin I myself run a 300Gb database on a Linux redhat 6.0 Machine. And it works fine. What you do is to read the manual about the CREATE TABLE RAIDTYPE = ... But before you do that you need to recompile using --with-raid, or download the -max version wich I think has the raid option. What the raid option do is to split the data files up into alot of smaller files (RAIDCHUNKS=XX) But only the datafile. Not the indexfile, with is my problem. So What I have done is to create my own indexfiles (its about 170 tables) and agve a realy simple key column (that isn't space comsuming in the index) I loose alot of performance in many of the serahces, but the searching in the indexfiles of my own I Can make a query over the 300Gb (about 4 500 000 000 rows) in about 2 sec, wich is ok for now. /roger - 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
SQL query question?
Hi there, So a question I have two tables. And i want to... (i just show you) Table 1. OwnerChar(30)Uniqe FileChar(80) OIDint(not in use yet) Table 2. IDintuniqe and so on OwnerChar NameChar adress etc So I want to give the OID in table 1 the corresponding ID from Table 2 so that I may remove The Owner Col. I can do it with using tmp tables and so on, ( my knowlage in SQL querys is wery limited), But I want to do it with Just ONE singel SQL line Any ideas? /roger
exe file for win2000
Hi again, Im looking for someone that has a win 2000 mysqld compiled with --with-raid Any one? Need it. And dont have any possibillity to compile it myself. /roger
win2000
Hey there, Im in need of of a win2000 binary with the option --with-raid, dont have any possibillity to compile it my self... So anyone with win2000 and the possibillity to download and recompile the source? /roger
Re: Re:pulling audio out of a blob and playing it. => just a question about performance
Just since the subject was brought up... Im going to relseas Lucas Web Server V2.0 in a few weeks, it stores everything (htmlfiles, images etc) in the DB. To add to the adv/dis list: Advantages --- Content management (for communites and larg corp) Dis -- Content magangment (for others) /roger > (I think) most people figure that the disadvantages of having images and > most other binary files stored within the DBMS far outweigh any > advantages. From the top of my head... > > Advantages > -- > - tidiness > - ease of backup - all data is in one respository. > > Disadvantages > - > - DB is bigger, therefore repairs/checks/etc take longer (?) > - for website apps, you can have your binary files (eg > images/wavs) stored under the web heirarchy, meaning that a mysql > application is not required to retrieve the file from disk. > > I'm sure there's more...I'm a bit short of time at the moment! > > P > > > On Tue, 27 Mar 2001, > Filip Sergeys wrote: > > > Hi > > Just a question. What about performance when storing audio files in a blob. > > What effect does it have on the database(load, space requirements compared to > > audio files,...) I will be confronted with this question in the near future > > where I will have to decide to store on disk or in blob. I you have some > > statistics, can you provide them? > > > > Thanks in advance. > > > > FS > > > > - > > 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: Mysql vs ....
Start with the speed checkout: http://www.mysql.com/information/benchmarks.html there you'l find som arguments... /roger > *This message was transferred with a trial version of CommuniGate(tm) Pro* > > Hi, > I would need some reasons for choosing MySQL instead of Microsoft SQL. > (beside the fact that MySQL is free). (not for me but for my boss). > It may sound silly but trust me I really need these reasons. So please help > me with this. > Thanks, > Ciprian A. > > > > - > 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
Wantaed: Sorry forgot...
Hi again, Ehh the script in my prev mesg, language: C Forgot that. Files that will be stored is: gifs jpegs html pages etc. /roger
Wanted: Script to store files i DB
Hi, Anyone got a small script to store a file in a BLOB. Nothing fancy, just so that I dont need to think that much today. /roger
Re: What this mean?
Hi there, > When I use C API ,mysql_query. > I got an error : > Commands out of sync; You can't run this command now > what this mean and what should I do? You are probobly sending a query to the DB thats generates a raply, like select for example. What you need to do is to cath the reply with mysql_use_result() and then free it, with mysql_free_result(). /roger - 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: (yet another) sock issue
Sorry.. thats was realy stupid Right... it works fine now... It wasn't the permissions, it was the filename hmm. hahaha :) /roger > Because it is my.cnf, not my.cfg. > > Also they need to be world readable. > > roger westin wrote: > > > > Have the same problem, nither the server or any client seems to read the > > my.cfg files, > > they are just going on the precompiled default value. > > Have tried to recomplie and alot off stuff but I always have to add > > the --socket /tmp/mysql.sock > > > > I got this problem after I installed the rpm clients and added the server by > > compiling an installing it. So ... > > Why isn't the rpm and installation source putting mysql in the same > > directory and have the same defaults. > > And how do you actualy make it read the my.cfg file? (shouldtn't it be read > > atomaticly?) > > > > /roger > > > > - Original Message - > > From: "Charles Mégnin" <[EMAIL PROTECTED]> > > To: "MYSQL" <[EMAIL PROTECTED]> > > Sent: Wednesday, March 21, 2001 9:24 AM > > Subject: (yet another) sock issue > > > > > Although the my.cnf file specifies > > > socket = /tmp/mysql.sock > > > the server expects mysql.sock to reside in > > > /var/lib/mysql > > > > > > [mysql@localhost]$ /usr/bin/mysqladmin -u root -p password > > > Enter password: > > > /usr/bin/mysqladmin: connect to server at 'localhost' failed > > > error: 'Can't connect to local MySQL server through socket > > > '/var/lib/mysql/mysql.sock' (111)' > > > Check that mysqld is running and that the socket: > > > '/var/lib/mysql/mysql.sock' exists! > > > > > > Any thoughts ? > > > > > > - > > > > - > 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: Accessing MySQL remote DB from VB5
>Can anybody tell me if my VB5 programs can query an MySQL DataBase on a Remote server? >If so, what should I distribute with my software? I have done some things like that, and since VB unses standard ODBC connections the only thing you need to include in your dist is the MyODBC API /roger - 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: Altering tables
Hi, I dont know whats wrong with my mysql but when I add a column with auto_inc (I just copied and paseted what you did) I got: Primary key cannot be NULL, so, but I got it working So thanks anyway. And as I always say... If something works, dont touch int. So I wont reinstall. /roger > mysql> select * from tbl; > +-+---+ > | oid | name | > +-+---+ > | 1 | bob | > | 2 | vera | > | 3 | steve | > | 4 | Mike | > +-+---+ > 4 rows in set (0.62 sec) > > mysql> alter table tbl drop primary key,drop oid; > Query OK, 4 rows affected (6.39 sec) > Records: 4 Duplicates: 0 Warnings: 0 > > mysql> alter table tbl add id int not null auto_increment primary key first; > Query OK, 4 rows affected (3.06 sec) > Records: 4 Duplicates: 0 Warnings: 0 > > mysql> select * from tbl; > ++---+ > | id | name | > ++---+ > | 5 | bob | > | 6 | vera | > | 7 | steve | > | 8 | Mike | > ++---+ > 4 rows in set (0.39 sec) > > mysql> alter table tbl drop primary key,drop id, > -> add nid int auto_increment not null primary key first; > Query OK, 4 rows affected (3.87 sec) > Records: 4 Duplicates: 0 Warnings: 0 > > mysql> select * from tbl; > +-+---+ > | nid | name | > +-+---+ > | 9 | bob | > | 10 | vera | > | 11 | steve | > | 12 | Mike | > +-+---+ > 4 rows in set (0.35 sec) > > mysql> select version(); > +---+ > | version() | > +---+ > | 3.23.33 | > +---+ > 1 row in set (0.09 sec) > > > -- > Don Read [EMAIL PROTECTED] > -- If you are going to sin, sin against God, not the bureaucracy. > God will forgive you but the bureaucrats won't. > - 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: Altering tables
Hi I solved it my self. If anyone whats to know the awnser to this it was NOT as easy as the manual would have described. The only thing I got to work was: 1. Drop the index 2. create new field (whitout index and auto_inc) if any of them where added I got an error and nothing worked. 3. make the new one an index (got an error but after flushing the table it had made it an index anyway) 4. add the auto_inc. And if someone can figure that procedure out with the manual. /roger > check the manual under ALTER TABLE > > roger westin wrote: > > > Hi there, > > Question: > > Whats the Easiest way to insert an AUTO_INCREMENT column into an existing table, > > the new field will take over the primary key and the index. > > - 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: (yet another) sock issue
Have the same problem, nither the server or any client seems to read the my.cfg files, they are just going on the precompiled default value. Have tried to recomplie and alot off stuff but I always have to add the --socket /tmp/mysql.sock I got this problem after I installed the rpm clients and added the server by compiling an installing it. So ... Why isn't the rpm and installation source putting mysql in the same directory and have the same defaults. And how do you actualy make it read the my.cfg file? (shouldtn't it be read atomaticly?) /roger - Original Message - From: "Charles Mégnin" <[EMAIL PROTECTED]> To: "MYSQL" <[EMAIL PROTECTED]> Sent: Wednesday, March 21, 2001 9:24 AM Subject: (yet another) sock issue > Although the my.cnf file specifies > socket = /tmp/mysql.sock > the server expects mysql.sock to reside in > /var/lib/mysql > > [mysql@localhost]$ /usr/bin/mysqladmin -u root -p password > Enter password: > /usr/bin/mysqladmin: connect to server at 'localhost' failed > error: 'Can't connect to local MySQL server through socket > '/var/lib/mysql/mysql.sock' (111)' > Check that mysqld is running and that the socket: > '/var/lib/mysql/mysql.sock' exists! > > Any thoughts ? > > - > 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
Hilfe!!! Help!!! ADDing AUTO_INC col into table
Hi there, Need to insert an AUTO_INC column into a table. And yes it will be the PRIMARY KEY Anyone done this? /roger
Re: selecting null values
Try checking the section 20.16 in the manual, it helped me. That section is titled: Problems with NULL Values But you could use: SELECT * FROM table WHERE title IS NULL LIMIT 1; /roger > Hi, > > I have a database which has a text field (let's name it title). The field > is NULL initially. Now I have about a hundred thousand records in the db, > where the title field is NULL. I have to fill these NULL title fields with > the appropriate data, so I have to select them one-by-one, calculate the > title field, and update the data. So my query would be: > > SELECT * FROM table WHERE title = NULL LIMIT 1; > > But it does not work. One of you wrote, that NULL is not equal with > anything, not even with NULL. Could you please help me, what kind of > select should I write in situations like this? In this particular case, I > will do find a workaround, but I am curious, how to handle NULL values. - 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
Altering tables
Hi there, Question: Whats the Easiest way to insert an AUTO_INCREMENT column into an existing table, the new field will take over the primary key and the index.
Store MD5 hash values
Whats the best way, any realy good space saving way to store a MD5 value? /roger
Re: How to have a table very very big?
Hi again, Theres not much written in the manual about RAID_X but you'll find it under CREATE TABLE >Thank you for your response (I said right?!? sorry for my little english!) >what you say is very interesting!!! >Where can I read more about RAID_TYPE ecc... (the 3° solution you said?)? > >Now I'm writing the program in C and I have not meet this problem but I >will :-( > >Just for curiosity: I have to study the flow of data in a net : I'm working >in a network desing. If somebody is doing that or is interested we can >exchange experiences and suggestions. >Thank you again. >Mario. > > > >Il 16:51, giovedì 15 marzo 2001, scrivesti: > > Hi Mario, > > I think I had the same problem as you, and got som help... > > You have three ways of doing this: > > 1. Switch to a FileSystem that supports bigger Files > > > > 2. Use MERGE, create a lot of small tables and use MERGE > > in you select Querys, The manual is quit god at explaining > > how to do this, but I'll think you will find the limitations > > about INSERT as irritating as I > > > > 3. Use the --with-raid option. This is what I do. You need to > > recompile the mysqld using --with-raid when configuering it. > > This way you can create tables Using: RAID_TYPE=1 RAID_CHUNKS=XX > > RAID_CHUNKSIZE=YY > > The RAID_CHUNKS tells the mysql how many separate files it will > > split the DB into. IE. RAID_CHUNKS=100 will create 100 datafiles, > > wich each can be 2GB = 2 000 GB. More about this in CREATE TABLE. > > The problem with this is the indexfile, wich now is the problem (max >2GB) > > But I'll will reach that in about 2 weeks so ill figure something out by > > then. > > > > /roger > > > > >I have to store data for Internet desining (10-20 Gb at Day) > > >so I have to use a data base very fast: MySql is fast? > > > > > >I have to put 10-20 Gb of data every day: but I can have a table only >of > > >2Gb > > >(I know that reading manual of Mysql). > > >How to do a table so big? > > > > > >Thank you in advance, Rino. > > > > > >- > > >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 > > > > >_ > > Get Your Private, Free E-mail from MSN Hotmail at >http://www.hotmail.com. > > > > > > - > > 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 _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - 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: How to have a table very very big?
Hi Mario, I think I had the same problem as you, and got som help... You have three ways of doing this: 1. Switch to a FileSystem that supports bigger Files 2. Use MERGE, create a lot of small tables and use MERGE in you select Querys, The manual is quit god at explaining how to do this, but I'll think you will find the limitations about INSERT as irritating as I 3. Use the --with-raid option. This is what I do. You need to recompile the mysqld using --with-raid when configuering it. This way you can create tables Using: RAID_TYPE=1 RAID_CHUNKS=XX RAID_CHUNKSIZE=YY The RAID_CHUNKS tells the mysql how many separate files it will split the DB into. IE. RAID_CHUNKS=100 will create 100 datafiles, wich each can be 2GB = 2 000 GB. More about this in CREATE TABLE. The problem with this is the indexfile, wich now is the problem (max 2GB) But I'll will reach that in about 2 weeks so ill figure something out by then. /roger > >I have to store data for Internet desining (10-20 Gb at Day) >so I have to use a data base very fast: MySql is fast? > >I have to put 10-20 Gb of data every day: but I can have a table only of >2Gb >(I know that reading manual of Mysql). >How to do a table so big? > >Thank you in advance, Rino. > >- >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 > _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - 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
Big Tables - New entry
Hi, Got some tips and trix from some users about big tables, -Using mysql 3.23.33 -ReadHat Linux 6.0 Kernel: 2.2.5 What I seem to must do is to get the "with-raid" to work if a going to solve my problem, MERGE will be to complicated to do when I have 11 diffrent Client prg working towards the DB and they make from 50 - 400 insert or replace per sec. So rewriting the diffrent clients into supporting MERGE will be my final solution. So anyone.. Anyone that can tell me a success story and a howto when it comes to the with-raid solution. Tried to recompile myslq 3.23.33 with the --with-raid but it dont seem to work. so... HELP /roger _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - 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: Big Tables
Thanks Setve, but right now I cant change the filesystem, so I need to go for the with-raid option, I read the manual and recompiled my MySQL, but I still cant get bigger files than 2GB. Accordning to the manual it shall create sub directorys named 00, 01, 02, etc any idea? /roger >From: Steve Ruby <[EMAIL PROTECTED]> >To: Roger Westin <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: Re: Big Tables >Date: Fri, 09 Mar 2001 11:07:11 -0700 > >Roger Westin wrote: > > > > Hi, > > Have a problem with big tables, > > Cant get them over 2GB > > Using mysql 3.23.33 > > and ReadHat Linux 6.0 Kernel: 2.2.5 > > > > Need to biuld a table atleast 70Gb so Anyone? > > > >switch to a file system that supports very large files > >The problem should be with linux no mysql. > >there is an option to split tables to different >files (see with-raid in the manual) but it won't >split indexes, and if you have 70gig of data you >probably have a very large index as well... > >- >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 > _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - 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
Big Tables
Hi, Have a problem with big tables, Cant get them over 2GB Using mysql 3.23.33 and ReadHat Linux 6.0 Kernel: 2.2.5 Need to biuld a table atleast 70Gb so Anyone? /roger _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - 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