عنوان
پدید آورنده
موضوع
رده
QA76.73.P224 .M977 2018
QA76
.
73
.
P224
.
M977
2018
کتابخانه
محل استقرار
INTERNATIONAL STANDARD BOOK NUMBER
(Number (ISBN
1788393848
(Number (ISBN
1788395190
(Number (ISBN
9781788393843
(Number (ISBN
9781788395199
TITLE AND STATEMENT OF RESPONSIBILITY
Title Proper
MySQL 8 Administrator's Guide :
General Material Designation
[Book]
Other Title Information
Effective guide to administering high-performance MySQL 8 solutions.
.PUBLICATION, DISTRIBUTION, ETC
Place of Publication, Distribution, etc.
Birmingham :
Name of Publisher, Distributor, etc.
Packt Publishing,
Date of Publication, Distribution, etc.
2018.
PHYSICAL DESCRIPTION
Specific Material Designation and Extent of Item
1 online resource (501 pages)
GENERAL NOTES
Text of Note
Environment variables.
CONTENTS NOTE
Text of Note
Cover; Copyright and Credits; Packt Upsell; Contributors; Table of Contents; Preface; Chapter 1: An Introduction to MYSQL 8; Overview of MySQL; MySQL as a relational database management system; License requirements of MySQL8; Reliability and scalability; Platform compatibility; Releases; Core features in MySQL; Structured database; Database storage engines and types; Overview of InnoDB; Overview of MyISAM; Overview of memory; Overview of archive; Overview of BLACKHOLE as a storage engine; Overview of CSV; Overview of merge; Overview of federated; Overview of the NDB cluster.
Text of Note
Improved features in MySQL 8Transactional data dictionary; Roles; InnoDB auto increment; Invisible indexes; Improving descending indexes; The SET PERSIST variant; Expanded GIS support; Default character set; Extended bit-wise operations; InnoDB Memcached; NOWAIT and SKIP LOCKED; JSON; Cloud; Resource management; Benefits of using MySQL 8; Security; Scalability; An open source relational database management system; High performance; High availability; Cross-platform capabilities; Limitations of MySQL 8; Number of tables or databases; Table size; Joins; Windows platform.
Text of Note
Installing MySQL 8 on Microsoft WindowsWindows-specific considerations; MySQL 8 installation layout; Choosing the right installation package; The MySQL 8 installer; Initial setup information; Installation workflow; InnoDB cluster sandbox test setup; Server configuration; MySQL installer product catalog and dashboard; MySQL installer console; MySQL 8 installation using a ZIP file; Installing MySQL 8 on Linux; Installation using the Yum repository; Installation using the RPM package; Installation using the Debian package; Post-installation setup for MySQL 8; Data directory initialization.
Text of Note
Securing the initial MySQL accountStarting and troubleshooting MySQL 8 services; Executing commands to test the server; Upgrading MySQL 8; Upgrading methods; In-place upgrade of MySQL; Logical upgrade for MySQL 8; Upgrading prerequisites for MySQL 5.7; MySQL 8 downgrading; Downgrading methods; Logical downgrade; Manual changes required before downgrading; Summary; Chapter 3: MySQL 8 â#x80;#x93; Using Programs and Utilities; Overview of MySQL 8 programs; MySQL programs in brief; Startup programs; Installation/upgradation programs; Client programs; Administrative and utilities programsÂ
Text of Note
Table column countRow size; InnoDB storage engine; Limitations of InnoDB storage engine; Restrictions; Data dictionary; Limitations of group replication in MySQL8; Limitations of partitioning; Constructs prohibition; Operators; Tables; Use cases of MySQL; Social media; Government; Media and entertainment; Fraud detection; Business mapping; E-commerce; Summary; Chapter 2: Installing and Upgrading MySQL 8; The MySQL 8 installation process; General installation guide; Downloading MySQL 8; Verifying the package integrity; Using MD5 checksums; Using cryptographic signatures.
0
8
8
8
8
SUMMARY OR ABSTRACT
Text of Note
MySQL is one of the most popular and widely used relational databases in the world today. The recently released version 8.0 brings along some major advancements in the way your MySQL solution can be administered. This book starts with a brief introduction to the newly introduced features in MySQL 8, followed by quickly jumping onto the crucial ...
ACQUISITION INFORMATION NOTE
Source for Acquisition/Subscription Address
OverDrive, Inc.
Source for Acquisition/Subscription Address
01201872
Stock Number
7A6DE7CC-D78A-48E7-8568-062A3DBEF14B
Stock Number
B08055
OTHER EDITION IN ANOTHER MEDIUM
Title
MySQL 8 Administrator's Guide : Effective guide to administering high-performance MySQL 8 solutions.
TITLE USED AS SUBJECT
MySQL (Electronic resource)
MySQL (Electronic resource)
TOPICAL NAME USED AS SUBJECT
SQL.
DEWEY DECIMAL CLASSIFICATION
Number
005
.
133
Edition
23
LIBRARY OF CONGRESS CLASSIFICATION
Class number
QA76
.
73
.
P224
Book number
.
M977
2018
PERSONAL NAME - PRIMARY RESPONSIBILITY
Mehta, Chintan.
PERSONAL NAME - ALTERNATIVE RESPONSIBILITY
Bhavsar, Ankit K.
Oza, Hetal.
Shah, Subhash.
ORIGINATING SOURCE
Date of Transaction
20200823060337.0
Cataloguing Rules (Descriptive Conventions))
pn
ELECTRONIC LOCATION AND ACCESS
Electronic name
مطالعه متن کتاب [Book]
Y
