Set innodb_buffer_pool_size to 70% of _available_ ram. That may be 11G on your
16GB machine, unless you have a lot of other bulky stuff there. Do _not_ make
it so large that it leads to swapping. Swapping is much worse on performance
than shrinking the buffer_pool.
36 seconds for a
Can you hexdump the file and post it the maillist?
Hello Larry,
On 7/3/2013 11:27 AM, Larry Martell wrote:
We recently changed from in memory files to InnoDB files. Today we
noticed that in every server's data dir there is file called '1' that
seems to get updated every time the iddata1
Hi,
in short what we did was the following:
- binary logs was written to a 20GB filesystem and due to company
policies we kept expire logs at 7 days.
- system got quite busy over the years so the space was becoming a
problem and thus we had to move to another directory.
-
Am 03.07.2013 14:50, schrieb Emmy Santi:
my name is Effiong Emmanuel.please, I love your products and your ways
helping human.pls can you send me MYSQL COMPILER to enable me install it in
my laptop computer and practice.I will be gratefull if my request is kindly
granted.
what are you
Using deductive reasoning one would surmise that Effiong wants to
install the MySql Database on a laptop,
But then the question to Effiong is:
What Operating System is running on your LapTop?
NOTE: You'll need a MySql Server and a MySql Client, and maybe a Gui
Interface/WorkBench?
You can
What setting(s) did you change to move to the separate partition?
SHOW VARIABLES LIKE '%bin%';
SHOW VARIABLES LIKE '%dir%';
(there may be other VARIABLES worth checking)
What steps did you take for the move? (Actually move bin.1? Start over? etc?)
Consider using expire_logs_days.
5.0
On Wed, Jul 3, 2013 at 9:51 AM, shawn green shawn.l.gr...@oracle.com wrote:
Hello Larry,
On 7/3/2013 11:27 AM, Larry Martell wrote:
We recently changed from in memory files to InnoDB files. Today we
noticed that in every server's data dir there is file called '1' that
seems to get updated
issue on the slave:
SHOW SLAVE STATUS\G and post here
most likely after you reset the master your slave can't synch anymore,
because its missing next sequence of replication file.
why don't you backup your master with mysqldump and re-issue it ont he new
setup (i.e. on MySQL 5.5 instance)?
my name is Effiong Emmanuel.I love your products and your ways of helping
human.pls can you send me MYSQL COMPILER to enable me install it in my laptop
computer and practice.I will be gratefull if my request is kindly granted.
Hello Larry,
On 7/3/2013 11:27 AM, Larry Martell wrote:
We recently changed from in memory files to InnoDB files. Today we
noticed that in every server's data dir there is file called '1' that
seems to get updated every time the iddata1 file gets updated. On some
servers it's comparable in size
On 07/04/2013 01:15 PM, Emmy Santi wrote:
my name is Effiong Emmanuel.I love your products and your ways of helping
human.pls can you send me MYSQL COMPILER to enable me install it in my laptop
computer and practice.I will be gratefull if my request is kindly granted.
what do you refer to
Andy , increase innodb_log_file size to 400mb
DK Sent from Phone
On 03-Jul-2013, at 23:39, Rick James rja...@yahoo-inc.com wrote:
Set innodb_buffer_pool_size to 70% of _available_ ram. That may be 11G on
your 16GB machine, unless you have a lot of other bulky stuff there. Do
_not_ make
*boah* do *not* recommend blindly a change which
leads in the server no longer starting without
refer to the documentation and give a hint what
happens if you change the setting
http://dev.mysql.com/doc/refman/5.0/en/innodb-data-log-reconfiguration.html
Am 05.07.2013 05:01, schrieb Divesh Kamra:
13 matches
Mail list logo