pra não esquecer…

março 29th, 2011

Mysql performance – MaatKit

Posted by Felipe Olivaes in MySQL

http://www.petefreitag.com/item/724.cfm

included in Maatkit:

* mk-archiver Archive rows from a MySQL table into another table or a file.
* mk-audit Analyze, summarize and report on MySQL config, schema and operation
* mk-checksum-filter Filter checksums from mk-table-checksum.
* mk-deadlock-logger Extract and log MySQL deadlock information.
* mk-duplicate-key-checker Find duplicate indexes and foreign keys on MySQL tables.
* mk-fifo-split Split files and pipe lines to a fifo without really splitting.
* mk-find Find MySQL tables and execute actions, like GNU find.
* mk-heartbeat Monitor MySQL replication delay.
* mk-kill Kill MySQL queries that match certain criteria.
* mk-loadavg Watch MySQL load and take action when it gets too high.
* mk-log-player Split and play MySQL slow logs.
* mk-parallel-dump Dump sets of MySQL tables in parallel.
* mk-parallel-restore Load files into MySQL in parallel.
* mk-profile-compact Compact the output from mk-query-profiler.
* mk-query-digest Parses logs and more. Analyze, transform, filter, review and report on queries.
* mk-query-profiler Execute SQL statements and print statistics, or measure activity caused by other processes.
* mk-show-grants Canonicalize and print MySQL grants so you can effectively replicate, compare and version-control them.
* mk-slave-delay Make a MySQL slave server lag behind its master.
* mk-slave-find Find and print replication hierarchy tree of MySQL slaves.
* mk-slave-move Move a MySQL slave around in the replication hierarchy.
* mk-slave-prefetch Pipeline relay logs on a MySQL slave to pre-warm caches.
* mk-slave-restart Watch and restart MySQL replication after errors.
* mk-table-checksum Perform an online replication consistency check, or checksum MySQL tables efficiently on one or many servers.
* mk-table-sync Synchronize MySQL tables efficiently.
* mk-upgrade Execute SQL statements against two MySQL servers and compare the results.
* mk-visual-explain Format EXPLAIN output as a tree.

agosto 20th, 2009

database hacks

Posted by Felipe Olivaes in Firebird, MS SQL Server, MySQL, Postgre SQL

realmente muito bom, dica do ara”ú”jo! =)

http://pentestmonkey.net/blog/mysql-sql-injection-cheat-sheet/
http://pentestmonkey.net/blog/postgres-sql-injection-cheat-sheet/
http://pentestmonkey.net/blog/oracle-sql-injection-cheat-sheet/
http://pentestmonkey.net/blog/mssql-sql-injection-cheat-sheet/
http://pentestmonkey.net/blog/ingres-sql-injection-cheat-sheet/
http://pentestmonkey.net/blog/db2-sql-injection-cheat-sheet/
http://pentestmonkey.net/blog/informix-sql-injection-cheat-sheet/

crack mysql hash password:
http://www.openwall.com/john/

agosto 6th, 2009

erro foreign key mysql

Posted by Felipe Olivaes in MySQL

Cannot add or update a child row: a foreign key constraint fails

Só adicionar isso no início do arquivo SQL:

set foreign_key_checks = 0;

fevereiro 25th, 2009

corrigindo o error 150 (#10005) no MySQL

Posted by Felipe Olivaes in MySQL

– Todas as tabelas do tipo InnoDB;
– Deve haver um indíce na tabela de origem e destino corresponde a nova chave estrangeira;
– Não são suportados para este tipo de relacionamento, campos text e blob;
– Os campos devem ter o mesmo tipo (em todas as características);
– Atenção, até UNSIGNED faz diferença;




nuvem de tags:

24 horas acentuação Apache bash benchmark bios boot celular centos charset comando console Download esxi Firebird firefox http importação intel ipod kinghost legenda Linux lost mod_deflate msn mssql MySQL owner Padel PHP placa mãe portabilidade Postgre SQL recovery root password rewrite shell sinuca sql server svn temporada completa veronica mars vmware Windows ícones