Fwd: Mysql tuning - server Crash 2

show status (now) +--+--+ | Variable_name| Value| +--+--+ | Aborted_clients | 1| | Aborted_connects | 2| | Bytes_received | 18819744 | | Bytes_sent | 67675629 |

nested aliases in select

Hi all. Can somebody explain to me why the following SELECT doesn't work?: SELECT COUNT(DISTINCT(CONCAT(contact_firstname,' ',contact_lastname) as contact_name)) as count FROM Contacts GROUP BY contact_ident ORDER BY contact_name; The table has: contact_ident contact_firstname contact_lastname

Mysql tuning - server Crash 1

Hi there, I have a problem with mysql. I have an application basically to track clicks to my website and last night it crashed. Can you have a look aty my situation? I run a server with 2GB RAM and a XEON processor! Thank you. - Max - error log - InnoDB: Warning: a long semaphore wait:

msAccess to Mysql on Linux

Hi, I'm trying to move databases from msaccess to Mysql and do this on a Linux machine. i have used following tools mdbtools: mdb-export -d# ./recepten.mdb tblRecepten recepten.txt dos2unix: dos2unix recepten.txt mysqlimport: mysqlimport -uroot -p --fields-terminated-by='#'

Problem with system tables

Hi, I'm working on a Linux Red Hat 7 (core 2.4.2-2), with Apache 2.0.53, PHP 5.0.3 and I'm trying to upgrade MySQL to version 4.1.10 with the rpms (I downloaded all of them). When i try to install, it reports a couple of errors here is screen shot sudo rpm --install -vv --force MySQL*.rpm

xml import

Hi, I seems not to figure out how to import a xml file into mysql 4.x I'm working on, Linux, help would he fine. Patrick -- You're dead, Jim. -- McCoy, Amok Time, stardate 3372.7.. Fingerprint = 2792 057F C445 9486 F932 3AEA D3A3 1B0C 1059 273B ICQ# 316932703 Registered Linux User #44550

InnoDB Rollback - 162 hrs remaining!?

Hi, We have a large InnoDB table to which we recently added an index. That index creation thread was issued a kill yesterday due to length of time, unfortunately according to 'show innodb status' the rollback is now 162 hrs away from completion (1 every 5 secs). We are not using per-table

mysql cpu usage

hi everybody, PLATFORM: MySQL 4.1.8 version,OS:windowsXP We are working on a project that requires MySQL database monitoring. As part of it we monitor the network traffic to and from MySQL,harddisk space used by Mysql ,primary memory used by it and so on.As part of it we need to

Re: getting type of field

At 14:49 -0800 2/25/05, Mohsen Pahlevanzadeh wrote: Dears, I need to get type of my field in C. I didn't find a func for it job. Please guide me Yours,Mohsen If you mean you want the data type of a column in a result set generated by a query, the information you want is in the manual:

Re: Primary Keys, Multiple Index and Searching

Hello. So in this case MySQL will choose to use the largest index that suits MySQL will choose index which returns less rows. Given the high cardinality of `manufacturer` Cardinality - the number of unique values in the index. So manufacturer index usually has low cardinality and

Re: InnoDB Rollback - 162 hrs remaining!?

John, - Original Message - From: John Taylor [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Saturday, February 26, 2005 6:54 PM Subject: InnoDB Rollback - 162 hrs remaining!? Hi, We have a large InnoDB table to which we recently added an index. That index creation thread

Regular Expression Query

I have a client that wants to search table fields for strings, and ignore any-non alphanumeric character in the field. (match only the alphanumeric portion of the field, and discard the rest) for example, a search for apple would return true on the following record a**__-p p + l ^^ @e I

Re: InnoDB Rollback - 162 hrs remaining!?

Thanks for the quick response. I note within the database directory a #sql- file but it has not been modified for two days, around the time the index was begun. Does this have a bearing on matters? Last thing we need is to kill mysqld processes and find the innodb data file is corrupt beyond

Re: Regular Expression Query

Scott Klarenbach wrote: I have a client that wants to search table fields for strings, and ignore any-non alphanumeric character in the field. (match only the alphanumeric portion of the field, and discard the rest) for example, a search for apple would return true on the following record a**__-p

nested aliases in select

Hi all. Can somebody explain to me why the following SELECT doesn't work?: SELECT COUNT(DISTINCT(CONCAT(contact_firstname,' ',contact_lastname) as contact_name)) as count FROM Contacts GROUP BY contact_ident ORDER BY contact_name; The error returned is: ERROR 1064: You have an error in your

Re: xml import

Patrick Marquetecken wrote: I seems not to figure out how to import a xml file into mysql 4.x I'm working on, Linux, help would he fine. XML is an hierarchical format, it does not map directly to a relational database, which has a tabular format. I don't know if there are any general purpose

are you receiving this?

I have sent a couple of emails to the list, but I don't know if they are posting or not, because I haven't received them back from the list, which I assumed I would. Can someone just confirm that this message is indeed being posted? -- MySQL General Mailing List For list archives:

Re: InnoDB Rollback - 162 hrs remaining!?

John, - Original Message - From: John Taylor [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Saturday, February 26, 2005 11:37 PM Subject: Re: InnoDB Rollback - 162 hrs remaining!? Thanks for the quick response. I note within the database directory a #sql- file but it has

Re: nested aliases in select

David Smithson wrote: Hi all. Can somebody explain to me why the following SELECT doesn't work?: SELECT COUNT(DISTINCT(CONCAT(contact_firstname,' ',contact_lastname) as contact_name)) as count FROM Contacts GROUP BY contact_ident ORDER BY contact_name; The error returned is: ERROR 1064: You have

Re: nested aliases in select

At 04:11 PM 2/26/2005, David Smithson wrote: Hi all. Can somebody explain to me why the following SELECT doesn't work?: SELECT COUNT(DISTINCT(CONCAT(contact_firstname,' ',contact_lastname) as contact_name)) as count FROM Contacts GROUP BY contact_ident ORDER BY contact_name; The error returned

Re: Solaris 10 performance improvements??

IIRC MySQL is (or was) developed on Solaris, so it's always been very stable and well supported. As for Linux outperforming Solaris .. 10 is very fast. We have it running in production (since 10_72) at over 1000qps on a dual opteron (8GB) and have never had any performance related problems.

Re: are you receiving this?

Looks like it made it through to here David Smithson wrote: I have sent a couple of emails to the list, but I don't know if they are posting or not, because I haven't received them back from the list, which I assumed I would. Can someone just confirm that this message is indeed being posted? --

Useful Relevance with FullText Boolean Mode - help

Is there any way to make relevance when using boolean mode more useful? If not, are there plans in the future Fulltext development todo for making it useful? I'm thinking of just counting the keyword occurences in records with a PHP script somehow and using that to order the records. Or doing a

Linking problems

Hi there, guys. I'm new to MySQL++. When I try to compile the first simple example of mysql++ tutorial, the following error occurs: g++ -g -O -Wall -I/usr/include/mysql++ -I/usr/include/mysql -c sqltest.cc In file included from sqltest.cc:3:

Re: Mysql tuning - server Crash 1

Max, please post all the relevant contents of the .err log. What MySQL version is this? What Linux version? Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables