Tag Info

New answers tagged

0

You can use SQL Activity Monitor. This will show the current queries executing in your SQL Server instance with below details SPID Login Database Name Task State Command Application Wait time Host Name and many more under PROCESSES tab Also you can have a look on Resource waits Data File I/O Recent Expensive Queries


1

I think your problem boils down to a misalignment of grants. When you run this query SELECT COUNT(1) column_count FROM information_schema.columns WHERE table_schema='mysql' AND table_name='user'; You should the following number If you get 43, MySQL 5.6 If you get 42, MySQL 5.5 If you get 39, MySQL 5.1 If you get 37, MySQL 5.0 It simply means you ...



Top 50 recent answers are included