innodb Archives

Will too many tables slow Mysql down?

By adminPosted on March 29, 2023

Question : I’m making a database which should be able to handle over 1,000,000,000 rows. in order to optimize it’s […]

By adminPosted on March 28, 2023

Question : I’ve seen some people suggest that O_DSYNC should be used with a SAN. The MySQL docs have this […]

By adminPosted on March 27, 2023

Question : I have a big MyISAM table with a fulltext index for searching. Problem is that inserting data into […]

By adminPosted on March 27, 2023

Question : I have a problem with OPTIMIZE TABLE query with one of my InnoDB database tables. I have a […]

By adminPosted on March 27, 2023

Question : I’ve got a single database of about 4.5GB running on a server with 8GB RAM. The vast majority […]

By adminPosted on March 27, 2023

Question : I have a PHP website, which is using the third-party software ResourceSpace, that when I installed it, it […]

By adminPosted on March 26, 2023

Question : I am using the php framework Laravel for my application, together with mysql 5.6, in order to have […]

By adminPosted on March 26, 2023

Question : I have read your post and I completely understand OPTIMIZE TABLE to perform in an environment where innodb_file_per_table […]

By adminPosted on March 26, 2023

Question : What I want to do is insert a row and than select its auto incremented id number, In […]

By adminPosted on March 25, 2023

Question : I have VPS with following setup: (4 x 2.40 GHz), 8192 MB RAM MEMORY, 20GB HDD space. My […]