ANN: Database Workbench 4.2.4 released, 70% discount!

2012-05-10 Thread Martijn Tonies
=newsid=20120510 The FREE Lite Editions will follow later. For a full list of fixes in this release, see: http://www.upscene.com/go/?go=trackerv=4.2.4id=3 Database Workbench supports: - Borland InterBase ( 6.x - XE ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008 ) - MySQL 4.x, 5

ANN: AnySQL Maestro 12.5 released

2012-05-10 Thread SQL Maestro Team
Hi! SQL Maestro Group announces the release of AnySQL Maestro 12.5, a powerful tool for managing any database engine accessible via ODBC driver or OLE DB provider (MySQL, SQLite, PostgreSQL, SQL Server, Oracle, Access, etc). The new version is immediately available at

RE: 回复： 回复： Why is creating indexes faster after inserting massive data rows?

2012-05-10 Thread Rick James
One more wrinkle... When adding a UNIQUE index, MySQL must build the BTree, and cannot do a sortmerge. (I think this is a true statement, but I am not positive.) The reason... A UNIQUE index is two things: an INDEX, and a UNUQUEness constraint. In order to enforce the constraint, it must

How to quickly detect if there are any crashed tables

2012-05-10 Thread Adrian Fita
Hi. I have several hundreds of databases with MyISAM tables in a server and after a power outage, I have to manually repair them with mysqlcheck. Sometimes I forget and it's not nice. So I am thinking of making a Nagios plugin to check if there are any crashed tables that need repairing. I tried

Re: How to quickly detect if there are any crashed tables

2012-05-10 Thread Mihail Manolov
You can enable check/recovery automatically by using myisam_recover. Look it up in the documentation. There is no way to repair them faster, though. On May 10, 2012, at 2:40 PM, Adrian Fita wrote: Hi. I have several hundreds of databases with MyISAM tables in a server and after a power

Re: How to quickly detect if there are any crashed tables

2012-05-10 Thread Adrian Fita
On 10/05/12 21:51, Mihail Manolov wrote: You can enable check/recovery automatically by using myisam_recover. Look it up in the documentation. There is no way to repair them faster, though. Thanks for the quick response. This definetly looks like a useable solution. Do you know if during the

New Fast MySQL Compatible Server (Take 2)

2012-05-10 Thread Hiromichi Watari
Hi, I created Parallel Universe which is a MySQL 5.5 compatible server with fast query execution. Speed is achieved by the new patent pending technology which utilizes multi core/CPU of server hardware. Pre-release field evaluation is being conducted and MySQL users are solicited to try out

Re: How to quickly detect if there are any crashed tables

2012-05-10 Thread Mihail Manolov
AFAIK the tables will be locked one by one until checked/repaired. On May 10, 2012, at 3:07 PM, Adrian Fita wrote: On 10/05/12 21:51, Mihail Manolov wrote: You can enable check/recovery automatically by using myisam_recover. Look it up in the documentation. There is no way to repair them

Re: New Fast MySQL Compatible Server (Take 2)

2012-05-10 Thread Reindl Harald
Am 10.05.2012 21:16, schrieb Hiromichi Watari: Hi, I created Parallel Universe which is a MySQL 5.5 compatible server with fast query execution. Speed is achieved by the new patent pending technology which utilizes multi core/CPU of server hardware after reading new patent pending

RE: How to quickly detect if there are any crashed tables

2012-05-10 Thread Steven Staples
AFAIK the tables will be locked one by one until checked/repaired. On May 10, 2012, at 3:07 PM, Adrian Fita wrote: On 10/05/12 21:51, Mihail Manolov wrote: You can enable check/recovery automatically by using myisam_recover. Look it up in the documentation. There is no way to