Re: Best Configuratuion ( my.cnf ) for a DB with many users and largecolumns ( Images in BLOB Columns ) on a Website

Hello. A lot of depends on the type of your queries. Find out which of them make the maximum load on the server and then tune your configuration. ESV Media GmbH wrote: > Hey, > > what do you think is the best configuration ( my.cnf ) for running a > database, > which many users access at the s

Best Configuratuion ( my.cnf ) for a DB with many users and large columns ( Images in BLOB Columns ) on a Website]

Hey, what do you think is the best configuration ( my.cnf ) for running a database, which many users access at the same time ( Website - Portal ). We´ve also saved our Pictures ( nearly 3.500 rows ) in our database. Every coloumn is round about 60-70 Kbyte, so i had to use mediumblob columns.

Best Configuratuion ( my.cnf ) for a DB with many users and large columns ( Images in BLOB Columns ) on a Website

Hey, what do you think is the best configuration ( my.cnf ) for running a database, which many users access at the same time ( Website - Portal ). We´ve also saved our Pictures ( nearly 3.500 rows ) in our database. Every coloumn is round about 60-70 Kbyte, so i had to use mediumblob columns.

Re: BLOB columns

I tend to use LOAD_FILE(), but your file has to be on the server and readable by MySQL ("INSERT INTO table ( field1, field2 ) VALUES ( 'a', LOAD_FILE( 'filepath' )" ). If you're using a programming language rather than just the MySQL client, you can also read the file into a variable and insert

BLOB columns

I am at a loss as to how to insert files into a BLOB column in a database, and how to extract them. Basically, I want to store files in the database itself, but do not know how to go about doing this. What sort of queries do you run to do this? Is it the same as regular "insert" and "select"

Re: INDEXes on BLOB Columns

At 5:29 -0400 9/10/03, Andrew Kuebler wrote: If I: ADD COLUMN Text (BLOB) And then INDEX (Text(10)) Will that index be beneficial if I am search for 10 characters only or anything 10 characters or less? Thanks in advance! If those characters occur at the beginning of column values, yes. -- Paul D

INDEXes on BLOB Columns

If I: ADD COLUMN Text (BLOB) And then INDEX (Text(10)) Will that index be beneficial if I am search for 10 characters only or anything 10 characters or less? Thanks in advance! Best Regards, Andrew Sql, query -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To u

Re: MySQLDump & BLOB Columns

:17 AM Subject: MySQLDump & BLOB Columns > Hello All; > > I am setting up a backup system for a client and am thinking to use > mysqldump on a daily cron job to back up my SQL database. Does anyone know > if I will have any concerns using mysqldump with a table that contains BL

MySQLDump & BLOB Columns

Hello All; I am setting up a backup system for a client and am thinking to use mysqldump on a daily cron job to back up my SQL database. Does anyone know if I will have any concerns using mysqldump with a table that contains BLOB columns? (No larger than 15 megs for any given file) Mike Hillyer

Re: How do I insert into BLOB Columns

gt; Portal building, prime number generating, script hacking and more... > > The prime number of the day is 364664071 > > > > On Thu, 29 Mar 2001, Darius Ivanauskas wrote: > > > > > Hello, > > > > >

Re: How do I insert into BLOB Columns (fwd)

hacking and more... The prime number of the day is 364664071 On Thu, 29 Mar 2001, Darius Ivanauskas wrote: > Hello, > > Does anybody know, how to insert large amount of data > (ex.: large binary files) into BLOB columns? > > Thanks, > Darius Ivanauskas > &

Re: How do I insert into BLOB Columns

On 3/29/01 3:37 AM, "Darius Ivanauskas" <[EMAIL PROTECTED]> wrote: > Hello, > > Does anybody know, how to insert large amount of data > (ex.: large binary files) into BLOB columns? > > Thanks, > Darius Ivanauskas > > P.S. Please reply to me. > &

How do I insert into BLOB Columns

Hello, Does anybody know, how to insert large amount of data (ex.: large binary files) into BLOB columns? Thanks, Darius Ivanauskas P.S. Please reply to me. - Before posting, please check: http://www.mysql.com/manual.php

Inserting binary files to blob columns

How can I, from the mysql-client command line, insert a local binary fil (i.e. an image) into a blob column in a table - using a standard insert query? For reference: Tablename = "pictures", Columnname(type mediumblob)="picture",Localfile="/tmp/test.gif" - Erling Paulsen -