Feed: Planet PostgreSQL. I was browsing the Postgres slack channel when I ran into this intriguing question from a member: How come my query SELECT TO_CHAR(POW(2,54), ‘9999999999999999999’) AS V0, TO_CHAR(POW(2,54)-1, ‘9999999999999999999’) AS V1; gives that result? v0 | v1 ------------------------------+---------------------- 18014398509481984 | 18014398509481984 Of course, I did some IT support, so my first reaction was to test by myself: laetitia=# select laetitia-# power(2,54) as v1, laetitia-# power(2,54)-1 as v2; v1 | v2 ------------------------+------------------------ 1.8014398509481984e+16 | 1.8014398509481984e+16 (1 row) The power function So, I looked at the power function definition in the documentation: power ( a numeric, b numeric ) → ... Read More

Feed: R-bloggers. Author: finnstats. [This article was first published on Data Analysis in R, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. The post Best ML Project with Dataset and Source Code appeared first on finnstats. If you are interested to learn more about data science, you can find more articles here finnstats. Best ML Project with Dataset and Source Code, Understanding how machine learning algorithms are applied in practice in business requires ... Read More

Feed: R-bloggers. Author: Jim. [This article was first published on Data Science Tutorials, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. The post Gamma distribution in R appeared first on Data Science Tutorials What do you have to lose?. Check out Data Science tutorials here Data Science Tutorials. Gamma distribution in R, This guide demonstrates how to use R to fit a gamma distribution to a dataset. Gamma Distribution Fitting in R Let’s ... Read More

Feed: Planet MySQL; Author: Kedar Vaijanapurkar; In the MySQL world, I am surrounded by some of the best database consultant, it brings them immense joy about having a “Friday”, so much so that they cannot believe that it actually is a Friday. Regardless of what they see on their watches and calendars, it becomes a crucial task of the day to prove it. Prove it technically that it actually is a Friday. This blog post is my attempt to share the proofs of existence of a “Friday”. Using MySQL datetime function: dayname MySQL [(Kedar)]> select dayname(now()); +----------------+ | dayname(now()) | ... Read More

Feed: R-bloggers. Author: finnstats. [This article was first published on Data Analysis in R, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. The post To become data scientists and engineers! appeared first on finnstats. If you are interested to learn more about data science, you can find more articles here finnstats. To become data scientists and engineers?, what to study when it came time to choose the academic program we wanted to enroll ... Read More

Our MySQL support engineers recently had a customer contact us about an interesting problem. Their MySQL server’s performance getting intermittently degraded. Their queries were getting stuck in the “Waiting for table flush” state. They were seeing this on a regular basis, but there was no obvious root cause. Unfortunately, transparency of their database setup was very poor because they were on a “managed service” database managed by their hosting provider. They were not granted sufficient privileges to see all running queries, only the ones executed by their application users. They could also not access the details about all running queries ... Read More

Feed: Teradata Blog. RegTech is the word on everyone’s lips as financial services businesses look for ways to manage the avalanche of regulatory reporting precipitated by the 2008 financial crisis. Most realise that there simply must be a better way of meeting reporting requirements than throwing increasing numbers of people and excel sheets at the problem. RegTech, the use of technology to enhance regulatory and compliance processes, is one of the fastest growing areas of the wider fintech ecosystem, predicted by some to grow at over 50% per year to reach $55 billion by 2025. But how can banks and ... Read More

Feed: Planet MySQL; Author: MyDBOPS; Mydumper supports streaming of backups right from version 0.11.3 and the latest version Mydumper 0.12.3 it enabled its support for compressed streaming backup. This was the most awaited feature added to Mydumper, making it a more powerful tool for data migration to RDS or Cloud. If you are hearing mydumper for the first time, then let’s have a quick catch-up on what Mydumper is and what it does exactly. Mydumper is a multithread logical backup and restores tool for MySQL and its forks. To know more you can refer to our previous blogs/presentations below. https://mydbops.wordpress.com/2016/01/31/faster-logical-backup-with-mydumper/ ... Read More

Feed: Planet MySQL; Author: Kristian Köhntopp; Query latencies in one data center are larger than elsewhere for one replication hierarchy, but only in the high percentiles. This impacts production and traffic is being failed away from that data center to protect production. When the P50 and P90 look okay, but the P99 and the P99.9 do not, the database(s) operate normally, and only some queries are running slow. The initial guess was “for some queries the plan has flipped, but only in that data center.” But first let’s have a look at the database size and the schema. The schema ... Read More

Feed: Planet MySQL; Author: Kristian Köhntopp; Two weeks ago I was being drawn into the debug of artdb, the Replication hierarchy used by our Artifactory instance. Artifactory overloaded the database. This was incident-handled by optimizing a number of slow queries using some covering index trickery, and by upgrading the hardware substantially. Using the runway we bought, we found and partially fixed the following problems: Fixed: A number of very expensive reporting queries were sped up 16x to 20x using covering indexes, from 180s runtime to 8s-12s runtime. Fixed: We optimized our database and data size by completing the data lifecycle ... Read More