Performances with BLOB fields in mySql

My application (C++, mySql++, WINNT) is very time-critical and space-critical and use blob field. How can I improve performances? Which parameters can I set? There's literature about this question? Thak's, I'm sorry for my English. Bye, Marco

MySQL Crash in my machine

below is a resolve stack . I use tis620 charset (thai) all query of my program with php is normaly command such as 'select' 'select count(*)' 'insert' 'update' 'delete' I didn't know why mysqld crash help meplease root@academic:/tmp# resolve_stack_dump -s /tmp/mysqld.sym -n mysqld.stack 0x80

Re: store JPG in MySQL DB

For real-life example, check out http://cdbaza.ultracgis.com, and check out the filename of the thumbnails images. I'm SELECTing those images from the MySQL database. That's how it's done: 1_ Create a table to store your JPGs, and the column that holds JPG data should be declared as BLOB

BLOB - JPG

Hi, If i have a JPG file, how can i put it into the database / table in MYsql with one field defined as BLOB.. Please help Sameer -- http://www.dypatil.edu For Better tomorrow - Before posting, please ch

Re: store JPG in MySQL DB

Hi, Can you please put some light on it.. How i can do it, or is it described in manual Sameer -- you wrote: Hi > Hi, > Can i have a table in which i can store my JPG file somehow in > MYSQL database. Absolutely. just declare a BLOB column, and load your images rightinto the col

Re: store JPG in MySQL DB

Hi > Hi, > Can i have a table in which i can store my JPG file somehow in > MYSQL database. Absolutely. just declare a BLOB column, and load your images rightinto the columsn > Sameer > > > > > > > > -- > http://www.dypatil.edu For Better tomorrow > > -

store JPG in MySQL DB

Hi, Can i have a table in which i can store my JPG file somehow in MYSQL database. like i can do it in Oracle Sameer -- http://www.dypatil.edu For Better tomorrow - Before posting, please check: ht

Re: query - primary key

Hi, Firstly, how do i correct that error of BAD text coz i actually have a text file which has a HISTORY dump from IE. Secondly what about the Duplicate Entry stuff, its comming for all the URLs why?? Regards Sameer -- you wrote: I'd take a look at this error first; you seem t

Re: query - primary key

In the last episode (May 20), Sameer Maggon said: > Hi, > Here are the errors i am getting > > You have an error in your SQL syntax > near 'http://www.indianrail.gov.in/frame.html') >
file://C:\\IIK\\for_you.html > ')' at line 1 I'd take a look at this error first; you seem to be passing ba

Re: query - primary key

Hi, Here are the errors i am getting You have an error in your SQL syntax near 'http://www.indianrail.gov.in/frame.html')
file://C:\\IIK\\for_you.html ')' at line 1 You have an error in your SQL syntax near 'http://www.cultureholidays.com/')
file://C:\\IIK\\Tour_del.html ')' at line 1 You h

Re: query - primary key

In the last episode (May 20), Sameer Maggon said: > Hi, > I have a table with four colums > > id > date > time > addr - varchar (used my sql C API) > > I want that when i add an entry, the PRIMARY KEY IS ALL OF THEM > means that no entry should repeat. > > I used ALTER TABLE

query - primary key

Hi, I have a table with four colums id date time addr - varchar (used my sql C API) I want that when i add an entry, the PRIMARY KEY IS ALL OF THEM means that no entry should repeat. I used ALTER TABLE sss ADD PRIMARY KEY (all four field) but not when i add my things, afte

Re: [7241] Indexes on columns that are declared differently?

In the last episode (May 20), Stephen Brownlow said: > The MySQL online manual says that MySQL cannot use indexes > efficiently unless the columns have the same type and the same > length. > > I can see no release notes that this problem has been fixed. > > My question: Is this still a problem?

Please help - Inserting

Hi, I have a table in which i have a field of VARCHAR(255), i am picking up URLs from a file and INSERTING into mysql table, i am using MySQL C API, the problem is that file contains 6700 records and it is just inserting few records like 100 or so, what may be the probnlem Please help Sameer

error message....somewhat lost

Hi All, The other day, I tried connecting to mysql via the good old >mysql -u me -p but I got a message saying that my mysql.sock is missing from the tmp folder. After checking the mailing list archive, I decided (well, guessed is the more appropriate word) that I could try to re-sta

[7241] Indexes on columns that are declared differently?

The MySQL online manual says that MySQL cannot use indexes efficiently unless the columns have the same type and the same length. I can see no release notes that this problem has been fixed. My question: Is this still a problem? Here is the extract from the latest manual: 7.29 EXPLAIN Syntax (G

error message....somewhat lost!

Hi All, The other day, I tried connecting to mysql via the good old >mysql -u me -p but I got a message saying that my mysql.sock is missing from the tmp folder. After checking the mailing list archive, I decided (well, guessed is the more appropriate word) that I could try to re-start the dae

Re: Concurrency control

In the last episode (May 19), Khaled Elmeleegy said: > How does MySQL handle concurrency control between two or more concurrent > quires (not transactions), on their website they say they use > multi-versioned concurrency control, but i guess this between transactions, > not queries. > > Consider

LOAD DATA FROM FLAT FILE (InnoDB Table)

Background: I tried to load data from a flat file. The flat file contains one line of heading data. It is comma delimited and line separate by line feed. I log on as root to do the load. Here is my result. [ldemeester@bidshiftdev ldemeester]$ mysql -u root -p test http://www.mysql.com/manual.p

Re: Concurrency control

mysql doesn't write transaction mysql-max does write transaction for details, you can check out at mysql web site or mysql & mysql-max manual if your application doesn't need transaction, I think mysql is better for better performance - Original Message - 寄件者: "Khaled Elmeleegy" <[EMAIL P

Insert into Table

Hi, I have a table in which i have a field of VARCHAR(255), i am picking up URLs from a file and INSERTING into mysql table, i am using MySQL C API, the problem is that file contains 6700 records and it is just inserting few records like 100 or so, what may be the probnlem Please help Sameer

Concurrency control

How does MySQL handle concurrency control between two or more concurrent quires (not transactions), on their website they say they use multi-versioned concurrency control, but i guess this between transactions, not queries. Consider the case we have two queries Q1: select * from table1 EXCEPT se

Re: job payment.

Hey everybody, thanks a lot for all the info i got, i know it's kindof a stragne question, but i really had no idea to expect what to earn or to be offered in a situation like the one i'm in now. Now i know what to compare with and how to deal with everything and i think i'm set on job-instruc

mysql connection handshaking

Hello list, I am planing to write a script to telnet mysql server(port:3306) and try to verify the server status. When I try something like this: home:~ #telnet localhost 3306 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. , 3.23.49-logúm>|zn:u`^,Connection closed by forei

please help a newbie!

Dear All , I believe this question is very simple and hope u ppl can help me out. Well i'm trying to develop a site using chinese characters where my users can login. I'm suppose to store their username which will be in chinese character in mysql . I tried looking for info abt it but in vain. Doe

LOCK & REPAIR

If I want to repair a table, with the REPAIR TABLE syntax, can I do a "FLUSH TABLES WITH READ LOCK" beforehand, or will that lock REPAIR out from writing too? Thanks! - Mark P.S. Keeping the bot happy: mysql - Before posting,

Re: Resorting entire Database

The normal way to do it is to pipe it to the mysql command line client which will make it enter batch mode and run the .sql file. The basic syntax will look something like: mysql -p database < file.sql This should work in windows or in any unix environment. This is also assuming the file is in

Re: MySql Client fails to connect

I had the same problem, it drove me up the friggin wall until I finally found the answer... Read the manual very carefully on how to set up user permissions. Pay particular attention to the description of how wild card permissions are applied. That's what was killing me... Also pay particular

Re: newbie mysql install

Just a guess, could it be that the Mac does not support sockets...?? I dunno, I'm just fishing since I have not yet had an opportunity to play with the OS X. What about permissions? non-the-less... Try changing your config file to use TCP and see if that works. The other thing I ran into wh

Re: mysql crashed and created huge .MYI files. All data lost?

Andy, I believe that that file is an on disk temporary file that was created during the query. I would suggest you wait for the recover to finish as I think (hope) your data will be returned to a fairly normal state when it does. Ric. - Original Message - From: "andy" <[EMAIL PROTECT

FW: Resorting entire Database

Hello Everyone. I backed up my entire db to data.sql file and now I want to restore and I don't know the right procedure could someone help. - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Database and all backups lost at same time

myisamchk -q Does a Quick check of the files... See the manual for the options to do a full repair / recovery of the files. - ??) Perhaps the backup files were already corrupt before the crash??? ??) Perhaps you have some issues with your hard disk? You can buy a CDRW drive for about $120

Re: random order by id

To pick one item at random what you want is Select foo from bar Where ID = rand() * scale To order them randomly, I seem to recall that there was an example of how to do it in the mySQL manual. -- Erik Perrohe - Original Message - From: "Per Andreas Buer" <[EMAIL PROTECTED]> To:

Re: Socket problem connecting

problem with permission; change rights to group and user mysql to mysql data directory Todd Cary > I am getting this message when I try to establish a connect to the DB. > Any suggestions on where I can find an answer? > > Warning: Can't connect to local MySQL server through socket > '/tmp/mys

Re: Can't connect to ....

problem in permission; change rights to group an user mysql Jaan Jürgenson > Hi everybody. > > Just installed Red Hat Linux on a machine. I included the MySQL > packages but cant get it up working. > > When starting from shell it looks like this: > > $ mysql > ERROR 2002: Can't connect to loca

RE: job payment.

Hi How long is a piece of string..? Hourly rate for independent work in the UK is £20-35 ish, roughly US$35-60. I think US programmers are forbidden to discuss rates, as it is considered price fixing! You could access Access through ODBC, using php. This will not support a busy site but

Resorting entire Database

Hello Everyone. I backed up my entire db to data.sql file and now I want to restore and I don't know the right procedure could someone help. - Before posting, please check: http://www.mysql.com/manual.php (the manual) h

Re: Remote admin of MySQL from Win 2K

YES! I was missing something: Telnet!! I can log in *BUT* I am unable to change the MySQL password. mysqladmin -h www.myhost.org -u root -p password 'new_password' asks me for the password and when I use the root password (su password), I get Access Denied. Todd -- Todd Cary Ariste Software 2

job payment.

Hey guys, I got an offer to do some php/mysql design for a local company, basically what it's going to be is to take the current Access DB and make it acessible through a webpage (that's the basic info they gave me). How much should i except to get paid for this, and what is an acceptable amoun

Search Query input works, but gives a blank page for results?

The following script, with some edits, has allowed access to a "LOCAL" mysql database. I have reworked it some to access a MySQL on another server I suppose I could transfer the script to that server for loading/execution, but I'd like to learn how one accesses a remote mySQL database (to faci

license question on libmysql.dll and C/C++ API

Hi all, I have a question on license of MySQL C API or MySQL++ API, and libmysql. What I want to do is to make a MS Windows program (C++) that accesses MySQL database, and to distribute it on internet without publishing its source code. It uses database server as its backend resource store. It c

mysql crashed and created huge .MYI files. All data lost?

Hi there, during a wrong select query on a table containing over 2 mill. records (involving other tables) mysql and the whole linux server crashed. After rebooting I did run myisamchk and this reported that some tables are damaged but still can be read. So I did shut down the server und run myis

Re: Reaching the unique id after inserting with auto increment

Hi, On Sun, May 19, 2002 at 05:14:49PM +0200, Gyulay Gabor wrote: > This is a basic problem. > I need an unique id in a table, so I choosed integer with > auto increment. (it is so simple...) > > After inserting a record, I have to display the created > unique id to identify that record later. >

Reaching the unique id after inserting with auto increment

Hi ! This is a basic problem. I need an unique id in a table, so I choosed integer with auto increment. (it is so simple...) After inserting a record, I have to display the created unique id to identify that record later. But how can I select it ? If I select the last record, I should get ano

indexing text fields possible?

Hi there, I am wondering if it would be anyhow possible to make a search on a mysql textfield faster. Right now the table contains 294000 entries and takes about 40 MB of space. Is there a way to apply a index with a resonable amount of disk space? I am also not so sure if I should use text or sm

GROUP BY on multiple fields apparently broken

>Description: mysql> describe DLSummary; ++--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-+---+ | DownloadID | int(10) unsigned | YES | MUL | NULL|

Problem with InnoDB + indexes

Hello, I've just switched to InnoDB table from myISAM and it's been running pretty smoothly except on this SQL statement it doesn't use any indexes when there are, and therefore is very slow. mysql> explain select pn.timestamp,ne.viewpoint,pn.id,pn.type,ne.type,ne.newsid,ne.hidestamp from ne

Re: A new GUI for mySQL

Sounds great! I'm all for GUI's for MySQL! It would help if you put some screen shots on your site so we can see what its interface is like before we download and install. Speaking for myself, my hard drive is full of stuff I've downloaded just to find out it isn't what I was looking for. Denn

difference between fixed length tables MyISAM vs. ISAM

Hello All, I recently moved my database from mysql 3.22.29 to 3.23.41, and udated all my tables to MyISAM tables. Under ISAM, I could take the filesize of the ISD table and divide by the record length to get the exact number of records returned by "select count(*)" from that table (or vise-ve

A new GUI for mySQL

greetings... Webyog has released mySQLyog, a win32 based Query analyzer. Its FREE and gives all the features that a mysql developer can ask for by a query analyzer. please visit www.webyog.com you can execute query of results of more than 10 records, supports multiple query execution and you c

Re: 4.0.1 Bugs

Richard, then it is possible that all the crashes are caused by SHOW CREATE TABLE. The memory corruption bug can crash InnoDB at any place, it is not always caught by an assertion like in the error log. Since the bug is nondeterministic, it is well possible it appears only under some specific dat

Re: 4.0.1 Bugs

Heikki, My set of queries performs about 4/5 "show create table" queries each hour. The purpose being to drop it then recreate it automatically. Last time I tried truncate it was as slow as delete, but that was near the begining of my development and never saw reason to retry it after show cr

Re: 4.0.1 Bugs

Richard, the assertion failure below is very probably caused by the SHOW CREATE TABLE memory corruption bug which was fixed in 3.23.48, but not yet in 4.0.1. It is usually caused by mysqldump. The regularity of the crashes suggests they might be connected to mysqldumps. If the memory consumption

Re: 4.0.1 Bugs

Richard, the assertion failure below is very probably caused by the SHOW CREATE TABLE memory corruption bug which was fixed in 3.23.48, but not yet in 4.0.1. It is usually caused by mysqldump. The regularity of the crashes suggests they might be connected to mysqldumps. If the memory consumption

Re: HELP - Insight into dates, please

Many thanks for the, Richard... You wrote: > > I'm not so sure what you are asking here but from this statement, > > More importantly are there functions in mySQL I can call to convert a > standard date, ie "mmdd" to the expected mySQL value?. Yeah, I was a bit vague :-) But your exa

Possible Bug in UPdATE in MySQL 4.0.1 alpha

>Description: Possible Bug in UPDATE in MySQL 4.0.1 The following is the message in the error log... Number of processes running now: 0 020519 04:55:30 mysqld restarted 020519 4:55:30 InnoDB: Started /usr/local/mysql/bin/mysqld: ready for connections mysqld got signal 11; Thi

Re: random order by id

Jule <[EMAIL PROTECTED]> writes: > Hey guys, > i have a db and a table with id and questions > > now i want these questions to be listed in a random order, is there a way to > format my SQL query or do i need some PHP work to? SELECT foo FROM bar ORDER BY rand(); Just to pick one: SELECT foo

Re: HELP - Insight into dates, please

Pierre, I'm not so sure what you are asking here but from this statement, More importantly are there functions in mySQL I can call to convert a standard date, ie "mmdd" to the expected mySQL value?. I can tell you that mysql is quite happy to accept mmdd formatted dates without any

RE: RE: ECS Error with 4.0.07 opening DB (still) again -EMEA2490

Hi Monty, > > > "venu" == venu <[EMAIL PROTECTED]> writes: > > > > venu> MySQL/MyODBC does accept connection timeout. Here is the code > venu> snippet from driver: > > venu> case SQL_ATTR_CONNECTION_TIMEOUT: > venu> DBUG_RETURN(mysql_options(&dbc->mysql, > MYSQL_OPT_CONNECT_T

RE: RE: ECS Error with 4.0.07 opening DB (still) again -EMEA2490

Hi! > "venu" == venu <[EMAIL PROTECTED]> writes: venu> MySQL/MyODBC does accept connection timeout. Here is the code venu> snippet from driver: venu> case SQL_ATTR_CONNECTION_TIMEOUT: venu> DBUG_RETURN(mysql_options(&dbc->mysql, MYSQL_OPT_CONNECT_TIMEOUT, venu> (con

HELP - Insight into dates, please

Excuse this old ACCESS/ CLARION hack for asking such a basic question, but the mySQL docs have given me a head-ache :-) I want to move an ACCESS database to mySQL. I am writing the Code in Delphi. My problem is assigning the date values in the SQL INSERT INTO string. In the system I'm using da