aelius Posted June 28, 2012 Report Share Posted June 28, 2012 (edited) Ori e privacy ori nu mai e ?mysql> use rstcenter;Database changedmysql> update post set ipaddress ='127.0.0.1';Query OK, 354914 rows affected (9.30 sec)Rows matched: 355196 Changed: 354914 Warnings: 0mysql> update adminlog set ipaddress ='127.0.0.1';Query OK, 54802 rows affected (0.13 sec)Rows matched: 54852 Changed: 54802 Warnings: 0mysql> update moderatorlog set ipaddress ='127.0.0.1';Query OK, 792 rows affected (0.01 sec)Rows matched: 792 Changed: 792 Warnings: 0mysql> update searchlog set ipaddress ='127.0.0.1';Query OK, 283 rows affected (0.00 sec)Rows matched: 283 Changed: 283 Warnings: 0mysql> update threadrate set ipaddress ='127.0.0.1';Query OK, 2341 rows affected (0.00 sec)Rows matched: 2347 Changed: 2341 Warnings: 0Adresa ip de la toate posturile de pe forum a fost schimbata in 127.0.0.1 (la toti utilizatorii) Edited June 28, 2012 by aelius Quote Link to comment Share on other sites More sharing options...
AlStar Posted June 28, 2012 Report Share Posted June 28, 2012 Ce-ti veni? Quote Link to comment Share on other sites More sharing options...
Zatarra Posted June 28, 2012 Report Share Posted June 28, 2012 Useless.. sti prea bine ca mai sunt metode sa ai ip-urile Quote Link to comment Share on other sites More sharing options...
aelius Posted June 28, 2012 Author Report Share Posted June 28, 2012 Useless.. sti prea bine ca mai sunt metode sa ai ip-urile E logging off pe web. "Clean-ul" a fost doar pe posturile existente Quote Link to comment Share on other sites More sharing options...
DarkyAngel Posted June 28, 2012 Report Share Posted June 28, 2012 Query OK, 354914 rows affected (9.30 sec)c? bine se mi?c? ! Quote Link to comment Share on other sites More sharing options...
aelius Posted June 28, 2012 Author Report Share Posted June 28, 2012 (edited) Query OK, 354914 rows affected (9.30 sec)c? bine se mi?c? ! E MyISAM, avand in vedere ca se face locking la greu pe tabela atunci cand este accesata (spre diferenta de InnoDB), 9.3 sec query time pe 354.914 inregistrari, este destul de fast.PS:Threads: 14 Questions: 258597548 Slow queries: 8810 Opens: 18144 Flush tables: 1 Open tables: 14626 Queries per second avg: 664.211 Edited June 28, 2012 by aelius Quote Link to comment Share on other sites More sharing options...
SticKyWoX Posted June 28, 2012 Report Share Posted June 28, 2012 Bun asa! Chiar, ce-ti veni? Quote Link to comment Share on other sites More sharing options...
totti93 Posted June 28, 2012 Report Share Posted June 28, 2012 (edited) Asta da privacy! Trebuia sa faci asa:mysql> update `table` set ipaddress ='127.0.0.1' WHERE username != 'empathy' /*_|_*/;Oricum nu stiu structura tabelelor (presupun ca e `uid` in loc de `username`). Era doar o chestie `Anti-Polonic`. Edited June 28, 2012 by totti93 Quote Link to comment Share on other sites More sharing options...
romanul Posted June 29, 2012 Report Share Posted June 29, 2012 frumos, bv. Quote Link to comment Share on other sites More sharing options...