We sometimes forget the impact of early mathematicians. Take for example John Venn who introduced the Venn diagram in 1881.
This is fundamental for Set Theory, and also fundamental for SQL, the basis of retrieving data in a RDBMS.
We sometimes forget the impact of early mathematicians. Take for example John Venn who introduced the Venn diagram in 1881.
This is fundamental for Set Theory, and also fundamental for SQL, the basis of retrieving data in a RDBMS.
In a CPU-bound database workload, regardless of price, would you scale-up or scale-new? What if price was the driving factor, would you scale-up or scale-new? I am using as a baseline the first available AWS Graviton2 processor for RDS (r6g).
Read moreAs part of using public datasets with my own Benchmarking Suite I wanted upsize a dataset for larger volume testing. I have always used the INFORMATION_SCHEMA.TABLES data_length and index_length columns as a sufficiently accurate measurement for actual disk space used.
Read moreDuring my setup of benchmarking I run a quick test-sysbench script to ensure my configuration is right before running an hour+ duration test. When pointing to a Readyset cache where I have cached the 5 queries used in the sysbench test, but I have not run any execution of the SQL, throughput went up 10x in 5 seconds.
Read more