# ibdata1 and ib\_logfile0 file size doesn't change **URL:** \ **Category:** Other MySQL® Questions\ **Created:** [June 1, 2010, 2:20pm UTC](https://forums.percona.com/t/ibdata1-and-ib-logfile0-file-size-doesnt-change/1420 "2010-06-01T14:20:21Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![kruc3fix](https://avatars.discourse-cdn.com/v4/letter/k/dfb087/32.png) [@kruc3fix](https://forums.percona.com/u/kruc3fix)\ **Post date:** [June 1, 2010, 2:20pm UTC](https://forums.percona.com/t/ibdata1-and-ib-logfile0-file-size-doesnt-change/1420/1 "2010-06-01T14:20:21Z")
Hi, Do you guys know why my innodb data and log files haven’t changed ? ibdata1 has 1.8G ib\_logfile0 has 5M ib\_logfile1 has 5M Here are my settings: innodb\_data\_home\_dir = /var/lib/mysql/ innodb\_data\_file\_path = ibdata1:1000M;ibdata2:10M:autoextend innodb\_log\_group\_home\_dir = /var/lib/mysql/ innodb\_log\_arch\_dir = /var/lib/mysql/ innodb\_buffer\_pool\_size = 2048M innodb\_additional\_mem\_pool\_size = 20M innodb\_log\_file\_size = 512M innodb\_log\_files\_in\_group = 2 innodb\_log\_buffer\_size = 8M innodb\_thread\_concurrency = 8 innodb\_flush\_log\_at\_trx\_commit = 1 innodb\_lock\_wait\_timeout = 50 I stopped mysqld, deleted the data+log files, but when I start mysql again the log shows: 100601 09:08:30 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 100601 9:08:30 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait… 100601 9:08:30 InnoDB: Log file ./ib\_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib\_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait… 100601 9:08:30 InnoDB: Log file ./ib\_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib\_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait… InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 100601 9:08:30 InnoDB: Started; log sequence number 0 0 100601 9:08:30 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.0.77′ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Source distribution A mysqld process already exists at Tue Jun 1 09:21:35 BST 2010 100601 9:39:04 InnoDB: ERROR: the age of the last checkpoint is 9434190, InnoDB: which exceeds the log group capacity 9433498. InnoDB: If you are using big BLOB or TEXT rows, you must set the InnoDB: combined size of log files at least 10 times bigger than the InnoDB: largest such row. ---
**Author:** ![gmouse](https://avatars.discourse-cdn.com/v4/letter/g/b9e5f3/32.png) [@gmouse](https://forums.percona.com/u/gmouse)\ **Post date:** [June 1, 2010, 2:41pm UTC](https://forums.percona.com/t/ibdata1-and-ib-logfile0-file-size-doesnt-change/1420/2 "2010-06-01T14:41:17Z")
A mysqld process already exists at Tue Jun 1 09:21:35 BST 2010 what’s that? ---
**Author:** ![sterin71](https://avatars.discourse-cdn.com/v4/letter/s/5e9695/32.png) [@sterin71](https://forums.percona.com/u/sterin71)\ **Post date:** [June 1, 2010, 4:05pm UTC](https://forums.percona.com/t/ibdata1-and-ib-logfile0-file-size-doesnt-change/1420/3 "2010-06-01T16:05:42Z")
Does it actually read in the rest of the settings or have you possibly placed the configuration rows in the wrong section of the my.cfg file? It should be in the [mysqld] section. Check it by running “SHOW GLOBAL VARIABLES;”. ---
**Author:** ![kruc3fix](https://avatars.discourse-cdn.com/v4/letter/k/dfb087/32.png) [@kruc3fix](https://forums.percona.com/u/kruc3fix)\ **Post date:** [June 3, 2010, 5:40am UTC](https://forums.percona.com/t/ibdata1-and-ib-logfile0-file-size-doesnt-change/1420/4 "2010-06-03T05:40:56Z")
My bad, I’ve added this chunk right in the middle of [mysqld] settings [mysqld\_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid So everything that was below [mysqld\_safe] was probably skipped including innodb settings. Thanx.