1 of 9
Recommended
BSLVTReport(Rishav-5912697)
BSLVTReport(Rishav-5912697)Rishav Ghosh This document provides a summary of the vocational training completed by Rishav Ghosh at the Bokaro Steel Plant (BSL) operated by Steel Authority of India Limited (SAIL). It includes an acknowledgement, abstract about BSL, and sections covering the organizational profile of SAIL and key parts of the integrated steel plant including the raw material handling plant, coke oven, sinter plant, blast furnace, steel melting shop, continuous casting, and rolling mills. The training covered various processes and gave Ghosh practical knowledge of the blast furnace and steel melting shop operations.
MySQL EXPLAIN Explained-Norvald H. Ryeng
MySQL EXPLAIN Explained-Norvald H. Ryeng郁萍 王 This document discusses using EXPLAIN to optimize queries in MySQL. It covers traditional, structured, and visualized EXPLAIN outputs. Traditional EXPLAIN can be complex and difficult to understand for complex queries. Structured EXPLAIN (with FORMAT=JSON) and visualized EXPLAIN in tools like MySQL Workbench provide more detailed and easier to understand outputs. The document also provides examples of using EXPLAIN for single table queries, index usage, range optimizations, and index merges.
Iron Ore Mining - India
Iron Ore Mining - Indiaraman109 The document discusses iron ore mining in the Indian states of Karnataka and Orissa. In Karnataka, iron ore experiences downhill movement from mines, with loading points at a higher elevation than unloading points. Transport vehicles commonly used include 6x4 trucks carrying 25-28 tons. Haul road gradients are steep at 1:10 to 1:16. In Orissa, movement is typically uphill from mines to unloading points. Larger 280HP trucks are used carrying around 27-28 tons. Haul road conditions are better with gradients of 1:16 to 1:20, allowing for overtaking. Customers in Karnataka prioritize initial cost while those in Orissa emphasize spare parts availability and uptime.
MySQL 5.7 GIS-Norvald H. Ryeng
MySQL 5.7 GIS-Norvald H. Ryeng郁萍 王 The document discusses MySQL 5.7's new GIS features, including integrating the Boost.Geometry library for geometry representation and comparisons, adding spatial indexes to InnoDB for faster spatial queries, supporting GeoJSON and additional functions, and providing examples of using spatial data from OpenStreetMap for proximity searches of restaurants near a given location.
MySQL cluster workshop
MySQL cluster workshop郁萍 王 This document provides an agenda and overview for a MySQL Cluster workshop. The agenda covers basics of MySQL, high availability options, an overview of MySQL Cluster, installation, configuration, programs, management and replication in MySQL Cluster. The document then goes into more detail on the basics of MySQL architecture and components, different high availability architectures in MySQL including master-slave, master-master and MySQL Cluster. It provides terminology and components used in MySQL Cluster including management nodes, data nodes, SQL nodes and APIs. It discusses different installation methods for MySQL Cluster including the auto-installer, traditional method and MySQL Cluster Manager.
Overview of Optimizer Features in 5.6 and 5.7-Manyi Lu
Overview of Optimizer Features in 5.6 and 5.7-Manyi Lu郁萍 王 The document discusses improvements to the MySQL optimizer in versions 5.6 and 5.7. Some key improvements include better handling of subqueries, optimization of queries with small LIMIT values, use of multi-range reads to improve join performance, persisting optimizer statistics, showing EXPLAIN output in JSON format, and using condition filtering to more accurately estimate costs. The optimizer is important for efficiently designing schemas and queries.
MySQL enterprise backup overview
MySQL enterprise backup overview郁萍 王 MySQL Enterprise Backup provides fast, consistent, online backups of MySQL databases. It allows for backing up InnoDB and MyISAM tables while the database is running, minimizing downtime. The tool takes physical backups of the data files rather than logical backups, allowing for very fast restore times compared to alternatives like mysqldump. It supports features like compressed backups, incremental backups, and point-in-time recovery.
From Nice to Have to Mission Critical: MySQL Enterprise Edition
From Nice to Have to Mission Critical: MySQL Enterprise Edition郁萍 王 This document outlines an agenda for a presentation on MySQL Enterprise Edition. The agenda includes an introduction to MySQL, discussing data in the modern enterprise, an overview of MySQL Enterprise Edition, Oracle product integrations and certifications, opportunities for learning more, and a question and answer session. It also includes a safe harbor statement indicating the product direction outlines are for information purposes only and not binding commitments.
More Related Content
More from 郁萍 王 (10)
MySQL cluster workshop
MySQL cluster workshop郁萍 王 This document provides an agenda and overview for a MySQL Cluster workshop. The agenda covers basics of MySQL, high availability options, an overview of MySQL Cluster, installation, configuration, programs, management and replication in MySQL Cluster. The document then goes into more detail on the basics of MySQL architecture and components, different high availability architectures in MySQL including master-slave, master-master and MySQL Cluster. It provides terminology and components used in MySQL Cluster including management nodes, data nodes, SQL nodes and APIs. It discusses different installation methods for MySQL Cluster including the auto-installer, traditional method and MySQL Cluster Manager.
Overview of Optimizer Features in 5.6 and 5.7-Manyi Lu
Overview of Optimizer Features in 5.6 and 5.7-Manyi Lu郁萍 王 The document discusses improvements to the MySQL optimizer in versions 5.6 and 5.7. Some key improvements include better handling of subqueries, optimization of queries with small LIMIT values, use of multi-range reads to improve join performance, persisting optimizer statistics, showing EXPLAIN output in JSON format, and using condition filtering to more accurately estimate costs. The optimizer is important for efficiently designing schemas and queries.
MySQL enterprise backup overview
MySQL enterprise backup overview郁萍 王 MySQL Enterprise Backup provides fast, consistent, online backups of MySQL databases. It allows for backing up InnoDB and MyISAM tables while the database is running, minimizing downtime. The tool takes physical backups of the data files rather than logical backups, allowing for very fast restore times compared to alternatives like mysqldump. It supports features like compressed backups, incremental backups, and point-in-time recovery.
From Nice to Have to Mission Critical: MySQL Enterprise Edition
From Nice to Have to Mission Critical: MySQL Enterprise Edition郁萍 王 This document outlines an agenda for a presentation on MySQL Enterprise Edition. The agenda includes an introduction to MySQL, discussing data in the modern enterprise, an overview of MySQL Enterprise Edition, Oracle product integrations and certifications, opportunities for learning more, and a question and answer session. It also includes a safe harbor statement indicating the product direction outlines are for information purposes only and not binding commitments.