mysql/os stuck

Hello, i have a strange problems appeared 2 week ago'. During the night with no apparently strange task mysql hang and if i try to do some query i have as result: 1) big timeout... or directly no response 2) ERROR 1018 (HY000): Can't read dir of '.' (errno: 24) to fix the problem i have to

Re: mysql/os stuck

Marco 2) ERROR 1018 (HY000): Can't read dir of '.' (errno: 24) It seems The current process(mysqld?) can't read current environment. #define EMFILE 24 /* Too many open files */ you have to resolve the environment any of resource below.. CPU(dual core/quad core) memory(need more

Re: bug_report

Hi Alksey, all ! Aleksey Fadeev wrote: preserve-dup-deps You are using a pretty weird mail format - nearly no body, just an attachment (which doesn't get quoted for replies). Also, in general it would be helpful if a bug report about build issues would list the MySQL version, the

Re: which query solution is better?

mysql performs slow with a subquery, its better to use sql without subquery On 7/8/08, Lamp Lists [EMAIL PROTECTED] wrote: - Original Message From: John Hicks [EMAIL PROTECTED] To: Lamp Lists [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Tuesday, July 8, 2008 11:20:16 AM

Insert into...on duplicate key problem

Is it possible to do an insert into with subselect and group by with an additional on duplicate insert ? CREATE TABLE NEW_TABLE ( `a` varchar(10), `b` double ) engine=MyISAM; INSERT INTO NEW_TABLE (select old.x,sum(old.y) from OLD_TABLE old group by old.a) on duplicate key update

Re: Insert into...on duplicate key problem

I think that you need to select old.a otherwise you cannot group by it. Arthur On 7/9/08, Phil [EMAIL PROTECTED] wrote: Is it possible to do an insert into with subselect and group by with an additional on duplicate insert ? CREATE TABLE NEW_TABLE ( `a` varchar(10), `b` double )

Super slow query

Can someone spot a way to improve the performance of this query? I see that every time it runs, it's Copying to tmp table and then Creating sort index and taking way too long. select count(distinct(stats.ip)) as popcount, stats.id, episodes.title from stats, episodes where

Re: Insert into...on duplicate key problem

you should say group by old.x and not old.a On 7/9/08, Arthur Fuller [EMAIL PROTECTED] wrote: I think that you need to select old.a otherwise you cannot group by it. Arthur On 7/9/08, Phil [EMAIL PROTECTED] wrote: Is it possible to do an insert into with subselect and group by with an

Multi-Language Web Content

Hi, I am in the planning stages of a multi-language web-content user management system. I may not be here to support this app forever so priority is on maintainability, scalability (pref. by less experienced programmers or laymen) We have a bunch of questionnaire type pages (name,

Re: Super slow query

On Wed, Jul 9, 2008 at 12:47 PM, Brian Dunning [EMAIL PROTECTED] wrote: Can someone spot a way to improve the performance of this query? I see that every time it runs, it's Copying to tmp table and then Creating sort index and taking way too long. You're sorting by a computed field. That's

Re: mysql/os stuck

Marco mangione wrote: Hello, i have a strange problems appeared 2 week ago'. During the night with no apparently strange task mysql hang and if i try to do some query i have as result: 1) big timeout... or directly no response 2) ERROR 1018 (HY000): Can't read dir of '.' (errno: 24) to fix the

RE: Multi-Language Web Content

I guess I don't understand the issue. Do you want to display the text equivalent of the occupation code in the language associated with the person in the database, or in the putative language used by the web browser? -Original Message- From: Ben A. Hilleli [mailto:[EMAIL PROTECTED] Sent:

Re: Multi-Language Web Content

Ben A. Hilleli wrote: Obviously this poses a problem for 'normal' relational-databases No, it just takes a little indirection to represent this in a properly normalized fashion. What you need is: 1. A table of language names mapped to IDs: Languages INTEGER id AUTO_INCREMENT

Re: Insert into...on duplicate key problem

Sorry, that was just a typo, should have been INSERT INTO NEW_TABLE (select old.x,sum(old.y) from OLD_TABLE old group by old.x) on duplicate key update b=sum(old.y); but this gives ERROR (HY000): Invalid use of group function INSERT INTO NEW_TABLE (select old.x,sum(old.y) from

Re: Moving Database from Windows to Linux

Aaron Aaron Blew さんは書きました: mysqldump -u USERNAME -p -h WINDOWS_HOST --opt DATABASE | mysql -u root -h localhost DATABASE perfect answer.. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql/os stuck

MarisR さんは書きました: 2) ERROR 1018 (HY000): Can't read dir of '.' (errno: 24) to fix the problem i have to reboot the entire server. Maybe check out file system consistency, check logs. Yes. create new partition, and move /var/lib/mysql/ to new partion. It may avoids OS dependent file problem.

RPM files

Hello I downloaded some of the document files but the file extension is rpm. How does one extract this file? Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]