Tag: query

Feed: Percona Database Performance Blog. Author: Peter Zaitsev. Peter Zaitsev  | September 20, 2017 |  Posted In: Database Monitoring, Insight for DBAs, MySQL PREVIOUS POST In this blog post, I will demonstrate how to run and use sysbench histograms. One of the features of sysbench that I often I see overlooked (and rarely used) is its ability to produce detailed query response time histograms in addition to computing percentile numbers. Looking at histograms together with throughput or latency over time provides many additional insights into query performance. Here is how you get detailed sysbench histograms and performance over time: sysbench --rand-type=uniform --report-interval=1 ... Read More

Feed: What's New. Kinesis Analytics is the easiest way to process streaming data in real time with standard SQL without having to learn new programming languages or processing frameworks. Kinesis Analytics enables you to query streaming data or build entire streaming applications using SQL, so that you can gain actionable insights and respond to your business and customer needs promptly.  Today, Kinesis Analytics expands its processing capabilities with 6 new stream processing functions. First, the new STEP() function provides you a simpler way to perform time-series analytics. Second, real-time sessionization use cases have become easier with the addition of the ... Read More

Feed: R-bloggers. Author: R Views. Inside the enterprise, a dashboard is expected to have up-to-the-minute information, to have a fast response time despite the large amount of data that supports it, and to be available on any device. An end user may expect that clicking on a bar or column inside a plot will result in either a more detailed report, or a list of the actual records that make up that number. This article will cover how to use a set of R packages, along with Shiny, to meet those requirements. The code A working example for the dashboard ... Read More

Feed: Actian. Author: John Bard. Join us at the Strata Data New York conference next week at Jacob K Javits Convention Center to learn how our data management and analytics products can help you manage and analyze hybrid data to better gain business insights.  This O’Reilly conference takes place September 25-28, with an opening reception from 5-6:30pm Tuesday in the Expo Hall.  Exhibits are open during the day Wednesday 10:30am-7:05pm and Thursday 10:30am-4:35pm.  There’s also a booth crawl Wednesday evening from 6:05-7:05pm, to relax with some refreshments after a long day of keynotes and speaking sessions.Actian will be in booth ... Read More

Feed: Percona Database Performance Blog. Author: Jervin Real. Jervin Real  | September 19, 2017 |  Posted In: MySQL, ProxySQL, Security, SSL PREVIOUS POST In this blog post, we’ll look at how ProxySQL improves MySQL SSL connection performance. When deploying MySQL with SSL, the main concern is that the initial handshake causes significant overhead if you are not using connection pools (i.e., mysqlnd-mux with PHP, mysql.connector.pooling in Python, etc.). Closing and making new connections over and over can greatly impact on your total query response time. A customer and colleague recently educated me that although you can improve SSL encryption/decryption performance with the AES-NI ... Read More

Feed: All - O'Reilly Media. Author: Lu Niu, Peng Du, Zhenxiao Luo. Uber’s Presto architecture (source: Courtesy of Zhenxiao Luo) For more on efficient geospatial analysis, check out Zhenxiao Luo and Wei Yan’s session, “Geospatial big data analysis at Uber,” at the Strata NYC Data Conference in NYC, September 25-28, 2017. From determining the most convenient rider pickup points to predicting the fastest routes, Uber aims to use data-driven analytics to create seamless trip experiences. Within engineering, analytics inform decision-making processes across the board. One of the distinct challenges for Uber is analyzing geospatial big data. City locations, trips, and ... Read More

Feed: Actian. Author: Emma McGrattan. Today we announce the introduction of the next release of Actian Vector in Hadoop, extending our support of Apache Spark to include direct access to native Hadoop file formats and tighter integration with Spark SQL and Spark R applications. In this release, we also incorporate performance improvements, integration with Hadoop security frameworks, and administrative enhancements. I’ll cover each of these in greater detail below.Combine Native Hadoop Tables with Vector Tables In previous releases, Vector in Hadoop required data to be stored in a proprietary format which optimized analytics performance and deliver great compression to reduce ... Read More

Feed: R-bloggers. Author: Chris Baker. Why care about patents? 1. Patents play a critical role in incentivizing innovation, withoutwhich we wouldn't have much of the technology we rely on everyday What does your iPhone, Google's PageRank algorithm, and a buttersubstitute called Smart Balance all have in common? …They all probably wouldn't be here if not for patents. A patentprovides its owner with the ability to make money off of something thatthey invented, without having to worry about someone else copying theirtechnology. Think Apple would spend millions of dollars developing theiPhone if Samsung could just come along and rip itoff?Probably not ... Read More

Feed: Big Data Made Simple - One source. Many perspectives.. Author: Baiju NT. Big Data is amazing. It describes our everyday behavior, keeps track of the places we go, stores what we like to do and how much time we spend doing our favorite activities. Big Data is made of numbers, and I think we all agree when we say: Numbers are difficult to look at. Enter Big Data visualization. Google, Facebook, Amazon, Apple, Twitter and Netflix all ask better questions of their data – and make better business decisions – by using data visualization. It gets better: Data visualization lets you interact with data. It goes beyond analysis. Visualization brings a presentation ... Read More

Feed: AWS Partner Network (APN) Blog. Author: Ian Scofield. By Ian Scofield, Juan Villa, and Mike Ruiz GameDay is an immersive, team-based event we’ve hosted at AWS Summits and re:Invent over the past few years. The event has teams of players settling into a challenging—and hopefully entertaining—scenario as DevOps leads at Unicorn.Rentals, a popular startup minutes away from the very public launch of a widely anticipated product. For more information, see the GameDay website. Of course, we have a lot going on behind the scenes to make GameDay work. Beyond all the enthusiastic acting and silly props, you’ll find a ... Read More