Log all queries in mysql while tomcat start

Log all queries in mysql while tomcat start :-

to log all mysql queries in database while tomcat start. we have to do below steps:-

Step 1.  Create log tables on mysql :-

         

  CREATE TABLE `slow_log` (

   `start_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP 

                          ON UPDATE CURRENT_TIMESTAMP,

   `user_host` mediumtext NOT NULL,

   `query_time` time NOT NULL,

   `lock_time` time NOT NULL,

   `rows_sent` int(11) NOT NULL,

   `rows_examined` int(11) NOT NULL,

   `db` varchar(512) NOT NULL,

   `last_insert_id` int(11) NOT NULL,

   `insert_id` int(11) NOT NULL,

   `server_id` int(10) unsigned NOT NULL,

   `sql_text` mediumtext NOT NULL,

   `thread_id` bigint(21) unsigned NOT NULL

  ) ENGINE=CSV DEFAULT CHARSET=utf8 COMMENT='Slow log'

  CREATE TABLE `general_log` (

   `event_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP

                          ON UPDATE CURRENT_TIMESTAMP,

   `user_host` mediumtext NOT NULL,

   `thread_id` bigint(21) unsigned NOT NULL,

   `server_id` int(10) unsigned NOT NULL,

   `command_type` varchar(64) NOT NULL,

   `argument` mediumtext NOT NULL

  ) ENGINE=CSV DEFAULT CHARSET=utf8 COMMENT='General log'

Step 2. Enable Query logging on mysql database :-

            SET global general_log = 1;

            SET global log_output = 'table';

Step 3. View logs on mysql

           select * from mysql.general_log

Step 4. Disable Query logging on mysql DB :-

            SET global general_log = 0;

Step 5. Check Count Of Queries :-

            select left(argument,50), count() from general_log group by left(argument,50) order by count() desc limit 50;