Neuigkeiten

Table of Contents

• Accounts not properly closing connections
• Unused indexes
• Who created temporary (disk) tables
• Accounts which never connected since last start-up
• Users which never connected since last start-up
• Totally unused accounts (never connected since last restart and not used to check Stored Program or View privileges) since last start-up
• SHOW FULL PROCESSLIST
• Storage Engines per schema
• Tables without a Primary Key
• Bad SQL queries of users
• SHOW PROFILE in PERFORMANCE_SCHEMA
• SELECT, INSERT, UPDATE and …

We did a similar thing this week with Galera Cluster for MySQL and the Galera Load Balancer (glb).

Here you can find the script.

I have not had the time yet to test it. Please let us know if it does not work or when you were successful...

Hi Fabio,

There are several ways to do this. The most simple one but possibly not what you need is:

mysql> pager grep A
SHOW DATABASES;

The better way to do this IMHO is:

mysql> SHOW DATABASES LIKE 'A';

And the best way (works in MySQL 5.0 and newer) IMHO is:

mysql> SELECT * FROM information_schema.schemata WHERE schema_name = 'A';

I hope this helps you solving your problem?

Regards,
Oli

VirtualBox

Network Interface does not start on Guest System:

MAC Address must be all the same in:

• /etc/sysconfig/network-script/ifcfg-eth0
• /etc/udev/rules.d/70-persistent-net.rules
• AND VirtualBox: Guest
  > Network
  > Adapter
  > Advanced
  > Mac Address

FromDual invites you to check out our 2013 professional course schedule, set out below.

You need to book early to avoid disappointment. Why?

Because we run small, intimate and in-depth classes, giving you more time for -

• individual attention
• lots of interaction
• sharing of insights and experience

Our aim is to give you real value for your money and a genuine return for your investment with us.

Special Addition

Due to customer requests, we have added two of our advanced MySQL training courses in late April …

Overview

• MySQL Security Products
• Useful Security Links
• Security Vulnerabilities Fixed in MariaDB
• Oracle Critical Patch Update (CPU) Advisory for MySQL
• RedHat/CentOS vulnerabilities by CVE name
• Ubuntu Security Notice (USN) for MariaDB
• Ubuntu Security Notice (USN) for MySQL
• Debian Security Advisories
• Debian Security Advisories for MySQL
• MySQL Exploits
• Debian Security Advisories for MariaDB
• MariaDB Exploits
• MariaDB Security Risk Matrix
• Cyber Emergency Response Team (CERT) in Australia and APAC
• MariaDB …

Register here for our MySQL and MariaDB trainings in Switzerland. For our MySQL and MariaDB trainings in Germany you can register directly on-line at the MySQL and MariaDB training class schedule.

Prices

The training fees for Switzerland are:

• SQL for beginner (3 days): CHF 2'880.-
• MySQL for beginner (2 days): CHF 1'920.-
• MySQL for developer (3 days): CHF 2'880.-
• Advanced MySQL (5 days): CHF 4'450.-
• Galera Cluster for MySQL (2 days): CHF 1'920.-

If you wish other training dates, please get in contact with …

You are already familiar with the MySQL or MariaDB and you are challenged to operate a serious MySQL database. If this is the case this training is the right one for you.

Requirements

You are familiar with the MySQL basics and have already some experience with MySQL or MariaDB operations. The SQL language does not look strange to you any more. Further you are familiar with the Linux console and rule the most important UNIX commands.

Audience

• MySQL application developer
• MySQL and MariaDB database …

Will come soon…

Please let us know your intention to for choosing this page!

Will come soon…

Please let us know your intention to for choosing this page!

Hallo MySQL Gemeinde,

Im neuen iX (2012-10) hat es zwei nette Artikel über: MySQL HA-Lösungen (S. 116) und MySQL 5.6 (S. 66).

Viel Spass beim Lesen!

Hello Frazer,

Thank you very much for your valuable feedback. Good that Oracle is doing something in this direction and make MySQL even easier to use!

Oli

Hello Roger,

The item FromDual.MySQL.check (MPM Agent is alive) is triggering the agent. Its interval is by default set to 10 seconds. Try to set the interval to 30 seconds and let us know if it helps…

Best regards, Oli

If you have questions related to FromDual GmbH please get in contact with us:

Photos

Photos about FromDual you can fint at Flickr

Blogs and Social Media

We provide you the following Company Blog aggregates:

• Our company technical blog in English
• Our company technical blog in German
• Our company information blog in English
• Our company information blog in German

You can follow FromDual at Twitter, Xing, LinkedIn and Facebook.

FromDual videos you can …

PHP Java bytecode

PHP Compiler

// Call with php -f test.php

error_reporting(E_ALL);

// Class (blueprint) = package => object (instantiated class)
class ParentClass {

  // variable = property

  // encapsulation
  // visible anywhere
  public $public       = 'Public';
  // visible only within the class, and in inherited and parent classes
  protected $protected = 'Protected';
  // visible only within class
  private $private     = 'Private';

  // function = methode
  public function printItem($string) …

Hello Mahesh,

Thanks for the suggestion. I have added MONyog...

Oli

SELECT t.table_schema, t.table_name, t.engine
  FROM information_schema.tables AS t
  LEFT JOIN information_schema.key_column_usage AS i ON t.table_schema = i.table_schema AND t.table_name = i.table_name AND i.constraint_name = 'PRIMARY'
 WHERE i.constraint_name IS NULL
   AND t.table_schema NOT IN ('information_schema', 'mysql')
;

InnoDB Buffer Pool

The InnoDB Buffer Pool is the memory area where the InnoDB Storage Engine caches its data and index blocks. Each InnoDB data and index block has a size of Innodb_page_size (16384 byte = 16 kbyte). The InnoDB Buffer Pool is configured in bytes with the innodb_buffer_pool_size variable. On a dedicated system the InnoDB Buffer Pool can be configured up to 80% of the systems physical RAM (free).

The innodb_buffer_pool_awe_mem_mb variable is relevant only on 32-bit Windows systems with more …

A bug report for the following problem has been opened: http://support.fromdual.com/bugs/view.php?id=40

A customer asked:

I would like to know if the FromDual Performance Monitor for MySQL works with Zabbix 2.0?

We do not know yet (June 2012). This is a project for this summer… We do not expect any problem if the Zabbix 2.0 interfaces have not changed significantly.

This customer kindly tested fpmmm on Zabbix 2.0 for us.

The customer reported:

In relation to FromDual Performance Monitor for MySQL, I’ve started a test today and I can import the xml files without any problem with Zabbix 2.0
To be …