MySQL database has tables to store data. All Big and small
organizations use MySQL database for storing the employee's
records. A database administrator can do various operations
on table like insert, delete, retrieve, arrange, and many more.
Tables are very prone to corruption, there may be various reasons
for corruption like Unexpected server shutdown, faulty hardware,
virus attach, and more.
Let’s consider a scenario, wherein a database administrator is
trying to access MySQL database table and got below error
message.
“undef error - DBD::mysql::db selectrow_array failed: Table
'emplyee' is
marked as crashed and should be repaired [for Statement "SELECT
LENGTH(thedata)
FROM attach_data WHERE id = ?"] at height/Formula.pm line
344
Height::Attachment::datasize('Bugzilla::Attachment=HASH(0x9df119c)')
called ”
The above error message states that employee's table is …
Percona is glad to announce the release of Percona Server 5.5.13-20.4 on July 1st, 2011 (Downloads are available here and from the Percona Software Repositories).
Based on MySQL 5.5.13, Percona Server Percona Server 5.5.13-20.4 is now the current stable release in the 5.5 series. All of Percona’s software is open-source and free, all the details of the release can be found in the 5.5.13-20.4 milestone at Launchpad.
Improvements SHM Buffer Pool has been replaced with LRU Dump/Restore
[Read more]This year I'll attend OSCON for the first time. I'll give two talks:
-
PHP and MySQL - Recent Developments
PHP’s MySQL support recently received many changes under the hood. PHP 5.3 introduced mysqlnd – the MySQL native driver which is a replacement for libmysql deeply bound into PHP. In this presentation you will learn what the PHP and MySQL development teams were up to. After starting with an introduction of the PHP-stack, demystifying things like mysqli, mysqlnd or PDO, this presentation will show you how to build mysqlnd plugins as PHP C extension and hooking into mysqlnd from PHP userland. It will also discuss existing plugins like a client side query cache or a module for doing read-write-splitting, both working transparently, without changes to your application. - …
I just finished my last MariaDB 5.3 feature before we go
beta:
Progress reporting for ALTER TABLE, LOAD DATA INFILE etc.
This is a feature that I think every MySQL user who has ever
waited for an ALTER TABLE to finish has wanted for a long time! I
know people who have written scripts to monitor the size of the
result files to try to estimate how much an ALTER TABLE has
progressed.
Progress reporting means that:
- There is a new column Progress in SHOW PROCESSLIST which shows the total progress (0-100 %)
- INFORMATION_SCHEMA.PROCESSLIST has three new columns which
allow you to see in which process stage we are and how much of
that stage is completed:
- STAGE
- MAX_STAGE
- PROGRESS_DONE (within current stage).
- The client receives out-of-band progress messages which it can display to the user …
MySQL Connector/Net 6.1.6, a update to our all-managed .NET driver for MySQL has been released. This is an update to our legacy 6.1 version line. All new development should be using a more recent product such as 6.3.7.
Version 6.1.6 is intended for use with versions of MySQL from 4.1 – 5.1. It is not suitable for use with MySQL 5.5 or later.
It is now available in source and binary form from here and mirror sites (note that not all
mirror sites may be up to date at this point of time
- if you can’t find this version on some mirror, please try again
later or choose another download site.)
This update includes more than 35 fixes from 6.1.5. Please review the change log that is included with the product to determine the exact nature of the changes.
Enjoy and thanks for the support!
…
[Read more]MySQL Connector/Net 6.4.2, a new version of the all-managed .NET driver for MySQL has been released. This is a Release Candidate and is intended for testing and exposure to new features. We strongly urge you to not use this release in a production environment.
Version 6.4.2 is intended for use with versions of MySQL from 5.0 – 5.5
It is now available in source and binary form from here and mirror sites (note that not all mirror
sites may be up to date at this point of time
- if you can’t find this version on some mirror, please try again
later or choose another download site.)
New features found in 6.4 include (please see release notes for more information)
- Windows Authentication — This release includes our new support for Windows authentication when connecting to MySQL Server …
There are many new features in MariaDB 5.3. I’m looking forward to many of them, but one of the ones I’m most excited about is Progress Reporting.
It’s a fact of life in the database world that some commands take longer to run than others. Commands like ALTER TABLE, LOAD DATA INFILE, and adding and dropping an index simply take time to run, depending (of course) on your data and schema. I always have hated having to wait for those commands to run with no indication of how much progress has been made or how much is left to do. All of that changes with the upcoming release of MariaDB 5.3.
In MariaDB 5.3 there is a new “Progress” column in the output of SHOW PROCESSLIST (this can be turned off) which …
[Read more]SkySQL today announced that it has partnered with Shadow-Soft, a reseller specializing in cloud and open source solutions, to resell SkySQL products, training and services in the U.S. With this partnership, SkySQL extends its U.S. sales reach to better meet growing demand for its products and services. SkySQL™ Enterprise, SkySQL™ Training and SkySQL™ Professional Services are all immediately available from Shadow-Soft.
“Working with SkySQL is a great fit for Shadow-Soft and a winning combination for the MySQL community,” said James Chinn, co-founder and CEO of Shadow-Soft. “Both companies are highly experienced in open source, share a deep commitment to allowing IT to leverage its investments in MySQL-based solutions and are capable of providing the best possible customer experience.”
Read today's …
[Read more]Continuent is hosting a technical introductory webcast highlighting the new features and functionality of Tungsten Enterprise Summer '11 Edition on Thursday, June 30th at 10 am PT. Robert Hodges, CEO and Edward Archibald, CTO at Continuent, will be joined by Gandalf Sollenberger, Manager of Web Software Development at Thomson Reuters to speak about how Tungsten speeds up the development and
The latest Tungsten Enterprise edition is designed to simplify the management of, and to ensure the availability and scalability of mission critical applications and services. This new edition includes enhancements to Tungsten's error detection, cluster throughput and replication, including: Compatibility with MySQL 5.5Higher throughput for row replication on MySQLSingle-command backup and