What?s the difference between query_cache_type 1 and 2?
Answer Posted / amith
The second one is on-demand and can be retrieved via SELECT
SQL_CACHE.
you can use SELECT /* SQL_CACHE */ id FROM ? - MySQL will
interpret the code inside comments, while other servers
will ignore it.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is “i_am_a_dump” flag in mysql?
Can I use mariadb instead of mysql?
How do I setup a mysql database?
What does mysql flush privileges do?
How do I flush privileges in mysql?
Is mysql good for big data?
Why to use char instead of varchar in the database?
How do you kill a long running query in mysql?
How to validate email addresses in mysql?
What are the benefits of mysql?
What is query design?
What is the difference between now() and current_date()?
How do I import database through command line?
Can we use mysql and mysqli together?
How to do login in mysql with unix shell.