Tag: PHP

Feed: R-bloggers. Author: hrbrmstr. International Code Talk Like A Pirate Day almost slipped by without me noticing (September has been a crazy busy month), but it popped up in the calendar notifications today and I was glad that I had prepped the meat of a post a few weeks back. There will be no ‘rrrrrr’ abuse in this post, I’m afraid, but there will be plenty of R code. We’re going to combine pirate day with “pirating” data, in the sense that I’m going to show one way on how to use the web scraping powers of R responsibly to ... 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: R-bloggers. Author: Christoph Safferling. Q: What has 8 legs, 8 arms and 8 eyes?A: 8 pirates. Avast, ye scurvy scum! Today be September 19, the International Talk Like A Pirate Day. While it’s a silly “holiday”, it’s a great chance to switch your Facebook to Pirate English (“Arr, this be pleasing to me eye!”). Also, it’s as good a reason as any to go sailing the Internet Main, scouring for booty (data)! Well, any excuse, y’know… What is today known (more or less) as “Pirate English” (the bit with all the “arrr!”, “ahoy, ye matey!”, etc) is in fact ... 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

Feed: Planet MySQL; Author: Sheeri K. Cabral; Notes/errata/updates for Chapter 3:See the official book errata at http://tahaghoghi.com/LearningMySQL/errata.php – Chapter 3 includes pages 95 – 106. On p. 96 – 97, there is an example of what you will see with SHOW DATABASES; You will likely also see sys, INFORMATION_SCHEMA and PERFORMANCE_SCHEMA databases. On p. 97, it says “There are some restrictions on what characters and words you can use in your database, table and other names.” These days, it is possible to escape characters and reserved words, but it is still not recommended. On p. 101-102, there are examples of ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; As continue of the previous blog posted on Aug 17, 2017, please find below a list conferences & events where you can find MySQL Community team or MySQL experts during the period of second half of September till end of December. The ones which are new are marked below. Please be aware that the list does not have to be final and during the time more events could be added or some of them removed.  Madison PHP, Madison, US, Sep 22-23, 2017​ MySQL Community team is supporting this PHP conference as Community partner. Oracle ... Read More

Feed: Planet MySQL; Author: jocelyn fournier; With the release of PrestaShop 1.7.2.2, we have tried to remove a few point of contention which were affecting badly overall PrestaShop performance: Specific price computation Sale page wrong pagination loading too much products on one page Let's check the specific price improvement! According to our internal software, specificPrice computation was particularly slow, AND present across a lot of pages. Basically our software is crawling a website, profile each page it founds, and then generates a global report. SpecificPrice was listed in the top 5 most resource and time consuming operation, overall. Each time a price ... Read More

Feed: R-bloggers. Author: The USGS OWI blog. A magnitude 8.1 earthquake was measured in the Pacific region offshore Chiapas, Mexico at 04:49:21 UTC on September 8th 2017. Working in the Water Mission Area for the USGS, our Data Science Team was already hard at work polishing up water visualizations for the devastating Hurricane Harvey, as well as creating a new visualization for Hurricane Irma. That is to say, the resources available for a timely visualization were already spent. By 10 am on Friday however, a team of USGS groundwater scientist had realized that the affects of the earthquake were being ... Read More

Feed: Percona Database Performance Blog. Author: Sveta Smirnova. Sveta Smirnova  | September 11, 2017 |  Posted In: Database Monitoring, InnoDB, Insight for DBAs, Insight for Developers, MySQL PREVIOUS POST In this post, we will discuss how to fix cardinality for InnoDB tables manually. As a support engineer, I often see situations when the cardinality of a table is not correct. When InnoDB calculates the cardinality of an index, it does not scan the full table by default. Instead it looks at random pages, as determined by options innodb_stats_sample_pages, innodb_stats_transient_sample_pages and innodb_stats_persistent_sample_pages, or by the  CREATE TABLE option STATS_SAMPLE_PAGES. The default value for persistent statistics is 20 ... Read More