unimportant

[pl] petelicki

by .pQd
dobre podsumowanie serji brutalnych samobojstw tutaj. a lemingi w najlepsze griluja cieszac sie co tym co im mainstream podrzuci. ciekawe komentarze na stronie michalkiewicza. + dla przeciwwagi – confirmation bias aka efekt potwierdzenia.

extracting single database from a [large] mysqldump

by .pQd
extracting the whole database: sed -n '/^-- Current Database: `databaseName`/,/^-- Current Database: `/p' /path/to/the/fill/dump.sql > output.sql single table: sed -n '/^CREATE TABLE `tableName`/,/^\-\- Table structure for table /p' /path/to/the/fill/dump.sql > output.sql [via this blog]

new sphinx, new connector/j headaches

by .pQd
sphinx 2.0.3 is out; and as new drama of getting mysql’s connector/j begins. i did not figure out [yet] any way of making both work using the latest 5.1.18 connector, but at least i’ve managed to convince one that i use now [ 5.1.15 ] to work with sphinx. what works: mysql-connector-java-5.1.13-bin.jar but.. only if ... Read More

excluding some mysql queries from the slow query log

by .pQd
i keep close eye on the mysql-slow.log log of queries that take more than 1s to execute. but at the same time i know about few house-keeping queries that are executed few times per day that by design take longer to execute [eg table checksums]. i don’t want those queries to ‘pollute’ the slow query ... Read More

ilo

by .pQd
i take care of one HP server with ILO remote access card. but recently i started having problems with using web applet to connect to it.