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

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.dll

Innodb Error

? Is 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: http

MyISAM - IN

. Edilson Vasconcelos de Melo Junior [EMAIL PROTECTED] (19) 3256-3577 ICQ 136192234 sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

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 de Melo Junior

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

NOW()

this? Is 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

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

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

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

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

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

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

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

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

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

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

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:

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