Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 121 to 130 of 34765 10 Older Entries
Are Your Data Systems a Technology Tar Pit
+0 Vote Up -1Vote Down

Are you still running yesterday’s database? Technology and workloads have changed, so it might be time to re-examine your trusty standby. But how do you determine whether the benefits of new data storage technology are worth the cost and effort of evaluating and switching?

Perhaps you think your current data retrieval system is “good enough,” but that “just fine” system might be creating huge technical debt that could come back to haunt you. To keep up with the times, you might need to re-evaluate your database. This could result in a leaner, meaner, and more modern back end that can grow with your business and save you money.

  [Read more...]
How to create a rock-solid MySQL database backup & recovery strategy
+0 Vote Up -1Vote Down

Have you ever wondered what could happen if your MySQL database goes down?

Although it’s evident such a crash will cause downtime – and surely some business impact in terms of revenue – can you do something to reduce this impact?

The simple answer is “yes” by doing regular backups (of course) but are you 100% sure that your current backup strategy will really come through when an outage occurs? And how much precious time will pass (and how much revenue will be lost) before you get your business back online?

I usually think of backups as the step after HA fails. Let’s say we’re in …

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

This Log buffer edition covers Oracle, SQL Server and MySQL blog posts about new features, tips, tricks and best practices.

Oracle:

  • Traditionally, assigning specific processes to a certain set of CPUs has been done by using processor sets (and resource pools). This is quite useful, but it requires the hard partitioning of processors in the system. That means, we can’t restrict process A to run on CPUs 1,2,3 and process B to run on CPUs 3,4,5, because these partitions overlap.
  • Parallel_Degree_Limit, …
  [Read more...]
Backing up and restoring tables named with special characters
Employee +0 Vote Up -0Vote Down

Introduction

The names of databases and tables within MySQL are known as identifiers. In the simplest case these identifiers are just strings of certain ASCII characters (the basic Latin letters, the digits 0-9, the dollar sign and the underscore). However, if an identifier is placed in quotes, it can contain any character of the full Unicode Basic Multilingual Plane (except U+0000). We say that a character is a special character if it is permitted in a quoted identifier but not in an unquoted identifier.

MySQL Enterprise Backup (MEB) 3.12.1 …

  [Read more...]
MySQL User Camp, Bangalore – 26th June, 2015
Employee_Team +0 Vote Up -0Vote Down

MySQL User Camp Bangalore, organized on 26th June, 2015, was a huge success with an excellent turnout of 49 attendees. We got many users from different companies, like Flipkart, Snapdeal, CTS, Capgemini, Yahoo, VMware, HCL, Datavail, Bosch, Rakuten and more. The event started on time with a welcome speech by Balasubramanian Kandasamy, (Principal Member Technical Staff, […]

Circular Partitioning scheme for a fully Automated Archival / Purge process with Events
+0 Vote Up -0Vote Down

Partitioning The advantage of partitioning is that we can drop / truncate the partitions which is real quick and done in seconds. It does lock the table (metadata lock) during this operation but only for few seconds. That duration depends on the number of pages in use in the buffer pool. With MySQL 5.6 it is possible to exchange the partitions , which helps in moving archived data to another table with similar structure.
   
Fully Automated archival / purge 

Consider a fast growing table which is partitioned to help the queries and help quick archival/purge. The queries if specify the …



  [Read more...]
Introducing MySQL Performance Analyzer
+1 Vote Up -0Vote Down

At Yahoo, we manage a massive number of MySQL databases spread across multiple data centers.

In order to identify and respond to performance issues, we rely on an extremely lightweight and robust web based tool to proactively investigate the issues in them.

The tool has real time tracking features and continually gathers the most important performance metrics, provides visualization and statistical analysis for quickly identifying performance patterns, bottlenecks and possible tuning opportunities.

Features

Lightweight Agentless Java Web Application
Rich User Interface
Gather and Store performance metrics




  [Read more...]
Pillars of PowerShell: SQL Server – Part 1
+0 Vote Up -1Vote Down

Introduction

This is the sixth and final post in the series on the Pillars of PowerShell, at least part one of the final post. The previous posts in the series are:

  1. Interacting
  2. Commanding
  3. Debugging
  4. Profiling
  5. Windows OS

PowerShell + SQL Server is just cool! You will see folks talk about the …

  [Read more...]
MySQL 5.7.8 - Now featuring super_read_only and disabled_storage_engines
Employee +0 Vote Up -0Vote Down

I wanted to highlight two new features that are making their way into MySQL 5.7 via the not-yet-released 5.7.8-rc2:

  • A new system variable super_read_only allows a more strict definition of 'read-only' which also applies to super users.
  • A new …
  [Read more...]
Become a MySQL DBA - Webinar series: Which High Availability Solution?
+0 Vote Up -0Vote Down

There are many many approaches to MySQL high availability - from traditional, loosely-coupled database setups based on asynchronous replication to more modern, tightly-coupled architectures based on synchronous replication. These offer varying degrees of protection, and DBAs almost always have to choose a trade-off between high-availability and cost.

In this webinar, we will look at some of the most widely used HA alternatives in the MySQL world and discuss their pros and cons.

DATE & TIME

Europe/MEA/APAC
Tuesday, July 28th at 09:00 BST / 10:00 CEST (Germany, France, …

  [Read more...]
10 Newer Entries Showing entries 121 to 130 of 34765 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.