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

ile (mysql.log) even with memory_limit in php.ini set to 1024MB [2] -rw-r- 1 imran imran 268M 2010-04-19 13:03 mysql.log -rw-r- 1 imran imran 721M 2010-04-19 12:56 mysql.log.1 -rw-r- 1 imran imran 737M 2010-04-19 13:05 mysql.log.2 -rw-r- 1 imran imran 554M 2010-04-19 13:06 mysql.log.3 -rw-

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

[RFH] Full Text search

[EMAIL PROTECTED] */; /*!40101 SET [EMAIL PROTECTED] */; /*!40101 SET [EMAIL PROTECTED] */; /*!40101 SET [EMAIL PROTECTED] */; /*!40111 SET [EMAIL PROTECTED] */; -- Dump completed on 2008-02-27 5:41:23 Thank you, -- Imran M Yousuf Entrepreneur & Software Engineer Smart IT Engineering Dhaka, Bangladesh Email: [EMAIL PROTECTED] Mobile: +880-1711402557

Help with this query

Hi: I have a table that I need help to summarize the data. I need to be able to create one row of data for custno + prodno + period + weekno combination summarized by Invtot. Any help will be greatly appreciated. Best regards I am attaching the relevant info below: Sales

Need help with a sql query

Hello all: I have two tables: 1. MenuAccess: accessId fkMenuId fkGroupid View Execute 2. MenuOptions MenuId MenuName I would like to get all of the records in MenuOptions and any record in MenuAccess with a specific fkGroupid. For example: A. MenuAccess AccessId

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

up a Perl program to create the data automatically. I would then use LOAD DATA INFILE statement or mysqlimport to get the data into my tables. These methods are extremely quick for inserts and will disable key updating etc. Regards, Imran -- http://www.ImranChaudhry.info MySQL Database Management & D

Re: Insert performance

t I'd add a little to the good advice already given to you. I find an easy way to derive the extended insert syntax is to perform a mysqldump of a small table. >From 4.1 onwards this wrapped the table dump in the extended insert syntax. Regards, Imran -- http://www.ImranChaudhry.info

Re: Sudden Mysql Crashes - table damage?

data and .frm files (use BACKUP TABLE) or a mysqldump before starting any repair procedure. Regards, Imran -- http://www.ImranChaudhry.info MySQL Database Management & Design Services -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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

Help in joining three tables

result set by CustNo and Branch. Best regards Imran. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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 Mai

Thank you ... Help on writing a sql statement

up the good work. Best regards Imran Solution --- Let me see if I can translate what you want in a query into regular language. I think you would like to see, grouped by date, customer, and product, the total cost and total

Re: Help on writing a sql statement

x27; where =schema name. In additon, THANK you for taking the time to clarify the confusion about connections .. you are a wealth of information. best regards Imran - Original Message - From: <[EMAIL PROTECTED]> To: "Imran" <[EMAIL PROTECTED]> Cc: Sent: Tuesd

Re: Help on writing a sql statement

) ... Since I am creating a temp table, will the temp table creation fail for subsequent users prior to the drop i.e. the table will exist already exist best regards Imran. - Original Message - From: <[EMAIL PROTECTED]> To: "Imran" <[EMAIL PROTECTED]> Cc: Sent: Tuesd

Re: Help on writing a sql statement

l Message ----- From: <[EMAIL PROTECTED]> To: "Imran" <[EMAIL PROTECTED]> Cc: Sent: Monday, October 10, 2005 4:17 PM Subject: Re: Help on writing a sql statement > "Imran" <[EMAIL PROTECTED]> wrote on 10/10/2005 03:52:21 PM: > > > Hi all: > > I

Help on writing a sql statement

Hi all: I need some help in writing a sql statement. I have three tables (Sales, Cust and Product). The sales table contains a large volume of data and I want to create a sql to group the sales table then join the resultant to both the Cust and Prod and to have additional fields selected fr

Segmentation fault while executing Mysql application.

23.54-11 package which install during linux installation. So, these were fact and figure which being happen in developing application. Kindly, suggest me. I 'll be very greatful to you. IMRAN SHABBIR Software Engineer Vibrant Wits Software Inc. Pakistan -- MySQL General Mailin

Problem with source distribution in installation

Most respectfully, I would like to get support regarding my problem. Description: I have installed Linux RedHat 9 (Shrike) now i am going to install Mysql-3.23.54a in Linux by compiling source code of respective package which has been downloaded from this site http://downloads.mysql.com/archives.

Re: FULL Text Limitation issue!

Thank you very much Paul and Keith for your response , I guess I will have to use LIKE clause in SQL statement for searching the records then. Imran - Original Message - From: "Keith C. Ivey" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Imran Aziz" &

FULL Text Limitation issue!

Server or am I doing something wrong , can anyone please help me with this and let me know how to alter the limit of the input phrase for FULL TEXT search. Imran.

Imran Javed/Kamino is out of the office.

I will be out of the office starting 21/08/2003 and will not return until 08/09/2003. I will respond to your message when I return. If you have any urgent queries please contact Stuart Mclean == Disclaimer Notice This messa

import CSV

can any one help is there a way where i can import a csv file into multiple tables in MySQL database this has to be a run when ever there is a file in a wating directory thanks in advance == Disclaimer Notice This message

mysqladmin access denied error

Hi, I'm using solaris 8 with mysql v 3.23.54. I want to enable a solaris user - 'user1', to use the mysqlimport command without using a password. I've run, as root, the following sql command: mysql>grant all on db1.* to user1@localhost -this appears to work fine. However as user1 in the solari

mysqlimport access denied errors

Hi, I'm working on SOlaris 8 with MySQL v3.23.54. I'm trying to give a user 'user1' access to one of my databases 'db1', and specifically one table 'table1'. As root I've run: msql> grant all on db1 to user1@localhost -and it appears to work fine. However when as the solaris user 'user1', I ru

Can't access MySQL via PHP

cript! I got 'Access Denied' Error. I've tried MySQL grant commands e.g. Grant ALL PRIVILEGES ON mydb.* TO imran@%; (replaced % with my hostname etc. too) command is executed properly. Here is the PHP script: include("passwords.php"); $openConn2db =

Back up procedure for Mysql

Sir, As i am using mysql on my linux server and want to shift it to other linux box, so regarding this matter i want the information regarding this and how to go forword in this situation. thank you Imran Get free email