<div>
Allright, then the cache question is solved..however how can I check in realtime the queries being executed on the MySQL server &gt;?
</div>


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

<div>
I do not quite understand what you mean by &quot;check in realtime&quot; the queries. What exactly do you want to check? There are mysql logs and then there are query results. Take a look at &quot;Mysql administrator&quot; or mysql query browser. You may find something useful.
</div>


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.

<div>
<div class="content wysiwyg-content">
Hi All<br />
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 ?<br />
Thx
</div>
</div>


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

Clear MySQL Cache ? On RHEL

Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.

Linux

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.