Re: load data infile and character set

Hi, Try this. set session collation_database=latin1_swedish_ci; set session character_set_database=latin1; regards anandkl On 10/29/07, Dušan Pavlica [EMAIL PROTECTED] wrote: Are you sure your file is coded in utf8? Character set of your file must be same as charset of your database.

Under utilization of CPU by MySQL

Hello friends, I'm using MySQL5 on RHEL5. From the top, i understood that the CPU is under utlized by MySQL, whose idle time is around 37%. It is dedicated box for MySQL alone. Is there any way to reduce the idle time of the CPU or how can i make my MySQL to Utilize the full CPU time.

Re: Under utilization of CPU by MySQL

Hi Devi, If idle time is around 37%, it means your cpu is 63% utilized. It again depends on what kind of query is running on ur system. Can u also please check %us, %wa and %sy. %us will give amount cpu utilized by any applicaiton running on the machine. %wa will give amount of wait io. %sys

Re: load data infile and character set

Are you sure your file is coded in utf8? Character set of your file must be same as charset of your database. Dusan Caleb Racey napsal(a): Does anyone know how to get the load data infile command to load utf8 data? I have setup a database as utf8 with a collation of utf8_general_ci, the

Re: Under utilization of CPU by MySQL

Hi Anand, Thanks for the immediate response. The us% is around 50 and sy% is around 10. Other than idle some 3-5% was given to software hardware interrupts. If not wrong, for any application, we can estimate the performance level only it its idle time is less than 5%. Thanks DEVI.G

Re: Under utilization of CPU by MySQL

This says, that all app running on this machine are using 50% CPU (50%us). If not wrong, for any application, we can estimate the performance level only it its idle time is less than 5%. What do u mean by the above statement. regards anandkl On 10/29/07, Devi [EMAIL PROTECTED] wrote: Hi

Re: Under utilization of CPU by MySQL

Hi, I'm running only MySQL in that machine. That's why i can't understand why it consumes only 50% of CPU. Interestingly its nice% is also 0. I mean only if MySQL utilizes the full CPU, i can estimate the performance of MySQL for different Client Applications. Thanks DEVI.G -

Re: Mysql and filesystems question

Thanks for the answer :) Yes, you are right about fedora. I forgot to tell that we are moving the servers to CentOS 5 now :) i think also that other important thing that i forgot to tell is that our databases use INNODB engine. i'm waiting for other opinions. -- MySQL General Mailing List

Re: Under utilization of CPU by MySQL

with this CPU load, is there any database slowness or any other issues. regards anandkl On 10/29/07, Devi [EMAIL PROTECTED] wrote: Hi, I'm running only MySQL in that machine. That's why i can't understand why it consumes only 50% of CPU. Interestingly its nice% is also 0. I mean only

Re: Mysql and filesystems question

B. Keith Murphy wrote: I dashed off this email too fast. What I meant to say was I am migrating our data partitions for MySQL from reiserfs to xfs because xfs has faster write rates than reiserfs. Those fast writes come at a price. There is no way I'd have any important data on XFS. Dave

Re: Under utilization of CPU by MySQL

no.. i had an impression that the slowness can be perfectly measured only if i have very less idle CPU.. My worries how to make MySQL to utilize the fullest CPU time.. either in User/Nice mode. Thanks DEVI.G - Original Message - From: Ananda Kumar To: Devi Cc:

Re: Under utilization of CPU by MySQL

Hi ! Devi wrote: Hi, I'm running only MySQL in that machine. That's why i can't understand why it consumes only 50% of CPU. Interestingly its nice% is also 0. Like any other user program (as seen from the operating system point of view), the MySQL server will use all CPU cycles it is

Re: Under utilization of CPU by MySQL

At 04:13 AM 10/29/2007, Devi wrote: I'm running only MySQL in that machine. That's why i can't understand why it consumes only 50% of CPU. Because MySQL has to wait for the hard disk. If your table fits into memory, then make it a memory table and CPU utilitization should increase

ibdata file size

hi all, i don't understand the size of the ibdata7 -rw-rw1 mysqlmysql2.0G Oct 29 15:18 ibdata1 -rw-rw1 mysqlmysql2.0G Oct 29 15:17 ibdata2 -rw-rw1 mysqlmysql2.0G Oct 29 15:17 ibdata3 -rw-rw1 mysqlmysql2.0G Oct 29

Re: load data infile and character set

Ananda Kumar wrote: Hi, Try this. set session collation_database=latin1_swedish_ci; set session character_set_database=latin1; Rather: set session collation_database=utf8_general_ci; set session character_set_database=utf8; Also, make sure you have these in my.cnf: [client]

Re: ibdata file size

In the last episode (Oct 29), Thomas Raso said: i don't understand the size of the ibdata7 -rw-rw1 mysqlmysql2.0G Oct 29 15:18 ibdata1 -rw-rw1 mysqlmysql2.0G Oct 29 15:17 ibdata2 -rw-rw1 mysqlmysql2.0G Oct 29 15:17 ibdata3

Re: ibdata file size

There is no way whitout stopping mysql ? for information it is a version 4.1 2007/10/29, Dan Nelson [EMAIL PROTECTED]: In the last episode (Oct 29), Thomas Raso said: i don't understand the size of the ibdata7 -rw-rw1 mysqlmysql2.0G Oct 29 15:18 ibdata1 -rw-rw

Re: ibdata file size

In the last episode (Oct 29), Thomas Raso said: 2007/10/29, Dan Nelson [EMAIL PROTECTED]: In the last episode (Oct 29), Thomas Raso said: i don't understand the size of the ibdata7 -rw-rw1 mysqlmysql2.0G Oct 29 15:18 ibdata1 -rw-rw1 mysqlmysql2.0G Oct

Re: Post Installation for Mysql on Ubuntu

sudo apt-get install mysql-server Should install it. It will even create the user account for you... http://www.supriyadisw.net/2006/12/lamp-installation-on-ubuntu Has further information. Scroll down to MySQL. On 10/29/07, Tim Johnson [EMAIL PROTECTED] wrote: Hello: I am preparing to

Re: ibdata file size

ok thanks, this mysql has got a replication slave... On the slave the ibdata has got a size close to 15Go (ie the master's size is 22Go) have you got an idea about this ??? thanks 2007/10/29, Dan Nelson [EMAIL PROTECTED]: In the last episode (Oct 29), Thomas Raso said: 2007/10/29, Dan

Re: query question

Hi, Andrey Dmitriev wrote: This is kind of achievable in Oracle in either sqlplus mode, or with the use of analytical functions. Or in the worst case by writing a function. But basically I have a few tables Services, Hosts, service_names And I can have a query something like select

Fulltext Relevancy not returning anticipated results?

I have a database of products, doing a search on them trying to achieve a modicum of relevancy, but am getting a strange result on some returned rows: QUERY: select *,match(code) against ('vic*' IN BOOLEAN MODE) * 8 + match(name) against ('vic*' IN BOOLEAN MODE) * 4 + match(small_desc) against

query question

This is kind of achievable in Oracle in either sqlplus mode, or with the use of analytical functions. Or in the worst case by writing a function. But basically I have a few tables Services, Hosts, service_names And I can have a query something like select service_names.name as 'Service',

Replace on Join

I'm trying to do a join on two pieces of data that are not quite exactly the same. Basic story, I have 2 tables (output from 2 mainframes) in MySQL where one table has our email addresses as @wncc.edu (our old name) and the other has it as @wnc.edu (our new name). So here is an abbreviated

Re: Replace on Join

How about this ... update schedule s join directory d on s.email = replace(d.email, '@wnc.edu', '@wncc.edu') set s.email=replace(s.email, '@wncc.edu', '@wnc.edu' ); PB - Kevin Murphy wrote: I'm trying to do a join on two pieces of data that are not quite exactly the same. Basic story, I

Re: Problem with *very* slow replication

On Thu, 25 Oct 2007, [EMAIL PROTECTED] wrote: Not sure that I get the whole picture. We have been running replication since about 4.0 and we have been through several upgrades and are now at 5.0.27. The 'show slave status' always gives us an accurate reflection of where it is at which is

Sort results by order in list

Hello, I have a query like: SELECT id, start_date FROM iddt WHERE id IN ('109k7','s3x6','sxmns','wt57'); which gives me: +---+-+ | id| start_date | +---+-+ | 109k7 | 2007-10-07 12:06:58 | | sxmns | 2007-10-06 02:17:30 | | wt57 |

RE: query question

Thanks.. It doesn't seem to work though.. I did verify I am on 5.0 mysql select service_names.name as 'Service', - group_concat (hosts.name) - from monarch.hosts as hosts, monarch.services as services, monarch.service_names as service_names - where -

Re: Sort results by order in list

I.e. the ideal output would be: +---+-+ | id| start_date | +---+-+ | 109k7 | 2007-10-07 12:06:58 | | s3x6 | 2007-10-07 08:58:20 | | wt57 | 2007-10-07 15:57:37 | | sxmns | 2007-10-06 02:17:30 | +---+-+ What

Re: query question

Thanks.. It doesn't seem to work though.. I did verify I am on 5.0 Try lose the space after group_concat. PB Andrey Dmitriev wrote: Thanks.. It doesn't seem to work though.. I did verify I am on 5.0 mysql select service_names.name as 'Service', - group_concat (hosts.name) - from