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
Helpful, step-by-step instructions for setting up PHP and MySQL on OS X Yosemite.
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.
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.
A Hibernate persistence context can hold one and only one reference of a given entity. The first level cache guarantees session-level repeatable reads.
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.
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...
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.
Grouping sets is one of the cool feature came in SQL SERVER 2008. Lets understand here with problem and solution.
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.
In this post, we'll get Sqoop (1.99.3) connected to an Oracle database, extracting records to HDFS.
One of the pain points for any SQL engineer is “Performance”. There are various reasons due to which your SQL Server database is slow.
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.
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.
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.
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.
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.
Hello friends, just wanted to share some technical words here again...
When field access mode is used, JPA directly reads the state values from the fields of an entity using reflection.
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.
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.
A short introduction to using heap tables in SQL.
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.
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.
SQLite developer Richard Hipp posted recently that the database has become 50% faster than it was 16 months ago.