Re: Analysis of a weeks worth of general log

> 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

Analysis of a weeks worth of general log

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

Replication breakage when Heartbeat Failover occurs

ng by dumping the master databases again, re-import to the slave hosts and bootstrap the slaves. What is the best way to make this consistent and ensure that replication continues smoothly after a failover (and failback) event? Thank you, Imran Chaudhry -- MySQL General Mailing List For list a

Re: Interesting SQL Query - Total and Grouped Counts together?

;, 1, 0)) AS 'count image' FROM tableA GROUP BY domain ORDER BY domain Thanks again, Imran Chaudhry -- Atom Database A Custom Database Designed for Your Business [EMAIL PROTECTED] http://atomdatabase.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

Interesting SQL Query - Total and Grouped Counts together?

I'm wondering if any of you can assist with an interesing SQL query. I have a single table within a database, the relevant fields of which are defined as: CREATE TABLE tableA ( domain text, mime text ); Where "domain" is a domain, such as: go

RE: Error: Duplicate entry 'xxxx-L' for key 6

Key 6 relates to the 6th key, or index, in the CREATE TABLE statement for this table: >> PRIMARY KEY (`prod_id`), >> UNIQUE KEY `prod_no` (`prod_no`), >> KEY `products_index1` (`prod_status`), >> KEY `products_index2` (`prod_start_date`,`prod_end_date`), >> KEY `on_sale` (`on_sale`),

Best way to Relational Model a "Score"

e score is a count and subcategory, then type=2 and time is NULL. I want to aim for 3NF and this seems ugly solution, there must be an elegant way to do this? Thanks, Imran Chaudhry -- http://www.atomdatabase.com MySQL Database Management & Design Services -- MySQL General Mailing List For li

LIMIT behavior in Stored Procedure

Noord-Holland | 731200 | +++-+---++ 5 rows in set (0.00 sec) Not sure how useful that is. Maybe it is useful if one is frequently querying a certain table when working on the command line? Imran Chaudhry -- http://www.atomdatabase.com MySQL Database Ma

Re: mysqlhotcopy

Good stuff Peter, can you tell us your solution so folks can benefit from your efforts? (I expect the regex has to be POSIX style such as: mydb./'~(expirations|rtt)'/ right?) Imran Chaudhry -- http://www.ImranChaudhry.info MySQL Database Management & Design Services -- MySQL G

Re: Installation Issue

se is that /var/lib/mysql is not owned by mysql If so, as superuser: chown -R mysql:mysql /var/lib/mysql Regards, Imran Chaudhry -- http://www.ImranChaudhry.info MySQL Database Management & Design Services -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To u

Re: MySQL PDA Synch

> Thoughts, comments and advice very appreciated Adrian, just in case your question is out of scope for this crowd... MySQL have a number of forums and one is 'Embedded MySQL' http://forums.mysql.com/list.php?58 Hope that helps, Imran Chaudhry -- http://www.ImranChaudhry.info M

Re: data entry GUI

On 2/1/06, THUFIR HAWAT <[EMAIL PROTECTED]> wrote: > Just as there's MySQL Query Browser for queries and table design, is > there a similar GUI front end for data entry? I'm not building > anything complex, just a simple database to muck with. Is it easier > to do data entry on a spreadsheet, the

Re: Insert performance

> I am using mysql5.0 on Hp-UX. IT took about 14 hours to insert 1.7 millin > records. How do I make >my insert run faster.The table has three foreign key > references and the referencing columns are >indexed . Is that impacting the > insert statement performance. Just thought I'd add a little

Re: Sudden Mysql Crashes - table damage?

On 1/31/06, Adrian Bruce <[EMAIL PROTECTED]> wrote: > HI > > MySQL 5.0 (windows XP) > > I have a problem where i think some of my tables have somehow been > corrupted, if i try to run a check table command against some tables the > mysql service crashes and i have to restart it. I am not sure how

Re: How NOT to log SHOW INNODB STATUS in the query log.

> Hi; > My query.log is full of 'show innodb status' queries. > How do I get this ascii log file not to log these. OR some help with a > grep script to copy the file without these lines. I noticed the same in the logs of a 4.1 test server. I put it down to MySQL Administrator which was monitoring

Fwd: mysql-plain Digest 24 Jan 2006 10:16:15 -0000 Issue 3629

> My web hosting server runs PHP 4.4 and MySQL 4.1. But > PHP 4.4 doesn't fully support MySQL 4.1. and i have > problems restoring a utf8 encoded database dumped from > a MySQL 4.0 server to the new 4.1 server. Do i have > any chance to get it working in this setup or should i > persuade the hostin

RE: Lost Connection executing query

same database (non-replicated). I would recommend trying the re-index tactic there first if you havne't already. Hope that Helps, Imran Chaudhry -- http://www.EjectDisc.com Get your Digital Identity - Domain Names, Web Space, E-mail & More! -- MySQL General Mailing List For list

Re: logging issue

tabase? How you tried invoking the MailScanner connection at different times of the day? What interface does MailScanner use to connect? It looks like Perl DBI, but you may be using ODBC? Finally, can you tell me your perl version by: perl -v Imran Chaudhry -- http://www.EjectDisc.com Get your D

Re: need to upgrade

ql.com/doc/refman/4.1/en/upgrading-from-3-23.html I think you'll find the upgrade pretty painless from a data point of view, but you will need to heed the changes to the GRANT tables. Imran Chaudhry -- http://www.EjectDisc.com Get your Digital Identity - Domain Names, Web Space, E-mail &a

Re: REVOKE GRANT OPTION - is that possible?

USER is the ticket). Final thing, as you're a MySQL admin type writing an access control app, you want to know when the priv changes take effect. You will probably find this info useful: http://dev.mysql.com/doc/refman/5.0/en/privilege-changes.html Hope that helps, Imran Chaudhry -- http://ww

Re: REVOKE GRANT OPTION - is that possible?

ential for error and you dont want that where security is related. It is probably worth the "pain" of learning the ins and outs of GRANT/REVOKE. Hope that Helps, Imran Chaudhry -- http://www.EjectDisc.com Get your Digital Identity - Domain Names, Web Space, E-mail & More! -- My

Re: installed modules

, a way is: perl -M -e '' (where module name is perlish name like DBI or XML::Simple) It should return silently without errors if it is installed. Hope that helps, Imran Chaudhry -- http://www.EjectDisc.com Get your Digital Identity - Domain Names, Web Space, E-mail & More! -- My

Re: install trouble, perl DBI

Lewis, As you already have perl installed, an easier way of getting modules is by way of CPAN (www.cpan.org). Give this a try, as superuser: cpan install DBI Regards, Imran -- http://www.EjectDisc.com Get your Digital Identity - Domain Names, Web Space, E-mail & More! -- MySQL General Mailing L