SQL Zone is brought to you in partnership with:
  • submit to reddit
Peter Zaitsev10/31/14
206 views
0 replies

MySQL 5.6 Full Text Search Throwdown: Webinar Q&A

Yesterday (Oct. 22) I gave a presentation titled “MySQL 5.6 Full Text Search Throwdown.” If you missed it, you can still register to view the recording and my slides. Thanks to everyone who attended, and especially to folks who asked the great questions. I answered as many as we had time for during the session, but here are all the questions with my complete answers

Rob Allen10/30/14
2296 views
0 replies

Setting up PHP & MySQL on OS X Yosemite

Helpful, step-by-step instructions for setting up PHP and MySQL on OS X Yosemite.

Peter Zaitsev10/30/14
563 views
0 replies

Innodb Transaction History Often Hides Dangerous ‘Debt’

In many write-intensive workloads Innodb/XtraDB storage engines you may see hidden and dangerous “debt” being accumulated – unpurged transaction “history” which if not kept in check over time will cause serve performance regression or will take all free space and cause an outage. Let’s talk about where it comes from and what can you do to avoid running into the trouble.

Kevin Rutherford10/28/14
3864 views
0 replies

Where Is the Database?

I have just watched an interesting conversation between Martin Fowler and Badri Janakiraman about #hexagonalrails, and in particular about the role of databases. The central question in the discussion is whether the database should be considered outside or inside the domain.

Vlad Mihalcea10/27/14
2018 views
0 replies

Hibernate Application-Level Repeatable Reads

A Hibernate persistence context can hold one and only one reference of a given entity. The first level cache guarantees session-level repeatable reads.

Peter Zaitsev10/27/14
2435 views
0 replies

Percona Toolkit for MySQL with MySQL-SSL Connections

I recently had a client ask me how to use Percona Toolkit tools with an SSL connection to MySQL (MySQL-SSL). SSL connections aren’t widely used in MySQL due to most installations being within an internal network. Still, there are cases where you could be accessing MySQL over public internet or even over a public “private” network.

G. Ryan Spain10/26/14
3064 views
0 replies

The Best of the Week (Oct. 17): SQL Zone

Make sure you didn't miss anything with this list of the Best of the Week in the SQL Zone (October 17 - October 24). Here they are, in order of popularity...

Peter Zaitsev10/24/14
3223 views
0 replies

How to Avoid Hash Collisions When Using MySQL’s CRC32 Function

Percona Toolkit’s pt-table-checksum performs an online replication consistency check by executing checksum queries on the master, which produces different results on replicas that are inconsistent with the master – and the tool pt-table-sync synchronizes data efficiently between MySQL tables.

Rajat Jaiswal10/24/14
1238 views
0 replies

Grouping Sets: Good to Know Feature TIP# 60

Grouping sets is one of the cool feature came in SQL SERVER 2008. Lets understand here with problem and solution.

Rob Sanders10/23/14
894 views
0 replies

Server and Storage Tuning

This week at work, I’ve spent a fair amount of time working in the infrastructure space as we conducted a review of SQL Server and the underlying network infrastructure. As always, it inspired me to take a look at my home configuration – and do some tinkering.

Brian O' Neill10/22/14
2776 views
0 replies

Sqoop Oracle Example : Getting Started with Oracle -> HDFS Import/Extract

In this post, we'll get Sqoop (1.99.3) connected to an Oracle database, extracting records to HDFS.

Rajat Jaiswal10/22/14
940 views
0 replies

Find Last Statistics Updated Date Detail: Maintenance TIP #59

One of the pain points for any SQL engineer is “Performance”. There are various reasons due to which your SQL Server database is slow.

Lukas Eder10/21/14
2520 views
6 replies

Stop Claiming That You're Using a Schemaless Database

One of MongoDB’s arguments when evangelising MongoDB is the fact that MongoDB is a “schemaless” database... But it doesn’t mean that there is no schema.

Peter Zaitsev10/20/14
3787 views
0 replies

MySQL Compression: Compressed and Uncompressed Data Size

MySQL has information_schema.tables that contain information such as “data_length” or “avg_row_length.” Documentation on this table however is quite poor, making an assumption that those fields are self explanatory – they are not when it comes to tables that employ compression.

Joydeep Das10/18/14
1222 views
0 replies

Understanding of Execution Plan - III - B [ The OPERATORS ]

IN my previous Article we focused on Cluster Index Scan and Clustered Index Seek operators. Continuing my Article series named Understanding of Execution Plan – part III, we are moving on with some other operators.

Joydeep Das10/17/14
1742 views
0 replies

Understanding of Execution Plan - III - A [ The OPERATORS ]

In this article we are mostly focusing on the Logical and Physical Operators and trying to understand each as it is very important to understand them before understanding the Execution Plan.

Peter Zaitsev10/16/14
1230 views
0 replies

MySQL Ring Replication: Why It Is a Bad Option

I’ve recently worked with customers using replication rings with 4+ servers; several servers accepting writes. The idea behind this design is always the same: by having multiple servers, you get high availability and by having multiple writer nodes, you get write scalability.

Rajat Jaiswal10/16/14
2425 views
0 replies

Good to Know SQL JARGON - An interview TIP #56

Hello friends, just wanted to share some technical words here again...

Sayem Ahmed10/15/14
7418 views
0 replies

JPA Tutorial: Mapping Entities – Part 3

When field access mode is used, JPA directly reads the state values from the fields of an entity using reflection.

Peter Zaitsev10/15/14
2566 views
0 replies

MySQL Replication: 'Got fatal error 1236' Causes and Cures

MySQL replication is a core process for maintaining multiple copies of data – and replication is a very important aspect in database administration. In order to synchronize data between master and slaves you need to make sure that data transfers smoothly, and to do so you need to act promptly regarding replication errors to continue data synchronization.

Kathiravelu Pra...10/15/14
1050 views
1 replies

Fault-Tolerant Data Replication and Synchronization with Infinispan

Having multiple instances running over different nodes provide fault-tolerance, as when one node terminates, the other nodes have the backup replica of the partitions stored in the terminated node.

Peter Zaitsev10/13/14
2811 views
0 replies

Percona XtraBackup 2.2.5 Now Available (Free MySQL Hot Backup Software)

Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime.

Anders Karlsson10/11/14
3874 views
0 replies

OraMySQL 1.0 Alpha Released - Replication from Oracle to MariaDB and MySQL!!

Now it's time to release something useful! At least I hope so. I have been going through how I came up with this idea and how I came up with the implementation in a series of blog posts, but now it's time for the real deal, the software itself.

G. Ryan Spain10/10/14
5429 views
1 replies

SQLite - Now 50% Faster!

SQLite developer Richard Hipp posted recently that the database has become 50% faster than it was 16 months ago.