Last week some one asked how to Copy the tables (Only structure
and NO DATA..also no other DB objects) from one schema to another
on EE. This can be easily done from command line but user wanted
to do this thru stored procedure.
http://www.experts-exchange.com/Database/MySQL/Q_25024073.html
So I came with a very small MySQL procedure which was doing as
needed by the user. I'm not sure whether this is the best way to
do this but "There is always room for
improvement."
DELIMITER $$
DROP PROCEDURE IF EXISTS `CopySchema`$$
CREATE PROCEDURE `CopySchema`(sourceSchema
VARCHAR(64),targetSchema VARCHAR(64))
BEGIN
DECLARE no_more_rows BOOLEAN;
DECLARE loop_cntr INT DEFAULT 0;
DECLARE num_rows INT DEFAULT 0;
DECLARE …
MySQL/Galera release 0.7.1 ships out.
This is a maintenance release, which has fixes for 9 issues,
listed in launchpad release page:
https://launchpad.net/codership-mysql/0.7/0.7.1
It makes sense to upgrade, if you suffer from any of the
above.
Most notable changes are perhaps fixes for running concurrently
DDL and DML queries. The MySQL version has also been bumped two
notches up to 5.1.41
Prebuilt binary downloads are available, as usual, in the
launchpad site:
https://launchpad.net/codership-mysql/+download.
Pay attention to pick the latest 0.7.1 version, as launchpad
seems to give precedence for the old 0.7 release (no matter how
hard I try to configure LP...).
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...
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...
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
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 …
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 …
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:
-
Bug#488315:
rename columns and add …
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 …