Verfügbarkeit: MySQL 8 Administrator's Guide :

MySQL 8 Administrator's Guide :: Effective guide to administering high-performance MySQL 8 solutions.

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,...

Ausführliche Beschreibung

Gespeichert in:

Bibliographische Detailangaben
1. Verfasser:	Mehta, Chintan
Weitere Verfasser:	Oza, Hetal, Bhavsar, Ankit K., Shah, Subhash
Format:	Elektronisch E-Book
Sprache:	English
Veröffentlicht:	Birmingham : Packt Publishing, 2018.
Schlagworte:	MySQL (Electronic resource) SQL.
Online-Zugang:	Volltext
Zusammenfassung:	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 ...
Beschreibung:	Environment variables.
Beschreibung:	1 online resource (501 pages)
ISBN:	9781788393843 1788393848 1788395190 9781788395199

Internformat

MARC


LEADER	00000cam a2200000Mi 4500
001	ZDB-4-EBA-on1024270453
003	OCoLC
005	20241004212047.0
006	m o d
007	cr \|n\|---\|\|\|\|\|
008	180224s2018 enk o 000 0 eng d
040			\|a EBLCP \|b eng \|e pn \|c EBLCP \|d NLE \|d MERUC \|d CHVBK \|d OCLCO \|d IDB \|d OCLCQ \|d OCLCF \|d VT2 \|d TEFOD \|d OCLCQ \|d LVT \|d C6I \|d UKAHL \|d UKMGB \|d OCLCQ \|d N$T \|d NZAUC \|d OCLCQ \|d OCLCO \|d OCLCL
015			\|a GBB838165 \|2 bnb
016	7		\|a 018758015 \|2 Uk
020			\|a 9781788393843 \|q (electronic bk.)
020			\|a 1788393848 \|q (electronic bk.)
020			\|a 1788395190
020			\|a 9781788395199
024	3		\|a 9781788395199
035			\|a (OCoLC)1024270453
037			\|a B08055 \|b 01201872
037			\|a 7A6DE7CC-D78A-48E7-8568-062A3DBEF14B \|b OverDrive, Inc. \|n http://www.overdrive.com
050		4	\|a QA76.73.P224 \|b .M977 2018
082	7		\|a 005.133 \|2 23
049			\|a MAIN
100	1		\|a Mehta, Chintan.
245	1	0	\|a MySQL 8 Administrator's Guide : \|b Effective guide to administering high-performance MySQL 8 solutions.
260			\|a Birmingham : \|b Packt Publishing, \|c 2018.
300			\|a 1 online resource (501 pages)
336			\|a text \|b txt \|2 rdacontent
337			\|a computer \|b c \|2 rdamedia
338			\|a online resource \|b cr \|2 rdacarrier
588	0		\|a Print version record.
505	0		\|a 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.
505	8		\|a Improved features in MySQL 8TransactionalÂ dataÂ dictionary; Roles; InnoDB auto increment; Invisible indexes; Improving descending indexes; TheÂ SET PERSIST variant; Expanded GIS support; Default character set; Extended bit-wise operations; InnoDB Memcached; NOWAITÂ andÂ SKIPÂ LOCKED; JSON; Cloud; Resource management; Benefits of using MySQL 8; Security; Scalability; An open source relational database management system; HighÂ performance; High availability; Cross-platform capabilities; Limitations of MySQL 8; Number of tables or databases; Table size; Joins; Windows platform.
505	8		\|a 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.
505	8		\|a 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 setupÂ forÂ MySQL 8; Data directory initialization.
505	8		\|a Securing the initial MySQL accountStarting and troubleshooting MySQL 8 services; Executing commands to test the server; Upgrading MySQL 8; Upgrading methods; In-place upgradeÂ 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 â#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 programsÂ
500			\|a Environment variables.
520			\|a 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 ...
630	0	0	\|a MySQL (Electronic resource) \|0 http://id.loc.gov/authorities/names/n2004021601
630	0	7	\|a MySQL (Electronic resource) \|2 fast
650		0	\|a SQL.
700	1		\|a Oza, Hetal.
700	1		\|a Bhavsar, Ankit K.
700	1		\|a Shah, Subhash.
758			\|i has work: \|a MySQL 8 administrator's guide (Text) \|1 https://id.oclc.org/worldcat/entity/E39PCFvK7GJmQGYTthbwrgXgqP \|4 https://id.oclc.org/worldcat/ontology/hasWork
776	0	8	\|i Print version: \|a Mehta, Chintan. \|t MySQL 8 Administrator's Guide : Effective guide to administering high-performance MySQL 8 solutions. \|d Birmingham : Packt Publishing, ©2018
856	4	0	\|l FWS01 \|p ZDB-4-EBA \|q FWS_PDA_EBA \|u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1712730 \|3 Volltext
938			\|a Askews and Holts Library Services \|b ASKH \|n AH33903714
938			\|a EBL - Ebook Library \|b EBLB \|n EBL5301595
938			\|a EBSCOhost \|b EBSC \|n 1712730
994			\|a 92 \|b GEBAY
912			\|a ZDB-4-EBA
049			\|a DE-863

Datensatz im Suchindex

DE-BY-FWS_katkey	ZDB-4-EBA-on1024270453
_version_	1816882414180368384
adam_text
any_adam_object
author	Mehta, Chintan
author2	Oza, Hetal Bhavsar, Ankit K. Shah, Subhash
author2_role
author2_variant	h o ho a k b ak akb s s ss
author_facet	Mehta, Chintan Oza, Hetal Bhavsar, Ankit K. Shah, Subhash
author_role
author_sort	Mehta, Chintan
author_variant	c m cm
building	Verbundindex
bvnumber	localFWS
callnumber-first	Q - Science
callnumber-label	QA76
callnumber-raw	QA76.73.P224 .M977 2018
callnumber-search	QA76.73.P224 .M977 2018
callnumber-sort	QA 276.73 P224 M977 42018
callnumber-subject	QA - Mathematics
collection	ZDB-4-EBA
contents	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. Improved features in MySQL 8TransactionalÂ dataÂ dictionary; Roles; InnoDB auto increment; Invisible indexes; Improving descending indexes; TheÂ SET PERSIST variant; Expanded GIS support; Default character set; Extended bit-wise operations; InnoDB Memcached; NOWAITÂ andÂ SKIPÂ LOCKED; JSON; Cloud; Resource management; Benefits of using MySQL 8; Security; Scalability; An open source relational database management system; HighÂ performance; High availability; Cross-platform capabilities; Limitations of MySQL 8; Number of tables or databases; Table size; Joins; Windows platform. 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. 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 setupÂ forÂ MySQL 8; Data directory initialization. Securing the initial MySQL accountStarting and troubleshooting MySQL 8 services; Executing commands to test the server; Upgrading MySQL 8; Upgrading methods; In-place upgradeÂ 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 â#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 programsÂ
ctrlnum	(OCoLC)1024270453
dewey-full	005.133
dewey-hundreds	000 - Computer science, information, general works
dewey-ones	005 - Computer programming, programs, data, security
dewey-raw	005.133
dewey-search	005.133
dewey-sort	15.133
dewey-tens	000 - Computer science, information, general works
discipline	Informatik
format	Electronic eBook
fullrecord	<?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>05631cam a2200601Mi 4500</leader><controlfield tag="001">ZDB-4-EBA-on1024270453</controlfield><controlfield tag="003">OCoLC</controlfield><controlfield tag="005">20241004212047.0</controlfield><controlfield tag="006">m o d </controlfield><controlfield tag="007">cr \|n\|---\|\|\|\|\|</controlfield><controlfield tag="008">180224s2018 enk o 000 0 eng d</controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">EBLCP</subfield><subfield code="b">eng</subfield><subfield code="e">pn</subfield><subfield code="c">EBLCP</subfield><subfield code="d">NLE</subfield><subfield code="d">MERUC</subfield><subfield code="d">CHVBK</subfield><subfield code="d">OCLCO</subfield><subfield code="d">IDB</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCF</subfield><subfield code="d">VT2</subfield><subfield code="d">TEFOD</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">LVT</subfield><subfield code="d">C6I</subfield><subfield code="d">UKAHL</subfield><subfield code="d">UKMGB</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">N$T</subfield><subfield code="d">NZAUC</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCL</subfield></datafield><datafield tag="015" ind1=" " ind2=" "><subfield code="a">GBB838165</subfield><subfield code="2">bnb</subfield></datafield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">018758015</subfield><subfield code="2">Uk</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781788393843</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1788393848</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1788395190</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781788395199</subfield></datafield><datafield tag="024" ind1="3" ind2=" "><subfield code="a">9781788395199</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1024270453</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">B08055</subfield><subfield code="b">01201872</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">7A6DE7CC-D78A-48E7-8568-062A3DBEF14B</subfield><subfield code="b">OverDrive, Inc.</subfield><subfield code="n">http://www.overdrive.com</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">QA76.73.P224</subfield><subfield code="b">.M977 2018</subfield></datafield><datafield tag="082" ind1="7" ind2=" "><subfield code="a">005.133</subfield><subfield code="2">23</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">MAIN</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Mehta, Chintan.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">MySQL 8 Administrator's Guide :</subfield><subfield code="b">Effective guide to administering high-performance MySQL 8 solutions.</subfield></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="a">Birmingham :</subfield><subfield code="b">Packt Publishing,</subfield><subfield code="c">2018.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (501 pages)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="588" ind1="0" ind2=" "><subfield code="a">Print version record.</subfield></datafield><datafield tag="505" ind1="0" ind2=" "><subfield code="a">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.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Improved features in MySQL 8TransactionalÂ dataÂ dictionary; Roles; InnoDB auto increment; Invisible indexes; Improving descending indexes; TheÂ SET PERSIST variant; Expanded GIS support; Default character set; Extended bit-wise operations; InnoDB Memcached; NOWAITÂ andÂ SKIPÂ LOCKED; JSON; Cloud; Resource management; Benefits of using MySQL 8; Security; Scalability; An open source relational database management system; HighÂ performance; High availability; Cross-platform capabilities; Limitations of MySQL 8; Number of tables or databases; Table size; Joins; Windows platform.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">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.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">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 setupÂ forÂ MySQL 8; Data directory initialization.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Securing the initial MySQL accountStarting and troubleshooting MySQL 8 services; Executing commands to test the server; Upgrading MySQL 8; Upgrading methods; In-place upgradeÂ 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 â#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 programsÂ</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Environment variables.</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">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 ...</subfield></datafield><datafield tag="630" ind1="0" ind2="0"><subfield code="a">MySQL (Electronic resource)</subfield><subfield code="0">http://id.loc.gov/authorities/names/n2004021601</subfield></datafield><datafield tag="630" ind1="0" ind2="7"><subfield code="a">MySQL (Electronic resource)</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">SQL.</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Oza, Hetal.</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Bhavsar, Ankit K.</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Shah, Subhash.</subfield></datafield><datafield tag="758" ind1=" " ind2=" "><subfield code="i">has work:</subfield><subfield code="a">MySQL 8 administrator's guide (Text)</subfield><subfield code="1">https://id.oclc.org/worldcat/entity/E39PCFvK7GJmQGYTthbwrgXgqP</subfield><subfield code="4">https://id.oclc.org/worldcat/ontology/hasWork</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Print version:</subfield><subfield code="a">Mehta, Chintan.</subfield><subfield code="t">MySQL 8 Administrator's Guide : Effective guide to administering high-performance MySQL 8 solutions.</subfield><subfield code="d">Birmingham : Packt Publishing, ©2018</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="l">FWS01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FWS_PDA_EBA</subfield><subfield code="u">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1712730</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">Askews and Holts Library Services</subfield><subfield code="b">ASKH</subfield><subfield code="n">AH33903714</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBL - Ebook Library</subfield><subfield code="b">EBLB</subfield><subfield code="n">EBL5301595</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">1712730</subfield></datafield><datafield tag="994" ind1=" " ind2=" "><subfield code="a">92</subfield><subfield code="b">GEBAY</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-863</subfield></datafield></record></collection>
id	ZDB-4-EBA-on1024270453
illustrated	Not Illustrated
indexdate	2024-11-27T13:28:14Z
institution	BVB
isbn	9781788393843 1788393848 1788395190 9781788395199
language	English
oclc_num	1024270453
open_access_boolean
owner	MAIN DE-863 DE-BY-FWS
owner_facet	MAIN DE-863 DE-BY-FWS
physical	1 online resource (501 pages)
psigel	ZDB-4-EBA
publishDate	2018
publishDateSearch	2018
publishDateSort	2018
publisher	Packt Publishing,
record_format	marc
spelling	Mehta, Chintan. MySQL 8 Administrator's Guide : Effective guide to administering high-performance MySQL 8 solutions. Birmingham : Packt Publishing, 2018. 1 online resource (501 pages) text txt rdacontent computer c rdamedia online resource cr rdacarrier Print version record. 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. Improved features in MySQL 8TransactionalÂ dataÂ dictionary; Roles; InnoDB auto increment; Invisible indexes; Improving descending indexes; TheÂ SET PERSIST variant; Expanded GIS support; Default character set; Extended bit-wise operations; InnoDB Memcached; NOWAITÂ andÂ SKIPÂ LOCKED; JSON; Cloud; Resource management; Benefits of using MySQL 8; Security; Scalability; An open source relational database management system; HighÂ performance; High availability; Cross-platform capabilities; Limitations of MySQL 8; Number of tables or databases; Table size; Joins; Windows platform. 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. 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 setupÂ forÂ MySQL 8; Data directory initialization. Securing the initial MySQL accountStarting and troubleshooting MySQL 8 services; Executing commands to test the server; Upgrading MySQL 8; Upgrading methods; In-place upgradeÂ 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 â#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 programsÂ Environment variables. 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 ... MySQL (Electronic resource) http://id.loc.gov/authorities/names/n2004021601 MySQL (Electronic resource) fast SQL. Oza, Hetal. Bhavsar, Ankit K. Shah, Subhash. has work: MySQL 8 administrator's guide (Text) https://id.oclc.org/worldcat/entity/E39PCFvK7GJmQGYTthbwrgXgqP https://id.oclc.org/worldcat/ontology/hasWork Print version: Mehta, Chintan. MySQL 8 Administrator's Guide : Effective guide to administering high-performance MySQL 8 solutions. Birmingham : Packt Publishing, ©2018 FWS01 ZDB-4-EBA FWS_PDA_EBA https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1712730 Volltext
spellingShingle	Mehta, Chintan MySQL 8 Administrator's Guide : Effective guide to administering high-performance MySQL 8 solutions. 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. Improved features in MySQL 8TransactionalÂ dataÂ dictionary; Roles; InnoDB auto increment; Invisible indexes; Improving descending indexes; TheÂ SET PERSIST variant; Expanded GIS support; Default character set; Extended bit-wise operations; InnoDB Memcached; NOWAITÂ andÂ SKIPÂ LOCKED; JSON; Cloud; Resource management; Benefits of using MySQL 8; Security; Scalability; An open source relational database management system; HighÂ performance; High availability; Cross-platform capabilities; Limitations of MySQL 8; Number of tables or databases; Table size; Joins; Windows platform. 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. 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 setupÂ forÂ MySQL 8; Data directory initialization. Securing the initial MySQL accountStarting and troubleshooting MySQL 8 services; Executing commands to test the server; Upgrading MySQL 8; Upgrading methods; In-place upgradeÂ 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 â#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 programsÂ MySQL (Electronic resource) http://id.loc.gov/authorities/names/n2004021601 MySQL (Electronic resource) fast SQL.
subject_GND	http://id.loc.gov/authorities/names/n2004021601
title	MySQL 8 Administrator's Guide : Effective guide to administering high-performance MySQL 8 solutions.
title_auth	MySQL 8 Administrator's Guide : Effective guide to administering high-performance MySQL 8 solutions.
title_exact_search	MySQL 8 Administrator's Guide : Effective guide to administering high-performance MySQL 8 solutions.
title_full	MySQL 8 Administrator's Guide : Effective guide to administering high-performance MySQL 8 solutions.
title_fullStr	MySQL 8 Administrator's Guide : Effective guide to administering high-performance MySQL 8 solutions.
title_full_unstemmed	MySQL 8 Administrator's Guide : Effective guide to administering high-performance MySQL 8 solutions.
title_short	MySQL 8 Administrator's Guide :
title_sort	mysql 8 administrator s guide effective guide to administering high performance mysql 8 solutions
title_sub	Effective guide to administering high-performance MySQL 8 solutions.
topic	MySQL (Electronic resource) http://id.loc.gov/authorities/names/n2004021601 MySQL (Electronic resource) fast SQL.
topic_facet	MySQL (Electronic resource) SQL.
url	https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1712730
work_keys_str_mv	AT mehtachintan mysql8administratorsguideeffectiveguidetoadministeringhighperformancemysql8solutions AT ozahetal mysql8administratorsguideeffectiveguidetoadministeringhighperformancemysql8solutions AT bhavsarankitk mysql8administratorsguideeffectiveguidetoadministeringhighperformancemysql8solutions AT shahsubhash mysql8administratorsguideeffectiveguidetoadministeringhighperformancemysql8solutions

Verfügbarkeit

Es ist kein Print-Exemplar vorhanden.

Volltext öffnen

MARC

Datensatz im Suchindex

Es ist kein Print-Exemplar vorhanden.

Ähnliche Einträge