Question : I have a partitioned table on the basis of the Primary key having 1.5 Billion rows in it. […]
Category: Performance
Execute a query but not return results to client
Question : I am testing the performance a query and trying to fix a parameter sniffing issue. Based on the […]
How can I optimize a mysqldump of a large database?
Question : I have a symfony application with an InnoDB database that is ~2GB with 57 tables. The majority of […]
SQL 2008 Server agent cant see perfmon counters
Question : I am trying to create a new SQL server agent alert to capture “SQLServer:General Statistics|Processes Blocked||>|5′ but it […]
Large INSERT INTO SELECT [..] FROM gradually gets slower
Question : I’ve written a program that does a large INSERT in batches of 100,000 and shows its progress. The […]
Why does MariaDB 10.1.2 blow away MySQL 5.6.22 in sysbench?
Question : Problem Maria DB is doing roughly twice the number of transactions that mysql is using standard oltp benchmark. […]
MySQL creates tables very slow
Question : On my home machine running Ubuntu 18.04 and MySQL version 8.0.12 with better hardware, table creation, database creation […]
Performance problem using mysql fulltext search
Question : I have a fulltext index on a column that contains an absolute file path (file_path), for a file […]
Why would I NOT use the SQL Server option “optimize for ad hoc workloads”?
Question : I’ve been reading some great articles regarding SQL Server plan caching by Kimberly Tripp such as this one: […]
How to get MariaDB (MySql) query time?
Question : I’m using MariaDB 10.1. How to get actual query time for all of executed query? It seems that […]