How normal mysql server 5.1 uses multiple cores

Hi All, Can anyone provide me any input on How to make mysql use multiple CPU cores avaliable. I am sorry if I am souding very unclear with this. Let me know if you have any questions. Thanks in advance. -- Regards, Manasi Save Artificial Machines Pvt Ltd. -- MySQL General Mailing List

Re: How normal mysql server 5.1 uses multiple cores

MySQL is already a multithreaded process, even though you only see a single process. Note that it doesn't scale very well above eight or so cores, especially InnoDB iirc. If you are wondering about parallel query execution (that is, splitting a single query over multiple cores for faster

Re: How normal mysql server 5.1 uses multiple cores

Hi Johan, Thanks for the quick response. Is there any command available in mysql using which I can check how much CPU is being used by each mysql thread. Or any article where how mysql multi-threading works. -- Thanks and Regards, Manasi Save Artificial Machines Pvt Ltd. MySQL is already a

Re: How normal mysql server 5.1 uses multiple cores

the command 'top -H' will show you the individual threads with their CPU use, but I'm afraid I don't know how to link that up with a MySQL 'show processlist'. On Tue, Nov 24, 2009 at 12:22 PM, Manasi Save manasi.s...@artificialmachines.com wrote: Hi Johan, Thanks for the quick response.

Re: How normal mysql server 5.1 uses multiple cores

2009/11/24 Johan De Meersman vegiv...@tuxera.be: If you are wondering about parallel query execution (that is, splitting a single query over multiple cores for faster execution), that is currently not supported by MySQL. [offtopic] Probably is something stupid, but could that be done with ndb

MySQL Performance with large data

Hi, I am using MySQL 5.0.45 in production environment. One of my tables (using MyISAM Engine) is expected to have around 4 billion records and each record will have 1867 bytes of data. All fields in this table are of character data type. I have 8 GB RAM on the server, RAID 5 with 750 GB

Re: How normal mysql server 5.1 uses multiple cores

At 06:44 AM 11/24/2009, you wrote: 2009/11/24 Johan De Meersman vegiv...@tuxera.be: If you are wondering about parallel query execution (that is, splitting a single query over multiple cores for faster execution), that is currently not supported by MySQL. [offtopic] Probably is something

Re: MySQL Performance with large data

The amount and type of data is less the issue than the amount and type of queries is :-) The machine you've described should be able to handle quite a bit of load, though, if well-tuned. On Tue, Nov 24, 2009 at 4:45 PM, Manish Ranjan (Stigasoft) manish.ran...@stigasoft.com wrote: Hi, I am

RE: MySQL Performance with large data

Thank you Johan. The table will be read only. There will be two steps - first to get the count using search conditions and then to get data from some columns based on those search conditions. The fields will be indexed as per search requirements. _ From: vegiv...@gmail.com

Re: phpMyAdmin links?

Is there a way to have a permalink to pages in phpMyAdmin, particularly record editing pages? I successfully did it -- for a while -- by simply copying the URL when I was on a record editing page and replacing the obvious key GET parameter with a variable. But that URL has a GET parameter

Re: MySQL Performance with large data

First off, for 4.000.000.000 records at 1867 byte per record, you're gonna need more storage than that (over 1.6 terabyte if I did my maths right) , unless you're using compressed tables - then your requirements will strongly depend on the actual data: text may easily compress to a factor ten,

Re: MySQL Performance with large data

I second that RAID 10 with as many spindles as you can get recommendation.. for any kind of load, even read-only load, you are going to need it. Also, that 8G of RAM is paltry for the kind of dataset you propose. As already noted, the particulars will come down to the types and frequency of the

Re: Specific benchmarking tool

Johan, Yes, there are built in parsers for different formats, for example I was using the general log. mk-log-player --split Thread_id --type genlog (genlog was added the other day and is only in trunk so far) http://www.maatkit.org/doc/mk-log-player.html --type type: string; group: Split

Re: Specific benchmarking tool

Yeah, I figured that out in the mean time :-) I was putting the log type right after --split, and the damn thing doesn't think of throwing an 'unknown field' error :-) It's working now, thanks a lot ! On Tue, Nov 24, 2009 at 8:27 PM, ewen fortune ewen.fort...@gmail.comwrote: Johan, Yes,

How to concatenate a constant to an int?

Hello: This seems like it should be simple, but I am having trouble figuring it out. I have a table contact which has: nameString contact_id int Lets assume the contact table has this row: name: Neil Aggarwal contact_id: 1 I want to create a

Re: How to concatenate a constant to an int?

create or replace view view_AllData as select c.name, concat('C',c.contact_id) as ref from contact c On Tue, Nov 24, 2009 at 6:52 PM, Neil Aggarwal n...@jammconsulting.com wrote: Hello: This seems like it should be simple, but I am having trouble figuring it out. I have

RE: How to concatenate a constant to an int?

concat('C',c.contact_id) as ref That worked. Thanks the the tip. Now, lets say I have three tables: contact contact_id int prospect prospect_id int client client_id int If a contact is a prospect, it will have a line in both the contact and prospect table,

Re: How to concatenate a constant to an int?

untested, but you are looking for something like this (formatted for humans): select concat( ifnull( if(l.client_id,'L',null), ifnull( if(p.prospect_id,'P',null), 'C')), c.contact_id) as reference_number, from contact

question regarding mysql database location

Hi All, I have asked this question before But, I think I am not able to describe it better. Sorry for asking it again. I have multiple databases but there is a limit on the folders getting created in one folder. I have mysql default directory set as /var/lib/mysql/data. Now, After 32000 folder

Re: question regarding mysql database location

Also I forgot to mention that I have gone through the innodb option of innodb_data_file_path but I can just specify it as : innodb_data_file_path=ibdata1:2048M:autoextend:max:1024M;ibdata1:2048M:autoextend:max:1024M; But not as :