Tag: row

Feed: Planet MySQL; Author: MyDBOPS; In my day to day tasks as a DB Engineer at Mydbops we have been using multiple MySQL tools for multiple use cases to ensure an optimal performance and availability for servers managed by our Remote DBA Team. A tool like pt-online-schema can be used for any DDL changes ( Overview to DDL algorithm ), if any tool which needs to scheduled for longer period we tend to use screen or cron. Some of the problems we face when we demonise the process or use screen for running processes. The daemon process gets killed when ... Read More

Feed: Matillion. Author: Julie Polito; Applying transformations to an organization’s data helps make that data useful for analytics. However, transforming data can mean that data stored in source systems, such as Salesforce, differs from the data stored in a data warehouse. It can be a challenge for data teams to keep data in sync.  To help with this problem, Matillion has released a Salesforce Output component in v1.46. With this new component, a user can use the Salesforce API to write the contents of a source table or view back into Salesforce objects. The user can employ operations such as: ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Ever wanted to extend MySQL and add some feature you think it is missing?  With MySQL plugins, you can do exactly that.  One thing that has bothered me for several years is that you cannot easily retrieve system metrics from within MySQL.  Whether I am connecting via a remote connection or looking to add features to monitoring without the need for another interface with the server, I have wanted to retrieve system metrics without leaving the MySQL interface.So, I started a Proof of Concept for this.  My goal was to get metrics such ... Read More

Feed: SAS Blogs. Author: Rick Wicklin. The iml action in SAS Viya (introduced in Viya 3.5) provides a set of general programming tools that you can use to implement a custom parallel algorithm. This makes the iml action different than other Viya actions, which use distributed computations to solve specific problems in statistics, machine learning, and artificial intelligence. By using the iml action, you can use programming statements to define the problem you want to solve. One of the simplest ways to run a parallel program is to use the MAPREDUCE function in the iml action, ... Read More

Feed: Clustrix Blog. Author: Rob Hedgpeth. One of the most notable changes in MariaDB Community Server 10.5 is the addition of ColumnStore as a pluggable storage engine. With this addition, analytics is available to millions of users deploying the open source MariaDB community version for free. Sure, that sounds good, but how easy is it to actually use? If you want to see it in action before downloading MariaDB Community Server 10.5 for yourself, take a look at our recent webinar.In the webinar (which also includes an overview of the new features in MariaDB Community Server 10.5), I explain why ... Read More

Feed: Planet MySQL; Author: Marco Tusa; Why another article on this, Marco?MySQL deadlocks is a topic covered many times, including here at Percona. I suggest you review the reference section at the end of this post for articles on how to identify deadlocks and from where they are generated.So why another article?The answer is that messages we receive like the following are still very common:User (John): “Marco, our MySQL is having problems”Marco: “Ok John what problems? Can you be a bit more specific?”John: “Our log scraper is collecting that MySQL has a lot of errors”Marco: “Ok can you share the ... Read More

Feed: Planet MySQL; Author: Justin Swanhart; Oracle MySQL is in need of a columnar storage engine for analytics workloads.  A columnar engine (or column store) stores data vertically, that is, it stores all the data associated with a column together, instead of the traditional RDBMS storage method of storing entire rows together, either in a index organized manner, like InnoDB, or in a heap, like MyISAM.   Columnar storage has the benefit of reducing IO when only a subset of the row is accessed in a query, because only the data for the accessed rows must be read from disk ... Read More

Feed: MemSQL Blog. Author: Carl Sverre. As part of the #memsql4good initiative, hosted at MemSQL.org, MemSQL is excited to contribute to the SafeGraph COVID-19 Data Consortium. The Consortium provides free access to relevant datasets to researchers, non-profits, and governments. MemSQL has created a repository to help existing customers, and those who wish to get started with MemSQL for free, to use our software in processing coronavirus-related data.  SafeGraph is a company that offers point of interest (POI), business listing, and foot traffic data. They have started the COVID-19 Data Consortium to enable access to free data for responses to the ... Read More

Feed: Planet PostgreSQL. By Josh Williams July 2, 2020 Image from Flickr user fsse8info Recently the topic of generating random-looking coupon codes and other strings came up on internal chat. My go-to for something like that is always this solution based on Feistel networks, which I didn’t think was terribly obscure. But I was surprised when nobody else seemed to recognize it, so maybe it is. In any case here’s a little illustration of the thing in action. Feistel networks are the mathematical basis of the ciphers behind DES and other encryption algorithms. I won’t go into details (because that ... Read More

Feed: Planet PostgreSQL. By David Christensen June 30, 2020 Photo by Maxpax, used under CC BY-SA 2.0, cropped from original. When working with large tables, even simple actions can have high costs to complete. What queries are acceptable for smaller tables can often be less than ideal when applied to large tables, so your specific choice of approach to a given problem becomes more important. Note: We are using PostgreSQL 12, which supports some nice features like parallel btree index building, which can speed up parts of this process compared to earlier versions. We are using the default settings for ... Read More