Question : I have a SQL Server 2008 R2 instance running on a production system. I’m not a DBA; I’m […]
Tag: database-tuning
Is my.cnf for mysql 5.5 is suitable and well tuned for below hardware spec?
Question : My Hardware Spec Technology: Ivy Bridge CPU: Intel Xeon E3 1245v2 Intel Smart Cache: 8MB Cores / Threads: […]
How to tell if database tuning is fruitful (PostgreSQL)
Question : As a DBA, I regularly observe my database, tune up some queries (either getting the programmers to re-write […]
Can I safely kill OPTIMIZE TABLE on an InnoDB table?
Question : MySQL’s documentation for kill warns: Warning Killing a REPAIR TABLE or OPTIMIZE TABLE operation on a MyISAM table […]
How to optimize MySQL for large BLOB updates
Question : I have a table that holds large BLOBs (up to 10M), and is updated frequently. The problem is […]
What are these files in MongoDB?
Question : I was looking into my server and I found this: [root@host ~]# cd /var/lib/mongo/journal/ [root@host journal]# ls -lh […]
Is it possible to allow write-through computed columns for legacy code that expects a column to be read/write?
Question : I have this existing table for IP storage: CREATE TABLE [dbo].[IPAddresses]( [ID] [int] IDENTITY(1,1) NOT NULL, [IPv4Address] [varchar](15) […]
How fast should I expect to load data on a high performance computer?
Question : I am considering a model where I use PostgreSQL COPY to copy data from a file into a […]
Could running ANALYZE on all databases on large InnoDB tables show some performance increase?
Question : So we have an old database that was fragmented until we ran OPTIMIZE on all tables. The database/tables […]
Access and filter in oracle plan
Question : I came to a execution plan where oracle choose to access the index but instead of using the […]