RE: NoSQL help

2012-06-14 Thread Manivannan S.
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

Re: NoSQL help

2012-06-14 Thread Ananda Kumar
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

RE: NoSQL help

2012-06-14 Thread Manivannan S.
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;

RE: NoSQL help

2012-06-14 Thread Manivannan S.
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;

ANN: Data Wizard for MySQL 12.6 released

2012-06-14 Thread SQL Maestro Team
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

Re: NoSQL help

2012-06-14 Thread Ananda Kumar
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

Re: Minor collation question

2012-06-14 Thread Johan De Meersman
- 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.

Re: Minor collation question

2012-06-14 Thread walter
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,

RE: NoSQL help

2012-06-14 Thread Rick James
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

RE: NoSQL help

2012-06-14 Thread Rick James
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

RE: Is there any performance difference, maintaining separate ibdata files for each and every table insted of having one singl tabale for all databases.

2012-06-14 Thread Rick James
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

Re: Is there any performance difference, maintaining separate ibdata files for each and every table insted of having one singl tabale for all databases.

2012-06-14 Thread Prabhat Kumar
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

Re: i need advice on redundancy of mysql server.

2012-06-14 Thread Joey L
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

console input

2012-06-14 Thread Gary Aitken
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

Re: console input

2012-06-14 Thread Keith Keller
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