[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1786
  • Last Modified:

Clear MySQL Cache ? On RHEL

Hi All
I have MySQL5 server running on RHEL. I have a client app that queries this server for information. The thing is that I can see the result of the query. The result are 3 rows in a table..those are causing problems so I deleted them..however the application is still receiving those 3 rows as a result from the database..I checked in the database and they were gone .. I even restarted the database...this is weird...does MySQL cache any results..? If yes, how can I clear the cache..? And how can I check in realtime the sql queries being executed on the MySQL server ?
Thx
0
http:// thevpn.guru
Asked:
http:// thevpn.guru
  • 2
1 Solution
 
sanjoozCommented:
According to mysql manual query cache does not return stale data.

http://dev.mysql.com/doc/refman/5.0/en/query-cache.html.

Are you sure you are querying the same database? There might be multiple databases with similar content.
Is you application using some kind of ORM? Does it has its own cache?
0
 
http:// thevpn.guruAuthor Commented:
Allright, then the cache question is solved..however how can I check in realtime the queries being executed on the MySQL server >?
0
 
sanjoozCommented:
I do not quite understand what you mean by "check in realtime" the queries. What exactly do you want to check? There are mysql logs and then there are query results. Take a look at "Mysql administrator" or mysql query browser. You may find something useful.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now