Tag: INDEX

Feed: Cloudwards. Author: Gary Stevens; The deep web and dark web are terms that have enjoyed plenty of headlines in recent years. You could conclude — wrongly, it turns out — that nothing exists in that seedy cyber alley except for deals that involve contract killing, illegal drugs, human trafficking, weapons, pornography and other not-so-nice products and services. The Silk Road, a website synonymous with shady dealings, was shut down twice by the FBI and its founder, the Dread Pirate Roberts, also known as Ross Ulbricht, imprisoned for life. The deep web and dark web aren’t the same thing, though ... Read More

Feed: R-bloggers. Author: statcompute. In the post (https://statcompute.wordpress.com/2018/09/15/how-to-avoid-for-loop-in-r), I briefly introduced the idea of vectorization and potential use cases. One might be wondering why we even need the Vectorize() function given the fact that it is just a wrapper and whether there is any material efficiency gain by vectorizing a function. It is true that the Vectorize() function is not able to improve the efficiency of any function itself that is wrapped around, e.g. vectorized. However, the vectorization can change the input format of a function that normally consumes scalar inputs before being vectorized and therefore would improve the processing ... Read More

Feed: Planet MySQL; Author: Severalnines; In the previous two blog posts we covered both deploying the four types of clustering/replication (MySQL/Galera, MySQL Replication, MongoDB & PostgreSQL) and managing/monitoring your existing databases and clusters. So, after reading these two first blog posts you were able to add your 20 existing replication setups to ClusterControl, expand them and additionally deployed two new Galera clusters while doing a ton of other things. Or maybe you deployed MongoDB and/or PostgreSQL systems. So now, how do you keep them healthy? That’s exactly what this blog post is about: how to leverage ClusterControl performance monitoring and ... Read More

Feed: Planet MySQL; Author: Ivan Ma; MySQL Document Store Building Index SearchThis is a tutorial to go through setting Up MySQL 8.0 Document Store, Importing World_x Sample database and building GENERATED COLUMN with Index and lastly to show the QUERY PLAN using collection.find() that uses the INDEX built.INSTALLATION Pre-requisite 1. MySQL 8.0.11+ 2. MySQL Shell 8.0.11+ 3. Download  Sample Database "world_x database" from https://dev.mysql.com/doc/index-other.htmlMySQL Database Initialization   Using --initialize-insecure for this tutorial which means it initializes a database with empty password for root@localhost user. Assuming we have 'mysql', 'mysqld' setup properly.mysqld --initialize-insecure --datadir=Create my.cnf  (example E:/temp/data1/my.cnf)Startup MySQL Server  Connecting to MySQL ... Read More

Feed: R-bloggers. Author: Econometrics and Free Software. In a previous blog post I have showedhow you could use the {tidyxl} package to go from a human readable Excel Workbook to a tidydata set (or flat file, as they are also called). Some people then contributed their solutions,which is always something I really enjoy when it happens. This way, I also get to learn things! @expersso proposed a solution without {tidyxl}: Interesting data wrangling exercise in #rstats. My solution (without using {tidyxl}): https://t.co/VjuOoM82yX https://t.co/VsXFyowigu — Eric (@expersso) September 12, 2018 Ben Stenhaug also proposed a solution on his githubwhich is simpler ... Read More

Feed: AWS Big Data Blog. Bushfires are frequent events in the warmer months of the year when the climate is hot and dry. Countries like Australia and the United States are severely impacted due to the bushfires causing devastating effects to human lives and property. Over the years the prediction of bushfires has been a subject of study in various research projects. Many of these projects use complex machine learning algorithms. These algorithms learn to predict the bushfires from the real-time spread for the fire over a particular geographical region­.In this blog post, we use event processing paradigm provided by ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Ceri Williams | September 14, 2018 |  Posted In: MySQL, Percona Server for MySQL, Security PREVIOUS POST In my last post I compared data at-rest encryption features available for MySQL and MariaDB. As noted at the time, some of the features available for Percona Server for MySQL were in development, and the latest version (5.7.23) sees two of them released as ALPHA quality. Encrypting the InnoDB system tablespace The first of the new features is InnoDB system tablespace encryption via innodb_sys_tablespace_encrypt, which would provide encryption of the following data: the change buffer, which caches changes to ... Read More

Feed: IBM Big Data & Analytics Hub - All Content; Author: hao-xin; As a kid, I dreamed about the flying cars and jetpacks that would hopefully define our future lives. Up until recently, the technology that could make them even remotely possible was both expensive and difficult to manufacture. Now, thanks to 3-D printing and machine learning, engineers can quickly and cost effectively design, test and commercialize new designs, making the era of autonomous vehicles — yes, even flying cars — closer to reality than ever.After years of combined academic and industry expertise in millimeter wave technology, I discovered a way ... Read More

Feed: Planet MySQL; Author: Mark Callaghan; SlimDB is a paper worth reading from VLDB 2018. The highlights from the paper are that it shows:How to use less memory for filters and indexes with an LSM How to reduce the CPU penalty for queries with tiered compaction The benefit of more diversity in LSM tree shapes Overview Cache amplification has become more important as database:RAM ratios increase. With SSD it is possible to attach many TB of usable data to a server for OLTP. By usable I mean that the SSD has enough IOPs to access the data. But it isn't ... Read More

Feed: Microsoft Azure Blog. Author: Tad Brockway. Media and entertainment industry conferences are by far some of my favorites. Creativity, disruption, opportunity, and technology – particularly cloud, edge, and AI – are everywhere. It’s been exciting to see those things come together at NAB 2018, SIGGRAPH, and now IBC Show 2018. Together with teams from across Microsoft, I’m looking forward to IBC Show and the chance to learn, collaborate, and advance the state of this dynamic industry. At this year’s IBC we’re excited to announce the general availability of Video Indexer, our advanced metadata extraction service. Announced as public preview ... Read More