Dear All,
I hit belown problem when i compile(make install) 5.5.4-M3 on centos 5.0.
-bash-3.1# cat /etc/redhat-release
CentOS release 5 (Final)
-bash-3.1# uname -a
Linux dbte
On Sun, Apr 18, 2010 at 9:04 PM, Eric Bergen wrote:
> Usually I prefer to have linux kill processes rather than excessively
> swapping. I've worked on machines before that have swapped so badly
>
I guess you never had the OOM killer randomly shooting down your SSH daemon
on a machine hundred of
On Sun, Apr 18, 2010 at 9:35 PM, Eric Bergen wrote:
> This can become a problem when using replication. For example if you do:
>
> begin;
> insert into innodb_table;
> insert into myisam_table;
> insert into innodb_table;
> rollback;
>
> The innodb rows won't be replicated but the myisam row will
On Mon, Apr 19, 2010 at 6:48 AM, Rob Wultsch wrote:
>
> And if your slave's IO lags badly enough this will hose you. Further
>
True, but if you remove logs that haven't been transferred, yet, you lose
your slave.
Transfer of logs shouldn't be lagging that much, really, unless you're
replicating
Google oom_adj and oom_score. You can control which process is most
likely to be killed.
On Mon, Apr 19, 2010 at 12:53 AM, Johan De Meersman wrote:
>
>
> On Sun, Apr 18, 2010 at 9:04 PM, Eric Bergen wrote:
>>
>> Usually I prefer to have linux kill processes rather than excessively
>> swapping. I
On Mon, Apr 19, 2010 at 1:07 AM, Johan De Meersman wrote:
> On Mon, Apr 19, 2010 at 6:48 AM, Rob Wultsch wrote:
>>
>> And if your slave's IO lags badly enough this will hose you. Further
>
> True, but if you remove logs that haven't been transferred, yet, you lose
> your slave.
>
> Transfer of lo
On Mon, Apr 19, 2010 at 12:16 PM, Rob Wultsch wrote:
> One way or another this
> should be a conscious decision, not a copy and paste from a mailing
> list.
>
As is the case with most settings :-)
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt,
How recent is your source tree? It looks like it may be a recent issue, so
going back 6 months or so
might solve it.
The bug report you noted doesn't seem to have a work-around, though I would
guess you could look at
the source and probably fix the issue quite easily. It looks like you have do
> > Consider the following concept,
> >
> > ~/index.php
> >
> > #1. Fetch data from an external webpage using PHP Curl;
> > #2. Preg_match/Prepare Data to INSERT from local MySQL; - this may take a
> > few secs
> > #3. While Loop { INSERT data (from #2) into local MySQL } - this may take
> > only m
On Fri, Apr 16, 2010 at 1:31 PM, Nigel Wood wrote:
> P.S. Sorry to the other list users for a PHP oriented discussion.
>
Get a room, you two :-)
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
Hi Yang Wang, everybody!
Yang Wang wrote:
> Dear All,
>
> I hit belown problem when i compile(make install) 5.5.4-M3 on centos 5.0.
>
>
>
> -bash-3.1# cat /etc/redhat-releas
On this level, it's more of an apache/web-server-in-general issue.
There are 2 connections to be considered here: the connection between
the browser and the web server and the connection between the
webserver (running PHP for example) and the database and they have
very different behaviours.
If t
I'm using MySQL to manage data on my computer .
The total data is 50 Gig in MyISAM folders.
As I type, I already have the folder with the myd, frm, etc being
copied offsite. As I understand it, if this computer dies tomorrow, I
can reinstall MySQL on a new computer, drag over the archive, stick
Mitchell Maltenfort wrote:
I'm using MySQL to manage data on my computer .
The total data is 50 Gig in MyISAM folders.
As I type, I already have the folder with the myd, frm, etc being
copied offsite. As I understand it, if this computer dies tomorrow, I
can reinstall MySQL on a new computer,
What Shawn said is important.
Better options:
1. Use InnoDB, and then you can make a consistent backup with `mysqldump
--single-transaction > backup.sql` and keep your db server actively responding
to requests at the same time.
2. Use something like LVM to create filesytem snapshots which allo
Hi, Joerg
Thanks you very much.
I slove it with second method(hack "sql/share/Makefile"
http://lists.mysql.com/commits/102846).
r...@localhost:(none) 09:09:30>select version();
+
16 matches
Mail list logo
