- Original Message -
> From: "Gary Aitken"
>
> surprising as the source did not enforce uniqueness. My problem is
> the load data simply dies without indicating which line of the input
> file was in error; the error message refers to line 3, which is not
> even the SQL statement for the
Did you try using "IGNORE" keyword while using the LOAD DATAFILE command.
This will ignore duplicate rows from getting inserted and proceed further.
On Fri, Jun 15, 2012 at 11:05 AM, Keith Keller <
kkel...@wombat.san-francisco.ca.us> wrote:
> On 2012-06-14, Gary Aitken wrote:
> >
> > So... I wa
On 2012-06-14, Gary Aitken 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 a file. What am
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 di
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 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 are very carefu
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
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
> 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 report
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 happeni
http://bugs.mysql.com/bug.php?id=27877
W.T.
> - Original Message -
>> From: "Rick James"
>>
>> 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
- Original Message -
> From: "Rick James"
>
> 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.
The unix boys
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
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
w
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; U
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; U
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 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 terms
17 matches
Mail list logo
