OpenForum RSS: �� innodb ��

�� innodb �� (Michael)

Mon, 11 Apr 2011 20:38:46 GMT

> �� , �� -�� -��
> �� , �� -��?

�� , �� .

�� innodb �� (VArtem)

Mon, 11 Apr 2011 12:01:40 GMT

�� -�� -�� ibdata1. �� , �.�. �� .

�� , �� :

110411 10:44:38 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
110411 10:44:39 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
110411 10:44:39 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
110411 10:44:41 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...
110411 10:44:43 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

�� innodb �� (VArtem)

Mon, 11 Apr 2011 11:01:47 GMT

+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| InnoDB | YES | Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
| CSV | YES | CSV storage engine | NO |

�� innodb �� (Michael)

Mon, 11 Apr 2011 10:41:55 GMT

>[�� ]
> table exists. Maybe you have deleted and recreated InnoDB data
> files but have forgotten to delete the corresponding .frm files
> of InnoDB tables, or you have moved .frm files to another database?
> or, the table contains indexes that this version of the engine
> doesn't support.
> See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html
> how you can resolve the problem.
> �� , �� innodb, �
> �� . ��
> ��, �.�. Db1, �� .

show engines ��

OpenForum RSS: ������� innodb ������� ����� ����������� ������������

������� innodb ������� ����� ����������� ������������ (Michael)

������� innodb ������� ����� ����������� ������������ (VArtem)

������� innodb ������� ����� ����������� ������������ (VArtem)

������� innodb ������� ����� ����������� ������������ (Michael)

OpenForum RSS: �� innodb ��

�� innodb �� (Michael)

�� innodb �� (VArtem)

�� innodb �� (VArtem)

�� innodb �� (Michael)