The query doesn't use the specified indexes

2010-06-21 Thread Octavian Rasnita
. Thanks. -- Octavian __ Information from ESET NOD32 Antivirus, version of virus signature database 5214 (20100621) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com

Re: The query doesn't use the specified indexes

2010-06-21 Thread Joerg Bruehe
Hi Octavian, all! Octavian Rasnita wrote: Hi, I have made an InnoDB table and I am trying to search using some keys, but they are not used, and the query takes a very long time. Here is a test table: CREATE TABLE `test` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `symbol`

MySQL crashes

2010-06-21 Thread Charlene
Anybody have any idea why MySQL would start to have this error message every 4 or so days at midnight: Connection error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) This just started happening a little more than 2 weeks ago. The server has been

Re: MySQL crashes

2010-06-21 Thread Tyler Poland
Charlene, You should check the mysql error log and if there isn't a message about the cause there you may want to check /var/log/syslog for mysql being killed by oomkiller. Tyler On 6/21/10 11:11 AM, Charlene wrote: Anybody have any idea why MySQL would start to have this error message

Re: MySQL crashes

2010-06-21 Thread Ann W. Harrison
Charlene wrote: Anybody have any idea why MySQL would start to have this error message every 4 or so days at midnight: Do look at the logs, but if the error always occurs at midnight, you might look for a disk backup or compression program that's scheduled to run than and accesses the

Re: MySQL crashes

2010-06-21 Thread Guifre Bosch Fabregas
you can stop your Mysql server (the program) and delete the file mysql.sock and the try to start. 2010/6/21 Tyler Poland tpol...@engineyard.com Charlene, You should check the mysql error log and if there isn't a message about the cause there you may want to check /var/log/syslog for mysql

A Marco Zoptta desk lamp

2010-06-21 Thread Vanpeez1
I have a Marco Zotta Arcobaleno desk lamp that requires repair. The Museum of Modern Art in NYC has one in its collectionon. The transformer needs replacing. Can you advise who can do what is required and where can repair be done?. It is shown on Marco Zotta's website. Your advice will be