Hi, Witold! On Mar 05, Witold Filipczyk wrote: > > > The idea to resolve it is: > > > in find_files(...) instead of the for loop execute query: > > > SELECT REPLACE(TABLE_SCHEMA, '\\', '') FROM > > > INFORMATION_SCHEMA.SCHEMA_PRIVILEGES WHERE PRIVILEGE_TYPE = 'SELECT'; > > > There are databases with names with _ in them and \_ in GRANTS. > > > > That's a very interesting idea. > > > > Basically, you're saying that if a user has no probal privileges and > > database privileges on only one database and no wildcards in the > > database name (*), then SELECT * FROM INFORMATION_SCHEMA.SCHEMATA > > essentially has an implicit WHERE schema_name="FOO" clause. Yes, > > that's certainly doable. It's even not very difficult to do, I'd > > think. > > I guess, I did not understand. > I did something like this: ... > And turned on INFORMATION_SCHEMA in phpmyadmin and it is slow, very > slow. What I'm doing wrong here? How to speed up?
I cannot answer it like that, sorry. The idea looks good and promising. Your implementation looks fine too, I didn't spot anything obviously wrong. Try to profile your code, see where it spends the time. Regards, Sergei Chief Architect MariaDB and secur...@mariadb.org _______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
