Re: Delete duplicate records

Manish wrote: I have got few duplicate record in my DB as follows.- Let's say record_no is the unique id of duplicate records. So I have fields ID, record_no , X and Y. (ID is a dif filed and is a primary key) To find duplicates I do following - select record_no,count(record_no) from mytable group

Re: Delete duplicate records

delete from mytable where record_no=? limit ? Setting the first parameter to the record number and the second to count - 1. Ah limit, yes that should help. However, I do not know each individual nos for these record_no Can I have sth that will dynamically delete those records when

enrror in foreign key reference

Hello i'd like to converte this DDL for mysql ALTER TABLE MYTABLE_ROLE ADD ( FOREIGN KEY (LOGIN) REFERENCES MYTABLE_USER ) ; i wrote ALTER TABLE MYTABLE_ROLE ADD FOREIGN KEY (LOGIN) REFERENCES MYTABLE_USER ; by it return me this error.

Re: Innodb corrpution. Very Urgent

Calos, Well i didn´t change nothing at no config file. Any suggestions? thanks. If you didn´t change anything, it´s supposed to be time to you configure the my.cnf file. A better tunning should solve your problem. Ronan -- MySQL General Mailing List For list archives:

Re[2]: Poor performance for SELECT from 50.000 records - MySQL PERFORMANCE TEST

Hello Brent, Thanks for your answer, I have try to use clause SQL_CALC_FOUND_ROWS within my SELECT query (and I also didn't use SELECT COUNT(*) ... query). But when I used SQL_CALC_FOUND_ROWS and then I retrieved number of all columns using SELECT FOUND_ROWS(), the performance was worse

Diffrence between MySQL 4.0.21 and MySQL 4.0.17

Hi, Is there any functional differences between 4.0.21 and 4.0.17?. Please help me in knowing it. Thanks, Narasimha Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s)

libmysqlclient.so.12 for solaris 8

PLease help me to download libmysqlclient.so.12 for MySQL 4.x for solaris 8. Kinndly provide me some site from where i can download it. ___ ALL-NEW Yahoo! Messenger - all new features - even more fun!

Re: host blocked, but can't see errors

Hello. In this context 'errors' means interrupted connections. Increase max_connect_errors. See: http://dev.mysql.com/doc/mysql/en/Server_system_variables.html Anne Ramey [EMAIL PROTECTED] wrote: Last week I got this message: Cannot connect DBI:mysql:formmail;myhost.net: Host

glibc thread_stack

Hello, For a few servers with 1000 concurrent connections, I've compiled glibc 2.3.3 with a patched STACK_SIZE in linuxthreads/descr.h : #ifndef STACK_SIZE #define STACK_SIZE (128 * 1024) #endif instead of #define STACK_SIZE (2 * 1024 * 1024) This by the hints on the Documentation @

Re: enrror in foreign key reference

Is there an index on the column in the table referenced? F.Balicchia wrote: Hello i'd like to converte this DDL for mysql ALTER TABLE MYTABLE_ROLE ADD ( FOREIGN KEY (LOGIN) REFERENCES MYTABLE_USER ) ; i wrote ALTER TABLE MYTABLE_ROLE ADD

Binary Log for a specific table?

Hi, is there any setting in binary log that helps me to create a log for a specific table in a database? I know that I can force binary log to create a log for a specific database, but I need it for a specific table. thanks -- MySQL General Mailing List For list archives:

Re: Poor performance for SELECT from 50.000 records - MySQL PERFORMANCE TEST

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Juleni wrote: Hello Brent, Thanks for your answer, I have try to use clause SQL_CALC_FOUND_ROWS within my SELECT query (and I also didn't use SELECT COUNT(*) ... query). But when I used SQL_CALC_FOUND_ROWS and then I retrieved number of

Re: mysql maximum number of table entries

At 1:29 -0600 11/25/04, tom miller wrote: yes i do have tinyint and i have even tried mediumint both of which i set the value to 255 knowing i will never come close to filling that many rows this is in a database shared with phpbb2 and i included a script to log the ip browser and a timestamp.

MatLab connector

Do you know if I can use MySQL data from MatLab? Does it exists a connector for MatLab in the same sense as JDBC for Java? Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Mysql 4.1.7 and cluster compilation problem

Hi all, I try to make a rpm with rpmbuild -ta mysql-4.1.7.tar.gz from tarball mysql-4.1.7.tar.gz, i have modified the mysql-4.1.7.spec file and add --with-ndbcluster on the configure lines. I got a fedora core 2 and at the compile time i got that error : [...]

Re: MatLab connector

http://www.mmf.utoronto.ca/resrchres/mysql/ I use this.. it works well.. Ferhat - Original Message - From: Jose Antonio [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 25, 2004 4:57 PM Subject: MatLab connector Do you know if I can use MySQL data from MatLab? Does

timestamp and DST: impossible to backup database? *AND* bugs in TIMEDIFF, FROM_UNIXTIME, et.al.?

*** Claim *** I seem to have discovered that MySQL cannot handle the hour where DST becomes non-DST reliably (on Oct 31st in CET): 2am 3am | problem | | time|

Re: Partial Restore

Replying to my own message: - Original Message - We are shortly to go live with a new set of databases (InnoDB). The data in each database is identical in fields and types, the only difference being in the relevance of the data - they are soccer leagues, and each database

Innodb Corruption with error logs now.

Well, let me begin again.. I´m new in a corporation and my jobs is deal with mysql. We had, running mysqld 4.1.7 and using Innodb for a database of 4.7GB~. But some time inserting data into it, the server crashed. So i get the server do analyze it. When i get to the server the

Re: Innodb Corruption with error logs now.

Carlos, when filing bug reports for any software, not just MySQL, you should provide the full information. You should not try to pick the relevant material yourself. What do you have in your my.cnf file? What does the '/data' directory contain? The errors below look like you would have at

Re[2]: Poor performance for SELECT from 50.000 records - MySQL PERFORMANCE TEST

Hello Mark, Thanks for your short response. I have checked it again. I have restarted MySQL first. When I executed command select SQL_CALC_FOUND_ROWS BF_USER.LOGIN_NAME, BF_USER.EMAIL, BF_USER.ID, BF_USER.MODIFICATION_DATE, BF_USER.SUPER_USER, BF_USER.GUEST_ACCESS_ENABLED,

Re: Innodb Corruption with error logs now.

ib_logfile is different from ibdata1. Just because i get the database without Ib_logfiles... I´m sorry, i´m sending now my.cnf and what is in /data directory Dir: 11/25/2004 04:51 PMDIR . 11/25/2004 04:51 PMDIR .. 11/15/2004 11:31 AM 5,010,096,128 ibdata1

Tunning Problem

Hi All, I´m having a trouble where my server is falling to it's knees when a certain number of connections are match. Well, in a short, I configured the my.cnf files to accept up to 120 connections. When the server receives about to 55 connections, it hangs the connections and I don´t get me

Re: Innodb Corruption with error logs now.

Carlos, mysqld is not reading your my.ini. Look: you specified innodb_log_file_size as 61M, but InnoDB only created the default 5M logfiles that it creates if the user does not specify any log file size! I tested crashing mysqld, and deleting the ib_logfiles. I got the output pasted below.

Re: enrror in foreign key reference

Filippo, you used a FOREIGN KEY syntax that MySQL/InnoDB does not support. Look at the correct syntax here: http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a

MySQL 4.1.3 Java/UTF8 support question

Hi, In my.cnf, I have: [mysql] default-character-set=utf8 When I connect via mysql client and try to run a query which has a CONCAT string function, it works fine and I get the proper output. Example: SELECT CONCAT ('a', ' - ', 'b') = a-b Now, I am trying to do make this work via Java and: I

I want cluster, can I use MySQL?

Hi list ! I want a high availability DB whcih means I need failover andload balancing. Can I use MySQL cluster to achieve this? becasue MySQL cluster is only in gramma, I wonder if I can use it in a commerical environment. Also if my website is commerical, do I need to have commerical license of

PHP and MySQL

Hi all, I have installed MySQL Server 4.1.7 on a Linux Fedora Core 3 machine. It works great locally and remotely. This machine also supposed to act as a web server by using Apache 2.0.52 and it works fine too. Apache is enhanced with PHP and they works together perfect. The only problem is

Re: PHP and MySQL

On Fri, 26 Nov 2004 05:44:00 +0100, Danesh Daroui [EMAIL PROTECTED] said: Hi all, I have installed MySQL Server 4.1.7 on a Linux Fedora Core 3 machine. It works great locally and remotely. This machine also supposed to act as a web server by using Apache 2.0.52 and it works fine too.

RE: PHP and MySQL

snip When I run this little PHP script I always get fail error message: /[EMAIL PROTECTED](localhost, root, myrootpass); if (!$link_id) { echo Failed !; exit; } */ Should I change something in php.ini ? / snip Try removing the '@' from the mysql_pconnect statement to get a more

libmysqlclient.so.12 download for solaris

PLease help me to download libmysqlclient.so.12 for MySQL 4.x for solaris 8. Kinndly provide me some site from where i can download it. ___ Win a castle for NYE with your mates and Yahoo! Messenger

Socket Error While Starting MySQL

Hi All, I am facing some problems with installation of MySQL on Mac. I have installed MySQL on mac 10.3.5. but now whenever I try to run and start MySQL, it gives me following error ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) I went to the