IT大道IT大道

首页 > TAG信息列表 > mysql

  • Exposing connection status in the MySQL command-line prompt

    Exposing connection status in the MySQL command-line prompt

    While working on something unrelated, I came across the
    server status flags
    that are exposed to client connections by the client library. I have never used...

    2017-10-09 itdadao 技术 28 ℃ 0
  • 十年前,我在抓虾

    十年前,我在抓虾

    前些天在抓虾老同事的群里聊些话题,才发现在抓虾的日子竟然已经过去十年了。如今还会有人提到抓虾,但往往是把它当成徐易容的一次创业失败的教训。但是对亲身参与的人来说,那段...

    2017-10-08 itdadao 技术 29 ℃ 0
  • Fosdem 2018 – MySQL & Friends Devroom: CfP is open !

    Fosdem 2018 – MySQL & Friends Devroom: CfP is open !

    Good news ! The MySQL & Friends Devroom has been accepted for Fosdem’s 2018 edition !
    This event is a real success story for the MySQL ecosystem, the con...

    2017-10-08 itdadao 技术 43 ℃ 0
  • Sense-driven Development

    Sense-driven Development

    One of the people who taught me a lot of what I know right now as a developer is our former TestLab team lead Czar Pino . Sometimes when he’s making a decisio...

    2017-10-08 itdadao 技术 35 ℃ 0
  • ?? ?? 199 – bye bye bug #199, MySQL auto_increment is fixed !

    ?? ?? 199 – bye bye bug #199, MySQL auto_increment is fixed !

    It was expected for a long time…. here is the fix for bug #199!!

    The bug #199submitted by PeterZhas been fixed in 8.0. Thank you to Zhang Sim...

    2017-10-06 itdadao 技术 33 ℃ 0
  • MySQL Performance : 2.1M QPS on 8.0-rc

    MySQL Performance : 2.1M QPS on 8.0-rc

    The first release candidate of MySQL 8.0 is here, and I'm happy to share few performance stories about. This article will be about the "most simple" one -- our...

    2017-10-04 itdadao 技术 31 ℃ 0
  • Brighter MySQL Command Store

    Brighter MySQL Command Store

    I’ve been wanting to explore Brighter for awhile, probably over a year. I figured I’d try something new this time around and actually explore it by contrib...

    2017-10-04 itdadao 技术 46 ℃ 0
  • Using MySQL JDBC Driver With Spring Boot

    Using MySQL JDBC Driver With Spring Boot

    In this article, I will show you how to connect a MySQL database with your Spring Boot application.
    Tools used in this article include:

    Spring Boot 1.5....

    2017-10-04 itdadao 技术 61 ℃ 0
  • MyRocks Metrics Now in PMM 1.3.0

    MyRocks Metrics Now in PMM 1.3.0

    One of the most exciting features shipped in the Percona Monitoring and Management 1.3.0 (PMM) release is support for MyRocks metrics via a new Metrics Monitor...

    2017-10-04 itdadao 技术 30 ℃ 0
  • Histogram statistics in MySQL

    Histogram statistics in MySQL

    As of MySQL 8.0.3, you now have the ability to create histogram statistics in order to provide more statistics to the optimizer. In this blog post, we will have...

    2017-10-03 itdadao 技术 47 ℃ 0
  • One Million Tables in MySQL 8.0

    One Million Tables in MySQL 8.0

    In my previous blog post, I talked about new general tablespaces in MySQL 8.0. Recently MySQL 8.0.3-rc was released, which includes a new data dictionary. My g...

    2017-10-02 itdadao 技术 34 ℃ 0
  • LinkedIn计划开源不增加开销的MySQL查询分析工具Query Analyzer

    LinkedIn计划开源不增加开销的MySQL查询分析工具Query Analyzer

    LinkedIn有超过500个内部应用程序基于MySQL。为了便于管理,提高利用率,他们构建了MySQL即服务模型。该模型有个缺点,一个应用程序的查询可能会影响其他应用程序的查询。为了控...

    2017-09-30 itdadao 技术 34 ℃ 0
  • 有赞MySQL自动化运维之路—ZanDB

    有赞MySQL自动化运维之路—ZanDB

    一、前言
    在互联网时代,业务规模常常出现爆发式的增长。快速的实例交付,数据库优化以及备份管理等任务都对DBA产生了更高的要求,单纯的凭借记忆力去管理那几十套DB已经不再适...

    2017-09-29 itdadao 技术 53 ℃ 0
  • What’s new in MySQL 8.0

    What’s new in MySQL 8.0

    MySQL, the popular open-source database that’s a standard element in many web application stacks, has unveiled the first release candidate for version 8.0....

    2017-09-28 itdadao 技术 29 ℃ 0
  • mysql技能提升篇 - Sqlyog高级应用

    mysql技能提升篇 - Sqlyog高级应用

    mysql作为绝大部分公司使用的数据库,自然是牛牛牛!
    每个人都能设计数据库,都能从删库到跑路。但是,如何做到更好,更快,更准地建立你的mysql数据库,这是个值得关注的问题(尽管很多人...

    2017-09-28 itdadao 技术 23 ℃ 0
  • 万字总结:学习MySQL优化原理,这一篇就够了!

    万字总结:学习MySQL优化原理,这一篇就够了!

    前言
    说起MySQL的查询优化,相信大家收藏了一堆奇技淫巧:不能使用SELECT *、不使用NULL字段、合理创建索引、为字段选择合适的数据类型..... 你是否真的理解这些优化技巧?是...

    2017-09-28 itdadao 技术 55 ℃ 0
  • 如何使用简单的 SQL 查询在 MySQL 中计算中位数

    如何使用简单的 SQL 查询在 MySQL 中计算中位数

    什么是中位数?

    数值型数组的中位数是在数据排序后位于数组中间项的值。如果数组有偶数个元素,中位数就是 最中间的两个数值的平均数。

    中位数对于了解“我...

    2017-09-28 itdadao 技术 45 ℃ 0
  • 一个MySQL 5.7 分区表性能下降的案例分析

    一个MySQL 5.7 分区表性能下降的案例分析

    前言 :希望通过本文,使MySQL5.7.18的使用者知晓分区表使用中存在的陷阱,避免在该版本上继续踩坑。同时通过对源码的分享,升级MySQL5.7.18时分区表性能下降的根本原因,向MySQL源...

    2017-09-28 itdadao 技术 23 ℃ 0
  • MySQL 8.0 Will Bring Unicode 9.0, Schema-less JSON, Greater Geospatial Support

    MySQL 8.0 Will Bring Unicode 9.0, Schema-less JSON, Greater Geospatial Support

    MySQL users got a gift this week with the newly unveiled release candidate 1 of MySQL 8.0 . This new edition of the open source database management system adds...

    2017-09-27 itdadao 技术 21 ℃ 0
  • Avoid Shared Locks from Subqueries When Possible

    Avoid Shared Locks from Subqueries When Possible

    In this blog post, we’ll look at how to avoid shared locks from subqueries.
    I’m pretty sure most of you have seen an UPDATE statement matching rows retur...

    2017-09-26 itdadao 技术 24 ℃ 0
  • MySQL 8.0 RC1 – Highlights

    MySQL 8.0 RC1 – Highlights

    The long awaited first release candidate of MySQL 8.0 is now available. The theme of this release is “making MySQL better for modern apps”
    . What does tha...

    2017-09-26 itdadao 技术 30 ℃ 0
  • HackerOne and Former MySQL CEO Marten Mickos Interview

    HackerOne and Former MySQL CEO Marten Mickos Interview

    “Leadership is actually nothing other than taking a little bit more responsibility than anyone is expecting you to.”



    For those of...

    2017-09-26 itdadao 技术 49 ℃ 0
  • Attached Storage Hindering Commit Performance

    Attached Storage Hindering Commit Performance

    Even with SSD becoming more prolific for local-ish storage even on cloud servers, we still encounter attached storage (SAN) quite frequently. This can be fine,...

    2017-09-25 itdadao 技术 22 ℃ 0
  • Replication Features in MySQL 8.0.3

    Replication Features in MySQL 8.0.3

    Great news! MySQL 8.0.3 is out and it is a release candidate.In the replication team we have been busy working on interesting new enhancements and also...

    2017-09-22 itdadao 技术 33 ℃ 0
  • semi-sync插件崩溃导致MySQL重启故障详析

    semi-sync插件崩溃导致MySQL重启故障详析

    导读
    semi-sync插件崩溃导致MySQL重启的故障分析全过程~
    作者:刘安
    现为爱可生高级测试工程师,拥有丰富的自动测试开发经验;曾先后在文思海辉、Splunk担任测试工程师。

    ...

    2017-09-22 itdadao 技术 49 ℃ 0
 21088    1 2 3 4 5 6 7 8 9 10 下一页 尾页
标签列表