Not the answer you need?
Register and ask your own question!

Disabling Queries

moazammoazam EntrantInactive User Role Participant
Hello,
I read in high performance mysql book that its possible to block such queries.

DELETE FROM table;
UPDATE TABLE SET X=10;

any query that updates full table and also full table scan queries.

Any hint would be really helpful.

Thanks

Comments

  • xaprbxaprb Mentor Inactive User Role Leader
    There is a --safe-updates option for the mysql command-line client, but that only works if you're connecting through the command-line client.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.