SHOW PROCESSLIST displays incorrect slave latency in MySQL 3.23

2004-05-10 Thread mysql-support
. Doing SLAVE STOP; SLAVE START; has no effect. Fix: Unknown (except to work around it as shown above). Submitter-Id: submitter ID Originator:root Organization: NewsNow Publishing Limited MySQL support: none Synopsis: SHOW PROCESSLIST displays incorrect slave latency in MySQL 3.23

Re: Excel file

2004-04-07 Thread mysql-support
Please read the attached file. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: converting tables MyISAM to InnoDB

2003-12-22 Thread MySQL Support
Unknown Sender [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi, I recently upgraded from MySQL v3.23 to MySQL 4, and converted my tables from MyISAM to InnoDB by using the ALTER TABLE command. I did this for 16 tables. I know that MyISAM creates seperate data/index files for

InnoDB file data size against MyISAM files data sizes

2003-12-22 Thread MySQL Support
Hello, My HDD is running low and I MyISAM tables are keep crashing... I think that converting to InnoDB will be more stable, but what about the data files sizes? convertion to InnoDB will need more or less disk space than MyISAM? -thanks, Eli -- MySQL General Mailing List For list archives:

Re: Getting a particular row from GROUP BY

2003-12-21 Thread MySQL Support
Michael Shuler [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] What would be the rules for deciding if id 3 should be fr or de? if 'en' does not exist, then it does not matter which language is returned (even be the first available language in the rows order in the DB). But would be

Re: Getting a particular row from GROUP BY

2003-12-21 Thread MySQL Support
Thanks for your help, but it is not giving the result. The problem is that when you make GROUP BY id then the row representing the group is the first row in the group, and adding ORDER BY ... after the group by part just orders the grouped rows, but the grouped rows are in the wrong languages,