I tried with myisam engine also. But it also taking more time to generate the
report. In my database I am having 8 innodb tables and at the same time I am
joining 4 tables to get the report.
I am maintaining 60days records because the user will try to generate the
report out of 60 days in
can u share the sql, explain plan, indexes etc,
show full processlist out put when the sql's are running
On Thu, Jun 14, 2012 at 3:03 PM, Manivannan S.
manivanna...@spanservices.com wrote:
I tried with myisam engine also. But it also taking more time to generate
the report. In my database I
id
select_type
table
type
possible_keys
key
key_len
ref
rows
Extra
1
SIMPLE
ibf
ALL
ibf_MsgId
\N
\N
\N
160944
1
SIMPLE
pl
ref
idx_unique_key_ib_msg\,index_message_id\,index_message_processing_status
idx_unique_key_ib_msg
180
reports.ibf.Message_Id\,const
1
Using where;
id
select_type
table
type
possible_keys
key
key_len
ref
rows
Extra
1
SIMPLE
ibf
ALL
ibf_MsgId
\N
\N
\N
160944
1
SIMPLE
pl
ref
idx_unique_key_ib_msg\,index_message_id\,index_message_processing_status
idx_unique_key_ib_msg
180
reports.ibf.Message_Id\,const
1
Using where;
Hi!
SQL Maestro Group announces the release of Data Wizard for MySQL 12.6,
a powerful Windows GUI solution for MySQL data management.
The new version is immediately available at
http://www.sqlmaestro.com/products/mysql/datawizard/
Data Wizard for MySQL provides you with a number of easy-to-use
As seen below,
Full table scan is happening on table ibf.
Can share the indexes on this table and also the complete sql
On Thu, Jun 14, 2012 at 4:17 PM, Manivannan S.
manivanna...@spanservices.com wrote:
id
select_type
table
type
possible_keys
key
- Original Message -
From: Rick James rja...@yahoo-inc.com
A warning about β -- There was a change in the collation at 5.1.24.
Search http://mysql.rjweb.org/doc.php/charcoll for 'German'; there is
a brief discussion near the end.
Aha, also a very good bit of information, thank you.
http://bugs.mysql.com/bug.php?id=27877
W.T.
- Original Message -
From: Rick James rja...@yahoo-inc.com
A warning about β -- There was a change in the collation at 5.1.24.
Search http://mysql.rjweb.org/doc.php/charcoll for 'German'; there is
a brief discussion near the end.
Aha,
SHOW CREATE TABLE
SHOW TABLE STATUS
EXPLAIN SELECT ... \G
-Original Message-
From: Ananda Kumar [mailto:anan...@gmail.com]
Sent: Thursday, June 14, 2012 4:04 AM
To: Manivannan S.
Cc: mysql@lists.mysql.com
Subject: Re: NoSQL help
As seen below,
Full table scan is happening on
the report out of 60 days in terms of second, minute, hourly, weekly and
Monthly report also
1-second reports?? Wouldn't that have millions of rows? Is there anything
useful to summarize?
For Second and Minute over narrow ranges, you might do fine reading the raw
data.
For hourly reports
There should be little or no difference.
If you are using thousands of tables, you might encounter overhead in opening
the .ibd files.
If you are tight on disk space, a single ibdata1 might be more efficient at
reusing free blocks.
OTOH, if you shrink or drop a big table, the freed space is not
there is performance issues with a larger number of datafiles than a
single, that the reason innodb_file_per_table in not a default option.
other, with innodb_file_per_table, you'll use more resources, there can be
a problem if you have _many_ tables, there is obviously the problem to
keep number
Guys - thanks for the replys - do any of you guys are on odesk or elancer.com ??
thanks
On Wed, Jun 13, 2012 at 7:28 PM, Rick James rja...@yahoo-inc.com wrote:
I prefer:
* Master-Master (dual master) but write to only one of them. (Writing to
both can lead to duplicate keys, etc., unless you
Hi all,
I've looked high and low for what I hope is a trivial answer.
I was trying to load a table using LOAD DATA INFILE. Unfortunately, it craps
out because there are some duplicate primary keys. Not surprising as the
source did not enforce uniqueness. My problem is the load data simply
On 2012-06-14, Gary Aitken my...@dreamchaser.org wrote:
So... I wanted to read the data line at a time and use a plain INSERT
statement. That way I could check for duplicate keys and discover where the
duplicate records are. However, I can't find a way to read input from the
console or
15 matches
Mail list logo