Re: Optimal InnoDB datafile size? 150GB data.

Jesper Krogh wrote: I gmane.comp.db.mysql.general, skrev Kurt Haegeman: What is the optimal InnoDB datafile size? Is 75 * 2GB prefered over 1 * 1G:autoextend? The filesystem (ext3) has no problems handling the filesizes, so that should not be an issue. If your one large datafile suffers

Re: Optimal InnoDB datafile size? 150GB data.

e would be better without them (smaller tables -> more speed). Greetings, Kurt Haegeman Mediargus.be -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: fulltext indices

Yahoo! Finance Tax Center - File online. File on time. Absolutely. In an R&D environment, I created a table with more than 7 million newspaper articles. Didn't use load data local infile, though, but a fairly simple Perl script. Regards, Kurt Haegeman Mediargus.be -- MySQL General Ma

Re: Saving file into database

Eve Atley wrote: Is there an advantage to storing the PDFs directly into the database? I'm also curious how large this would make a database. Is there any space saved through this method, or would they still be the same size as the original PDF? - Eve There's a percentage of disk space lo

Re: Saving file into database

Erich Beyrent wrote: Use the BLOB, Luke! See your local MySQL manual for details. We're using BLOBs to store PDF in our database, and through the use of HTTP headers, we're able to let user download the PDFs without having to store a local copy on disk, directly from the databa

Re: Saving file into database

ion header). Hope this helps. Kurt Haegeman Mediargus.com Paul Rigor wrote: Are you running a web server (or ftp server) as well? Because if you are, then you can upload the files to a separate directory using perl and just store the links to that file into a table in your database... If you'r

Re: Fulltext creation on 4.1: ERROR 1034

Hi, Sergei Golubchik wrote: Hi! On Jan 13, Kurt Haegeman wrote: Hi, When trying to create a fulltext index on my large table, I get the following error: ERROR 1034 (HY000): 121 when fixing table Sorry, I still cannot repeat this :( Could you try to create a smaller test case ? I

Re: Fulltext creation on 4.1: ERROR 1034

Hi Eli, Eli Hen wrote: "Kurt Haegeman" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Sergei Golubchik wrote: Hi! On Jan 13, Kurt Haegeman wrote: Hi, When trying to create a fulltext index on my large table, I get the following error: ERROR 1034 (

Re: Fulltext creation on 4.1: ERROR 1034

Sergei Golubchik wrote: Hi! On Jan 13, Kurt Haegeman wrote: Hi, When trying to create a fulltext index on my large table, I get the following error: ERROR 1034 (HY000): 121 when fixing table I'm using version 4.1.1-alpha of the MySQL database, a source-compiled version with the -

Fulltext creation on 4.1: ERROR 1034

Hi, When trying to create a fulltext index on my large table, I get the following error: ERROR 1034 (HY000): 121 when fixing table I'm using version 4.1.1-alpha of the MySQL database, a source-compiled version with the --with-raid option. I'm trying to build a newpaper article search engine.