shufil
- Total activity 86
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 15
Comments
Recent activity by shufil-
[quote="shufil, post: 1625111">Hello, Can this increase without increase our primary ram . show process list will give current mysql activity, but how can we know each query how many memory consum...
-
[quote="shufil, post: 1612422">Hello, Currently our innodb_buffer_pool_size = 1073741824, so we need to increase to 1573741824, is this get any result . Regards, Shufil Hello, Can this increase...
-
[quote="thinkbot, post: 1610301">Becouse you got too small buffers to fit InnoDB data/indexes to RAM [!!] InnoDB data size / buffer pool: 12.8G/1.0G and you are using 32-bit system [!!] Allocating...
-
[quote="thinkbot, post: 1604392">Yes, but in this case you should convert to InnoDB only the table which had problems with locking And previously you might not had properly configured myisam key bu...
-
[quote="thinkbot, post: 1603631">The thing is, for fast query execution it's important to have indexes (MyISAM) and data+indexes (Innodb) in memory, RAM MyISAM places only indexes in RAM, InnoDB ...
-
[quote="thinkbot, post: 1603492">You got 15GB in MyISAM and 12GB in InnoDB For MyISAM, key_buffer_size must be higher than 620M if you use all contents indexes, so [OK] Key buffer size / total MyI...
-
[quote="cPanelMichael, post: 1599742">You may want to post the full output of the tuner, as opposed to just the recommendations. It might help users to better offer you advice on settings to change...