Tag: collation

Feed: Hadoop Dev. Author: Mara_Matias. The objective of this series is to explore performance for BigSQL Federation using practical examples. This series is divided into two parts. Part 1 will look at function performance with emphasis on pushdown analysis Part 2 will look at performance for queries that join nicknames with local tables and/or other nicknames You are reading Part 1. All the commands and plans shown were generated using jsqsh as a command line interface on an environment running HDP2.6.2, and BigSQLv5.0.3.IP addresses and hostnames were masked using substitution.We will not go look at setting up federation, but the ... Read More

Feed: Planet MySQL; Author: MinervaDB; In this blog post, we have multiple OLTP performance benchmarking scenarios using sysbench 1.0.14 on InnoDB and MyRocks. InnoDB and MyRocks (RocksDB with MySQL) are definitely not to supplement each other, They actually compliment well with respective advantages, Let me quickly explain how InnoDB and MyRocks can benefit you when used wisely, Again this blog post is not to show who (InnoDB or MyRocks) is better ? We regularly benchmark both of these storage engines before recommending to our customers on what is best suited for their database infrastructure operations ? so we would like to share our ... Read More

Feed: Planet MySQL; Author: Dimitri Kravtchuk; Looking on my previously obtained results on Read-Only (RO) tests for latin1 and UTF8 charsets, one question continued to turn in my mind : - if MariaDB 10.3 is hitting a so deep drop on "distinct-ranges" workload : - why then this is not impacting the "mixed" OLTP_RO workload results (which is containing "distinct-ranges" query too) : The answer was within the test title : I've missed one zero in my scripts while preparing initial tests.. ;-)) so, the "distinct-ranges" test was using range size=10 (instead of 100 by default) while "mixed" OLTP_RO remained ... Read More

Feed: Planet MySQL; Author: MinervaDB; We are are an vendor neutral and independent open source database technologies consulting, support and remote DBA services provider with several customers using MySQL GA, MySQL Enterprise, InnoDB/XtraDB, Percona Server, MariaDB, MyRocks and ClickHouse. The customers continue doing business with us for being an technology / vendor agnostic company. We spend considerable amount of time doing research on open source database technologies, Often customers ask us about the performance comparison between InnoDB and MyRocks so we decided to write this post to compare performance between InnoDB (MySQL 8.0) and MyRocks (MariaDB 10.3.7) using Sysbench 1.0.14:Software Infrastructure ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; Last time I reviewed my recent subscriptions to MySQL bugs it was April 1, 2018. I was busy working, blogging about other bugs, running random MTR tests on MySQL 8.0.11 and got two weeks of vacation since than. Now it's time to briefly review 20 recent bug reports (mostly for MySQL 8.0.11) I was interested in.As usual, I start with most recent bug reports:Bug #91010 - "WolfSSL build broken due to cmake typo". MySQL 8 can be compiled using wolfSSL according to the manual, but as Laurynas Biveinis found this is not the case ... Read More

Feed: Clustrix Blog. Author: BetterSQL. Last fall, we announced that our most recent generally-available release, ClustrixDB 9, supports deploying a single database across multiple AWS Availability Zones (AZs). With this release, Clustrix continues its commitment to provide application developers with both scale and high-availability so they don’t have to choose one over the other. Clustrix 9 also features numerous enhancement to performance, stability, and supportability. “The Clustrix mission has always been to provide a highly-scalable, distributed database that also provides high availability and ACID compliance,” said Mike Azevedo, CEO of Clustrix. “With an increasing number of our customers taking advantage of ... Read More

Feed: Blog. Author: Lisa Waugh; We are pleased to announce the availability of the Aqua Data Studio version 19.0 release.  This release greatly enhances several areas of the product. You can now view explain plans for NoSQL data warehouse platforms, like Hive, Spark and Impala.   Gain faster insights to your data  with the enhancements to the visual analytics tool. Ability to share workspaces, thereby increasing collaboration and usability in team environments Enhancements to Aqua Data Studio’s filtering capabilities.  Allowing users to quickly analyze their data and gain insight through data visualization Our new combined fields offer a quick and convenient ... Read More

Feed: Planet MySQL; Author: Markus Popp; MySQL 8.0 has been released as stable (GA) earlier this month. For db4free.net this means it’s time to make MySQL 8.0 the default version and to deprecate the MySQL 5.7 server instance. The new MySQL 8.0 server is running on the default port 3306. All new registrations will have the database created on this server. It is fresh and empty and will start from scratch. The previous MySQL 5.7 server will remain available on port 3308. All users who have data there which they want to keep should migrate it to the new MySQL ... Read More

Feed: Planet MySQL; Author: Dimitri Kravtchuk; The world is moving to UTF8, MySQL 8.0 has utf8mb4 charset as default now, but, to be honest, I was pretty surprised how sensible the "charset" related topic could be.. -- in fact you may easily hit huge performance overhead just by using an "odd" config settings around your client/server charset and collation. While to avoid any potential charset mismatch between client and server, MySQL has from a long time an excellent option : "skip-character-set-client-handshake" which is forcing any client connection to be "aligned" with server settings ! (for more details see the ref ... Read More

Feed: SQL Server Release Services. Author: Pedro Lopes (PL). The SQL Server team is excited to bring you the second service pack release for SQL Server 2016! The SQL Server 2016 Service Pack 2 (SP2) contains a rollup of released hotfixes as well as multiple improvements centered around performance, scalability, and supportability based on feedback from customers and the SQL community. These improvements enable SQL Server 2016 to perform faster and with expanded supportability and diagnostics. It also showcases the SQL Server product team’s commitment to provide continued value into in-market releases. SQL Server 2016 Service Pack 2 includes: Performance ... Read More