MySQL (8.0.22)https://sikushima.hatenablog.com/entry/2019/04/10/181921 キャッシュされない模様。 SET optimizer_trace="enabled=on";SET optimizer_trace_max_mem_size = 1048576;select count(*) from tab1 a,tab1 b,tab1 c;select * from information…

MySQL (8.0.22) drop user 'user60'@'%';create user 'user60'@'%' identified by 'user60'; drop role role1;create role role1; grant select on test.tab1 to role1;grant create routine on test.* to role1;grant alter routine on test.* to role1;gra…