Tag: FULLTEXT

Feed: Planet MySQL; Author: Vlad Mihalcea; Introduction In this article, I’m going to explain how to do query profiling using the MySQL Performance Schema. The Performance Schema has been available since MySQL 5.5.3 and allows MySQL to instrument SQL queries and store their trace information in various tables that you can later inspect in order to determine why a given SQL statement is slow. On older versions of MySQL, you might have used the SHOW PROFILE command, but since this feature has been deprecated, you should now use the Performance Schema for SQL query profiling. Enabling the MySQL Performance Schema ... Read More

Feed: AWS for SAP. Author: Patrick Leung. Most companies have processes to better understand their customers and data is fast becoming the key to strengthening customer relationships. However, merely collecting data isn’t enough. While most organizations have access to plenty of data, determining the meaning behind the data can be difficult. In this blog post, we show how you can use a combination of SAP Data Intelligence 3 (DI3), SAP HANA and Amazon S3 to build a data-driven architecture to better understand customer feedback and derive meaningful insight. We start with the deployment of SAP Data Intelligence 3 and show ... Read More

Feed: Planet MySQL; Author: Marcelo Altmann; MySQL 5.7, alongside other many improvements, brought bulk load for creating an index (WL#7277 to be specific), which made ADD INDEX operations much faster by disabling redo logging and making the changes directly to tablespace files. This change requires extra care for backup tools. To block DDL statements on an instance, Percona Server for MySQL implemented LOCK TABLES FOR BACKUP. Percona XtraBackup (PXB) uses this lock for the duration of the backup. This lock does not affect DML statements.MySQL 5.7 doesn’t have an option to block an instance against DDL and to allow all ... Read More

Feed: Planet MySQL; Author: Severalnines; Mysqldump is a popular logical backup tool for MySQL which was originally written by Igor Romanenko. Mysqldump performs logical backups (set of SQL statements). By default, mysqldump does not dump information_schema tables and it never takes performance_schema. But the major drawback of mysqldump is that it uses only one thread while doing backup and restore. (Even your server has 64 cores). To overcome this drawback, MySQL introduced new utilities on the Shell client. In this blog I am going to explain these new backup utilities. Overview of MySQL Shell  The MySQL shell is a powerful ... Read More

Feed: Planet MySQL; Author: Severalnines; The ALTER TABLE statement is one of the most frequently used statements in the MySQL world - the statement allows you to add, delete or modify columns in a table. In this blog post we will try to look deeper into what it is, what it does and when should it be used. What is ALTER TABLE and What Does it Do? As already mentioned above, the ALTER TABLE statement enables DBAs and developers to add, delete or modify columns in a table. Simply put ALTER TABLE changes the structure of a table - it ... Read More

Feed: R-bloggers. Author: rOpenSci - open tools for open science. fulltext is a package I maintain for text-mining the scholarly literature (package docs). You can search for articles, fetch article metadata and abstracts, and fetch full text of some articles. Text-mining the scholarly literature is a research tool used across disciplines. Full text of articles (entire article, not just the abstract) is the gold standard in text-mining in most cases. Over the past years the fulltext package has evolved under the hood in its approach to attempting to get full text articles for its users. The following is a walk ... Read More

Feed: R-bloggers. Author: rOpenSci - open tools for open science. rOpenSci HQ rOpenSci at R-Ladies Our community manager Stefanie Butland, and one of our software review editors Brooke Anderson, are speaking remotely at an R-Ladies East Lansing meetup Thursday, October 22nd. They will talk about our how to get involved in rOpenSci using our new Contributing Guide as an entry point, and through participating in software review as a package author or reviewer. Contributing Guide Release The purpose of our new Contributing Guide is to welcome you to rOpenSci and help you recognize yourself as a potential contributor. It will ... Read More

Feed: AWS Compute Blog. Author: Moheeb Zara. This guide demonstrates creating and deploying a production ready document scanning application. It allows users to manage projects, upload images, and generate a PDF from detected text. The sample can be used as a template for building expense tracking applications, handling forms and legal documents, or for digitizing books and notes.The frontend application is written in Vue.js and uses the Amplify Framework. The backend is built using AWS serverless technologies and consists of an Amazon API Gateway REST API that invokes AWS Lambda functions. Amazon Textract is used to analyze text from uploaded ... Read More

Feed: R-bloggers. Author: rOpenSci - open tools for open science. I’m starting to tackle a few hard packages (spplit and spenv) having to do with integrating disparate data sources. I’ll talk here about spplit. I haven’t worked on spplit in a few years; I thought I’d make another attempt with “fresh” eyes.There are many use cases I can imagine for spplit; I’ll highlight a few. First, one may want to find literature that mentions particular scientific names (find all the journal articles that include the name Ursus americanus (American black bear)). Second, one could extract scientific names from scientific literature ... Read More

Feed: Planet MySQL; Author: MySQL Server Dev Team; This is part 3 of the blog post series about MySQL Shell Dump & Load: Introduced in MySQL Shell 8.0.21, the new MySQL Shell Dump and Load utilities has as its main goal to minimize the time needed to create and restore logical dumps of large data sets. Through heavy parallelization and other techniques, we were able to reduce the time needed for these tasks by an order of magnitude compared to previous dump utilities. In fact, we’ve observed dump speeds close to 3 GB/s and loads at over 200MB/s in benchmarks using ... Read More