Interessante Dinge und Links aus iX 4/2013

Posted onAutoradmin-up

  • Secunia SmallBusiness  – für die ersten 5 Stationen kostenlos
  • Telekom will mit Fon’s Hilfe seine WLAN-Access Points von 12000 auf 2.5Mio vergrößern
  • Ein paar interessante Befehle für Mysql
    • select user, sum(current_connections) as anzahl from accounts where user is not null group by user order by anzahl desc
    • show processlist
    • alternativ: select * from threads join events_statements_current using (thread_id)
    • show global status
    • alternativ: select schema_name, digest_test, sum_created_tmp_disk_tables from events_statements_summary_by_digest where sum_created_tmp_disk_tables > 0
    • select file_name, count_read+count_write from file_summary_by_instance order by (count_read+count_write) desc limit 10