Homepage: http://www.mozilla.com/firefox/
Add-ons: https://addons.mozilla.org/en-US/firefox/
My preferred add-ons:
All-in-One Gestures
All-in-One Sidebar
Cooliris Previews
Fast Dial
FishEyeTabs
Informational Tab
PermaTabs
Speed Dial
Yet Another Smooth Scrolling
check table %TABLE% for upgrade;
mysql> create database DATABASENAME; mysql> grant all privileges on DATABASENAME.* to 'USERNAME'@'LOCALHOST' identified by 'PASSWORD'; mysql> flush privileges; mysql> exit
show tables;
show databases;
use %DATABASENAME%
Activate or deactivate the profiler for the current session:
set profiling=1;
set profiling=0;
Display queries ID and durations:
show profiles;
Display query informations:
show profile for query %QUERYID%;
Display query information details:
show profile %VALUE% for query %QUERYID%;
where %VALUE% can be: ALL, CPU, BLOCK IO, CONTEXT SWITCHES, IPC, PAGE FAULTS, SOURCE or SWAPS.
Normal login:
mysql -D %DATABASENAME% -u %USERNAME% -p
Execute script:
mysql -D %DATABASENAME% -u %USERNAME% -p < %SCRIPTFILE% > %OUTPUTFILE%
show status like '%PARAMS%%';
Purge log files (with MySQL replication):
mysql -u root -p -e "PURGE BINARY LOGS BEFORE '2011-5-13 10:06:06';"
SQL statement:
FLUSH LOGS
Unix command line:
mysqladmin flush-logs
show slave status \G;
slave start;
Crontab user postgres:
00 23 * * * /%PATHTOSCRIPT%/backuppostgres.sh >>/dev/null
Script:
DATE=$(date +%Y-%m-%d)
pg_dump DBNAME | gzip > /data/backup/DBNAME_${DATE}.gz
su postgres psql -d %DATABASENAME%
SELECT tablename FROM pg_tables
psql -l
vmware-cmd /vmfs/volumes/%VMFSSTORAGE%/%VMNAME%/%VMNAME%.vmx removesnapshots
/usr/sbin/vmkfstools -E %OLDNAME%.vmdk %NEWNAME%.vmdk
http://www.commentcamarche.net/faq/9773-reinitialiser-le-mot-de-passe-root-de-mysql
mysqladmin status
Calculate Total Database Index Size
mysql -u mysqlusername -p -e “SELECT CONCAT(ROUND(SUM(index_length)/(1024*1024), 2), ' MB') AS 'Total Index Size' FROM information_schema.TABLES WHERE table_schema LIKE '%DATABASE%';”
Calculate the Total Size of Table Data
mysql -u mysqlusername -p -e “SELECT CONCAT(ROUND(SUM(data_length)/(1024*1024), 2), ' MB') AS 'Total Data Size' FROM information_schema.TABLES WHERE table_schema LIKE 'databasename';”