MySQL Forums
Forum List  »  InnoDB

Re: Woocommerce my.cnf phpmysql
Posted by: Iain Macandrew
Date: February 06, 2018 04:28PM

Hi Peter,

Thank you for your help so far,

Here is the results of free -m

total used free shared buffers cached
Mem: 7680 4358 3322 57 388 2373
-/+ buffers/cache: 1596 6083
Swap: 0 0 0

The data I am importing was originally going into a MYISAM Table but I converted this table to InnoDB as I was under the impression this was a better engine.

With me converting that table should I look to increase the InnoDB buffer?

I am just working out how to use EXPLAIN I will let you know the results.

Options: ReplyQuote


Subject
Views
Written By
Posted
1463
February 05, 2018 04:24PM
737
February 06, 2018 11:35AM
799
February 06, 2018 01:53PM
714
February 06, 2018 03:55PM
Re: Woocommerce my.cnf phpmysql
670
February 06, 2018 04:28PM
575
February 06, 2018 08:15PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.