Solved

My SQL size limits

Posted on 2011-03-21
5
400 Views
Last Modified: 2012-05-11
I'm looking for the ballpark limitations for deploying MySQL 5.0 or 5.1 on 64-bit RedHat 2.6.18-194.el5 with 4G of memory, with decent speed SAN storage. Lets assume I've configured the OS & mysql correctly. Here are the categories I'm interested in:
- max database size
- max table size
- max concurrent users
- max G/hour mysqldump backup
- max G/hour mysqldump restore
- max OLTP transaction volume
0
Comment
Question by:Rick-Fox
  • 2
5 Comments
 
LVL 5

Expert Comment

by:mayankagarwal
ID: 35181928
0
 

Author Comment

by:Rick-Fox
ID: 35202657
Thanks - the infomation provided is relevant, but addresses only a portion of my information I'm looking for
0
 
LVL 51

Accepted Solution

by:
Ted Bouskill earned 500 total points
ID: 35219213
This will partially answer the maximum number of connections question (4096) however that is in an ideal world.  If each connection is consuming sufficient resources which is related to the complexity of the TSQL it could be far less.

http://dev.mysql.com/tech-resources/articles/mysql-administrator-best-practices.html

Disk I/O will directly affect the performance for backup/restore plus load while those events are occurring.

I haven't worked with OLTP on MySQL so I cannot answer that one.
0
 

Author Closing Comment

by:Rick-Fox
ID: 35328183
I appreciate the help it gets me part of the way to what I need
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MySQL: Updating SubQuery Match Faster 9 53
MySql hide the stored procedures 2 54
Sql query on a varchar that is numeric. 8 44
Upgrade MySQL 5.5 to MySQL 5.6 on Windows 13 47
Fore-Foreword Today (2016) Maxmind has a new approach to the distribution of its data sets.  This article may be obsolete.  Instead of using the examples here, have a look at the MaxMind API (https://www.maxmind.com/en/geolite2-developer-package). …
More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question