PRICING

HELP

BLOG

APPSTORE

COMPANY

LEGAL

LOGIN

AI Assisted Content Management System

Analytics & Lead Generation

Automation Projects

Browser Extension Apps

Dashboard Theme Analysis: LN1

Data Exchange Automation Tools

Getting Started With Building Hybrid Apps

Izyware Hybrid UX Design Guidelines

Legacy Features and Backward Compatibility

How does the legacy frame architecture work

Izyware Legacy UI Circus Engine

Case Studies and Knowledge Center

Build and deploy a content distribution app in less than five minutes: Part II

Comparison of CSS Preprocessors SASS vs LESS vs STYLUS

Comparison of node.js test frameworks and utilities: lab, chai, sinon

Manage and automate your day to day business tools using IzyCloud Tasks: Part I

MySql Performance Optimization

Onboarding Tutorial: Creating & publishing an app

Rebranding and Customizing Websites

Using IzyCloud on Android: IzyCloud Query App

Technical Resources

.NET SDKCore IzyWare

accounts README

ElasticSearch IzyWare Data Console Feature

End To End Testing

End To End Testing, Part II

frames and nav (ui/w/shell/navmulti) README

izy-circus README

izy-idman-tools README

izy-pop3 README

izy-proxy README

izy-sync README

IzyIDE README

IzyShell readme

ReKey Feature Package README for IzyWare SQL Console

Tasks Migration : V5 guidelines

V5 Migration : apps/pulse guidelines README

Container Orchestration

Izy Kubernetes Internal Networking Troubleshooting

Application Hosting

Content Publisher

Domain Registration

Email Hosting

Izyware Browser Extension

Izyware Deployment Engine

Izyware Session Management

Messaging System APIs and functionality

Single SignOn

Integration APIs

AWS SDK

Azure and .NET

<< Manage and automate your day to day business tools using IzyCloud Tasks: Part I

Onboarding Tutorial: Creating & publishing an app >>

MySql Performance Optimization

MySql Performance Optimization

How large should be mysql innodbbufferpool_size?

Use this query:

SELECT CEILING(TotalInnoDBBytes*1.6/POWER(1024,3)) RIBPS FROM

(SELECT SUM(datalength+indexlength) TotalInnoDBBytes

FROM information_schema.tables WHERE engine='InnoDB') A;

This will give you the RIBPS, Recommended InnoDB Buffer Pool Size based on all InnoDB Data and Indexes with an additional 60%.

SELECT (PagesData*PageSize)/POWER(1024,3) DataGB FROM

(SELECT variable_value PagesData

FROM informationschema.globalstatus

WHERE variablename='Innodbbufferpoolpages_data') A,

(SELECT variable_value PageSize

FROM informationschema.globalstatus

WHERE variablename='Innodbpage_size') B;

This will give you how many actual GB of memory is in use by InnoDB Data in the InnoDB Buffer Pool at this moment.

This might also be useful:

SELECT engine, count() tables, concat(round(sum(table_rows)/1000000,2),'M') rows, concat(round(sum(data_length)/(102410241024),2),'G') data, concat(round(sum(index_length)/(102410241024),2),'G') idx, concat(round(sum(data_length+index_length)/(10241024*1024),2),'G') totalsize, round(sum(indexlength)/sum(data_length),2) idxfrac

FROM information_schema.TABLES GROUP BY engine

ORDER BY sum(datalength+indexlength) DESC LIMIT 10;