How does the below not guarantee me 100% that everything that can be
consistent, is ?
mysql> flush tables with read lock;
unixhost# sync
unixhost# lvm create snapshot
mysql> unlock tables;
I agree that there may be data inconsistencies within MyISAM, as it has no
transactions, but there's also no
Gavin,
Right,
that is also an option, but you are really not sure 100% that everything
that is on memory is on the disk (buffers etc...)
also if it is definitely good for a disaster recovery.
What I meant is that the only way to have a 100% guaranteed consistent
binary backup is when the databa
is_file($row['image_file'])) {
> echo ' height="100px"/>';
> }
>
> As a bonus question, does anyone have any idea why the image would show up
> in IE9, and not FF?
>
> Thanks for your help.
>
> Gary
>
Version 2.8 of VTD-XML, the next generation XML parsing/indexing/Xpath lib, has
been released. Please visit https://sourceforge.net/projects/vtd-xml/files/ to
download the latest version.
a.. Expansion of Core VTD-XML API
a.. VTDGen adds support for capturing white spaces
b.. VTDNa
_file'])) {
echo '';
}
As a bonus question, does anyone have any idea why the image would show up
in IE9, and not FF?
Thanks for your help.
Gary
__ Information from ESET NOD32 Antivirus, version of virus signature
database 5045 (20100420) __
The message
You can make binary backups from the master using filesystem snapshots. You
only need to hold a global read lock for a split second.
Regards,
Gavin Towey
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: Tuesday, April 20, 2010 1:19 PM
To: Gavin Towey
Cc: andrew.2.mo...@nokia.com; li..
Hi there,
I would like to find out the maximum (signed or unsigned) integer from MySQL.
SELECT CAST( POW(2,100) as UNSIGNED) as max_int;
# max_int | 9223372036854775808
This seems to be a MAX_BIGINT from the lookup table at
http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html
Is there a wa
;' . $row['description'] . '';
if (is_file($row['image_file'])) {
echo 'height="100px"/>';
}
As a bonus question, does anyone have any idea why the image would show up
in IE9, and not FF?
Thanks for your help.
Gary
Where is Falcon (Sorry)
the only way to have a really consistent binary backup is to shut down the
server.
the best way to shut down a server is to have a slave dedicated to backups
that you can shutdown any time.
if you have only the content of the database folders under [datadir] it is
not
On Tue, Apr 20, 2010 at 11:03 AM, Gavin Towey wrote:
> More good ideas from Andrew!
>
> Just a note though, I noticed someone added replication to a slave as a
> backup option. I really discourage that. Replication makes no guarantees
> that the data on your slave is the same as the data on yo
More good ideas from Andrew!
Just a note though, I noticed someone added replication to a slave as a backup
option. I really discourage that. Replication makes no guarantees that the
data on your slave is the same as the data on your master. Unless you're also
checking consistency, a slave s
> Minor correction: The post i point to is about the slow log, but I presume
> also relevant for the general log. And the good comments I mentioned come in
> the followup posting at http://www.bitbybit.dk/carsten/blog/?p=116
>
> / Carsten
Thanks Carsten, I read the comments and Sheeri mentions mys
Well, first thing I'd do, is symlink the log table files onto a separate set
of spindles. No use bogging the main data spindles down with logwrites.
On Tue, Apr 20, 2010 at 5:33 PM, Carsten Pedersen wrote:
> Carsten Pedersen skrev:
>
> Jim Lyons skrev:
>>
>>> Has anyone tried using the log_out
Carsten Pedersen skrev:
Jim Lyons skrev:
Has anyone tried using the log_output option in mysql 5.1 to have the
general log put into a table and not a flat file? I used it for a while
before having to downgrade back to 5.0 but thought it was a great
idea. I'm
curious to see if anyone feels it
Jim Lyons skrev:
Has anyone tried using the log_output option in mysql 5.1 to have the
general log put into a table and not a flat file? I used it for a while
before having to downgrade back to 5.0 but thought it was a great idea. I'm
curious to see if anyone feels it helps analysis.
I tried
Hello List,
I am kind of novice to MySQL
I am using MySQL 5.1.44 with partitioning.
I have a table with daily partitions. Master table and child tables are in
innodb engine.
Few days before I have created partition for april month from 1st to 30th.
Everything was working properly till today
Hi Imran,
you can have a look at mysqldumpslow utility to analyze the data..
Thanks
Anand
On Tue, Apr 20, 2010 at 5:48 PM, Jim Lyons wrote:
> Has anyone tried using the log_output option in mysql 5.1 to have the
> general log put into a table and not a flat file? I used it for a while
> befor
http://www.mysqlperformanceblog.com/2008/11/07/poor-mans-query-logging/
On Tue, Apr 20, 2010 at 7:19 PM, Keith Murphy wrote:
> You should look at www.hackmysql.com. He has a sniffed program strictly
> for
> Mysql. Should do what you want.
>
> HTH
>
> Keith
>
> On Apr 20, 2010 5:48 AM, "Brent Clar
You should look at www.hackmysql.com. He has a sniffed program strictly for
Mysql. Should do what you want.
HTH
Keith
On Apr 20, 2010 5:48 AM, "Brent Clark" wrote:
Hiya
I tried getting the following command running from the following youtube
clip.
http://www.youtube.com/watch?v=Zofzid6xIZ4
L
Has anyone tried using the log_output option in mysql 5.1 to have the
general log put into a table and not a flat file? I used it for a while
before having to downgrade back to 5.0 but thought it was a great idea. I'm
curious to see if anyone feels it helps analysis.
On Tue, Apr 20, 2010 at 6:02
Maybe one of the maatkit tools will do it, but I tend to graph that kind of
data live in Munin from the internal counters.
On Tue, Apr 20, 2010 at 1:02 PM, Imran Chaudhry wrote:
> I have 7 days worth of general log data totalling 4.4GB.
>
> I want to analyze this data to get:
>
> a) queries per
I have 7 days worth of general log data totalling 4.4GB.
I want to analyze this data to get:
a) queries per second, minute, hour and day
b) a count of the number of selects versus write statements (delete,
insert, replace and update)
c) a variation of the above with "select, replace, delete and i
Hiya
I tried getting the following command running from the following youtube
clip.
http://www.youtube.com/watch?v=Zofzid6xIZ4
Look at 19:25
I know I can use tcpdump, with maatkit (Im not always able to install
maatkit on clients machines). But based on whats above in the clip, Did
Mr Calla
I would also recommend looking into some 3rd party tools.
http://www.percona.com/docs/wiki/percona-xtrabackup:start - Backup Innodb,
MyISAM and XtraDB engines.
http://www.maatkit.org/ - Packed with useful features inc a parallel
dump/import.
There's some great features in both products. I will
Gavin Towey wrote:
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
25 matches
Mail list logo
