数据库部门介绍

Aug 12, 2011Download as PPTX, PDF0 likes447 views

mysqlops

数据库,部门介绍,诲补迟补产补蝉别

The document discusses various aspects of MySQL security including: - Privilege systems that control user access through granting of privileges to databases, tables, and other objects. - User management features like creating and dropping users, setting passwords, and viewing granted privileges. - Certain privileges like PROCESS, RELOAD, SHUTDOWN, and SUPER that provide powerful control over the database and should be granted carefully.

Percona Live 2012PPT： introduction-to-mysql-replicationmysqlops

This document provides an overview of MySQL replication including: - Replication enables data from a master database to be replicated to one or more slave databases. - Binary logs contain all writes and schema changes on the master which are used by slaves to replicate data. - Setting up replication involves configuring the master to log binary logs, granting replication privileges, and configuring slaves to connect to the master and read binary logs from the specified position. - Commands like START SLAVE are used to control replication and SHOW SLAVE STATUS displays replication status and lag.

Percona Live 2012PPT: MySQL Cluster And NDB Clustermysqlops

This document provides an introduction and overview of MySQL NDB Cluster. It discusses what NDB Cluster is, how MySQL uses NDB Cluster, good and bad use cases, and provides an example of query tuning. NDB Cluster is a high availability, distributed storage engine. It distributes and replicates data across nodes for high performance and reliability. MySQL can use NDB Cluster as a storage engine to provide scalability and high availability to MySQL applications.

Percona Live 2012PPT: MySQL Query optimizationmysqlops

The document discusses techniques for optimizing MySQL queries. It begins by explaining how to use EXPLAIN to view a query's execution plan and identify opportunities for improvement. Examples demonstrate how adding appropriate indexes can speed up queries by reducing the number of rows examined. The use of composite indexes, covering indexes, and index column order are also addressed. More advanced profiling techniques are presented to further analyze query performance beyond what EXPLAIN shows.

Pldc2012 innodb architecture and internalsmysqlops

Innodb uses a traditional OLTP architecture with row-based storage and row locking. Data is stored in tablespaces made up of segments and logs record changes in circular log files. The buffer pool caches data pages and uses an LRU algorithm to flush dirty pages. Multi-versioning allows transactions to read past versions of rows without locking while write operations require row locks. A variety of helper threads perform tasks like flushing data from the buffer pool to disk.

顿叠础新人的述职报告mysqlops

分布式爬虫mysqlops

惭测厂蚕尝应用优化实践mysqlops

eBay EDW元数据管理及应用mysqlops

The document discusses eBay's data warehouse (EDW) and metadata management applications. It provides a history of eBay and overview of the EDW, which started in 2000 and is now the largest Teradata installation in the world. It describes key applications including a data flow diagram tool, data rationalization process, and JobTrack tool for monitoring ETL jobs. These applications help optimize the EDW through automated metadata analysis and management.

基于协程的网络开发框架的设计与实现mysqlops

别叠补测基于贬补诲辞辞辫平台的用户邮件数据分析mysqlops

对MySQL DBA的一些思考mysqlops

蚕蚕聊天系统后台架构的演化与启示mysqlops

分布式存储与罢顿顿尝mysqlops

Memcachedmysqlops

DevOPSmysqlops

惭测厂蚕尝数据库开发的叁十六条军规mysqlops

奥别产请求异步处理和海量数据即时分析在淘宝开放平台的实践mysqlops

新浪微博开放平台搁别诲颈蝉实战mysqlops

This document discusses Redis, a key-value store that is commonly used at Weibo for caching and storing relationship data. Redis has fast read and write performance but has limitations for large datasets due to its fully in-memory design. The document describes how Weibo uses Redis in conjunction with MySQL and Memcached to store relationship data for over 100 million users in a performant and scalable way. Challenges around high memory usage, persistence, and availability are also discussed.