Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 34222 10 Older Entries
FromDual.en: MySQL Environment MyEnv 1.2.0 has been released
+0 Vote Up -0Vote Down

Taxonomy upgrade extras: myenvoperationMySQL Operationsmulti instanceconsolidationtestingupgrade

FromDual has the pleasure to announce the release of the new …

  [Read more...]
Ruby-MySQL Columns
+0 Vote Up -0Vote Down

Last week I posted how to configure and test Ruby and MySQL. Somebody asked me how to handle a dynamic list of columns. So, here’s a quick little program to show how to read the list of column:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
require 'rubygems'
require 'mysql'
 
# Begin block.
begin
  # Create a new connection resource.
  db = Mysql.new('localhost','student','student','studentdb')
 
  # Create a result set.
  rs = db.query('SELECT …
  [Read more...]
mysqldiskusage – source code examination
+0 Vote Up -0Vote Down

As you know there is a great toolset named “MySQL Utilities”, which you can use for solving various administrative tasks.
mysqldiskusage utility is for calculating MySQL Server’s disk usage and generating informative reports.
Of course this project is open source and everybody could review the source code.
A few words about how mysqldiskusage calculates database disk usage will be crucial for understanding algorithm.
The source tree is: mysql-utilities-1.5.4/scripts/mysqldiskusage.py
If you open this Python file you will …




  [Read more...]
a wild Supposition: can MySQL be Kafka ?
+0 Vote Up -0Vote Down

This is an idea which i presented at percona live 2015.

Is MySQL an avatar of Apache Kafka ?

Can it be Kafka ?

Yes, it can.

This talk takes a shot at modeling MySQL as Kafka.

PS: it’s unconventional, hence a WILD supposition :)

slides @

http://www.slideshare.net/jaihind213/can-mysql-bekafka

 or

http://www.percona.com/live/mysql-conference-2015/sessions/wild-supposition-can-mysql-be-kafka

Java-MySQL Program
+0 Vote Up -0Vote Down

It turns out that configuring Perl wasn’t the last step for my student instance. It appears that I neglected to configure my student instance to support Java connectivity to MySQL. This post reviews the configuration of Java to run programs against MySQL. It also covers the new syntax on how you register a DriverManager, and avoid Java compilation errors with the older syntax.

In prior posts, I’ve shown how to use Perl , PHP, …

  [Read more...]
Introducing VMware Continuent 4.0 – MySQL Clustering and Real-time Replication to Data Warehouses
+0 Vote Up -0Vote Down

It’s with great pleasure we announce the general availability of VMware Continuent 4.0 – a new suite of solutions for clustering and replication of MySQL to data warehouses.

VMware Continuent enables enterprises running business-critical database applications to achieve commercial-grade high availability (HA), globally redundant disaster recovery (DR) and performance scaling. The new suite

Social Networking Using OQGraph
+0 Vote Up -0Vote Down

I was given the chance to experiment typical social networking query on an existing 60 Millions edges dataset
How You're Connected


  [Read more...]
Log Buffer #419: A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

This Log Buffer Edition covers Oracle, MySQL, SQL Server blog posts from around the world.

Oracle:

  • Why the Internet of Things should matter to you
  • Modifying Sales Behavior Using Oracle SPM – Written by Tyrice Johnson
  [Read more...]
MySQL-AutoXtrabackup command line tool for using Percona Xtrabackup
+0 Vote Up -0Vote Down

Want to introduce our MySQL-AutoXtraBackup command line tool, using Percona Xtrabackup in core. Looking for contributor

Project Structure:

XtraBackup is powerfull and open-source hot online backup tool for MySQL from Percona.
This script is using XtraBackup for full and incremental backups, also for preparing and recovering taken backups.
Here is project path tree (default location is /home/MySQL-AutoXtraBackup):

* backup_dir — The main folder for storing backups.
* master_backup_script — Full and Incremental …



  [Read more...]
Performance Schema: Great Power Comes Without Great Cost
Employee_Team +1 Vote Up -0Vote Down

Performance Schema is used extensively both internally and within the MySQL community, and I expect even more usage with the new SYS Schema and the Performance Schema enhancements in 5.7. Performance Schema is the single best tool available for monitoring MySQL Server internals and execution details at a lower level. Having said that, we are …

  [Read more...]
Showing entries 1 to 10 of 34222 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.