The MySQL 5.7.7 release candidate has been available for several months, but it doesn't include the new JSON datatype or built-in JSON functions. Those are currently only available in the MySQL JSON Labs Release. Unlike the regular 5.7.7 release, the MySQL JSON Labs Release is only available in two download formats:
This Log Buffer Edition covers Oracle, SQL Server and MySQL blogs of the running week.
Oracle:
Previously I tested Tokutek’s Fractal Trees (TokuMX & TokuMXse) as MongoDB storage engines – today let’s look into the MySQL area.
I am going to use modified LinkBench in a heavy IO-load.
I compared InnoDB without compression, InnoDB with 8k
compression, TokuDB with quicklz compression.
Uncompressed datasize is 115GiB, and cachesize
is 12GiB for InnoDB and 8GiB +
4GiB OS cache for TokuDB.
Important to note is that I used
tokudb_fanout=128, which is only available in
our latest Percona Server release.
I will …
MySQL Tcpdump system : use percona-toolkit to analyze network packages
We can identify problem SQLs with high execution frequency.
With DBMON system and AWR system we can find problem SQLs in a special time (high frequency, occurs over a period of time)
View this PDF:
Practical tips and a live demo of how to get your data warehouse loading projects off the ground quickly and efficiently when replicating from MySQL and Oracle into Amazon Redshift, HP Vertica and Hadoop.
Webinar-on-demand. Recorded 07/23/15.
While MONyog MySQL Monitor is being embraced by DBAs and DevOps around the world, we are constantly adding more features to make MONyog the most complete MySQL monitoring tool.
MONyog ships 40+ MySQL and system metric charts. It also lets you add custom charts. With the latest update, we have made Charts more powerful by adding few important features to help you find problem queries with ease.
Here’s a 1 minute video to walk you through the new
features.
Existing customers can download MONyog 6.33 from Customer Area. To evaluate MONyog 6.33, please download a 14-day trial.
We are really excited about this update and we hope you like the new features. Please feel free to share your feedback.
Cheers,
Team MONyog
The post …
[Read more]Thank you for attending my July 15 webinar, “Creating Best in Class Backup solutions for your MySQL environment.” Due to the amount of content we discussed and some minor technical difficulties faced near the end of webinar we have decided to cover the final two slides of the presentation along with the questions asked by attendees during the webinar via this blog post.
The slides are available for download. And you can watch the webinar in it’s entirety here.
The final two slides were about our tips for having a …
[Read more][…] = CRC32. This is because innodb_checksum_algorithm = INNODB is the default setting. See this post for a sample […]
Dear community, maybe you have already tested, there are new added features in MySQL 5.7. See previous post -> About 5.7.7-rc BUGs
“General Tablespace” feature -> From now you can place tables to separate tablespaces. Prior, on our hands there were only “System TableSpace” and “InnoDB file per table” options. Today’s topic is altering table to use this “General Tablespace”.
Our sample table structure:
mysql> show create table t1;
| Table | Create Table
| t1 | CREATE TABLE `t1` (
`id` int(11) DEFAULT NULL,
`c1` varchar(85) DEFAULT NULL
) /*!50100 TABLESPACE innodb_file_per_table */ ENGINE=InnoDB DEFAULT CHARSET=utf8
Note that there is a comment about tablespace of our table -> /*!50100 TABLESPACE …
[Read more]Welcome to MySQL QA Episode 8: Reducing Testcases for Engineers: tuning reducer.sh
Full-screen viewing @ 720p resolution recommended.
The post MySQL QA Episode 8: Reducing Testcases for Engineers: tuning reducer.sh …
[Read more]