The MySQL team are busily working on improving ways to use MySQL in scalable highly available systems. As most of you are already aware, the MySQL Group Replication project is progressing at full speed. Indeed, we just got preview release 0.5 out, while Fabric 1.5.6 was just released and work is ongoing for the Fabric 1.6 release.…

There are at least three issues with the catalog URL rewrite indexer and URL rewrite management in Magento:

• A reindex will add a new rows for products with duplicate url_key's - every single time you reindex
• Disabled products generate new rows
• Products that are not-visible individually generate new rows

Core bug

I’m pretty late to the party, but decided to investigate it anyway since I have to deal with many stores whose indexers get stuck because of various SQL errors related to the URL rewrite index and whose tables are way too big and out of proportions for the amount of categories and products they have.

This bug will make your table grow into the millions of rows and hundreds of …

[…] Aurora CPU […]

This Log Buffer Edition dives deep into the ocean of blogosphere and surfaces with some cool blog posts from Oracle, SQL Server and MySQL.

Oracle:

• Lets Talk DB Perth
• The Fundamental Challenge of Computer System Performance
• Index Advanced Compression: Multi-Column Index
• Middleware Diagnostics Advisor (MDA) Setup
• Most people are now aware that in 12c, a …

Intro

The purpose of this project was to measure the potential overhead of VividCortex Agent, which is used by VividCortex.com database monitoring system. This benchmark is part of a consulting engagement with VividCortex and paid by the customer.

The assumption is that VividCortex agent uses CPU processing time, and we should see an impact on user queries when the workload is CPU-intensive (how much is to be measured). The impact on IO-bound should be small or insignificant.

Workload Description
For this, we use LinkBenchX benchmark in a combination of different options.

Workloads

There are 3 different workloads we want to look into:

• CPU bound. …

Welcome to WordPress. This is your first post. Edit or delete it, then start writing!

The post Hello world! appeared first on ScaleDB Extending MySQL for Volume and Velocity.

Indonesia, the fourth most populous country in the world, is emerging as an economic powerhouse in Asia Pacific. With 60% of a population of 250 million being under 30 years of age, growing internet penetration and greater spending power by the middle-class have catalyzed the eCommerce sector. The vast majority of Indonesians don’t own credit cards, so local eCommerce players have developed innovative payment solutions.

Veritrans was established in October 2012, and in under 3 years, has grown into one of the largest payment gateways in the country. The company processes payments (credit/debit card, internet and mobile banking) for over 1000 merchants, including businesses such as Garuda Indonesia (the national airline of Indonesia), Groupon Indonesia (Disdus) and Rakuten Indonesia. The company has a staff of 85 employees. Competitors include the likes of Doku, iPayMu, Pay88 and a dozen others. Doku alone processed …

In two earlier posts, I gave some examples on how to use Perl to send tweets stored in a MySQL database to Twitter, and then how to automatically reply to your retweets with a “thanks”. In this post, I will show you how to automatically download your direct messages from Twitter, store the messages in a MySQL database, and then delete them.

I don’t like the way Twitter makes me read my direct messages. Granted, the majority of them are not real messages. The message is usually thanking me for following the sender, and then there is a personal website link or a link to a product they are selling. But if I want to delete a direct message, I have to …

[…] PlanetMySQL Voting: Vote UP / Vote DOWN Full article:MySQL Aurora CPU spikes […]

Or should I say to: "not to get soaked"...

The Amsterdam weather forecasts for next week is out  and it does not look so good during Percona Live MySQL and NoSQL Conference:

Of course, this is not a problem during talks, and I take this opportunity to invite you to my talks:

Riding the Binlog: an in Deep Dissection of the Replication Stream(22 September 11:20AM - 12:10PM @ Matterhorn 3)