Category: MySQL & MariaDB

Feed: Planet MySQL; Author: MySQL Performance Blog; We all like when error messages are descriptive and give a clear idea about what is happening; however, there are some cases when a few possible reasons lay behind one error message. “MySQL server has gone away” is one of them. Most of the cases when the error occurs are described in MySQL documentation, but it can get tricky. And here, I’d like to talk about “tricky”.There are only a few major cases when this happens:1. MySQL Thread Was Killed by an Administrator or a Utility Such as pt-killThe manual intervention is likely ... Read More

Feed: Planet MySQL; Author: The Pythian Group; If you have a New Relic Infrastructure Pro license, and unmonitored MySQL servers, there’s now an easy solution at your fingertips. With the New Relic MySQL integration you can monitor and graph almost any detailed metric you could possibly want. New Relic recently unified its analytics tools with New Relic One, a dashboard that provides quick access to all the New Relic tools. With an Infrastructure Pro subscription, you get access to: New Relic Infrastructure: Flexible, dynamic monitoring of your entire infrastructure, from services running in the cloud or on dedicated hosts, to ... Read More

Feed: Planet MySQL; Author: Kristian Köhntopp; In Deleting data we have been looking at a process that loads data into MySQL, leveraging partitions to make it easier and faster to later get rid of the data again. For this, we created three processes, a data loader process, and two observers - one for creating partitions, and one for deleting them.The observer processes have been running ANALYZE TABLES and then polling INFORMATION_SCHEMA.PARTITIONS every 1/10th of a second to check if intervention is needed. They then have been dynamically generating the necessary ALTER TABLE statements maintaining the proper partitioning of the table ... Read More

Feed: Planet MySQL; Author: Michael McLaughlin; MySQL will be used for our online sections because the VMware instance and Docker configurations where too large to effectively download this term. MySQL 8.0.21 Installation Steps After you download the MySQL 8 MSI file, you will perform the following 24 steps to install MySQL on Windows 10. If you want a full developer install you must install Microsoft Excel and Visual Studio first. The first thing you need to do is grant privileges to allow the MySQL Installer application to work in Windows 10. Click the Yes button to authorize the MySQL Installer ... Read More

Feed: Planet MySQL; Author: ProxySQL; This post is the first of a series of blogposts on how to easily use ProxySQL to scale-out your application’s database workload on a Galera cluster. This series will explore the main concepts in configuring ProxySQL for Galera across three articles as follows: – A first introductory post describing the minimal configuration needed for ProxySQL to monitor and manage a Galera Cluster.– A second post describing how to setup a read/write split configuration for our Galera Cluster, using ProxySQL query rules.– A third and final post with examples on specific cluster configuration options and more ... Read More

Feed: Planet MySQL; Author: Kristian Köhntopp; Completing the data lifecycle is often harder than originally expected: Deleting data can cost sometimes way more than inserting it in the first place. MySQL Partitions can offer a way out. We have an earlier post on the subject.A sample table, and a problem statement Let’s define a kind of log table, to which data is added with an auto_increment id value and some data. #! /usr/bin/env python3 from time import sleep from random import randint from multiprocessing import Process import click import MySQLdb import MySQLdb.cursors db_config = dict( host="localhost", user="kris", passwd="geheim", db="kris", cursorclass=MySQLdb.cursors.DictCursor, ... Read More

Feed: Recent Announcements. With an increased storage limit of 128TB, you’re less likely to reach the limit when you scale up your application on a single Amazon Aurora database cluster. This means you won’t need to delete data or to split the database across multiple instances. Learn more by visiting the Amazon Aurora Storage and Reliability documentation.   128TB support is available with Aurora MySQL engine version 1.23, compatible with MySQL 5.6, with engine version 2.09, compatible with MySQL 5.7, and with Aurora PostgreSQL 9.6.17, 10.12 and 11.7. Amazon Aurora is a MySQL and PostgreSQL-compatible relational database built for the ... Read More

Feed: Featured Blog Posts - Data Science Central. Author: Sharmistha Chatterjee. Importance of C++ in Data Science and Big Data Introduction and Motivation – Why C++ C++ is ideal for dynamic load balancing, adaptive caching, and developing large big data frameworks, and libraries. Google’s MapReduce, MongoDB, most of the deep learning libraries listed below have been implemented using C++. Scylla known for its ultra-low latency and extremely high throughput is coded using C++ acts as a replacement to Apache Cassandra and Amazon DynamoDB. With some of the unique advantages of C++ as a programming language, (including memory management, performance characteristics, and systems programming), it definitely serves as one of the most efficient tools for developing fast scalable Data Science and Big Data libraries. Further, Julia (a compiled and interactive language – ... Read More

Feed: R-bloggers. Author: George Pipis. [This article was first published on R – Predictive Hacks, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. Need to Connect R with SQL It is common for Data Analysts/Scientists to connect R with SQL. For that reason, there exist many different packages designed for different Databases like PostgreSQL, MySQL etc. My suggestion is to work with the DBI package which is compatible with almost all the Databases ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; Our pleasure to announce the MySQL Day which will be hold on September 26, 2020. Please find more details below and at the Oracle India User Group website. Name: MySQL Day Date: September 26, 2020 Agenda:  11:00 to 11:20 - Welcome: MySQL Day Agenda by Sanjay Manwani, the MySQL India Dev. Sr. Director, Oracle.  11:30 to 12:00 - Keynote: State of MySQL by Tomas Ulin, the Vice President, Oracle 12:15 to 13:15 - Hands-On: Introduction to MySQL Database Service (MDS) by Jothir Ganesan, the Software Development Manager, Oracle   13:15 to 14:15 - Lunch Break     ... Read More