The problem was here:
---TRANSACTION 154B1E00, ACTIVE 265942 sec rollback
mysql tables in use 1, locked 1
ROLLING BACK 297751 lock struct(s), heap size 35387832, 74438247 row
lock(s), undo log entries 66688203
MySQL thread id 37, OS thread handle 0x7f11bc4b9700, query id 110 localhost
pau query en
Your drop index table needs the table rebuild and locked the drop table. In
this case, you have to drop table rather than drop indexes or deleting data.
On Sun, May 17, 2015 at 7:11 AM, Pau Marc Muñoz Torres
wrote:
> i solved the problem by rebooting my computer. i just drop the table in
> secon
i solved the problem by rebooting my computer. i just drop the table in
seconds
thanks
Pau Marc Muñoz Torres
skype: pau_marc
http://www.linkedin.com/in/paumarc
http://www.researchgate.net/profile/Pau_Marc_Torres3/info/
2015-05-17 12:00 GMT+02:00 Pau Marc Muñoz Torres :
> this is the innodb out
this is the innodb output,
i tried to kill the process using kil, kill query and kill connection but
doesn't worked. what can i do?
thanks
150517 11:50:46 INNODB MONITOR OUTPUT
=
Per second averages calculated from the last 3 seconds
-
BACKGRO
On Sun, May 17, 2015 at 02:01:57PM +0530, Pothanaboyina Trimurthy wrote:
Guys, can I implore you to post to a mailing list using its address in To:
field and not CC:ing it? You are constantly breaking out of my filters.
--
vag·a·bond adjective \ˈva-gə-ˌbänd\
a : of, relating to, or characteri
Hi Pou,
Before killing those connections first check for the undo log entries from
the engine innodb status. If there are too many undo log entries it will
take some time to clean up those entries. If you force fully kill those
connections there are more chances to crash the DB instance.
On 17 May
Hi Pou,
This is the reason why your drop commands taking too much time because they
are in waiting state.Even it is quite surprising to me the purpose of the
delete command. I would say ,kill all pids ( 37,58,59,66 ) and just drop
the table ( it will delete everything ). Please take a backup if ne
this is my process list
++--+---+--+-++-+--+
| Id | User | Host | db | Command | Time |
State | Info |
++--+---+--
Hi Pau,
Ideally drop table should not take that much time , you have to check if
your command is executing or it is in waiting stage. May be you are not
able to get lock on that table.
Cheers,
Adarsh Sharma
On Sat, 16 May 2015 at 23:34 Pau Marc Muñoz Torres
wrote:
> Hello every body
>
> i hav
Hi Pau,
Would you please paste the timeout error ? If you want to get rid of a
table then the recommendation is to drop the table in non-peak hours.
Thanks
Suresh Kuna
On Sat, May 16, 2015 at 2:00 PM, Pau Marc Muñoz Torres
wrote:
> Hello every body
>
> i have a big table in my sql server and
Hello every body
i have a big table in my sql server and i want to delete it, it also have
some indexes. I tried to "drop table" and "delete" commands but i
eventually get a time out. Wath can i do with it, does it exist any method
to delete tables quicly?
i know that drop and delete are not equ
11 matches
Mail list logo
