Clear MySQL Cache ? On RHEL

Posted on 2007-10-01
Last Modified: 2013-12-16
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 ?
Question by:http://
    LVL 9

    Accepted Solution

    According to mysql manual query cache does not return stale data.

    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?
    LVL 19

    Author Comment

    Allright, then the cache question is solved..however how can I check in realtime the queries being executed on the MySQL server >?
    LVL 9

    Expert Comment

    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.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
    Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo‚Ķ
    Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
    Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now