16 Cores 12 GB RAM server MySql Configuration - my.cnf; As a point of reference, I have a client at my employer's web hosting company that has three DB Servers in Circular Replication. Each DB server has the following: MySQL 5.5.9; 192 GB RAM; 162 GB InnoDB Buffer Pool; dual hexacore (that's right, 12 CPUs) 1.8TB Disk Volume; 978 multitenant ...

Aug 24, 2015 · Here is a little bit information about our current database server: MySQL Database; InnoDB for all tables; About 80 tables; Largest tables are: 15 GB, 13 GB, 12 GB, 5 GB, rest smaller than 1 GB; Size of database on disk is 175 GB with ibdata1, and 56 GB without it; Database grows about 10% per month -- 12 month ago it was about 5-6%

Mar 20, 2021 · I will be setting up a database to hold records of registered voters in various states for business purposes. Each table will contain the records for registered voters in one state. The average number of records for each table will be approximately 6 to 7 million records.

PostgreSQL can start and run (for a small db with few concurrent connections!) on very modest hardware. As of 9.2 you can get linear scalability for reads up to about 64 cores, and for writes up to around 20 cores, if I understand Robert Haas's blog posts correctly.

We are upgrading our database hardware and software. The previous server is about 5 years old and is running SQL Server 2005 while the new one is SQL Server 2012. Every hardware component is faster in the new server. Selects are faster and multiple inserts inside a transaction are around 50% faster, but raw inserts are actually slower by about 50%.

MySQL 5.1 InnoDB Plugin, MySQL 5.5, and Percona Server's XtraDB all have settings YOU MUST PROPERLY CONFIGURE to get InnoDB to access all cores. The real incentive for doing this stems from the fact that some older versions of MySQL LEFT UNCONFIGURED are faster than newer versions as I discussed in my past posts:

We have a bunch of applications that depends on about 10 different databases servers (all sql server) in our network. We are looking to build a development environment where we could have a mirror of the production databases. Our plan is to have one server and put all the 10 databases inside it as separate sql server instances.

Apr 27, 2017 · Our primary authentication database that is used for 100k+ users, and growing is a VM on a shared machine that we want to extract into its own isolated hardware. This will let us isolate resources, ...

Aug 1, 2011 · That is, you can start your database now on a slow server and as traffic increases you can adjust accordingly with minimal changes to your code or your db structure. What will change is your hardware and your db configuration. Most database servers will support failover/clustering with little to no change to your existing code or structures.

Apr 23, 2020 · Is there an ability to query below system specifications using T-SQL? cpu (show number of processors / cores / frequency) memory (show total amount of RAM on a machine; show allocated RAM; show re...