# MYSQL goes very slow after every 4-5 hours

**URL:** <https://forums.percona.com/t/mysql-goes-very-slow-after-every-4-5-hours/270>\
**Category:** Other MySQL® Questions\
**Created:** [April 3, 2007, 3:32am UTC](https://forums.percona.com/t/mysql-goes-very-slow-after-every-4-5-hours/270 "2007-04-03T03:32:44Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![verma\_ndev](https://avatars.discourse-cdn.com/v4/letter/v/87869e/32.png) [@verma\_ndev](https://forums.percona.com/u/verma_ndev)\
**Post date:** [April 3, 2007, 3:32am UTC](https://forums.percona.com/t/mysql-goes-very-slow-after-every-4-5-hours/270/1 "2007-04-03T03:32:44Z")

</div>

Hi ALL,

I have dual core Intel processor with 2.66 GHz with 4 GB RAM.  
I am using MySQL 5.0.27 with Tomcat for a software developed in JAVA used in office Intranet environment.

I m experiencing problem that after every 4-5 hours the MySQL server goes very slow and i need to restart the tomcat web server.

below is the details of status variables for the peak time:

| Aborted\_clients | 404 |  
| Aborted\_connects | 1 |  
| Binlog\_cache\_disk\_use | 0 |  
| Binlog\_cache\_use | 9868 |  
| Bytes\_received | 43484521 |  
| Bytes\_sent | 597525519 |  
| Com\_admin\_commands | 1039 |  
| Com\_alter\_db | 0 |  
| Com\_alter\_table | 0 |  
| Com\_analyze | 0 |  
| Com\_backup\_table | 0 |  
| Com\_begin | 0 |  
| Com\_change\_db | 4 |  
| Com\_change\_master | 0 |  
| Com\_check | 0 |  
| Com\_checksum | 0 |  
| Com\_commit | 0 |  
| Com\_create\_db | 0 |  
| Com\_create\_function | 0 |  
| Com\_create\_index | 0 |  
| Com\_create\_table | 0 |  
| Com\_dealloc\_sql | 0 |  
| Com\_delete | 8 |  
| Com\_delete\_multi | 0 |  
| Com\_do | 0 |  
| Com\_drop\_db | 0 |  
| Com\_drop\_function | 0 |  
| Com\_drop\_index | 0 |  
| Com\_drop\_table | 0 |  
| Com\_drop\_user | 0 |  
| Com\_execute\_sql | 0 |  
| Com\_flush | 0 |  
| Com\_grant | 0 |  
| Com\_ha\_close | 0 |  
| Com\_ha\_open | 0 |  
| Com\_ha\_read | 0 |  
| Com\_help | 0 |  
| Com\_insert | 2159 |  
| Com\_insert\_select | 0 |  
| Com\_kill | 0 |  
| Com\_load | 0 |  
| Com\_load\_master\_data | 0 |  
| Com\_load\_master\_table | 0 |  
| Com\_lock\_tables | 0 |  
| Com\_optimize | 0 |  
| Com\_preload\_keys | 0 |  
| Com\_prepare\_sql | 0 |  
| Com\_purge | 0 |  
| Com\_purge\_before\_date | 0 |  
| Com\_rename\_table | 0 |  
| Com\_repair | 0 |  
| Com\_replace | 0 |  
| Com\_replace\_select | 0 |  
| Com\_reset | 0 |  
| Com\_restore\_table | 0 |  
| Com\_revoke | 0 |  
| Com\_revoke\_all | 0 |  
| Com\_rollback | 0 |  
| Com\_savepoint | 0 |  
| Com\_select | 132852 |  
| Com\_set\_option | 26810 |  
| Com\_show\_binlog\_events | 0 |  
| Com\_show\_binlogs | 0 |  
| Com\_show\_charsets | 0 |  
| Com\_show\_collations | 4115 |  
| Com\_show\_column\_types | 0 |  
| Com\_show\_create\_db | 0 |  
| Com\_show\_create\_table | 0 |  
| Com\_show\_databases | 1 |  
| Com\_show\_errors | 0 |  
| Com\_show\_fields | 90 |  
| Com\_show\_grants | 0 |  
| Com\_show\_innodb\_status | 1003 |  
| Com\_show\_keys | 0 |  
| Com\_show\_logs | 0 |  
| Com\_show\_master\_status | 0 |  
| Com\_show\_ndb\_status | 0 |  
| Com\_show\_new\_master | 0 |  
| Com\_show\_open\_tables | 0 |  
| Com\_show\_privileges | 0 |  
| Com\_show\_processlist | 16 |  
| Com\_show\_slave\_hosts | 0 |  
| Com\_show\_slave\_status | 0 |  
| Com\_show\_status | 1004 |  
| Com\_show\_storage\_engines | 0 |  
| Com\_show\_tables | 3 |  
| Com\_show\_triggers | 0 |  
| Com\_show\_variables | 4120 |  
| Com\_show\_warnings | 3 |  
| Com\_slave\_start | 0 |  
| Com\_slave\_stop | 0 |  
| Com\_stmt\_close | 0 |  
| Com\_stmt\_execute | 0 |  
| Com\_stmt\_fetch | 0 |  
| Com\_stmt\_prepare | 0 |  
| Com\_stmt\_reset | 0 |  
| Com\_stmt\_send\_long\_data | 0 |  
| Com\_truncate | 0 |  
| Com\_unlock\_tables | 0 |  
| Com\_update | 7713 |  
| Com\_update\_multi | 0 |  
| Com\_xa\_commit | 0 |  
| Com\_xa\_end | 0 |  
| Com\_xa\_prepare | 0 |  
| Com\_xa\_recover | 0 |  
| Com\_xa\_rollback | 0 |  
| Com\_xa\_start | 0 |  
| Compression | OFF |  
| Connections | 4627 |  
| Created\_tmp\_disk\_tables | 335 |  
| Created\_tmp\_files | 5 |  
| Created\_tmp\_tables | 11441 |  
| Delayed\_errors | 0 |  
| Delayed\_insert\_threads | 0 |  
| Delayed\_writes | 0 |  
| Flush\_commands | 1 |  
| Handler\_commit | 19736 |  
| Handler\_delete | 0 |  
| Handler\_discover | 0 |  
| Handler\_prepare | 19736 |  
| Handler\_read\_first | 74 |  
| Handler\_read\_key | 1969064 |  
| Handler\_read\_next | 13566316 |  
| Handler\_read\_prev | 0 |  
| Handler\_read\_rnd | 384583 |  
| Handler\_read\_rnd\_next | 5096399 |  
| Handler\_rollback | 7 |  
| Handler\_savepoint | 0 |  
| Handler\_savepoint\_rollback | 0 |  
| Handler\_update | 0 |  
| Handler\_write | 1679665 |  
| Innodb\_buffer\_pool\_pages\_data | 20526 |  
| Innodb\_buffer\_pool\_pages\_dirty | 6 |  
| Innodb\_buffer\_pool\_pages\_flushed | 21340 |  
| Innodb\_buffer\_pool\_pages\_free | 44269 |  
| Innodb\_buffer\_pool\_pages\_latched | 0 |  
| Innodb\_buffer\_pool\_pages\_misc | 741 |  
| Innodb\_buffer\_pool\_pages\_total | 65536 |  
| Innodb\_buffer\_pool\_read\_ahead\_rnd | 5 |  
| Innodb\_buffer\_pool\_read\_ahead\_seq | 218 |  
| Innodb\_buffer\_pool\_read\_requests | 27565700 |  
| Innodb\_buffer\_pool\_reads | 7549 |  
| Innodb\_buffer\_pool\_wait\_free | 0 |  
| Innodb\_buffer\_pool\_write\_requests | 72234 |  
| Innodb\_data\_fsyncs | 21760 |  
| Innodb\_data\_pending\_fsyncs | 0 |  
| Innodb\_data\_pending\_reads | 0 |  
| Innodb\_data\_pending\_writes | 0 |  
| Innodb\_data\_read | 337809408 |  
| Innodb\_data\_reads | 8373 |  
| Innodb\_data\_writes | 39319 |  
| Innodb\_data\_written | 713125376 |  
| Innodb\_dblwr\_pages\_written | 21340 |  
| Innodb\_dblwr\_writes | 1882 |  
| Innodb\_log\_waits | 0 |  
| Innodb\_log\_write\_requests | 9893 |  
| Innodb\_log\_writes | 16791 |  
| Innodb\_os\_log\_fsyncs | 17992 |  
| Innodb\_os\_log\_pending\_fsyncs | 0 |  
| Innodb\_os\_log\_pending\_writes | 0 |  
| Innodb\_os\_log\_written | 13241344 |  
| Innodb\_page\_size | 16384 |  
| Innodb\_pages\_created | 41 |  
| Innodb\_pages\_read | 20485 |  
| Innodb\_pages\_written | 21340 |  
| Innodb\_row\_lock\_current\_waits | 0 |  
| Innodb\_row\_lock\_time | 218 |  
| Innodb\_row\_lock\_time\_avg | 0 |  
| Innodb\_row\_lock\_time\_max | 3 |  
| Innodb\_row\_lock\_waits | 330 |  
| Innodb\_rows\_deleted | 8 |  
| Innodb\_rows\_inserted | 2152 |  
| Innodb\_rows\_read | 17358613 |  
| Innodb\_rows\_updated | 5692 |  
| Key\_blocks\_not\_flushed | 0 |  
| Key\_blocks\_unused | 1293436 |  
| Key\_blocks\_used | 1 |  
| Key\_read\_requests | 134 |  
| Key\_reads | 48 |  
| Key\_write\_requests | 115 |  
| Key\_writes | 0 |  
| Last\_query\_cost | 0.000000 |  
| Max\_used\_connections | 194 |  
| Not\_flushed\_delayed\_rows | 0 |  
| Open\_files | 15 |  
| Open\_streams | 0 |  
| Open\_tables | 52 |  
| Opened\_tables | 58 |  
| Qcache\_free\_blocks | 471 |  
| Qcache\_free\_memory | 266224976 |  
| Qcache\_hits | 332056 |  
| Qcache\_inserts | 128197 |  
| Qcache\_lowmem\_prunes | 0 |  
| Qcache\_not\_cached | 13987 |  
| Qcache\_queries\_in\_cache | 1447 |  
| Qcache\_total\_blocks | 3388 |  
| Questions | 523631 |  
| Rpl\_status | NULL |  
| Select\_full\_join | 0 |  
| Select\_full\_range\_join | 0 |  
| Select\_range | 4695 |  
| Select\_range\_check | 0 |  
| Select\_scan | 9392 |  
| Slave\_open\_temp\_tables | 0 |  
| Slave\_retried\_transactions | 0 |  
| Slave\_running | OFF |  
| Slow\_launch\_threads | 0 |  
| Slow\_queries | 2 |  
| Sort\_merge\_passes | 0 |  
| Sort\_range | 3700 |  
| Sort\_rows | 220199 |  
| Sort\_scan | 1000 |  
| Ssl\_accept\_renegotiates | 0 |  
| Ssl\_accepts | 0 |  
| Ssl\_callback\_cache\_hits | 0 |  
| Ssl\_cipher | |  
| Ssl\_cipher\_list | |  
| Ssl\_client\_connects | 0 |  
| Ssl\_connect\_renegotiates | 0 |  
| Ssl\_ctx\_verify\_depth | 0 |  
| Ssl\_ctx\_verify\_mode | 0 |  
| Ssl\_default\_timeout | 0 |  
| Ssl\_finished\_accepts | 0 |  
| Ssl\_finished\_connects | 0 |  
| Ssl\_session\_cache\_hits | 0 |  
| Ssl\_session\_cache\_misses | 0 |  
| Ssl\_session\_cache\_mode | NONE |  
| Ssl\_session\_cache\_overflows | 0 |  
| Ssl\_session\_cache\_size | 0 |  
| Ssl\_session\_cache\_timeouts | 0 |  
| Ssl\_sessions\_reused | 0 |  
| Ssl\_used\_session\_cache\_entries | 0 |  
| Ssl\_verify\_depth | 0 |  
| Ssl\_verify\_mode | 0 |  
| Ssl\_version | |  
| Table\_locks\_immediate | 156262 |  
| Table\_locks\_waited | 0 |  
| Tc\_log\_max\_pages\_used | 0 |  
| Tc\_log\_page\_size | 0 |  
| Tc\_log\_page\_waits | 0 |  
| Threads\_cached | 14 |  
| Threads\_connected | 180 |  
| Threads\_created | 233 |  
| Threads\_running | 1 |  
| Uptime | 13777 |

Any help plz.

---

<div class="post-metadata">

**Author:** ![carpii](https://avatars.discourse-cdn.com/v4/letter/c/b5ac83/32.png) [@carpii](https://forums.percona.com/u/carpii)\
**Post date:** [April 4, 2007, 7:03pm UTC](https://forums.percona.com/t/mysql-goes-very-slow-after-every-4-5-hours/270/2 "2007-04-04T19:03:42Z")

</div>

What makes you believe its the mysql process causing the problem?

Could it be tomcat?  
Could it be a problem in your Java?