Dear all,
Today i am creating a partition table in my mysql server
5.1.34-community-log .
create table sample( a integer, dt_stamp timestamp not null default
current timestamp, content varchar)engine= innodb
PARTITION BY RANGE ( UNIX_TIMESTAMP(dt_stamp) ) (
-> PARTITION p0 VALUES LES
And also make sure that you have the SUPER privilege to kill it.
Regards,
KarthiK.P.R
On Fri, Jan 27, 2012 at 9:09 AM, Suresh Kuna wrote:
> login into another session, check the thread id and kill it. ( Kill
> threadid.)
>
> On Fri, Jan 27, 2012 at 3:51 AM, Dotan Cohen wrote:
>
> > If I see t
login into another session, check the thread id and kill it. ( Kill
threadid.)
On Fri, Jan 27, 2012 at 3:51 AM, Dotan Cohen wrote:
> If I see that a query is taking a long time to finish, how can I
> interrupt the MySQL CLI interpreter? Ctrl-C does not work. Thanks.
>
> --
> Dotan Cohen
>
> http
>>>> 20120126 10:34 AM +0200, a bv >>>>
Database contains
tables (structures?) which gets montly data , and these tables are
named as
name1_name2_ yearmonth . I only want to have the whole database system
for last 2 years, and automaticly clean the data which became more
thanks. it took about 15 hrs. but right now everything seems ok. does
the check last as long as the repair?
On 1/24/12 3:51 AM, Johan De Meersman wrote:
> - Original Message -
>> From: "kalin m"
>>
>> ok. thanks. i thought so. it's been about 8 hrs so far. and the TMD
>> file is about h
Mysqld crashes when I try to dump everything at once. I made a test by
extracting information from only one table, and it worked. I will try yet with
another tables. But I guess that is it... Thanks a lot, people. You were great.
=)
-Mensagem original-
De: Johan De Meersman [mailto:vegi
- Original Message -
> From: "Todd Lyons"
>
> It doesn't matter what you set in innodb_force_recovery. If you do
> not have the obras.frm file (which contains the schema definition of
> the table), I don't know if you can retrieve the info. Put that file
I recommended he delete that f
2012/1/26 Suporte Avanutri :
[At this point I deleted the table “obras.frm”. Still trying to dump,
crashing every time, and restarting mysqld with a higher
“innodb_force_recovery” value at a time]
It doesn't matter what you set in innodb_force_recovery. If you do
not hav
Ok. Well, I put the entire log right below:
120126 12:12:49 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer.
