Something boring about mysql application!!!

Hi,all I have installed a Mysql4 verion on Turbo Linux successfully recently.But I always got the error prompt from the database when I did the connect to this DB. Details: [EMAIL PROTECTED] bin]$ mysqlshow mysqlshow: Can't connect to local MySQL server through socket '/opt/usr/

Innodb optimzation

Hi all, I have an Innodb database (MySQL 4.0.21 on Linux). The db is made of 11 tables. 10 of these tables are just a few MBs altogether, while the 11th table, due to a longtext field where binary data is stored, is about 3GBs and counting (about 80MBs inserted everyday). Since Innodb doesn't

RE: performance on single column index with few distinct values

Actually, given the below CREATE statement, there is not an index on (master_id, ticket_id). There's KEY `comp_ticket_master` (`ticket_id`,`master_id`), which is not the same--the order in which the columns are specified matters. If you try a (master_id, ticket_id) index and MySQL still won't use

Re: Filling database with "load data"

http://dev.mysql.com/doc/mysql/en/load-data-local.html # If LOAD DATA LOCAL INFILE is disabled, either in the server or the client, a client that attempts to issue such a statement receives the following error message: ERROR 1148: The used command is not allowed with this MySQL version I h

Filling database with "load data"

Hallo, I'm using MySQL 4.0.23a as found in the SlackWare 10.1 distribution. As I'm totally new to MySQL I tried tom follow the tutorial from the manual. When I tried to fill the data base using a text file with the command load data local infile '~/temp' into table huisdier; I got ERROR 1148: The

RE: Could not initialize master info structure, check permisions on master.info

FYI -Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: Sunday, May 29, 2005 5:18 PM To: mysql@lists.mysql.com Subject: Re: Could not initialize master info structure, check permisions on master.info Hello. Are you restoring the database on the running slave? Wha

Replication problem

Hi all: I have replication problem on my FreeBSD 5.4 AMD64 box. Sometimes replication will stop and throw an error code 1054, but the query is not the original one in the master. A query like UPDATE table_a SET col_a = 'abc' where col_b = 234 the right most character will become a strange chara

Re: basic sql join question...

re-send : Hi, you can use mysql variables : set @total:=0; select name,price,quantity, price*quantity as subtotal,@total:[EMAIL PROTECTED] from fruits; ++---+--+--+---+ | name | price | quantity | subtotal | @total:[EMAIL PROTECTED

Re: multi-thread insert into innodb table with auto_increment column cause deadlock

Gu Lei 写道: Description:  SQL state: HYT00  Native error: 1213  SQL Errortext: Deadlock found when trying to get lock; try restarting transaction SQL STATEMENT: insert into OCHARTORGANIZATION (CORPID,MODIFIED,MODIFIER,ORGIID,PARENTIID) values(?,?,?,?,?) mysql> desc OCHARTORGANIZATIO

Re: MySQL+InnoDB Licenses

Hi, the only right answers sould be here : http://www.mysql.com/company/legal/licensing/ Mathias Selon Daniel Kiss <[EMAIL PROTECTED]>: > Hi All, > > I would have a question about licensing MySQL. > > I am writing an application that relies on MySQL+InnoDB (uses MySQL as a > database backend).

Re: MySQL+InnoDB Licenses

Hi, the only right answers sould be here : http://www.mysql.com/company/legal/licensing/ Mathias Selon Daniel Kiss <[EMAIL PROTECTED]>: > Hi All, > > I would have a question about licensing MySQL. > > I am writing an application that relies on MySQL+InnoDB (uses MySQL as a > database backend).

Re: mysql and php

re-send : hi, php has to be configured with mysql support. see http://www.whoopis.com/howtos/php-mysql-osx.html and a general google search : http://www.google.fr/search?q=mysql+php+mac+os&hl=fr&lr=&start=30&sa=N Mathias > > > Selon Michael Stassen <[EMAIL PROTECTED]>: > > > You haven't gi