Linked Questions

1 vote
1 answer
844 views

How do i increase the total MyISAM indexes?

I have just made a check for my server with mysqltuner. -------- Storage Engine Statistics ------------------------------------------- [--] Status: +Archive -BDB +Federated +InnoDB -ISAM -NDBCluster ...
Toi Lee's user avatar
  • 35
1 vote
1 answer
590 views

Is it normal that I have to FLUSH QUERY CACHE once every 6 hours to maintain fast queries?

I am running MySQL 5.5.37. I have a cronjob set to run every 6 hours to flush the query cache. I realized that if I don't do that, then the cache becomes fragmented and average query response time ...
brant's user avatar
  • 113
1 vote
1 answer
351 views

mysql multiple database prioritize innodb buffer pool size

With a mysql instance and multiple databases within that instance is there a way to allocate which database you would like to assign priority to the buffer pool size?
tommo's user avatar
  • 135
1 vote
1 answer
131 views

extra steps after changing storage engine and adding index

Someone told me to look into his website for quick optimization; I'm a programmer and i don't have much experience optimizing databases. I have a php/MySQL site uses the MyISAM storage engine. It ...
max's user avatar
  • 145
1 vote
1 answer
417 views

Large queries on MyISAM tables crashing MySQL

I have a PHP website, which is using the third-party software ResourceSpace, that when I installed it, it used my default storage engine to create the tables, which at the time was MyISAM. Now that ...
patrick.j.goodwin's user avatar
1 vote
1 answer
711 views

Does MySQL's MyISAM use cache before insert?

I want to test two different disks, one of them is HDD and another is SSD. I use exactly the same information and app for both servers. They are exactly the same, just one of them is SSD and another ...
Ata's user avatar
  • 141
1 vote
1 answer
987 views

MySQL: To use MYISAM or INNODB engine? (plot twist enclosed)

We use INNODB for all of our tables, but I have one special table, a 100+ GB reference table (only read-queries against it). We are loading changes to this table in a nightly batch job using LOAD ...
David Parks's user avatar
1 vote
1 answer
566 views

For 768M RAM server is 617M allocation in my.cnf good or bad?

I have a write-intensive web app, and I bought a VDS with 768M RAM Is this my.cnf good for my purposes? I specified bulk_insert_buffer_size to 126M and some other parameters as below: [mysqld] ...
Alireza's user avatar
  • 3,636
1 vote
1 answer
2k views

What are some good methods of structuring a MySQL audit trail to be both immutable, and perform well for usage?

In one application, we have an audit table that uses the ArchiveEngine in conjunction with a few triggers to capture 100% of the changes that occur. The upside to this is that 20+ million rows ...
Bryan Agee's user avatar
1 vote
1 answer
242 views

Normalization, field types and relationship

The following table is part of my project. I'm really strict about field types and store engines. I've read a lot of questions from this site, but I think there are a lot to do in the first step. Is ...
Alireza's user avatar
  • 3,636
1 vote
1 answer
272 views

MySQL Performance Planning

I am considering moving my existing script which is downloaded to be a hosted script. One of the things it does is to keep track of some stats. My concern is with heavy hitters (100,000 pageviews/...
QuaffAPint's user avatar
0 votes
1 answer
719 views

Complex query performance in MySQL InnoDB versus MyISAM

I am running on MariaDB 10.0.15 on a 4GB RAM cloud server with Local SSD disk for database. My model: users <n---n> right_holders <n---n> tracks ---n> raw_detections I have this ...
Daniel Cukier's user avatar
0 votes
1 answer
998 views

WordPress MySQL writes during "Flush Tables With Read Lock" are rejected instead of being queued

I'm running into an odd issue when setting MySQL into a brief read-only mode for backup. Reads continue fine during that "read only" minute, but writes are just rejected instead of being ...
Dan's user avatar
  • 1
0 votes
1 answer
213 views

Few Insert queries rollbacked due to system crash

Well, this problem occured to me first time. Yesterday, one of our mysql system server crashed and when it restarted last few inserts were completely rollbacked. I am sure that they were proper ...
simply-put's user avatar
-1 votes
1 answer
828 views

How important is InnoDB versus MyISAM? [duplicate]

Does it really matter if the default storage engine is InnoDB? My default storage engine is MyISAM
EGB's user avatar
  • 1

15 30 50 per page
1
2 3 4 5