#storage engine

[bdarfler]

Interest New MySQL Storage Engine

[azrad]

How to fix issue with DB Storage Engine failure

I have done numerous LAMP stack installation and had no issue with MySQL until recently. Upon checking with the mysqld.log file, it seems my storage engine db init function returned error.

I'm not sure what would caused the issue here, but it seems my findings suggested that the mysql/data files that has something to do with the issue. Reading the log file points that the ib_logfile0 has different size.

So, since the mysqld is already at stopped, I just delete the following files:

ib_logfile0

ib_logfile1

ibdata1

Using the following command to remote the files:

sudo rm /var/lib/mysql/data/ib*

Hope others find the article useful.

[up4vn]

FilePursue - http://filepursue.com/mysql-5-5-29/

New Post has been published on http://filepursue.com/mysql-5-5-29/

MySQL 5.5.29

DescriptionScreenshotOld Versions

MySQL Community Edition is a freely downloadable version of the world’s most popular open source database that is supported by an active community of open source developers and enthusiasts.

MySQL delivers enterprise features, including:

Partitioning to improve performance and management of very large database environments

Row-based/Hybrid Replication for improved replication security

Event Scheduler to create and schedule jobs that perform various database tasks

XPath Support

Dynamic General/Slow Query Log

Performance/Load Testing Utility (mysqlslap)

Improved! Full Text Search (faster, new dev templates)

Improved! Archive engine (better compression, more features)

Improved! User session and problem SQL identification

Improved! MySQL embedded library (libmysqld)

Additional INFORMATION_SCHEMA objects

Faster data import operations (parallel file load)

ACID Transactions to build reliable and secure business critical applications

Stored Procedures to improve developer productivity

Triggers to enforce complex business rules at the database level

Views to ensure sensitive information is not compromised

Information Schema to provide easy access to metadata

Pluggable Storage Engine Architecture for maximum flexibility

Archive Storage Engine for historical and audit data

MySQL 5.5.28

Download

[oriya-tech]

[H3 2011] 대형사이트 구축을 위한 MySQL 튜닝전략

[ukd1-blog]

A new-ish storage engine for MySQL - supports some interesting tradeoffs and an fractal tree indexing.