# MySql DB crashing: **URL:** \ **Category:** Other MySQL® Questions\ **Created:** [March 2, 2009, 6:09am UTC](https://forums.percona.com/t/mysql-db-crashing/1099 "2009-03-02T06:09:07Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![madhusvuce](https://avatars.discourse-cdn.com/v4/letter/m/dbc845/32.png) [@madhusvuce](https://forums.percona.com/u/madhusvuce)\ **Post date:** [March 2, 2009, 6:09am UTC](https://forums.percona.com/t/mysql-db-crashing/1099/1 "2009-03-02T06:09:07Z")
I’m using Mysql (version : 5.0.24) which is accessed by web application developed by [ASP.NET](http://ASP.NET) 2.0 .The version of the .net connector i’m using is 5.0.7.0 .Now the problem is the DB service is crashing unexpectedly i.e. the DB service is stopped & to be started manually. This to happening in irregular intervals. Some times it’s happening for every 3 days & in sometimes its happening for every 7 days. The log entry in the error log is given below. 090126 3:05:00 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files… InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer… 090126 3:05:00 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 3 3969103191. InnoDB: Doing recovery: scanned up to log sequence number 3 3969103932 090126 3:05:00 InnoDB: Starting an apply batch of log records to the database… InnoDB: Progress in percents: 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed 090126 3:05:01 InnoDB: Started; log sequence number 3 3969103932 090126 3:05:01 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections. Version: ‘5.0.24-community-nt-log’ socket: ‘’ port: 3306 MySQL Community Edition (GPL) In one of the mysql forums somebody posted that if the log files has “-” in its name, that may lead to crash. I’ve ensued that log files doest have “-” in its name. Still the problem exists. What might be the possible reasons for crashing DB like this? ---
**Author:** ![aftabkhanahmed](https://avatars.discourse-cdn.com/v4/letter/a/e9c0ed/32.png) [@aftabkhanahmed](https://forums.percona.com/u/aftabkhanahmed)\ **Post date:** [March 6, 2009, 8:21am UTC](https://forums.percona.com/t/mysql-db-crashing/1099/2 "2009-03-06T08:21:20Z")
Can you provide us following info? my.ini?# what is the size of innodb buffer pool and innodb log file size? How much is the RAM?# innodb buffer pool size shouldn’t be greater than 80% of total RAM if mysql is running on dedicated server. complete error log? ---
**Author:** ![aftabkhanahmed](https://avatars.discourse-cdn.com/v4/letter/a/e9c0ed/32.png) [@aftabkhanahmed](https://forums.percona.com/u/aftabkhanahmed)\ **Post date:** [March 6, 2009, 8:24am UTC](https://forums.percona.com/t/mysql-db-crashing/1099/3 "2009-03-06T08:24:28Z")
Can you provide us following info? my.ini?# what is the size of innodb buffer pool and innodb log file size? How much is the RAM?# innodb buffer pool size shouldn’t be greater than 80% of total RAM if mysql is running on dedicated server. complete error log? ---
**Author:** ![madhusvuce](https://avatars.discourse-cdn.com/v4/letter/m/dbc845/32.png) [@madhusvuce](https://forums.percona.com/u/madhusvuce)\ **Post date:** [March 9, 2009, 12:09am UTC](https://forums.percona.com/t/mysql-db-crashing/1099/4 "2009-03-09T00:09:52Z")
Following are the details what u’ve asked. The MySql is not in dedicated server. Buffer Pool Size : 47 M Log File size : 24 M Log Buffer size : 1 M RAM : 2 GB