block write access to table from an application in mysql

Posted by hoberion on Stack Overflow See other posts from Stack Overflow or by hoberion
Published on 2010-05-09T13:04:24Z Indexed on 2010/05/09 13:08 UTC
Read the original article Hit count: 214

Filed under:
|
|
|

Hello,

We have a CMS plugin that writes statistics to 1 table, this creates performance issues on the entire platform. We decided to use another statistics plugin which can connect to a different database server (the first plugin couldn't!) however we need parts of the first plugin.

I want to lock the statistics table to prevent misusage (not allowed to drop it by the developer) So I was wondering if a lock table could do this or if I can implement some sort of read only table

© Stack Overflow or respective owner

Related posts about mysql

Related posts about table