Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 91 to 100 of 962 10 Older Entries

Displaying posts with tag: Uncategorized (reset)

Will be speaking at Perconal Live London 2014
+0 Vote Up -0Vote Down

10 common replication problems
+0 Vote Up -0Vote Down

Below are 10 common replication problems :

1)Session binlog :

Setting sql_log_bin = 0 will disable binary logging for the session. So any DML/DDL query executed within that session on the master will not be replicated to slave


Turn off binary logging on master :

mysql> set sql_log_bin = 0 ;
Query OK, 0 rows affected (0.00 sec)

Create table in reptest database ( on master )

mysql> create table reptest(ID int) ;
Query OK, 0 rows affected (0.01 sec)

mysql> show tables ;
| Tables_in_reptest |
| reptest           |
1 …
  [Read more...]
Using information_schema tables – Part 1
+0 Vote Up -0Vote Down

Below are some of the common scenarios where information_schema is useful :

Tables table

How to check the database size using information_schema ?

SELECT table_schema "Data Base Name", SUM( data_length + index_length) / 1024 / 1024 
"Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema ;

How to list the tables created before 4 days ?

 select * from information_schema.tables where CREATE_TIME < NOW() - INTERVAL 4 DAY ;

Columns table :

List all the tables that have a column called birth_date

select table_name from …
  [Read more...]
Tracing down a problem, finding sloppy code
+0 Vote Up -0Vote Down

Daniel was tracking down what appeared to be a networking problem….

  • server reported 113 (No route to host)
  • However, an strace did not reveal the networking stack ever returning that.
  • On the other side, IP packets were actually received.
  • When confronted with mysteries like this, I get suspicious – mainly of (fellow) programmers.
  • I suggested a grep through the source code, which revealed  return -EHOSTUNREACH;
  • Mystery solved, which allowed us to find what was actually going on.

  [Read more...]
MySQL process list – Customized connection counts
+0 Vote Up -0Vote Down

You got a production support call related to connection usage. Max_connections is set to 400 and  connection usage has reached the maximum limit.

Below are some of the customized reports that can be used to trace the problem

Count by host :

mysql> select count(*),host from information_schema.processlist group by HOST;
| count(*) | host |
| 1 | localhost |
1 row in set (0.03 sec)

Count by database:

mysql> select count(*),host from information_schema.processlist group by DB; …
  [Read more...]
MySQL Workbench 6.2.1 BETA has been released
Employee_Team +1 Vote Up -0Vote Down

Dear MySQL Users,

The MySQL Workbench team is announcing availability of the first beta
release of its upcoming major product update, MySQL Workbench 6.2.

MySQL Workbench 6.2 focuses on support for innovations released in MySQL
5.6 and MySQL 5.7 DMR (Development Release) as well as MySQL Fabric 1.5,
with features such as:

* A new spatial data viewer, allowing graphical views of result sets
containing GEOMETRY data and taking advantage of the new GIS
capabilities in MySQL 5.7.
* Support for new MySQL 5.7.4 SQL syntax and configuration options.
* Metadata Locks View shows …

  [Read more...]
NDB – Forced node shutdown completed. Caused by error 2341: ‘Internal program error (failed ndbrequire)
+0 Vote Up -0Vote Down

recently while working on MySQL cluster 7.3.5, we came across this error

Forced node shutdown completed. Caused by error 2341: 'Internal program error (failed ndbrequire)(Internal error, programming error or missing error message, please report a bug). Temporary error, restart node'.

The management nodes would start up but

the data nodes would complete phase 1 & shutdown, some times at phase 2 and some times at phase 5.

The error one would see in the trace file would be as follows:

Status: Temporary error, restart node
Message: Internal program …
  [Read more...]
Upgrade MySQL to a new version with a fresh installation & use shell scripts and mysqldump to reload your data
+0 Vote Up -0Vote Down

There are several ways to upgrade MySQL. In this post, we will use a combination of shell scripts and the mysqldump application to export our MySQL data, and then re-import it back into the upgraded version of MySQL.

In this example, we will be doing a minor version upgrade. We will be going from 5.6.17 to 5.6.19. This method may not work if …

  [Read more...]
New! MySQL Utilities release-1.4.4 GA
Employee_Team +0 Vote Up -0Vote Down

The MySQL Utilities Team is pleased to announce the latest GA release of MySQL Utilities, release-1.4.4. This release includes improvements in terms of usability, stability, security and an overall improvement regarding the comprehensibility of the provided error messages.


The following highlights a few of the more significant improvements.

  • mysqlrpladmin errant transactions for switchover have been improved. Note : The errant transactions check requires all servers in the topology to have GTID’s enabled.
  • Failed MySQL server connection error messages now display the actual error returned from the …
  [Read more...]
New! MySQL Utilities Now Supports SSL and Configuration Files
Employee_Team +0 Vote Up -0Vote Down

The MySQL Utilities Team is pleased to announce a new release that contains our newest features – SSL and configuration file support. These were added to release-1.5.0-alpha.

How can I make a secure connection to my server via Utilities?

Use the new SSL command-line options that are available for all utilities:

–ssl-ca : The path to a file that contains a list of trusted SSL certificate authorities.
–ssl-cert : The name of the SSL certificate file to use for establishing a secure connection.
–ssl-key : The name of the SSL key file to use for establishing a secure connection.

  [Read more...]
10 Newer Entries Showing entries 91 to 100 of 962 10 Older Entries

Planet MySQL © 1995, 2015, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.