Tag Archives: MySQL

.htaccess zastita direktorija

Odavno nisam morao ‘rucno’ zastiti direktorij na apache-u jer mi je za to sluzio pleskov interface. Medjutim danas sam trebao zastiti jedan folder sa .htaccess-om ali na poddomeni – sa Pleskom to nije moguce… makar sa  sarenim web interface-om. Pa se podsjetimo kako se to radi .htaccess 1234AuthName "Protected Folder" AuthType Basic AuthUserFile /var/www/vhosts/yourdomain.com/subdomains/yoursubdomain/httpdocs/.htpasswd Require [...]

Kako MySQL izvrsava query

Vrlo lijepo opisano kako MySQL izvrsava query. Vrijedi procitati: http://www.xaprb.com/blog/2009/04/01/how-mysql-really-executes-a-query/

MySQLTuner

Vrlo korisna perl skriptica koja Vam olaksava optimizaciju MySQL servera. Klasicni output: ./mysqltuner.pl 123456789101112131415161718192021222324252627282930313233343536373839404142  MySQLTuner 1.0.0 – Major Hayden   Bug reports, feature requests, and downloads at http://mysqltuner.com/   Run with ‘–help’ for additional options and output filtering ——– General Statistics ————————————————– [--] Skipped version check for MySQLTuner script [OK] Currently running supported MySQL version [...]