Showing entries 25121 to 25130 of 44955
« 10 Newer Entries | 10 Older Entries »
1.0.0 RC1 release available


We are pleased and excited to announce the availability of 1.0.0 Release Candidate 1 of InfiniDB Community Edition.  This is our initial release candidate and is not recommended for production work.

This release includes a number of bug fixes that you can see at http://bugs.launchpad.net/infinidb.  We will continue with weekly releases this month marching towards our GA release in early February.  You can download the latest InfiniDB binaries, source code, aRead More...

1.0.0 RC1 release available


We are pleased and excited to announce the availability of 1.0.0 Release Candidate 1 of InfiniDB Community Edition.  This is our initial release candidate and is not recommended for production work.

This release includes a number of bug fixes that you can see at http://bugs.launchpad.net/infinidb.  We will continue with weekly releases this month marching towards our GA release in early February.  You can download the latest InfiniDB binaries, source code, aRead More...

Installing MySQL 5.1 on Linux using MOCA

IntroductionThe following instructions will lay out an installation of MySQL on Linux using the MySQL Optimal Configuration Architecture (MOCA) for someone with fundamental knowledge of MySQL and basic Linux administration skills. MOCA is a set of best practices I put together to lay out a set of guidelines for installing and configuring a MySQL database server.  MOCA is designed for someone with

Rolling back 432 million rows in MySQL 5.0

Believe it or not, I haven't put myself into this position before. The day before yesterday I started a LOAD DATA INFILE for 760 million rows. Didn't really think too hard about it, figured I'd let it run until it finished.

Unfortunately MySQL did that thing where the row insertion rate slowed to molasses over time, and the box was hosed. I killed the query. So it started rolling back the transaction. Which was 431 million rows in.

Using `SHOW ENGINE INNODB STATUS` you can look at the number of undo entries a transaction has left to go:

---TRANSACTION 0 1161525892, ACTIVE 18598 sec, process no 20139, OS thread id 1131772224
ROLLING BACK , undo log entries 431301691


Something like that. I left it to rollback overnight. The next day, it had only moved through a few million entries. It's going to take a week or more! I could just drop the table but it's locked from the transaction …

[Read more]
Rolling back 432 million rows in MySQL 5.0

Believe it or not, I haven't put myself into this position before. The day before yesterday I started a LOAD DATA INFILE for 760 million rows. Didn't really think too hard about it, figured I'd let it run until it finished.

Unfortunately MySQL did that thing where the row insertion rate slowed to molasses over time, and the box was hosed. I killed the query. So it started rolling back the transaction. Which was 431 million rows in.

Using `SHOW ENGINE INNODB STATUS` you can look at the number of undo entries a transaction has left to go:

---TRANSACTION 0 1161525892, ACTIVE 18598 sec, process no 20139, OS thread id 1131772224
ROLLING BACK , undo log entries 431301691


Something like that. I left it to rollback overnight. The next day, it had only moved through a few million entries. It's going to take a week or more! I could just drop the table but it's locked from the transaction …

[Read more]
XtraDB storage engine release 1.0.6-9

Dear Community,

As of today Release 9 of XtraDB storage engine is available.

The release includes following new features:

  • The release is base on 1.0.6 version of InnoDB plugin.
  • MySQL 5.1.42 as a base release
  • Separate purge thread and LRU dump is implemented (this feature was actually added in Release 8, but somehow it was forgotten)
  • New patch innodb_relax_table_creation
  • Added extended statistics to slow log
  • Adjust defaults with performance intention
  • Added parameter to control checkpoint age
  • Added recovery statistics output when crash recovery (disabled by default)
  • Patch to dump and restore innodb_buffer_pool

Fixed bugs:

[Read more]
Ubuntu Karmic's Network Manager Issues

Since Ubuntu 8.04 aka Hardy Heron, I've had issues with every new release. As Ubuntu evolves into being a viable desktop OS alternative, its complexity has been growing and with the new and improved looks new challenges arise. This bug in particular has been very difficult to diagnose and I can't imagine anyone without enough Linux experience to overcome it on their own, so I decided to summarize the steps I took to fix it ... and vent my frustration at the end.
The SymptomI came across the issue for the first time while trying Ubuntu's Karmic Netbook remix. After overcoming the typical Broadcom wifi driver, Network Manager would connect, but Firefox would fail to load the web pages 90% of the time. Using ping in the command line worked just fine. Maybe I needed to update the software packages to get the latest patches, surprise, apt-get was having similar problems and timing out. So the problem …

[Read more]
Performance Tuning Your Database From Drupal

I began porting the dba module to Drupal 7 as an opportunity to learn more about the new database abstraction layer. In this upcoming Drupal release, our database layer is now built upon the PHP Data Objects (PDO) data-access abstraction layer, introducing new syntax and symantecs into writing queries with Drupal. A powerful new query builder makes it possible to easily write queries that run on any database type supported by Drupal, currently including MySQL, PostgreSQL and SQLite.

The dba module was always intended to be a useful tool for any database administrator, and toward that end I have recently merged in mysqlreport functionality which utilizes MySQL's server statistics to offer an overview of server health and performance. As an …

[Read more]
HP Needs a Linux OLTP Database...FAST

Oracle, after dating HP, Dell, Netapp and EMC has found its mate in Sun. Oracle is now becoming a systems company, and unceremoniously dumping these former paramours. These leaves the spurned lovers to find alternate accommodations, especially in the area of the database.

As I have stated previously on this blog, the clear partner of choice on the Windows front is Microsoft. This is demonstrated by today’s partner announcement around MS SQL Server for OLTP. But who is their partner in the Linux segment?

The following are contenders:
* Postgres (HP rolls their own)
* EnterpriseDB (pre-rolled Postgres)
* Ingres or Sybase—Oracle has felled them both in the past, …

[Read more]
Advanced analytics report added to Kontrollbase CLI-reporter

It didn’t take long, but the advanced analytics reporting code has been added to the command line reporter version of Kontrollbase. Click here to see an example of the tuning and analytics report output (html format). Now you have all of the reporting features (minus the growth over time) features that are offered in the [...]

Showing entries 25121 to 25130 of 44955
« 10 Newer Entries | 10 Older Entries »