Re: To:, CC: & mailing lists

2015-05-17 Thread hsv
On 2015/05/17 14:10, Jigal van Hemert wrote: I've set filters on "To: or Cc: contains" to catch all the mails. The others in this thread use Gmail which obviously lacks a button "Reply to list". One does not need such a button, only attention to the addressee list that one s e-mail client produc

Re: deleting big tables

2015-05-17 Thread wagnerbianchi.com
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

Re: To:, CC: & mailing lists

2015-05-17 Thread Reindl Harald
Am 17.05.2015 um 20:10 schrieb Jigal van Hemert: Hi, On 17/05/2015 11:37, Emil Oppeln-Bronikowski 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. I've set filters on "To: or Cc: contains

Re: To:, CC: & mailing lists

2015-05-17 Thread Jigal van Hemert
Hi, On 17/05/2015 11:37, Emil Oppeln-Bronikowski 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. I've set filters on "To: or Cc: contains" to catch all the mails. The others in this thread

Re: deleting big tables

2015-05-17 Thread Suresh Kuna
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

Re: deleting big tables

2015-05-17 Thread Pau Marc Muñoz Torres
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

Re: deleting big tables

2015-05-17 Thread Pau Marc Muñoz Torres
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

To:, CC: & mailing lists (was: Re: deleting big tables)

2015-05-17 Thread Emil Oppeln-Bronikowski
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

Re: deleting big tables

2015-05-17 Thread Pothanaboyina Trimurthy
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

Re: deleting big tables

2015-05-17 Thread Adarsh Sharma
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

Re: deleting big tables

2015-05-17 Thread Pau Marc Muñoz Torres
this is my process list ++--+---+--+-++-+--+ | Id | User | Host | db | Command | Time | State | Info | ++--+---+--