Tag: INDEX

Feed: Planet MySQL; Author: MyDBOPS; MySQL 8.0 has come with a list of new features for DBA’s ,we will discuss the new feature in MySQL 8.0 which supports Descending index.Prior to MySQL 8.0 (i.e MySQL 5.6 and 5.7) creating desc index syntax was supported but desc keyword was ignored, Now in MySQL 8.0 release descending index is extended are supported. What is index? Indexes play an important role in performance optimization  and they are used frequently to speed up access to particular data and reduce disk I/O operations . To understand index easily you can imagine a book,every book has ... Read More

Feed: Planet MySQL; Author: Severalnines; One of the cool features in Galera is automatic node provisioning and membership control. If a node fails or loses communication, it will be automatically evicted from the cluster and remain unoperational. As long as the majority of nodes are still communicating (Galera calls this PC - primary component), there is a very high chance the failed node would be able to automatically rejoin, resync and resume the replication once the connectivity is back. Generally, all Galera nodes are equal. They hold the same data set and same role as masters, capable of handling read ... Read More

Feed: Hortonworks Blog – Hortonworks. Author: Saumitra Buragohain. We’re excited to announce the long-awaited release of Hortonworks Data Platform 3.0.0. HDP 3.0 is faster, smarter, hybrid, bigger, trusted and real-time database. We encourage you to read our blog that announced HDP 3.0. You can also view our keynote presentation from DataWorks Summit, where we demoed an autonomous car (1/10 scale), trained with HDP 3.0 technologies. We also want to thank  our current and prospective customers and partners for signing up for the HDP 3.0 Early Access and we are encouraged by the huge interest- now, you can use the HDP ... Read More

Feed: Planet MySQL; Author: HowToForge; Nextcloud is a free (Open Source) Dropbox-like software, a fork of the ownCloud project. Nextcloud is written in PHP and JavaScript, it supports many database systems such as MySQL/MariaDB, PostgreSQL, Oracle Database, and SQLite. In order to keep your files synchronized between Desktop and your own server, Nextcloud provides applications for Windows, Linux, and Mac desktops and a mobile app for Android and iOS. Nextcloud is not just a Dropbox clone, it provides additional features like Calendar, Contacts, Schedule tasks, and streaming media with Ampache etc. In this tutorial, we will show you how to ... Read More

Feed: Planet MySQL; Author: Severalnines; Before you attempt to perform any schema changes on your production databases, you should make sure that you have a rock solid rollback plan; and that your change procedure has been successfully tested and validated in a separate environment. At the same time, it’s your responsibility to make sure that the change causes none or the least possible impact acceptable to the business. It’s definitely not an easy task. In this article, we will take a look at how to perform database changes on MySQL and MariaDB in a controlled way. We will talk about ... Read More

Feed: MemSQL Blog. Author: Rick Negrin. It’s time for us to admit what we have all known is true for a long time; NoSQL is the wrong tool for many of the modern application use cases, and it’s time that we move on. NoSQL came into existence because the databases at the time couldn’t handle the scale required. The rise of this new generation of data services solved many of the problems of web scale and rapidly growing data sets when it was created more than a decade ago. NoSQL also offered a new, cost-effective method for cold storage/occasional batch ... Read More

Feed: Cloudera Manager – Cloudera Engineering Blog. Author: Justin Kestelyn. Thanks to Jonathan Natkins, a field engineer from StreamSets, for the guest post below about using StreamSets Data Collector—open source, GUI-driven ingest technology for developing and operating data pipelines with a minimum of code—and Cloudera Search and HUE to build a real-time search environment. As pressure mounts on data engineers to deliver more data from more sources in less time, StreamSets Data Collector can serve as a linchpin in the data management process, helping them simplify ingest pipeline development and operations across the rapidly evolving ecosystem of big data tools ... Read More

Feed: R-bloggers. Author: Mathew McLean. 1. Improve sampler efficiency by picking the right model We need to address how we specify our models before even discussing writing code that is optimized computationally. Make sure that your model is parameterized in such a way that Stan can easily sample it using its algorithms – No U-TURN Sampler (NUTS) or Hamiltonian Monte Carlo (HMC). Simply selecting the right model can make a big difference in terms of efficiency. Due to differences in implementations and algorithms, an efficient parameterization in stan is not necessarily the one that was best in other software we’ve tried ... Read More

Feed: Planet MySQL; Author: Mark Callaghan; An LSM like RocksDB has much better write and space efficiency than a B-Tree. That means with RocksDB you will use less SSD than with a B-Tree and the SSD will either last longer or you can use lower endurance SSD. But this efficiency comes at a cost. In the worst-case RocksDB might use 2X more CPU/query than a B-Tree, which means that in the worst case QPS with RocksDB might be half of what it is with a B-Tree. In the examples below I show that RocksDB can use ~2X more comparisons per ... Read More

Feed: Planet big data. Author: David Smith. In case you missed them, here are some articles from June of particular interest to R users. An animated visualization of global migration, created in R by Guy Abel. My take on the question, Should you learn R or Python for data science? The BBC and Financial Times use R — without post-processing — for publication graphics. "Handling Strings in R", a free e-book by Gaston Sanchez, has been updated. The AI, Machine Learning and Data Science roundup for June 2018. The PYPL Popularity of Languages Index ranks R as the 7th most ... Read More