Showing entries 31 to 40 of 48
« 10 Newer Entries | 8 Older Entries »
Displaying posts with tag: Features (reset)
Allow UNDO logs to reside in their own tablespace

Note: this article was originally published on http://blogs.innodb.com on July 25, 2011 by Sunny Bains.

Introduction

The InnoDB  UNDO entries reside in a special system table called the UNDO log. This log is made up of several segments. These segments are called rollback segments. A segment in InnoDB is similar to what a file would be in a file system,e.g., user tables and indexes are also stored as separate segments within the same tablespace,  only their format is different. In that sense there is nothing special about InnoDB UNDO logs. This feature allows storing of the UNDO log across several tablespaces.

Purpose

UNDO logs  contain the before image of modified records. There are two types of UNDO records, one for insert and another for updates. The insert UNDO records can be …

[Read more]
Shortened warm-up times with a preloaded InnoDB buffer pool

Note: this article was originally published on http://blogs.innodb.com on July 25, 2011 by Vasil Dimov.

Are you running an InnoDB installation with a many-gigabytes buffer pool(s)? Does it take too long before it goes back to speed after a restart? If yes, then the following will be interesting to you.

In the latest MySQL 5.6 Labs release we have implemented an InnoDB buffer pool(s) dump and load to solve this problem.

The contents of the InnoDB buffer pool(s) can be saved on disk before MySQL is shut down and then read in after a restart so that the warm up time is drastically shortened – the buffer pool(s) go to the state they were before the server restart! The time needed for that is roughly the time needed to read data from disk that is about the size of the buffer pool(s).

Lets dive straight into the commands to perform …

[Read more]
Overview and Getting Started with InnoDB FTS

Note: this article was originally published on http://blogs.innodb.com on July 25, 2011 by Jimmy Yang.

This Summer’s lab release includes an important feature of InnoDB – InnoDB Fulltext Search. This feature would greatly enhance InnoDB’s capability in Text search and retrieving. Since the feature is designed for our transactional storage engine, its underlying architecture design and implementation are completely different with those of MyISAM. So it is worth to give a brief technology review of this feature, familiarize users with some important concepts in the InnoDB FTS so that they can better utilize this feature.

There are a few other posts on the subject. John Russell will give a brief tutorial on the InnoDB fulltext search command and syntax. I will also discuss some comparison with MyISAM fulltext search in another post. And Vinay in …

[Read more]
Difference between InnoDB FTS and MyISAM FTS

Note: this article was originally published on http://blogs.innodb.com on July 25, 2011 by Jimmy Yang.

With this lab release, InnoDB now has its own Fulltext Search (FTS) support. People might wonder how different is this FTS comparing with that of MyISAM. From the usage standpoint, they seem very similar with no apparent difference. However, in the underlying FTS engine, the difference is huge, since two are built on different storage engines with totally different design. So in some aspect such as DML, it might be difficult to make it an apple to apple comparison. However, we do try to list and explain the difference, so to make it easier for user to understand our design and make the transition to use InnoDB FTS easier.

The Design:

The most significant difference is the design. Like most transaction storage engine, …

[Read more]
Rewriting the Creating a CRUD Application with PHP tutorial cycle: help wanted!

I've been reworking the Creating a CRUD Application with PHP tutorials. The new version should be ready for 7.0 Beta 2 release. In the new version:

  • I replaced mysql functions with mysqli functions.
  • With the help of Christoper Jones, I've added OCI8 versions of the code for connecting to Oracle Database
  • I've fixed some old bugs and improved the tutorials overall.

In the course of this work, two things have come to my attention. These are two things that you can help with.

  • The title Creating a CRUD Application... is not very appealing.
  • The sample CSS used for Lesson 8 is terrible.

So first, can anyone suggest a new title? We have one suggestion already, internally: Creating a Database Application …

[Read more]
Rewriting the Creating a CRUD Application with PHP tutorial cycle: help wanted!

I've been reworking the Creating a CRUD Application with PHP tutorials. The new version should be ready for 7.0 Beta 2 release. In the new version:

  • I replaced mysql functions with mysqli functions.
  • With the help of Christoper Jones, I've added OCI8 versions of the code for connecting to Oracle Database
  • I've fixed some old bugs and improved the tutorials overall.

In the course of this work, two things have come to my attention. These are two things that you can help with.

  • The title Creating a CRUD Application... is not very appealing.
  • The sample CSS used for Lesson 8 is terrible.

So first, can anyone suggest a new title? We have one suggestion already, internally: Creating a Database Application …

[Read more]
Cloud openness contemplated

I caught some of the keynotes and discussion at the Linux Foundation Collaboration Summit today, and was particularly interested in the panel discussion on open source and cloud computing. While we are used to hearing and talking about how important open source software is to cloud computing (open source giving to cloud computing), moderator John Mark Walker posed the question of whether cloud computing gives back? The discussion also rightfully focused on openness in cloud computing, how open source might or might not translate to cloud openness and the importance of data to be open as well.

The discussion also centered on some issues regarding open standards and how open is open enough for cloud computing? …

[Read more]
Is there a MySQL New feature request list anywhere?

Since the time that I’ve been using MySQL I have filed quite a few bug reports. Some of these have been fixed and many of the bug reports are actually new feature requests. While working with MySQL Enterprise Monitor I’ve probably filed more feature requests than bug reports.

That’s fine of course and my opinion of what is needed in MySQL or Merlin is one thing,  yours or the MySQL developers is something else. We all have our own needs and find things missing which would solve our specific problems.

If I have ten feature requests open and only one could be added to the software I’d also like to be able to say: this feature is the most important one for me.

However, it seems to me that there is no easy way in the mysql bug tracker at the moment to group together different types of new feature requests into groups of related features and then see the different types of …

[Read more]
New TokuDB 2.2.0 feature: more query progress information

Last spring, we added a feature that allows the user to see the progress of writes in a statement. Vadim liked it. In 2.2.0, in “show processlist”, we add progress information on reads.

Here is an example of what “show processlist” displays on an update:

mysql> show processlist \G
*************************** 1. row ***************************
Id: 1
User: root
Host: localhost
db: test
Command: Query
Time: 7
State: Queried about 1576008 rows, Updated about 197000 rows
Info: update foo set a=9 where a=8

Here is an example of what “show processlist” displays on an insert that requires a query:

mysql> show processlist \G
*************************** 1. row ***************************
Id: 1
User: root
Host: localhost
db: test
Command: Query
Time: 6
State: Queried about 1542001 rows, Inserted about 771000 …
[Read more]
MySQL features timeline

I’ve begun a MySQL features timeline which is a quick reference showing as of what version MySQL features were added, changed or removed. The manual tells us this, of course, but I wanted a quicker reference. The list is far from complete as there’s a huge number of features to cover. I’ll continue to improve it and help is appreciated. Send me a quick email saying “feature x added/removed/changed as of version y” and I’ll do the rest. — If someone has already done this, please give me the url so I don’t reinvent the wheel.

Showing entries 31 to 40 of 48
« 10 Newer Entries | 8 Older Entries »