endorse content contained within
this transmission.
> Date: Wed, 15 Oct 2008 17:09:42 +0530
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Subject: Re: Trouble with large data in MySql
> CC: mysql@lists.mysql.com
>
> Hi,
>
> 1. Since requestid is a primary key then wh
my query? What should I configure in mysql? Can you
> help me with this?
>
>
>
> I have 6GB RAM, 2 cores and 7200 RPM disk with 1TB size.
>
>
>
> Thanks in advance
>
> Karthik
>
>
>
>
>
> *From:* Krishna Chandra Prajapati [mailto:[EMAIL PROTECTE
ance
Karthik
From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 15, 2008 3:43 PM
To: Karthik Pattabhiraman
Cc: mysql@lists.mysql.com
Subject: Re: Trouble with large data in MySql
Hi,
It depends on your query using join and sort. Also, on how much ram you
ha
attabhiraman
> *Cc:* mysql@lists.mysql.com
> *Subject:* Re: Trouble with large data in MySql
>
>
>
> Hi Karthik,
>
> You have many columns in a single table (although you can). But, if you
> break the below table into two tables ( Vertical partitioning). It will help
&
: Re: Trouble with large data in MySql
Hi Karthik,
You have many columns in a single table (although you can). But, if you
break the below table into two tables ( Vertical partitioning). It will
help you to run your query faster. You haven't shown join_buffer_size
and sort_buffer_size.
Sec
can u please show us the output of
show index from ;
On 10/14/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> Hi Karthik,
>
> You have many columns in a single table (although you can). But, if you
> break the below table into two tables ( Vertical partitioning). It will
> help
> yo
Hi Karthik,
You have many columns in a single table (although you can). But, if you
break the below table into two tables ( Vertical partitioning). It will help
you to run your query faster. You haven't shown join_buffer_size and
sort_buffer_size.
Secondly, check your all the queries with explain
Karthik,
I have included some of the parts of your original posting.
You may need to do some experiments, but these actions may help you
greatly. You may also want to consider the book "High Performance
MySQL", it has helped us a lot:
1. Make sure you have indexes on any column
To: mysql@lists.mysql.com
Subject: Trouble with large data in MySql
Hi,
We have 4 tables in which we have approximately 40 Million records
per month. We are having trouble getting results from MySql as it takes
about 4-5 hours to complete for each query. We are using this primarily
for reporting purpos
Hi,
We have 4 tables in which we have approximately 40 Million records
per month. We are having trouble getting results from MySql as it takes
about 4-5 hours to complete for each query. We are using this primarily
for reporting purposes.
My table schema is as follows
SMAS Table:
Colum
10 matches
Mail list logo
