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
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
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
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
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 ichaud...@gmail.com wrote:
I have 7 days worth of general log data totalling 4.4GB.
I want to analyze this data to get:
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
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 brentgclarkl...@gmail.com wrote:
Hiya
I tried getting the following command running from the following youtube
clip.
http://www.mysqlperformanceblog.com/2008/11/07/poor-mans-query-logging/
On Tue, Apr 20, 2010 at 7:19 PM, Keith Murphy bmur...@paragon-cs.comwrote:
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
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 jlyons4...@gmail.com 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
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
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
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
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 cars...@bitbybit.dkwrote:
Carsten Pedersen skrev:
Jim Lyons skrev:
Has anyone tried using
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
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
On Tue, Apr 20, 2010 at 11:03 AM, Gavin Towey gto...@ffn.com 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
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
of virus signature
database 5045 (20100420) __
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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
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;
//td';
}
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 was checked by ESET NOD32
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..
?
Thanks for your help.
Gary
__ Information from ESET NOD32 Antivirus, version of virus signature
database 5045 (20100420) __
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
--
MySQL General Mailing List
For list archives: http
23 matches
Mail list logo