storage-engine Archives

MySQL query ‘going away’ on executing INSERT ON DUPLICATE UPDATE statement with a 12524 character blob

By adminPosted on October 1, 2023

Question : I have a mysql insert on update query like so insert into table (col1, col2, col3) values (1,2,’huge […]

By adminPosted on September 12, 2023

Question : So I have a workload on 2 key tables in my application with the following characteristics: READ-ONLY DATA […]

By adminPosted on September 3, 2023

Question : I’m reading Itzik’s book “Querying Microsoft SQL Server 2012” as well as reading/watching different educational material on the […]

By adminPosted on August 23, 2023

Question : SAN LUN ambiguity wrt performance MSDN says to split read/write operations into a drive, sequential writes to another […]

By adminPosted on August 6, 2023

Question : What are the pros/cons of using the Sphinx Storage Engine in MySQL (doc) over the normal api? Answer […]

By adminPosted on August 1, 2023

Question : I have a table of 2 columns and 60 million rows. I want to update the table by […]

By adminPosted on July 29, 2023

Question : I have a pretty big MySQL table (70G) with about 15 columns and 1.5M rows. There is one […]

By adminPosted on July 21, 2023

Question : I install MariaDb and configured it to use TokuDb Engine. I need to use Fractal-Index Built-in on TokuDb […]

By adminPosted on July 17, 2023

Question : In mongoDB3 appeared a new storage engine: WiredTiger. Yet, MMAPv1 is still the default choice in Mongo. One […]

By adminPosted on July 6, 2023

Question : I have a table where I store all the urls from my website, and I update them from […]