4.1 x 5.0 INSERT Performance issues

Hi, My software use to run with mySQL 4.1, but now i have to use some of the new features of mySQL 5.0 i did dump all databases, uninistalled mysql4.1, installed the mysql5.0 and start loading the .sql file. This operation use to take about 4 hours but know it is taking 1day!!! Did anything hap

Copiando uma base de dados

Bom dia, Fiz um arquivo de instalacao para o meu sistema usando o install shield e estou com algumas duvidas qto a instalar a base de dados. Segue o que eu jah fiz: (1) Meu script de instalacao vai replicar o diretorio "C:\mysql\bin" na maquina do usuario (2) Copiarah tb "libmysql.d

Innodb Error

there anyway to save the data or should i recreate the innodb space? Thank u very much, Edilson. Edilson Vasconcelos de Melo Junior [EMAIL PROTECTED] (19) 3256-3577 ICQ 136192234 - Before posting, please check:

MyISAM -> IN

YPE=MyISAM with 220945 records Thank u very much, Edilson. Edilson Vasconcelos de Melo Junior [EMAIL PROTECTED] (19) 3256-3577 ICQ 136192234 sql,query - Before posting, please check: http://www.mysql.com/manual.php (

MyISAM -> Innodb

Hi, I have a lot of MyISAM table that i wanna convert ot Innodb. They don't have any foreign keys nor BLOB or TEXT column as index. How should i do this? Should i just "ALTER TABLE mytable TYPE=Innodb"? Is there any risk? Thank u very much, Edilson. Edilson Vasconcelos

Parsing strings

Hi, What characters should i parse when using an INSERT statement that has string values? So far, i had troubles with single quotes and minus signs. What should i do with them? Is there any others? Thank u very much, Edilson. Edilson Vasconcelos de Melo Junior [EMAIL

Query slow (again)

Hi, I have changed my query but it is so slow :( Please, help me! Thank u very much! Edilson. - Query -> SELECT a.idemail, a.fklastresp FROM wmkt_email a, wmkt_client b, wmkt_maillist_client c LEFT JOIN

Query too slow

Hi, I have the following query and everytime i try to run it, it returns an error "Mysql server has gone away". Is it beacause the query is very slow? If so, how can i speed it up? Query -> SELECT a.idemail, a.fklastresp FROM wmkt_email a, wmkt_client b, wmkt_maillist_client c WHERE bAct

Multiple indexes

Hi, A field can belongs to 2 or more indexes? Edilson Vasconcelos de Melo Junior www.jrsoftwares.com.br [EMAIL PROTECTED] Fone: (19) 3256-3577 sql, query --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.361 / Virus

NOW()

there another function that i can use to get the current datetime? Thank u very much, Edilson Vasconcelos de Melo Junior www.jrsoftwares.com.br [EMAIL PROTECTED] Fone: (19) 3256-3577 sql,query --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com

RES: Innodb

Hi, The server is not mine :( How do i know if the source was compiled with --with-innodb option? Thank u very much, Edilson. -Mensagem original- De: Paul DuBois [mailto:[EMAIL PROTECTED]] Enviada em: sexta-feira, 10 de maio de 2002 17:47 Para: Edilson Vasconcelos de Melo Junior; MYSQL

Length Limit

Hi, Using the C API, does the sql parameter in the mysql_query function a length limit? Thank u very much, Edilson. Edilson Vasconcelos de Melo Junior www.jrsoftwares.com.br [EMAIL PROTECTED] Fone: (19) 3256-3577 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system

Innodb

Hi, What versions of mysql support innodb tables? What about 3.23.45 or 3.23.47? Thank u very much, Edilson. Edilson Vasconcelos de Melo Junior www.jrsoftwares.com.br [EMAIL PROTECTED] Fone: (19) 3256-3577 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http

Number of affected rows

Hi, I'm using the C API for mysql and i wanna know how can i get the number of affected rows after a UPDATE statement. Thank u very much, Edilson. - Before posting, please check: http://www.mysql.com/manual.php (the manua

Group by "counted" records...

Hi, My table have two fields (iduser INT, dtaccess TIMESTAMP) with the following data: iduser | dtaccess --- 10 | '2000-10-02' 3 | '2000-12-04' 4 | '2000-10-09' 3 | '2000-12-04' 5

RES: My Query is TOOOOOOOOOOOO Slow :(

Hi, Thank u very much!! It helped a lot... I also created two indexes: one in wmkt_email_sent for (nmachine e fkpbl) and another in wmkt_client for fkEmail (both sugested by Luciano Barcaro). About the size of the resultset: all these table have about 100.000 records and they can be about 10.000.0

My Query is TOOOOOOOOOOOO Slow :(

Hi, My query is running very very VERY slowly and this is creating a lot of troubles. Please, see it below and if u find something useful and faster i'll be very grateful. MYSQL >> SELECT idemailsent, email, idclient FROM wmkt_email_sent a, wmkt_client b, wmkt_email c WHERE nMachine = 0

Should i repair?

Hi, I have a table that has now about 10 records (about 100bytes each one). My queries were too slow and some time a lost connection. But now i can't do anything with this table :( Even "SELECT * FROM mytable LIMIT 1" doesn't return a value... Is my table crashed? What should i do now

Locking Tables

Hi, What error occurs if i try to access (read or write) a table that was locked (LOCK TABLES mytable WRITE) by another thread? Dirso. PS: MYSQL - Before posting, please check: http://www.mysql.com/manual.php (the manual

Many clients working with distinct records

Hi, I'm building an appl that will be running in at least 10 machines in the same time connected to the same mysql server. They will working on the same table this way: 1) A client ask for 100 records, work with them and update them 2) Each record must be used just once (cause this, the table has

Count and Group By

Hi, I hava a table "tblA" that has two fields (id, description) and a table "tblB" with two fields (fk_tblA, dtInsert). My problem is that i need to count records in tblB grouping them by (id, description) to know how many children each record from tblA has in tblB. The sql i'm using is:

DATE_ADD ?

Hi, How do i the current timestamp plus 20 minutes in MYSQL? I have a Timestamp(14) field and i need to insert the current datetime plus 20 minutes. Thank u very much, Dirso. - Before posting, please check: http://www.mysql

Number of connections to mysql server

very much, Edilson. Edilson Vasconcelos de Melo Junior www.jrsoftwares.com.br - Portal JR [EMAIL PROTECTED] Fone: (+55)(19)3256-3577 Cel : (+55)(19)9111-5873 - Before posting, please check: http://www.mysql.com/manual.php

GetLastError in MYSQL

Hi, How do i get the last error message while using mysql C API? Thank u very much, Dirso Edilson Vasconcelos de Melo Junior www.jrsoftwares.com.br - Portal JR [EMAIL PROTECTED] Fone: (+55)(19)3256-3577 Cel : (+55)(19)9111-5873

StartTransaction

Hi, Is there anyway to start transaction, do rollback and/or commit changes using mysql c api? Thank u very much, Edilson Vasconcelos de Melo Junior www.jrsoftwares.com.br - Portal JR [EMAIL PROTECTED] Fone: (+55)(19)3256-3577 Cel : (+55)(19)9111-5873