FromDual TechFeed (de)

Workshop topics

Duration: 3 days, register here.

• Partitioning
  • Partitioning by time (temporal data)
  • Optimizer and Partitioning
  • Limitations
  • New 5.5 and 5.6 features of Partitioning
• InnoDB Architecture
  • Clustered PK
  • InnoDB Internals
  • InnoDB Online features
  • New Performance Features in 5.5 and 5.6
  • Operations of InnoDB
• Performance Tuning and Benchmarking
  • Basics, Latency and Throughput
  • Profiling
  • Benchmarking
  • Benchmarking Tools
• Memcached
  • Caching strategies
  • Operations
  • ding
• HA and replication solutions …

Dear MySQL and MariaDB User,

With this Newsletter you receive the News about FromDual for Spring 2011:

Topics

• Technical Information
• Support and Remote-DBA services for MySQL and MariaDB
• Open dates
• News about FromDual
• News about MySQL

Technical Information

We have compiled the following technical information for you:

• Configuration of MySQL for Shared Hosting: Operating MySQL in a Shared Hosting environment is one of the trickiest things you can do with MySQL. Some hints and information about it you can …

We do not currently operate any newsletter.

Old Newsletter

• Summer 2019
• Spring 2015
• Summer 2014
• Winter 2013
• Spring 2013
• Spring 2012
• Winter 2012
• Autumn 2011
• Summer 2011
• Spring 2011

Hi vishnuraj

Simple examples are always good to explain or to try to understand. So I created the following table:

In my database I have 3 fields as id,medicinename,quantity.
In medicinename I have many different names. Many names comes twice or thrice.

+------+----------------------+---------+
| id   | medicinename         | quantiy |
+------+----------------------+---------+
|    1 | Trifolium arvense L. |      25 |
|    2 | Agave americana      |     120 |
|    3 | Hypericum perforatum |      12 | …

The FromDual Performance Monitor for MySQL is now available on our download page.

An other customer was asking the following question related to this blog post:

Does this mean that the other node cannot even respond to read only queries?

Yes this is exactly what it means. It has nothing to do with Master-Slave Replication where you have for example a read-only Slave. In simple set-ups on the passive node there runs nothing except the Heartbeat and the DRBD process.

More details you can find on Wikipedia.

Some people who have their set-ups really under control run on the …

A friend made some private comments and allowed me to post them. IMHO they are worth considering. translate.google.com may help:

We configured Heartbeat to use the version 1 mode because of 3 reasons:

HA ist über Verfügbarkeit. Einfachheit der Konfiguration und eine geringe Anzahl zu testender Systemzustände sind ein wichtiger Punkt. CRM, und alles was danach kommt lösen keine Probleme sondern schaffen sie. Die Konfiguration wird so komplex, daß man sie nicht mehr ganz testen kann. Es geht darum, die …

Hi Henrik,

Yes great idea!

Basically the differences are: Zabbix is an integrated Monitoring and Alerting solution where Nagios is an Alerting Solution with Monitoring modules. Zabbix is technologically newer than Nagios. I have heard from some customers that they are not happy with how Fixes and Changes are included into Nagios. Incinga is a fork of Nagios and seems to address these problems.

More information you can find in the discussion: Can some one recommend some good monitoring tools for …

Due to lack of customer interest our Emergency Intervention service for MySQL, MariaDB and Percona Server has been withdrawn.

Please refer to our remote-DBA Services for MySQL, Galera Cluster for MySQL, MariaDB, and Percona Server for general MySQL DBA work OR our Support Services for MySQL, Galera Cluster for MySQL, MariaDB and Percona Server in case you expect and Emergency and require Emergency Intervention.

What you get

With this service you get your regular DBA work done. The difference to our Remote-DBA Service is that our specialist come on-site to your location.

• You get our MySQL DBA working for you on-site.
• You can buy a certain amount of days of DBA work to be performed: The minimum amount is 5 consecutive days.
• According to your business needs your standard database operation work is done on-site by our MySQL DBA’s. This includes for example:
  • Setup and installation of your MySQL database …

Our remote-DBA services are as flexible as our customers are different. We care about your mandates if they are related to MariaDB, MySQL or Galera Cluster. We also can support you in the database surroundings (Linux, Load Balancer, High-Availability). You purchase a 10 hour Service package and you can use it on demand during one year.

How our customers use their FromDual remote-DBA services

Our customers use their FromDual remote-DBA services in many different ways:

• A popular way using our services is to …

What you get

With our FromDual Database Health Check Service for MySQL and MariaDB you get your basic regular DBA work done:

• We check the mission critical information of your databases:
  • if your database is running smoothly.
  • if your servers have enough free disk space.
  • if your backup is done.
  • if your MySQL Cluster is up and running and has enough free memory.
  • if your replication is up and running and if it is lagging.
  • if your security rules are met.
  • if your DRBD and Heartbeat set-up is working properly. …

Backup is for sissies! Let’s have a look what we can do when we are not a sissy…

First of all: Your life is much easier when you have a proper backup process implemented and verified the restore procedure of your MySQL database.

But what if you have no backup in place and did a DROP TABLE. What shall we do?

We assume our data we just dropped are located on the following device:

# export IMAGE=/dev/hda1

First of all, power off your server. This avoids that the operating system writes data down …

Follow us on Twitter or subscribe to the FromDual Newsletter.

The content of this page has been moved to our company blog.

https://lists.launchpad.net/maria-developers/msg03814.html

Hello Justin,

Does the statement run in its own transaction after the main connection terminates?

It looks like not! :( I tried 4 different cases:

• KILL QUERY
• KILL CONNECTION
• kill <pid>
• kill -9 <pid>

Does the SQL properly increment global status variables, etc?

Yes. It looks like.

And referring to your last comment: You are absolutely right! This was just a pilot or prototype. So …

I just found that the MyISAM warm key blocks feature made it into MariaDB 5.2.4… :)

FromDual cooperates with the following companies:

Topic	Company	Description
MariaDB/MySQL Training	Linuxhotel GmbH	The Linuxhotel is one of the most important Open Source Software training and meeting places in German-speaking countries.
MariaDB Support	MariaDB AB	FromDual helps you to get into MariaDB Enterprise Subscriptions and Services.
MariaDB/MySQL Training	GFU Cyrus AG	GFU …

2000 - 2049

• Error: 2050 (CR_FETCH_CANCELED)

  Message: Row retrieval was canceled by mysql_stmt_close() call

• Error: 2051 (CR_NO_DATA)

  Message: Attempt to read column without prior row fetch

• Error: 2052 (CR_NO_STMT_METADATA)

  Message: Prepared statement contains no metadata

• Error: 2053 (CR_NO_RESULT_SET)

  Message: Attempt to read a row while there is no result set associated with the statement

• Error: 2054 (CR_NOT_IMPLEMENTED)

  Message: This feature is not implemented yet

• Error: 2055 ( …

1700 - 1749 2050 - 2099

• Error: 2000 (CR_UNKNOWN_ERROR)

  Message: Unknown MySQL error

• Error: 2001 (CR_SOCKET_CREATE_ERROR)

  Message: Can’t create UNIX socket (%d)

  ---

• Error: 2002 (CR_CONNECTION_ERROR) Message: Can’t connect to local MySQL server through socket ‘%s’

  How does the MySQL error message look like?

  shell> mysql --user=root --socket=/tmp/mysql.sock
  ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  

  What does the MySQL error …