*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:
Andy , increase innodb_log_file size to 400mb
DK Sent from Phone
On 03-Jul-2013, at 23:39, Rick James 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 it so large that i
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 w
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
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.
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)?
201
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 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 every time th
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 do
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 yo
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.
- sett
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 iddata
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 single-ro
13 matches
Mail list logo
