Robertas Reiciunas

Knowledge w/o sharing is nothing!

Tag: mysql

  • MySQL / Percona profiler

    —

    by

    Robertas Reiciunas
    in

    Hey, this is designed to profiles SQL queries on Percona Cluster, however it would run on normal MySQL without any issues. Log into mysql console and run the following (don’t logout of console until finished profiling, or take note of the changed variables): Wait for some time – 30-60 minutes, allow the queries to be…

  • MySQL

    —

    by

    Robertas Reiciunas
    in

    Create MySQL database with character set and collate: Show Database sizes: Show Table sizes: