Re: the way to get more info in logs

[Claudio Nanni]

seems like there is a problem of consistency of innodb data and recovery
does not go well.
try to take a look at innodb status:

>show engine innodb status

http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting.html
http://dev.mysql.com/doc/refman/5.0/en/innodb-monitors.html

Cheers

Claudio



2009/4/17 Mihail Vetchinov 

> Anybody can tell me about way which will force the mysqld write more
> information into logs (.err file)?
>
> My mysqld restarted every 20-30 minutes without reasonable info in log file
> and I dont understand why it occurs.
>
> I see only string "mysqld restarted" and nothing more! :(
>
> Example of log:
>
> 090417 16:34:14  InnoDB: Started; log sequence number 0 73771
> 090417 16:34:14 [Note] /usr/local/libexec/mysqld: ready for connections.
> Version: '5.0.77-log'  socket: '/tmp/mysql.sock'  port: 3306  FreeBSD port:
> mysql-server-5.0.77_1
> 090417 16:34:14 [Note] Slave SQL thread initialized, starting replication
> in log 'mysql-bin.000576' at position 530085643, relay log
> './beta23-relay-bin.000174' position: 93504
> 090417 16:34:14 [Note] Slave I/O thread: connected to master '
> bet...@beta27.rambler.ru:3306',  replication started in log
> 'mysql-bin.000576' at position 530085643
> 090417 16:39:38  mysqld restarted
> InnoDB: The log sequence number in ibdata files does not match
> InnoDB: the log sequence number in the ib_logfiles!
> 090417 16:39:39  InnoDB: Database was not shut down normally!
> InnoDB: Starting crash recovery.
> InnoDB: Reading tablespace information from the .ibd files...
> InnoDB: Restoring possible half-written data pages from the doublewrite
> InnoDB: buffer...
> 090417 16:39:39  InnoDB: Started; log sequence number 0 73781
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com
>
>

the way to get more info in logs

[Mihail Vetchinov]

Anybody can tell me about way which will force the mysqld write more 
information into logs (.err file)?


My mysqld restarted every 20-30 minutes without reasonable info in log 
file and I dont understand why it occurs.


I see only string "mysqld restarted" and nothing more! :(

Example of log:

090417 16:34:14  InnoDB: Started; log sequence number 0 73771
090417 16:34:14 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.0.77-log'  socket: '/tmp/mysql.sock'  port: 3306  FreeBSD 
port: mysql-server-5.0.77_1
090417 16:34:14 [Note] Slave SQL thread initialized, starting 
replication in log 'mysql-bin.000576' at position 530085643, relay log 
'./beta23-relay-bin.000174' position: 93504
090417 16:34:14 [Note] Slave I/O thread: connected to master 
'bet...@beta27.rambler.ru:3306',  replication started in log 
'mysql-bin.000576' at position 530085643

090417 16:39:38  mysqld restarted
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
090417 16:39:39  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090417 16:39:39  InnoDB: Started; log sequence number 0 73781


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Getting more info from "show full processlist"

[Jim Lyons]

One way to do it (maybe the only way for selects) is to use the general
log.  The Id number, 30399, is the thread id.  You can look up the thread id
in the general log and see the entire command.  But you have to have the
general log running.

If the command changes data (update, delete, insert) then it'll be in the
bin log with the thread id.  If you know what time the command was executed,
you can use the --start-datetime option of mysqlbinlog.  But only the
general log keeps selects.


On Mon, Oct 6, 2008 at 10:38 AM, MaBa.listas <[EMAIL PROTECTED]>wrote:

> Hello,
>reading the MySQL documentation I've run into the " show full
> processlist\G" command. In my case I've got an output similar to this:
>
>
> -
> mysql> show full processlist\G
> *** 1. row ***
> Id: 30127
> User: root
> Host: localhost
> db: NULL
> Command: Query
> Time: 0
> State: NULL
> Info: show full processlist
> *** 2. row ***
> Id: 30399
> User: root
> Host: localhost
> db: this would be my DB
> Command: Sleep
> Time: 0
> State:
> Info: NULL
>
> -----
>
>What I'd like to know is how to get more info about the query
> identified with 30399 (in this example). I mean, the exact query, like
> "SELECT pr1, pr2 FROM someDB".
>
> Thanks
>
> Matias
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>


-- 
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com

Re: Getting more info from "show full processlist"

[Moon's Father]

I also want to know the answer to this question.If it's for me.I'll scan all
the source code manually.But it's too complicated.

On Tue, Oct 7, 2008 at 1:02 AM, Olaf Stein <
[EMAIL PROTECTED]> wrote:

> It specifies the query in the Info field.
> In your case the connection is "sleeping", nothing is being executed at the
> moment, therefore info is NULL
>
>
>
> Olaf
>
>
> On 10/6/08 11:38 AM, "MaBa.listas" <[EMAIL PROTECTED]> wrote:
>
> > Hello,
> > reading the MySQL documentation I've run into the " show full
> > processlist\G" command. In my case I've got an output similar to this:
> >
> >
> --
> > ---
> > mysql> show full processlist\G
> > *** 1. row ***
> > Id: 30127
> > User: root
> > Host: localhost
> > db: NULL
> > Command: Query
> > Time: 0
> > State: NULL
> > Info: show full processlist
> > *** 2. row ***
> > Id: 30399
> > User: root
> > Host: localhost
> > db: this would be my DB
> > Command: Sleep
> > Time: 0
> > State:
> > Info: NULL
> >
> --
> > ---
> >
> > What I'd like to know is how to get more info about the query
> > identified with 30399 (in this example). I mean, the exact query, like
> > "SELECT pr1, pr2 FROM someDB".
> >
> > Thanks
> >
> > Matias
>
>
> - Confidentiality Notice:
> The following mail message, including any attachments, is for the
> sole use of the intended recipient(s) and may contain confidential
> and privileged information. The recipient is responsible to
> maintain the confidentiality of this information and to use the
> information only for authorized purposes. If you are not the
> intended recipient (or authorized to receive information for the
> intended recipient), you are hereby notified that any review, use,
> disclosure, distribution, copying, printing, or action taken in
> reliance on the contents of this e-mail is strictly prohibited. If
> you have received this communication in error, please notify us
> immediately by reply e-mail and destroy all copies of the original
> message. Thank you.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>


-- 
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn

Re: Getting more info from "show full processlist"

[Olaf Stein]

It specifies the query in the Info field.
In your case the connection is "sleeping", nothing is being executed at the
moment, therefore info is NULL



Olaf


On 10/6/08 11:38 AM, "MaBa.listas" <[EMAIL PROTECTED]> wrote:

> Hello,
> reading the MySQL documentation I've run into the " show full
> processlist\G" command. In my case I've got an output similar to this:
> 
> --
> ---
> mysql> show full processlist\G
> *** 1. row ***
> Id: 30127
> User: root
> Host: localhost
> db: NULL
> Command: Query
> Time: 0
> State: NULL
> Info: show full processlist
> *** 2. row ***
> Id: 30399
> User: root
> Host: localhost
> db: this would be my DB
> Command: Sleep
> Time: 0
> State:
> Info: NULL
> ------
> ---
> 
> What I'd like to know is how to get more info about the query
> identified with 30399 (in this example). I mean, the exact query, like
> "SELECT pr1, pr2 FROM someDB".
> 
> Thanks
> 
> Matias


- Confidentiality Notice:
The following mail message, including any attachments, is for the
sole use of the intended recipient(s) and may contain confidential
and privileged information. The recipient is responsible to
maintain the confidentiality of this information and to use the
information only for authorized purposes. If you are not the
intended recipient (or authorized to receive information for the
intended recipient), you are hereby notified that any review, use,
disclosure, distribution, copying, printing, or action taken in
reliance on the contents of this e-mail is strictly prohibited. If
you have received this communication in error, please notify us
immediately by reply e-mail and destroy all copies of the original
message. Thank you.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Getting more info from "show full processlist"

[MaBa.listas]

Hello,
reading the MySQL documentation I've run into the " show full
processlist\G" command. In my case I've got an output similar to this:

-
mysql> show full processlist\G
*** 1. row ***
Id: 30127
User: root
Host: localhost
db: NULL
Command: Query
Time: 0
State: NULL
Info: show full processlist
*** 2. row ***
Id: 30399
User: root
Host: localhost
db: this would be my DB
Command: Sleep
Time: 0
State:
Info: NULL
-

What I'd like to know is how to get more info about the query
identified with 30399 (in this example). I mean, the exact query, like
"SELECT pr1, pr2 FROM someDB".

Thanks

Matias

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: More info about 40001 SQL_NO_CACHE

[Logg, Connie A.]

Thank you...All I was doing was a musqldump of the tables in my data base to 
files, one file for each table. Yesterday I upgraded to mysql 5.0.27, so I will 
watch it for a while. It just started happening last Saturday night, and I had 
been running the system for a few months.  
 
Thanks for you response.
Connie Logg, Network Analyst
Stanford Linear Accelerator Center
ph: 650-926-2879
"Happiness is found along the way, not at the end of the road, and 'IF' is the 
middle word in life."





From: Howard Hart [mailto:[EMAIL PROTECTED] 
Sent: Thursday, November 16, 2006 8:41 AM
To: Logg, Connie A.
Subject: RE: More info about 40001 SQL_NO_CACHE



Looks like this may have been fixed in 5.0.25 or above, so if it's the same 
bug, you're good to go.

http://bugs.mysql.com/bug.php?id=21288

Howard


-Original Message-
From: Logg, Connie A. [mailto:[EMAIL PROTECTED]
Sent: Wed 11/15/2006 8:18 PM
To: mysql@lists.mysql.com
Subject: More info about 40001 SQL_NO_CACHE

 This showed up in 'show processlist' and it had had an active time of about 4 
days.  Numerous other inquiries were hung behind it, although the other 
inquiries completed eventually...but they were so slow as to backup the data 
base entry code and extraditions for the analysis by several hours.

Can someone please enlightn me on this problem? Like I mentioned, the web 
search entries indicated that this hanging was a mysql problem.

I have upgraded to 5.0.27. But I will not know until tomorrow if the mysqldump 
that I do tonight works.

-Original Message-
From: Logg, Connie A. [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 15, 2006 11:41 AM
To: mysql@lists.mysql.com
Subject: SELECT /*!40001 SQL_NO_CACHE */ * FROM `ROUTEDATA` message

I am running mysql version 5.0.24 and am seeing this error when running 
mysqldump.

>From what I can find on the web, this message is generated by an error in the 
>mysql code.
Please correct me if I am wrong.

Is this fixed in mysql 5.0.27 ?

Thanks,
Connie Logg, Network Analyst
Stanford Linear Accelerator Center
ph: 650-926-2879
"Happiness is found along the way, not at the end of the road, and 'IF' is the 
middle word in life."

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: More info about 40001 SQL_NO_CACHE

[Rolando Edwards]

The only time I ever saw a message just hang out in the processlist like that
is when I ran a mysqldump and piped it directly to mysql to load data directly
from one MySQL server to another. While doing this, the target MySQL system
ran out of room on the mounted drive where the datadir was pointing.

So the message you seeing I also saw from the source machine.

MySQL is a little polite in this matter. I just pauses and waits until
there is more room on the available target's datadir to continue
send more data to the target.

>From what you described, you problem sounds very simple yet complicated.

Try to find out what software issued that SQL statement and its intended target.

- Original Message -
From: Connie A. Logg <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Sent: Wednesday, November 15, 2006 11:18:31 PM GMT-0500 US/Eastern
Subject: More info about 40001 SQL_NO_CACHE

 This showed up in 'show processlist' and it had had an active time of about 4 
days.  Numerous other inquiries were hung behind it, although the other 
inquiries completed eventually...but they were so slow as to backup the data 
base entry code and extraditions for the analysis by several hours.

Can someone please enlightn me on this problem? Like I mentioned, the web 
search entries indicated that this hanging was a mysql problem. 

I have upgraded to 5.0.27. But I will not know until tomorrow if the mysqldump 
that I do tonight works.

-Original Message-
From: Logg, Connie A. [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 15, 2006 11:41 AM
To: mysql@lists.mysql.com
Subject: SELECT /*!40001 SQL_NO_CACHE */ * FROM `ROUTEDATA` message

I am running mysql version 5.0.24 and am seeing this error when running 
mysqldump.

>From what I can find on the web, this message is generated by an error in the 
>mysql code.
Please correct me if I am wrong.

Is this fixed in mysql 5.0.27 ?

Thanks,
Connie Logg, Network Analyst
Stanford Linear Accelerator Center
ph: 650-926-2879
"Happiness is found along the way, not at the end of the road, and 'IF' is the 
middle word in life."

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

More info about 40001 SQL_NO_CACHE

[Logg, Connie A.]

 This showed up in 'show processlist' and it had had an active time of about 4 
days.  Numerous other inquiries were hung behind it, although the other 
inquiries completed eventually...but they were so slow as to backup the data 
base entry code and extraditions for the analysis by several hours.

Can someone please enlightn me on this problem? Like I mentioned, the web 
search entries indicated that this hanging was a mysql problem. 

I have upgraded to 5.0.27. But I will not know until tomorrow if the mysqldump 
that I do tonight works.

-Original Message-
From: Logg, Connie A. [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 15, 2006 11:41 AM
To: mysql@lists.mysql.com
Subject: SELECT /*!40001 SQL_NO_CACHE */ * FROM `ROUTEDATA` message

I am running mysql version 5.0.24 and am seeing this error when running 
mysqldump.

>From what I can find on the web, this message is generated by an error in the 
>mysql code.
Please correct me if I am wrong.

Is this fixed in mysql 5.0.27 ?

Thanks,
Connie Logg, Network Analyst
Stanford Linear Accelerator Center
ph: 650-926-2879
"Happiness is found along the way, not at the end of the road, and 'IF' is the 
middle word in life."

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

re: would like more info on INSERT ... VALUES

[SGreen]

James Black <[EMAIL PROTECTED]> wrote on 12/08/2005 01:07:15 PM:

> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
> 
> In the manual (http://dev.mysql.com/doc/refman/5.0/en/insert.html) I saw
> this snippet: If you use an INSERT ... VALUES statement with multiple
> value lists
> 
> But, I thnk I am missing some information on the syntax of INSERT ...
> VALUES.
> 
> This may be what I am looking for, as I want to see if sending 100
> inserts at one time is faster than doing 100 inserts, one at a time. I
> expect it is, but I would like to get some numbers for my query.
> 
> Thank you for any help.
> 
> - --
> "Love is mutual self-giving that ends in self-recovery." Fulton Sheen
> James Black[EMAIL PROTECTED]
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v1.4.1 (MingW32)
> Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
> 
> iD8DBQFDmHZTikQgpVn8xrARAnFKAJ9Co+SEny8Xl3q/NaHW528qv+JawwCeOjgj
> jCma5KTtC6w7f51LnmgECHY=
> =HIjc
> -END PGP SIGNATURE-
> 
> -- 

You want to look at the first syntax definition:

INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE]
[INTO] tbl_name [(col_name,...)]
VALUES ({expr | DEFAULT},...),(...),...
[ ON DUPLICATE KEY UPDATE col_name=expr, ... ]

You enclose each set of values in their own set of parentheses and 
separate the sets with commas.

If you have a table (tbl1) with 3 fields (fld1, fld2, and fld3) and you 
wanted to insert the following sets of values:

1,1,'red'
1,1,'blue'
1,2,'red'
1,2,'green'
10,15,'violet'

The INSERT statement would look like this:

INSERT tbl1 (fld1, fld2, fld3) VALUES 
(1,1,'red'),(1,1,'blue'),(1,2,'red'),(1,2,'green'),(10,15,'violet');

HTH!
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

Re: would like more info on INSERT ... VALUES

[sheeri kritzer]

Hi James,

INSERT INTO table (a,b,c) VALUES (1,2,3),(4,5,6);

is an example of inserting multiple rows with one insert statement,
instead of these 2:

INSERT INTO table (a,b,c) VALUES (1,2,3);
INSERT INTO table (a,b,c) VALUES (4,5,6);

That should give you enough to work with.

-Sheeri

On 12/8/05, James Black <[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> In the manual (http://dev.mysql.com/doc/refman/5.0/en/insert.html) I saw
> this snippet: If you use an INSERT ... VALUES statement with multiple
> value lists
>
> But, I thnk I am missing some information on the syntax of INSERT ...
> VALUES.
>
> This may be what I am looking for, as I want to see if sending 100
> inserts at one time is faster than doing 100 inserts, one at a time. I
> expect it is, but I would like to get some numbers for my query.
>
> Thank you for any help.
>
> - --
> "Love is mutual self-giving that ends in self-recovery." Fulton Sheen
> James Black[EMAIL PROTECTED]
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v1.4.1 (MingW32)
> Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
>
> iD8DBQFDmHZTikQgpVn8xrARAnFKAJ9Co+SEny8Xl3q/NaHW528qv+JawwCeOjgj
> jCma5KTtC6w7f51LnmgECHY=
> =HIjc
> -END PGP SIGNATURE-
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

re: would like more info on INSERT ... VALUES

[James Black]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

In the manual (http://dev.mysql.com/doc/refman/5.0/en/insert.html) I saw
this snippet: If you use an INSERT ... VALUES statement with multiple
value lists

But, I thnk I am missing some information on the syntax of INSERT ...
VALUES.

This may be what I am looking for, as I want to see if sending 100
inserts at one time is faster than doing 100 inserts, one at a time. I
expect it is, but I would like to get some numbers for my query.

Thank you for any help.

- --
"Love is mutual self-giving that ends in self-recovery." Fulton Sheen
James Black[EMAIL PROTECTED]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFDmHZTikQgpVn8xrARAnFKAJ9Co+SEny8Xl3q/NaHW528qv+JawwCeOjgj
jCma5KTtC6w7f51LnmgECHY=
=HIjc
-END PGP SIGNATURE-

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Mysql compile error - more info

[Ryan Stille]

I thought I would get around the whole thing by just installing the RPM
instead of compiling.  So I downloaded MySQL-devel-4.1.14-0.i386.rpm and
installed it.  Then I went to install the DBD-mysql module and got this
error during the compile:

/usr/bin/ld: cannot find -lz
collect2: ld returned 1 exit status

An error occurred while linking the DBD::mysql driver. The error
message seems to indicate that you don't have a libz.a,
or a libz.so. This is typically resolved by:

1.) You may try to remove the -lz or -lgz flag from the libs list
by using the --libs switch for "perl Makefile.PL".
2.) On Red Hat Linux install libz-devel
3.) On other systems, please contact the mailing list

 [EMAIL PROTECTED]

For further hints, see INSTALL.html, section Linker flags.
make: *** [blib/arch/auto/DBD/mysql/mysql.so] Error 1 


So I figured out how to run mysql_config --libs and get that value, then
put it on the perl Makefile.PL line without the -lz:
perl Makefile.PL --libs="-L/usr/lib/mysql [the -lz was right here]
-lmysqlclient -lcrypt -lnsl -lm -lc -lnss_files -lnss_dns -lresolv -lc
-lnss_files -lnss_dns -lresolv"

Then I was able to compile without error.  So I installed the driver.
But when I try to use it to connect to mysql I get this error:

install_driver(mysql) failed: Can't load
'/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/mysql/mysql.so' for
module DBD::mysql:
/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/mysql/mysql.so:
undefined symbol: compress at
/usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169.

 at (eval 1) line 3
Perhaps a required shared library or dll isn't installed where expected
 at /home/wms/test1.pl line 8



Any help appriciated.  I apologize for this message being formatted
badly, there's no obvious break between my comments and my pasted error
messages.  I hate Outlook with a passion but am forced to use it.

-Ryan


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Need more info about currently running queries

[Anil Doppalapudi]

may be due to corrupted indexes it is taking long time. just re-org the
table.if your table is InnoDB type then use below command to re-org it.

mysql> alter  table <> type=InnoDB;

based on size of the table it may execute for long time . for us it has
solved performance issue.


Thanks
Anil





-Original Message-
From: Greg Fortune [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 22, 2004 1:34 AM
To: mysql@lists.mysql.com
Subject: Re: Need more info about currently running queries


Yep, mysqladmin can give the same info.  As noted in my original message, I
need much more detailed info.

The crux of the problem is that I need to run a query that could take
several
hours when it's using indexes correctly, but it is not working correctly so
it takes longer than I've been willing to wait (about 14 hours).  I need to
make changes to indexes and run the query again, but I don't want to wait
hours until I know whether the change was effective or not.  I really need a
way to find out how far the query has progressed after 15 minutes so I can
calculate how much improvement the changes made.

Greg

On Tuesday 21 December 2004 02:25 am, Gleb Paharenko wrote:
> Hello.
>
>
>
> Using SHOW PROCESSLIST you can just check if your query running, or
>
> is waiting for some lock. For more info, you can run "ps axm" in shell
>
> and look for the thread state, but that's more related to the kernel
stuff.
>
> See:
>
>   http://dev.mysql.com/doc/mysql/en/SHOW_PROCESSLIST.html
>
> Greg Fortune <[EMAIL PROTECTED]> wrote:
> > Is there anyway to get additional information about a query that is
> > currently
> >
> > running?  I've got some performance problems I'm trying to analyze while
> >
> > loading large data sets and I'm running a test query, but I don't have
> > any
> >
> > idea how far the query has progressed.
> >
> >
> >
> > The test query is a count(some_field) with the JOINs that I need and I'd
> > like
> >
> > to know how many rows it has counted or how many rows it has visited
from
> >
> > each table, etc, etc, etc.  I know ahead of time that the result should
> > be
> >
> > about 2.6 million and am just trying to get timing data.
> >
> >
> >
> > Is there any way to get at this kind of info?
> >
> >
> >
> > Greg
>
> --
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.NET http://www.ensita.net/
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
>  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
> /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
><___/   www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Need more info about currently running queries

[Greg Fortune]

Yep, mysqladmin can give the same info.  As noted in my original message, I 
need much more detailed info.  

The crux of the problem is that I need to run a query that could take several 
hours when it's using indexes correctly, but it is not working correctly so 
it takes longer than I've been willing to wait (about 14 hours).  I need to 
make changes to indexes and run the query again, but I don't want to wait 
hours until I know whether the change was effective or not.  I really need a 
way to find out how far the query has progressed after 15 minutes so I can 
calculate how much improvement the changes made.

Greg

On Tuesday 21 December 2004 02:25 am, Gleb Paharenko wrote:
> Hello.
>
>
>
> Using SHOW PROCESSLIST you can just check if your query running, or
>
> is waiting for some lock. For more info, you can run "ps axm" in shell
>
> and look for the thread state, but that's more related to the kernel stuff.
>
> See:
>
>   http://dev.mysql.com/doc/mysql/en/SHOW_PROCESSLIST.html
>
> Greg Fortune <[EMAIL PROTECTED]> wrote:
> > Is there anyway to get additional information about a query that is
> > currently
> >
> > running?  I've got some performance problems I'm trying to analyze while
> >
> > loading large data sets and I'm running a test query, but I don't have
> > any
> >
> > idea how far the query has progressed.
> >
> >
> >
> > The test query is a count(some_field) with the JOINs that I need and I'd
> > like
> >
> > to know how many rows it has counted or how many rows it has visited from
> >
> > each table, etc, etc, etc.  I know ahead of time that the result should
> > be
> >
> > about 2.6 million and am just trying to get timing data.
> >
> >
> >
> > Is there any way to get at this kind of info?
> >
> >
> >
> > Greg
>
> --
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.NET http://www.ensita.net/
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
>  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
> /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
><___/   www.mysql.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Need more info about currently running queries

[Gleb Paharenko]

Hello.



Using SHOW PROCESSLIST you can just check if your query running, or

is waiting for some lock. For more info, you can run "ps axm" in shell

and look for the thread state, but that's more related to the kernel stuff.

See:

  http://dev.mysql.com/doc/mysql/en/SHOW_PROCESSLIST.html





Greg Fortune <[EMAIL PROTECTED]> wrote:

> Is there anyway to get additional information about a query that is currently 

> running?  I've got some performance problems I'm trying to analyze while 

> loading large data sets and I'm running a test query, but I don't have any 

> idea how far the query has progressed. 

> 

> The test query is a count(some_field) with the JOINs that I need and I'd like 

> to know how many rows it has counted or how many rows it has visited from 

> each table, etc, etc, etc.  I know ahead of time that the result should be 

> about 2.6 million and am just trying to get timing data.

> 

> Is there any way to get at this kind of info?

> 

> Greg

> 

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Need more info about currently running queries

[Greg Fortune]

Is there anyway to get additional information about a query that is currently 
running?  I've got some performance problems I'm trying to analyze while 
loading large data sets and I'm running a test query, but I don't have any 
idea how far the query has progressed. 

The test query is a count(some_field) with the JOINs that I need and I'd like 
to know how many rows it has counted or how many rows it has visited from 
each table, etc, etc, etc.  I know ahead of time that the result should be 
about 2.6 million and am just trying to get timing data.

Is there any way to get at this kind of info?

Greg


-- 
Greg Fortune
Enterprise Systems
Eastern Washington University
Phone: 509-359-6690
Email: [EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: JOINs - More Info

[Jason Soza]

So my problem below still exists, but I think I have a better way (and SQL example) to 
describe what's going on. Consider the following SQL:

SELECT gc_info.award,amends.amend,payments.paid
FROM gc_info
LEFT JOIN amends ON gc_info.gc_number=amends.gc_number
LEFT JOIN payments ON amends.gc_number = payments.gc_number
WHERE gc_info.gc_number = "06-8479"

This gives me 3 columns, award, amend, and paid.

There is 1 record in the gc_info table for 06-8479, 1 record in amends for 06-8479, 
and there are 12 records in payments.

The result is 12 columns, each with the same award and amend record repeated for each 
payment record.

How can I arrange the SQL so that the award and amend show up in the first record, 
then are NULL for the remaining. My problem is resulting from doing a SUM(amend) and 
getting a result that's 12x what it should be - if I could eliminate the repeated 
values, I would be okay.

Thanks again! 

Jason
- Original Message -
From: Jason Soza <[EMAIL PROTECTED]>
Date: Tuesday, August 19, 2003 11:18 am
Subject: JOINs

> I may be trying to do too much in a single query here, but it 
> would be nice if I could get it working! Apparently, the version 
> of MySQL used by my work does not support the WITH ROLLUP feature, 
> otherwise I think that would work.
> 
> What I have are 3 tables: gc_info, amends, payments.
> 
> 'gc_info' contains a number that represents the original award 
> given to a contractor. If there are any increases, these are kept 
> in 'amends', and all payments are kept in 'payments'.
> 
> What I need to do is get three numbers: current total award 
> (award+amendments), current total paid (SUM(payments)), and 
> current balance ((awards + SUM(amendments)) - SUM(payments)).
> 
> This almost works with the below query, except that the where 
> there should only be 1 amendment, 11 more show up, or one for each 
> of the 12 payments made to the contractor:
> 
> SELECT org_name,FORMAT(award+amend,2) AS current_total, 
> FORMAT((award+SUM(amend))-SUM(paid),2) AS balance, 
> FORMAT(SUM(paid),2) AS total_paid FROM contact_info LEFT JOIN 
> gc_info ON contact_info.id=gc_info.contact_id LEFT JOIN amends ON 
> gc_info.gc_number=amends.gc_number LEFT JOIN payments ON 
> gc_info.gc_number = payments.gc_number WHERE gc_info.gc_number = 
> "06-8479" GROUP BY gc_info.gc_number
> 
> For example, on a contract with an original award of 168,000, one 
> amendment of 168,000, and 12 payments of 14,000, this gives me:
> 
> |org_name|current_total   |balance |total_paid 
> |
> |Org Name|336,000.00 (correct)|2,016,000.00 (incorrect)|168,000.00 
> (correct)|
> So in FORMAT((award+SUM(amend))-SUM(paid),2), SUM(amend) is adding 
> up 12 instances of amend instead of 1.
> 
> Any advice would be helpful. I've read through the JOIN section in 
> the MySQL manual, tried different JOINs, GROUP BYs, etc. but 
> cannot figure this one out. 
> 
> Thank you very much,
> Jason


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: [More Info] Unique compound index slower than non-unique?

[Pete Harlan]

Following up to my own question.  Some more information.

SLOW: Create unique compound index on a table, do a query.
FAST: Create same index, only non-unique, do a query.
FAST: Do slow method, but ANALYZE TABLE before doing query.

It looks like the key-distribution information that's stored by
ANALYZE TABLE is done (and stored) when creating a non-unique index,
but not when creating a unique one.

Tested in 4.0.12 and 3.23.56.

I have a simple test case if needed.  (There's way too much data in
the test case to present it here.)

--Pete


On Thu, Mar 27, 2003 at 08:39:41PM -0600,  wrote:
> Hi,
> 
> When querying a largish (370,000 rows) table, a unique compound index
> on its three int columns performs slower (as slow as no index at all)
> than when I use the same index created without the "unique" keyword.
> 
> I've repeated it dozens of times: Create the index unique, and it's
> slow, create it non-unique and it's fast.  The EXPLAINs look the same
> for both.
> 
> Is this to be expected under some circumstances, or do I get to
> isolate this messy situation (it's an ugly query) for a bug report?
> 
> MySQL-3.23.55, Linux, MyISAM.
> 
> Thanks,
> 
> --Pete

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: retry: Searching for values such as "10.2.4" via fulltext (more info)

[Thomas Spahni]

Adam,

this will not work with fulltext. Non-alphanumeric characters will be
ignored and treated as spaces. There remain some chunks like 10 2 4 and
these are too short (less than 3 characters) and will never be indexed.

Sorry, no way. Except for an ugly hack. You may try to replace dots
between numbers in your data and in your query with something else. But
your client application has to take care of this.
Let's have a look at an example abusing character with ASCII 254 decimal:

> create table ft ( r1 varchar(255), fulltext ftindex (r1)) type=MyISAM;

> insert into ft values('some data 10þ4þ6'),('today 2003þ3þ4'),('on mysql
  version 4þ0þ12');

> select * from ft where match(r1) against('10þ4þ6');

yields:

*** 1. row ***
r1: some data 10þ4þ6
1 row in set (0.01 sec)

and:

> select * from ft where match(r1) against('4þ0þ*' in boolean mode);

yields:

*** 1. row ***
r1: on mysql version 4þ0þ12
1 row in set (0.00 sec)

and its up to your client application to convert those 'þ' char(FE) back
to '.'

happy hacking,
Thomas Spahni

On Thu, 3 Apr 2003, Adam Randall wrote:

> Since no one responded to this message at all, I'm sending it again.
>
> I have a support system set up where people can search for various
> things using a fulltext index. The problem that I am having, though,
> is that I cannot seem to figure out how to get search results for
> values like "10.2.4" or "6.0.4". This is with MySQL 4.0.12, with the
> minimum word length of 3 (so we can search for PHP, IIS, etc).
>
> Here are some examples of how the search is being performed:
>
> select id,topic from articles where match(topic,summary,description)
> against ('10.2.4');
> (no results)
>
> select id,topic from articles where match(topic,summary,description)
> against ('"10.2.4"' in boolean mode);
> (no results)
>
> select id,topic from articles where topic like '%10.2.4%' or summary
> like '%10.2.4%' or description like '%10.2.4%';
> (3 rows found)
>
> I don't really want to do the last search because it's the slowest,
> and searching the most data un-indexed.
>
> Anyway, if anyone has any advice, I would appreciate it.
>
> Adam.
>
> ---
> Adam Randall  http://www.xaren.net/
> [EMAIL PROTECTED]   http://nt.xaren.net/
> [EMAIL PROTECTED]AIM/iChat:  blitz574
>
> "Macintosh users are a special case. They care passionately about the
> Mac OS and would rewire their own bodies to run on Mac OS X if such a
> thing were possible." -- Peter H. Lewis
>
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

retry: Searching for values such as "10.2.4" via fulltext (more info)

[Adam Randall]

Since no one responded to this message at all, I'm sending it again.

I have a support system set up where people can search for various 
things using a fulltext index. The problem that I am having, though, 
is that I cannot seem to figure out how to get search results for 
values like "10.2.4" or "6.0.4". This is with MySQL 4.0.12, with the 
minimum word length of 3 (so we can search for PHP, IIS, etc).

Here are some examples of how the search is being performed:

select id,topic from articles where match(topic,summary,description) 
against ('10.2.4');
(no results)

select id,topic from articles where match(topic,summary,description) 
against ('"10.2.4"' in boolean mode);
(no results)

select id,topic from articles where topic like '%10.2.4%' or summary 
like '%10.2.4%' or description like '%10.2.4%';
(3 rows found)

I don't really want to do the last search because it's the slowest, 
and searching the most data un-indexed.

Anyway, if anyone has any advice, I would appreciate it.

Adam.

---
Adam Randall  http://www.xaren.net/
[EMAIL PROTECTED]   http://nt.xaren.net/
[EMAIL PROTECTED]AIM/iChat:  blitz574
"Macintosh users are a special case. They care passionately about the
Mac OS and would rewire their own bodies to run on Mac OS X if such a
thing were possible." -- Peter H. Lewis
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Help with 4.0.12 on WinXP (more info)

[Dan Cumpian]

MySQL is installed as a service running locally. Also, this error occurs
with version 3.23.53 onwards (I never tested on older versions than
this).

Thanks,
Dan

-Original Message-
From: Dan Cumpian [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, April 02, 2003 10:27 PM
To: [EMAIL PROTECTED]
Subject: Help with 4.0.12 on WinXP

Hello,

 

I am having the following problem that I've been able to consistently
replicate:

I am using code written in Delphi with Zeos Database components and am
having a problem with a query returning "server connection error". I am
inserting a row into a table and then immediately selecting a row from a
table . This error occurs whether I select out of the table I inserted
the new row into or from any other table. After inserting 3700-3900
rows, the select will be unable to connect. For at least 10-30 seconds,
I cannot connect to MySQL, even with MySQL-Front (I get a "Can't connect
to server" error).  There are no errors being logged. After the 10-30
seconds passes, I can resume the program and it happens again after
3700-3900 rows.

This does not happen on Windows 2000, only Windows XP (both Home and
Pro). All connection are through Localhost. 

My configuration file is:
[mysqld]
set-variable=key_buffer_size=18M
set-variable=myisam_sort_buffer_size=8M
set-variable= max_allowed_packet=16M

Table type is MyISAM.

Machine is a P4-2.2Ghz with SCSI hard disks.

Can anyone please suggest what I might be able to do to resolve this
issue?

Thank you,
Dan Cumpian

 



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqld: Can't lock file (errno: 45) (More Info)

[Dan Nelson]

In the last episode (Feb 28), Mark Hennessy said:
> On Fri, 28 Feb 2003, Mark Hennessy wrote:
> > I just rebuilt mysql 3.23.55 on FreeBSD 5.0, and I am trying to start
> > mysqld with my databases, and all of a sudden I'm getting this error.  I
> > was wondering if anyone has seen this and might know where I should start
> > looking?
>
> Additionally, it appears that this error only comes up when the DATADIR
> for MySQL is set to a directory on an NFS-mounted drive.  I am also asking
> the FreeBSD list if they have seen anything like this come up.

$ perror 45
Error code  45:  Operation not supported
$

I bet MySQL is trying to lock the table ind index files and can't. 
Make sure you are running rpc.lockd on the NFS server, or disable file
locking in MySQL with the --skip-locking mysqld option (this does not
affect MySQL's internal table/row locks).

-- 
Dan Nelson
[EMAIL PROTECTED]

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysqld: Can't lock file (errno: 45) (More Info)

[Mark Hennessy]

Additionally, it appears that this error only comes up when the DATADIR
for MySQL is set to a directory on an NFS-mounted drive.  I am also asking
the FreeBSD list if they have seen anything like this come up.

--
 Mark P. Hennessy [EMAIL PROTECTED]

On Fri, 28 Feb 2003, Mark Hennessy wrote:

> Date: Fri, 28 Feb 2003 16:57:11 -0500 (EST)
> From: Mark Hennessy <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: mysqld: Can't lock file (errno: 45)
>
> I just rebuilt mysql 3.23.55 on FreeBSD 5.0, and I am trying to start
> mysqld with my databases, and all of a sudden I'm getting this error.  I
> was wondering if anyone has seen this and might know where I should start
> looking?
>
> --
>  Mark P. Hennessy   [EMAIL PROTECTED]
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Very basic question from a total newbie! MORE INFO

[Paul DuBois]

I did exactly what Paul described ... I changed the directory at the dos
prompt to
c:\program files\apache group\apache2\htdocs\phpcatalog\admin

and typed in

mysql testcatalog < createdb_mysql

my dos prompt brought up this error:

'mysql' is not recognized as an internal or external command, operable
program or batch file.
I'm looking right at my little stoplight at the bottom of my screen and the
light is green I pulled up WinMySQLadmin and everything looks like it's
working fine. What do I check next?
This document describes what you need to know about what your PATH
is and how to set it:
http://www.kitebird.com/mysql-cookbook/path.pdf

Thanks for your time!!!

Renee :)
sql, query

-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Very basic question from a total newbie! MORE INFO

[Solid Plasma (slpl)]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hello Stitchin',

Sunday, February 23, 2003, 4:38:17 PM, you wrote:

> When you say mysql.exe isn't in your path, what do you mean?  It is right
> where it was installed -
 by that i understand/mean
 System Environment Variable Path

>   c:\mysql\bin\mysql.exe

> Should I move it somewhere else or copy it to somewhere else?
nope
i mean when you write path in to a console window
you must get something like this

C:\WINDOWS\system32>path
PATH=c:\Perl\bin;C:\WINDOWS\system32;C:\WINDOWS;
C:\Program Files\doxygen\bin;C:\Tcl\bin;C:\GnuPG;
c:\unix\bin;C:\mysql\bin;c:\php\

if you don't have the directory C:\mysql\bin in your
system path then you must load mysql in memory by this command

C:\mysql\bin\mysql.exe


> Thanks so much!
> Renee :)

> -Original Message-
> From: Solid Plasma (slpl) [mailto:[EMAIL PROTECTED]
> Sent: Sunday, February 23, 2003 11:19 AM
> To: Stitchin'; [EMAIL PROTECTED]
> Subject: Re: Very basic question from a total newbie! MORE INFO


> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1

> Hello Stitchin',

> Sunday, February 23, 2003, 3:39:41 PM, you wrote:

>> I did exactly what Paul described ... I changed the directory at the dos
>> prompt to

>> c:\program files\apache group\apache2\htdocs\phpcatalog\admin

>> and typed in

>> mysql testcatalog < createdb_mysql

>> my dos prompt brought up this error:

>> 'mysql' is not recognized as an internal or external command, operable
>> program or batch file.

> seems to me your mysql.exe isn't in your path

>> I'm looking right at my little stoplight at the bottom of my screen and
> the
>> light is green I pulled up WinMySQLadmin and everything looks like it's
>> working fine. What do I check next?

>> Thanks for your time!!!

>> Renee :)

>> -Original Message-
>> From: Stitchin' [mailto:[EMAIL PROTECTED]
>> Sent: Saturday, February 22, 2003 8:32 PM
>> To: [EMAIL PROTECTED]
>> Subject: Very basic question from a total newbie!


>> I feel so stupid right now!  I just loaded up Apache, mySql, and PHP on my
>> home Windows XP machine to work on my website.  It'll be running on a
> Linux
>> server when I get it on the web.

>> I've been trying to check out this catalog program called PHP Catalog.
>> Their website has a free version to check out.  I can't even get it up and
>> running.  Their instructions say, "Create a new database and import
>> admin/createdb_mysql with the following commands from the PHPCatalog/admin
>> directory:

>> mysql database_name < createdb_mysql

>> where database_name is the name of the new database (which I'm calling
>> testcatalog).

>> OK, so why can't I figure out where I'm supposed to type this command???
> Do
>> I use the mysql.exe monitor?? I tried to type

>> testcatalog < createdb_mysql

>> at the mysql prompt in the monitor and it wouldn't take. Is there a way to
>> type this command into PHPMyAdmin??  I know the solution has to be s
>> easy and I'm just drawing a total blank.

>> Renee Toth
>> Stitchin' Up A Storm
>> www.stitchinupastorm.com


> - --
> Best regards,
>  Solid  <mailto:[EMAIL PROTECTED]>
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v1.2.1 (MingW32)

> iD8DBQE+WPSL2PEgI0nAJngRAgEBAJ9gBjY+VaL+++FxzJEZFx+drrkVIACghoHC
> fKrTIyexo0A2XxcILdMwxbM=
> =UtUW
> -END PGP SIGNATURE-


> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)

> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php









- --
Best regards,
 Solid  <mailto:[EMAIL PROTECTED]>
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.1 (MingW32)

iD8DBQE+WQIg2PEgI0nAJngRAsi0AJ90tyj6BDCCjfGMmQ5rIHclo0Q1DQCfdsgU
K9ZfAr1quF3zW96d/WWvz7c=
=UKr7
-END PGP SIGNATURE-


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Re[2]: Very basic question from a total newbie! MORE INFO

[Stitchin']

Thank you Stefan  I don't mean to clutter the forum with such basic
questions, but I haven't goofed around with dos prompt commands since the
late 80's.  The last decade or so I have to admit I've been trapped in the
Microsoft world in my old career as a CPA and Controller.  The last time I
did any real programming was in the mid 80's with COBOL!  I guess I've
revealed my age now  I'm probably old enough to be some of the member's
parents!

Renee :)

-Original Message-
From: Stefan Hinz [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 23, 2003 12:02 PM
To: Stitchin'
Cc: [EMAIL PROTECTED]
Subject: Re[2]: Very basic question from a total newbie! MORE INFO


Stitchin',

I don't want to be impolite, but please check some basics of your
operating system (e.g. what a "path" is).

Anyway, here's what you should enter (in a DOS window; C:\> is the
initial DOS prompt):

C:\> cd \program files\apache group\apache2\htdocs\phpcatalog\admin

C:\program files\apache group\apache2\htdocs\phpcatalog\admin>
C:\mysql\bin\mysql.exe testcatalog < createdb_mysql

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  iConnect GmbH <http://iConnect.de>
  Heesestr. 6, 12169 Berlin (Germany)
  Telefon: +49 30 7970948-0  Fax: +49 30 7970948-3

[filter fodder: sql, mysql, query]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re[2]: Very basic question from a total newbie! MORE INFO

[Stefan Hinz]

Stitchin',

I don't want to be impolite, but please check some basics of your
operating system (e.g. what a "path" is).

Anyway, here's what you should enter (in a DOS window; C:\> is the
initial DOS prompt):

C:\> cd \program files\apache group\apache2\htdocs\phpcatalog\admin

C:\program files\apache group\apache2\htdocs\phpcatalog\admin>
C:\mysql\bin\mysql.exe testcatalog < createdb_mysql

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  iConnect GmbH 
  Heesestr. 6, 12169 Berlin (Germany)
  Telefon: +49 30 7970948-0  Fax: +49 30 7970948-3

[filter fodder: sql, mysql, query]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Very basic question from a total newbie! MORE INFO

[Stitchin']

When you say mysql.exe isn't in your path, what do you mean?  It is right
where it was installed -

  c:\mysql\bin\mysql.exe

Should I move it somewhere else or copy it to somewhere else?

Thanks so much!
Renee :)

-Original Message-
From: Solid Plasma (slpl) [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 23, 2003 11:19 AM
To: Stitchin'; [EMAIL PROTECTED]
Subject: Re: Very basic question from a total newbie! MORE INFO


-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hello Stitchin',

Sunday, February 23, 2003, 3:39:41 PM, you wrote:

> I did exactly what Paul described ... I changed the directory at the dos
> prompt to

> c:\program files\apache group\apache2\htdocs\phpcatalog\admin

> and typed in

> mysql testcatalog < createdb_mysql

> my dos prompt brought up this error:

> 'mysql' is not recognized as an internal or external command, operable
> program or batch file.

seems to me your mysql.exe isn't in your path

> I'm looking right at my little stoplight at the bottom of my screen and
the
> light is green I pulled up WinMySQLadmin and everything looks like it's
> working fine. What do I check next?

> Thanks for your time!!!

> Renee :)

> -Original Message-
> From: Stitchin' [mailto:[EMAIL PROTECTED]
> Sent: Saturday, February 22, 2003 8:32 PM
> To: [EMAIL PROTECTED]
> Subject: Very basic question from a total newbie!


> I feel so stupid right now!  I just loaded up Apache, mySql, and PHP on my
> home Windows XP machine to work on my website.  It'll be running on a
Linux
> server when I get it on the web.

> I've been trying to check out this catalog program called PHP Catalog.
> Their website has a free version to check out.  I can't even get it up and
> running.  Their instructions say, "Create a new database and import
> admin/createdb_mysql with the following commands from the PHPCatalog/admin
> directory:

> mysql database_name < createdb_mysql

> where database_name is the name of the new database (which I'm calling
> testcatalog).

> OK, so why can't I figure out where I'm supposed to type this command???
Do
> I use the mysql.exe monitor?? I tried to type

> testcatalog < createdb_mysql

> at the mysql prompt in the monitor and it wouldn't take. Is there a way to
> type this command into PHPMyAdmin??  I know the solution has to be s
> easy and I'm just drawing a total blank.

> Renee Toth
> Stitchin' Up A Storm
> www.stitchinupastorm.com


- --
Best regards,
 Solid  <mailto:[EMAIL PROTECTED]>
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.1 (MingW32)

iD8DBQE+WPSL2PEgI0nAJngRAgEBAJ9gBjY+VaL+++FxzJEZFx+drrkVIACghoHC
fKrTIyexo0A2XxcILdMwxbM=
=UtUW
-END PGP SIGNATURE-


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Very basic question from a total newbie! MORE INFO

[Solid Plasma (slpl)]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hello Stitchin',

Sunday, February 23, 2003, 3:39:41 PM, you wrote:

> I did exactly what Paul described ... I changed the directory at the dos
> prompt to

> c:\program files\apache group\apache2\htdocs\phpcatalog\admin

> and typed in

> mysql testcatalog < createdb_mysql

> my dos prompt brought up this error:

> 'mysql' is not recognized as an internal or external command, operable
> program or batch file.

seems to me your mysql.exe isn't in your path

> I'm looking right at my little stoplight at the bottom of my screen and the
> light is green I pulled up WinMySQLadmin and everything looks like it's
> working fine. What do I check next?

> Thanks for your time!!!

> Renee :)

> -Original Message-
> From: Stitchin' [mailto:[EMAIL PROTECTED]
> Sent: Saturday, February 22, 2003 8:32 PM
> To: [EMAIL PROTECTED]
> Subject: Very basic question from a total newbie!


> I feel so stupid right now!  I just loaded up Apache, mySql, and PHP on my
> home Windows XP machine to work on my website.  It'll be running on a Linux
> server when I get it on the web.

> I've been trying to check out this catalog program called PHP Catalog.
> Their website has a free version to check out.  I can't even get it up and
> running.  Their instructions say, "Create a new database and import
> admin/createdb_mysql with the following commands from the PHPCatalog/admin
> directory:

> mysql database_name < createdb_mysql

> where database_name is the name of the new database (which I'm calling
> testcatalog).

> OK, so why can't I figure out where I'm supposed to type this command??? Do
> I use the mysql.exe monitor?? I tried to type

> testcatalog < createdb_mysql

> at the mysql prompt in the monitor and it wouldn't take. Is there a way to
> type this command into PHPMyAdmin??  I know the solution has to be s
> easy and I'm just drawing a total blank.

> Renee Toth
> Stitchin' Up A Storm
> www.stitchinupastorm.com


- --
Best regards,
 Solid  
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.1 (MingW32)

iD8DBQE+WPSL2PEgI0nAJngRAgEBAJ9gBjY+VaL+++FxzJEZFx+drrkVIACghoHC
fKrTIyexo0A2XxcILdMwxbM=
=UtUW
-END PGP SIGNATURE-


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Very basic question from a total newbie! MORE INFO

[Stitchin']

I did exactly what Paul described ... I changed the directory at the dos
prompt to

c:\program files\apache group\apache2\htdocs\phpcatalog\admin

and typed in

mysql testcatalog < createdb_mysql

my dos prompt brought up this error:

'mysql' is not recognized as an internal or external command, operable
program or batch file.

I'm looking right at my little stoplight at the bottom of my screen and the
light is green I pulled up WinMySQLadmin and everything looks like it's
working fine. What do I check next?

Thanks for your time!!!

Renee :)

-Original Message-
From: Stitchin' [mailto:[EMAIL PROTECTED]
Sent: Saturday, February 22, 2003 8:32 PM
To: [EMAIL PROTECTED]
Subject: Very basic question from a total newbie!


I feel so stupid right now!  I just loaded up Apache, mySql, and PHP on my
home Windows XP machine to work on my website.  It'll be running on a Linux
server when I get it on the web.

I've been trying to check out this catalog program called PHP Catalog.
Their website has a free version to check out.  I can't even get it up and
running.  Their instructions say, "Create a new database and import
admin/createdb_mysql with the following commands from the PHPCatalog/admin
directory:

mysql database_name < createdb_mysql

where database_name is the name of the new database (which I'm calling
testcatalog).

OK, so why can't I figure out where I'm supposed to type this command??? Do
I use the mysql.exe monitor?? I tried to type

testcatalog < createdb_mysql

at the mysql prompt in the monitor and it wouldn't take. Is there a way to
type this command into PHPMyAdmin??  I know the solution has to be s
easy and I'm just drawing a total blank.

Renee Toth
Stitchin' Up A Storm
www.stitchinupastorm.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: InnoDB Crash [more info]

[Heikki Tuuri]

Michael,

since the 'Spamcop':

"
  Recipient: <[EMAIL PROTECTED]>
  Reason:Blocked - see http://spamcop.net/bl.shtml?194.251.242.203
"

has blocked email to you, I post the patch here. This patch makes InnoDB to
print a lot of diagnostic info if it notices the failure you have. It also
tries to recover from the failure by discarding possible insert buffer
records for that page.

Best regards,

Heikki
Innobase Oy
sql query

--- 1.11/innobase/ibuf/ibuf0ibuf.c Mon Jul  8 19:27:47 2002
+++ 1.12/innobase/ibuf/ibuf0ibuf.c Fri Feb 21 23:11:10 2003
@@ -2483,7 +2483,9 @@
  ulint old_bits;
  ulint new_bits;
  dulint max_trx_id;
+ ibool corruption_noticed = FALSE;
  mtr_t mtr;
+ char err_buf[500];

  if (srv_force_recovery >= SRV_FORCE_NO_IBUF_MERGE) {

@@ -2535,7 +2537,38 @@
  block = buf_block_align(page);
  rw_lock_x_lock_move_ownership(&(block->lock));

- ut_a(fil_page_get_type(page) == FIL_PAGE_INDEX);
+ if (fil_page_get_type(page) != FIL_PAGE_INDEX) {
+
+ corruption_noticed = TRUE;
+
+ ut_print_timestamp(stderr);
+
+ mtr_start(&mtr);
+
+ fprintf(stderr,
+"  InnoDB: Dump of the ibuf bitmap page:\n");
+
+ bitmap_page = ibuf_bitmap_get_map_page(space, page_no,
+ &mtr);
+ buf_page_print(bitmap_page);
+
+ mtr_commit(&mtr);
+
+ fprintf(stderr, "\nInnoDB: Dump of the page:\n");
+
+ buf_page_print(page);
+
+ fprintf(stderr,
+"InnoDB: Error: corruption in the tablespace. Bitmap shows insert\n"
+"InnoDB: buffer records to page n:o %lu though the page\n"
+"InnoDB: type is %lu, which is not an index page!\n"
+"InnoDB: We try to resolve the problem by skipping the insert buffer\n"
+"InnoDB: merge for this page. Please run CHECK TABLE on your tables\n"
+"InnoDB: to determine if they are corrupt after this.\n\n"
+"InnoDB: Please make a detailed bug report and send it to\n"
+"InnoDB: [EMAIL PROTECTED]",
+ page_no, fil_page_get_type(page));
+ }
  }

  n_inserts = 0;
@@ -2578,8 +2611,14 @@

  goto reset_bit;
  }
+
+ if (corruption_noticed) {
+ rec_sprintf(err_buf, 450, ibuf_rec);
+
+ fprintf(stderr,
+"InnoDB: Discarding record\n %s\n from the insert buffer!\n\n", err_buf);

-if (page) {
+} else if (page) {
  /* Now we have at pcur a record which should be
  inserted to the index page; NOTE that the call below
  copies pointers to fields in ibuf_rec, and we must

- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, February 21, 2003 10:35 PM
Subject: Re: InnoDB Crash [more info]


> Michael,
>
> how do I send you email? A 'Spamcop' seems to block email to you.
>
> Regards,
>
> Heikki
>
> - Original Message -
> From: "Heikki Tuuri" <[EMAIL PROTECTED]>
> To: ""Michael T. Babcock"" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Friday, February 21, 2003 10:33 PM
> Subject: Re: InnoDB Crash [more info]
>
>
> > Michael,
> >
> > your database is probably corrupt.
> >
> > The normal procedure in this case is to use the my.cnf option
> >
> > set-variable=innodb_force_recovery=4
> >
> > and dump your tables and recreate the whole tablespace.
> >
> > But, please do not do that yet. I will send you a new version of
> >
> > /mysql/innobase/ibuf/ibuf0ibuf.c
> >
> > which will print a lot of diagnostic information. I want to see what it
> > prints.
> >
> > A general note: you are using a very old Linux kernel 2.2.14. Some
> > combinations of Linux + hardware seem to cause sporadic table
corruption.
> > One user was able to resolve the problem by upgrading to a stock kernel
> > 2.4.20.
> >
> > Regards,
> >
> > Heikki
> > Innobase Oy
> >
> > sql query
> >
> > - Original Message -
> > From: ""Michael T. Babcock"" <[EMAIL PROTECTED]>
> > Newsgroups: mailing.database.mysql
> > Sent: Friday, February 21, 2003 9:23 PM
> > Subject: Re: InnoDB Crash [more info]
> >
> >
> > > Michael T. Babcock wrote:
> > >
> > > >I've got a nice MySQL crash that happened during the night last night
> and
> > I
> > > >can't seem to get it to come back online for me
without --skip-innodb.
> > > >
> > > >
> > >
> > > Follow-up with mysql's bug report:
> > >
> > > MySQL support: none
> > > Synopsis:InnoDB Crashing on Startup
> > > Severity:critical
> > > Priority:medium
> > > Category:mysql
> > > Class:sw-bug
> > > Release:my

Re: InnoDB Crash [more info]

[Heikki Tuuri]

Michael,

how do I send you email? A 'Spamcop' seems to block email to you.

Regards,

Heikki

- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: ""Michael T. Babcock"" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, February 21, 2003 10:33 PM
Subject: Re: InnoDB Crash [more info]


> Michael,
>
> your database is probably corrupt.
>
> The normal procedure in this case is to use the my.cnf option
>
> set-variable=innodb_force_recovery=4
>
> and dump your tables and recreate the whole tablespace.
>
> But, please do not do that yet. I will send you a new version of
>
> /mysql/innobase/ibuf/ibuf0ibuf.c
>
> which will print a lot of diagnostic information. I want to see what it
> prints.
>
> A general note: you are using a very old Linux kernel 2.2.14. Some
> combinations of Linux + hardware seem to cause sporadic table corruption.
> One user was able to resolve the problem by upgrading to a stock kernel
> 2.4.20.
>
> Regards,
>
> Heikki
> Innobase Oy
>
> sql query
>
> - Original Message -
> From: ""Michael T. Babcock"" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.mysql
> Sent: Friday, February 21, 2003 9:23 PM
> Subject: Re: InnoDB Crash [more info]
>
>
> > Michael T. Babcock wrote:
> >
> > >I've got a nice MySQL crash that happened during the night last night
and
> I
> > >can't seem to get it to come back online for me without --skip-innodb.
> > >
> > >
> >
> > Follow-up with mysql's bug report:
> >
> > MySQL support: none
> > Synopsis:InnoDB Crashing on Startup
> > Severity:critical
> > Priority:medium
> > Category:mysql
> > Class:sw-bug
> > Release:mysql-3.23.55 (yes)
> >
> > Environment:
> > System: Linux web.fibrespeed.net 2.2.14-10.0 #21 Fri Apr 21 00:22:11 EDT
> > 2000 i686 unknown
> > Architecture: i686
> >
> > Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
> > /usr/bin/cc
> > GCC: Reading specs from
> > /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs
> > gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
> >
> > Compilation info: CC='gcc'  CFLAGS='-O2 -march=pentium'  CXX='gcc'
> > CXXFLAGS='-O2 -march=pentium'  LDFLAGS='-static'
> >
> > LIBC:
> > lrwxrwxrwx1 root root   13 Apr 10  2000 /lib/libc.so.6
> > -> libc-2.1.3.so
> > -rwxr-xr-x1 root root  4101836 Jan 15  2001
/lib/libc-2.1.3.so
> > -rw-r--r--1 root root 20273324 Jan 15  2001 /usr/lib/libc.a
> > -rw-r--r--1 root root  178 Jan 15  2001 /usr/lib/libc.so
> > lrwxrwxrwx1 root root   10 Jul 20  2001
> > /usr/lib/libc-client.a -> c-client.a
> >
> > Configure command: ./configure '--sysconfdir=/etc' '--prefix=/usr'
> > '--localstatedir=/var/mysql' '--enable-assembler' '--with-berkeley-db'
> > '--with-innodb' '--with-comment' '--enable-thread-safe-client' 'CC=gcc'
> > 'CFLAGS=-O2 -march=pentium' 'CXXFLAGS=-O2 -march=pentium' 'CXX=gcc'
> > 'LDFLAGS=-static'
> >
> > --
> > Michael T. Babcock
> > C.T.O., FibreSpeed Ltd.
> > http://www.fibrespeed.net/~mbabcock
> >
> >
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
>



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: InnoDB Crash [more info]

[Heikki Tuuri]

Michael,

your database is probably corrupt.

The normal procedure in this case is to use the my.cnf option

set-variable=innodb_force_recovery=4

and dump your tables and recreate the whole tablespace.

But, please do not do that yet. I will send you a new version of

/mysql/innobase/ibuf/ibuf0ibuf.c

which will print a lot of diagnostic information. I want to see what it
prints.

A general note: you are using a very old Linux kernel 2.2.14. Some
combinations of Linux + hardware seem to cause sporadic table corruption.
One user was able to resolve the problem by upgrading to a stock kernel
2.4.20.

Regards,

Heikki
Innobase Oy

sql query

- Original Message -
From: ""Michael T. Babcock"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Friday, February 21, 2003 9:23 PM
Subject: Re: InnoDB Crash [more info]


> Michael T. Babcock wrote:
>
> >I've got a nice MySQL crash that happened during the night last night and
I
> >can't seem to get it to come back online for me without --skip-innodb.
> >
> >
>
> Follow-up with mysql's bug report:
>
> MySQL support: none
> Synopsis:InnoDB Crashing on Startup
> Severity:critical
> Priority:medium
> Category:mysql
> Class:sw-bug
> Release:mysql-3.23.55 (yes)
>
> Environment:
> System: Linux web.fibrespeed.net 2.2.14-10.0 #21 Fri Apr 21 00:22:11 EDT
> 2000 i686 unknown
> Architecture: i686
>
> Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
> /usr/bin/cc
> GCC: Reading specs from
> /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs
> gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
>
> Compilation info: CC='gcc'  CFLAGS='-O2 -march=pentium'  CXX='gcc'
> CXXFLAGS='-O2 -march=pentium'  LDFLAGS='-static'
>
> LIBC:
> lrwxrwxrwx1 root root   13 Apr 10  2000 /lib/libc.so.6
> -> libc-2.1.3.so
> -rwxr-xr-x1 root root  4101836 Jan 15  2001 /lib/libc-2.1.3.so
> -rw-r--r--1 root root 20273324 Jan 15  2001 /usr/lib/libc.a
> -rw-r--r--1 root root  178 Jan 15  2001 /usr/lib/libc.so
> lrwxrwxrwx1 root root   10 Jul 20  2001
> /usr/lib/libc-client.a -> c-client.a
>
> Configure command: ./configure '--sysconfdir=/etc' '--prefix=/usr'
> '--localstatedir=/var/mysql' '--enable-assembler' '--with-berkeley-db'
> '--with-innodb' '--with-comment' '--enable-thread-safe-client' 'CC=gcc'
> 'CFLAGS=-O2 -march=pentium' 'CXXFLAGS=-O2 -march=pentium' 'CXX=gcc'
> 'LDFLAGS=-static'
>
> --
> Michael T. Babcock
> C.T.O., FibreSpeed Ltd.
> http://www.fibrespeed.net/~mbabcock
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: InnoDB Crash [more info]

[Michael T. Babcock]

Michael T. Babcock wrote:


I've got a nice MySQL crash that happened during the night last night and I 
can't seem to get it to come back online for me without --skip-innodb.
 


Follow-up with mysql's bug report:

MySQL support: none
Synopsis:InnoDB Crashing on Startup
Severity:critical
Priority:medium
Category:mysql
Class:sw-bug
Release:mysql-3.23.55 (yes)

Environment:
System: Linux web.fibrespeed.net 2.2.14-10.0 #21 Fri Apr 21 00:22:11 EDT 
2000 i686 unknown
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc 
/usr/bin/cc
GCC: Reading specs from 
/usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)

Compilation info: CC='gcc'  CFLAGS='-O2 -march=pentium'  CXX='gcc'  
CXXFLAGS='-O2 -march=pentium'  LDFLAGS='-static'

LIBC:
lrwxrwxrwx1 root root   13 Apr 10  2000 /lib/libc.so.6 
-> libc-2.1.3.so
-rwxr-xr-x1 root root  4101836 Jan 15  2001 /lib/libc-2.1.3.so
-rw-r--r--1 root root 20273324 Jan 15  2001 /usr/lib/libc.a
-rw-r--r--1 root root  178 Jan 15  2001 /usr/lib/libc.so
lrwxrwxrwx1 root root   10 Jul 20  2001 
/usr/lib/libc-client.a -> c-client.a

Configure command: ./configure '--sysconfdir=/etc' '--prefix=/usr' 
'--localstatedir=/var/mysql' '--enable-assembler' '--with-berkeley-db' 
'--with-innodb' '--with-comment' '--enable-thread-safe-client' 'CC=gcc' 
'CFLAGS=-O2 -march=pentium' 'CXXFLAGS=-O2 -march=pentium' 'CXX=gcc' 
'LDFLAGS=-static'

--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock



-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: More info on mysql sporadic crashes

[Victoria Reznichenko]

On Saturday 21 December 2002 15:14, Paul P Komkoff Jr wrote:

> I tracked down the bug
>
> I have one table with BLOB field in it
> Then I execute queries like
>
> SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% blabla %'))
>
> here, keywords is a blob fields
>
> when (LOWER(keywords) LIKE LOWER('% blabla %')) is true, mysql dies
>
> hope this helps

Sorry, but I couldn't repeat it on 4.0.5. It works perfectly well for me:

mysql> select count(*) from mytable where lower(body) like 
lower('%victoria%');
+--+
| count(*) |
+--+
| 1452 |
+--+
1 row in set (9.29 sec)




-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

More info on mysql sporadic crashes

[Paul P Komkoff Jr]

I tracked down the bug

I have one table with BLOB field in it
Then I execute queries like

SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% blabla %'))

here, keywords is a blob fields

when (LOWER(keywords) LIKE LOWER('% blabla %')) is true, mysql dies

hope this helps

-- 
Paul P 'Stingray' Komkoff 'Greatest' Jr /// (icq)23200764 /// (http)stingr.net
  When you're invisible, the only one really watching you is you (my keychain)

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Exciting new Replication Error -- more info

[Eric]

MASTER Ver 12.10 Distrib 4.0.2-alpha, for pc-linux-gnu (i686)

SLAVE Ver 12.10 Distrib 4.0.2-alpha, for unknown-freebsdelf4.6 (i386)


On my Master I am getting this:


mysql> SHOW BINLOG EVENTS IN '/usr/local/var/www200-bin.008' FROM 38717800;
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id:6227106
Current database: *** NONE ***

ERROR 2013: Lost connection to MySQL server during query







Slave SQL thread initialized, starting replication in log 'www200-bin.008' 
at position 38717817, relay log './s142-17-103-3-relay-bin.056' position: 
9212273
021114 16:34:12  Error in Log_event::read_log_event(): 'read error', 
data_len=161,event_type=2
021114 16:34:12  Slave SQL thread: I/O error reading event(errno: 
-1  cur_log->error: 122)
021114 16:34:12  Error reading relay log event: Aborting slave SQL thread 
because of partial event read
021114 16:34:12  Could not parse log event entry, check the master for 
binlog corruption
This may also be a network problem, or just a bug in the master or slave code.
021114 16:34:12  Error running query, slave SQL thread aborted. Fix the 
problem, and restart the slave SQL thread with "SLAVE START". We stopped at 
log 'www200-bin.008' position 38717817
021114 16:34:12  Slave SQL thread exiting, replication stopped in 
log  'www200-bin.008' at position 38717817
021114 16:34:17  Slave I/O thread: connected to master 
'[EMAIL PROTECTED]:3306',  replication started in log 
'www200-bin.008' at position 38748768


I don't have a clue what this could mean. I had a screw up where I made a 
unique index on the master, but the database table on the slave had data 
that was not unique while the master data was unique. I backed up the table 
on the slave, deleted the data from the master table, deleted the data from 
the slave table, restarted the slave, it worked, removed both indexes on 
the slave and master... Then I copied the data back to the slave table. Now 
I get the above messages, and typing either slave start, or slave stop 
hangs endlessly.

Thanks,


Eric 


-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

More info on the MySQL failure after Red Hat glibc update

[Lenz Grimmer]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi,

We currently receive a lot of reports from people running Red Hat
Linux (7.x and 8.0) that cannot access MySQL via TCP/IP after updating
the GNU C library (glibc) via Red Hat's up2date updating tool. MySQL
simply crashes in this case, only downgrading to the previous installed
glibc seemed to help.

I've done some more research on the subject and read up on several bugs
that have been filed into Red Hat's Bugzilla about that and I just wanted
to update you on the current situation:

https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=74943
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75128
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75290
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75297
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75684
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75507

HJ Lu, one of the GNU core developers mentioned the following in bug #75684:

"glibc 2.2.5-40 changes a buffer type from 1k to 64k. Unfortunately, resolver
uses that buffer on stack. As the result, many threaded applications, which
have a lower stack limit, start to dump core for no apparent reasons."

Red Hat's Jakub Jelinek is working on a fix for glibc (it breaks other 
threaded applications as well, e.g. Sun's JDK, see bug #75507) and has created 
a preliminary glibc upgrade package for people to test. If it passes final QA,
Red Hat will make it available via up2date:

ftp://people.redhat.com/jakub/glibc/errata/

Seems like this package resolves the problem, as some people have confirmed
later in bug #75128.

So it's being worked on and will hopefully be resolved very soon.

According to the Cc: list in bug #75128, quite a lot of people are interested
in getting informed, when it's finally fixed :)

Bye,
LenZ
- -- 
For technical support contracts, visit https://order.mysql.com/?ref=mlgr
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Lenz Grimmer <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Production Engineer
/_/  /_/\_, /___/\___\_\___/   Hamburg, Germany
   <___/   www.mysql.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.0 (GNU/Linux)

iD8DBQE9sDitSVDhKrJykfIRAlpqAJ0e3wM1VAXL8rCeYmOucPZzm3XgxQCdGYbI
CM8zLesbjVd7FMK4+Lk4cpU=
=oFO7
-END PGP SIGNATURE-


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: More info: Strange memory leak problem (C API)

[Ben Goodwin]

If I link the library with '-z nodelete' the leak goes away.  The library
doesn't get loaded and unloaded over and over again...

>From the Solaris 'ld' man page

 -z nodelete
   Marks the object as non-deletable at runtime. The run-
   time  processing  of an object that contains this flag
   mimics that which occurs if the object is added  to  a
   process using dlopen(3DL) with the RTLD_NODELETE mode.

and from dlopen:

 RTLD_NODELETE
   The specified object will  not  be  deleted  from  the
   address space as part of a dlclose().


While this cures my problem, it seems it's an inappropriate bandaid..
I don't see wide use of this option upon a cursory 'net search ... And I
don't know if this is a mysql problem or a solaris problem ... would
dlopen()ing a library that's compiled with -lmysqlclient, allocating memory
using a routine (mysql_init) from that included library, and then unloading
the library cause a memory leak if the included (mysqlclient) library
doesn't free certain other memory that's only initialized once mysql_init is
called?  IE does mysql_init do a one-time memory alloc that's never freed
(but under normal circumstances doesn't cause a leak because the alloc'ed
area is normally assumed to be  around for the duration of the program)?  So
subsequent loads of the librarys cause this one-time memory alloc to be
called over and over?  This might need to go to some core MySQL folks unless
someone here's familiar with the client library internals ... :-)

Thanks!

-=| Ben




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

More info: Strange memory leak problem (C API)

[Ben Goodwin]

I've compiled debugging into the library .. now I figured the library was
getting loaded/unloaded, but it didn't really come to mind until I ran it
with debugging.  My atomic tests (A standalone program that init's and
closes) does NOT do this.. So, I'm wondering if the leak is somehow being
incurred by constantly mmaping and un-mmaping the library even though the
master process (the one calling getpwnam over and over) never exits -
libmysqlclient is being dynamically loaded and unloaded over and over again.

---
MYSQL_DEBUG found. libmysql started with the following:
d:t:L:n:N:S:F
---

1: libmysql.c:  1664:1: >mysql_close
2: libmysql.c:  1700:1: mysql_close
2: libmysql.c:  1700:1: mysql_close
2: libmysql.c:  1700:1: http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Losing data more info

[Anna Carlsson]

create table EAP (eapID int auto_increment primary key,
Name varchar(60),
Addr1 varchar(50),
Addr2 varchar(50),
City varchar(30),
State varchar(2), index state_ind(state),
Foreign key (State) references State(StateShort),
Zip varchar(5),
RevisionDate Date,
FundingSource varchar(15),
CEnumber varchar(10),
CompanyContact varchar(150),
Eligibility text,
ProbationaryPeriod text,
Sessions text,
Copay text,
InsuranceInfo text,
RequiredForms text,
Instructions text
) type = innodb;

create table ForCompany (ForCompanyID int auto_increment primary key,
eapID int, index eap_ind(eapID),
Foreign key (eapID) references EAP(eapID),
Name varchar(50)
) type = innodb;

These are the tables. It's table ForCompany that loses data. It doesn't 
really matter what query I run, I've tried a few different. Examples:

1. Select * from ForCompany where eapID = $number;
2. Select * from ForComany;

The result differs from time to time. I have put 10 items in table ForCompany 
and every second time I run query 2 only two items show up, or four, or none 
at all. 
I had the database on mySQL 3.23.36 and upgraded recently to 4.0.1-alpha-nt, 
but nothing changed. I've tried to drop the database and create everything 
from scratch, but that didn't help either.
I couldn't find anything like this in the bug report, and I find it highly 
unlikly that it is a bug. Someone else should have encountered it long ago. 
Is there some kind of property I don't know about? The other 4 database are 
working fine. One of them is in production and I'd like to put the rest in 
production to, but I don't dare do that until I've found out why this db is 
misbehaving. 

Anna




This message was sent using SkyBURST Mail Center.
http://www.skyburst.net



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

More Query Help [more info]

[Daren Cotter]

I probably did not provide enough info the first time. The members table
is setup as follows:

Id (primary key)
Referer (relates to the primary key of the table)

I am given a member ID, say 4. I need to display all members who have
been referred by member 4 (obviously no problem). However, for each row
that matches, I also need the number of members referred by THAT member.
I tried a simple join, but it doesn't display members with 0 referrals,
so I'm thinking I need to left join the table to itself. The query I
initially posted:

SELECT m1.username, m1.first_name, m1.email, DATE_FORMAT(m1.signup_date,
'%b %e, %Y') AS signup_date, COUNT(m2.id) AS count FROM members AS m1
LEFT JOIN members AS m2 ON m1.referer = m2.id WHERE m1.referer = 4 GROUP
BY m1.referer;

Does not work. It returns only one row (should be 3)...the count at the
end is 3, which is the total of all members referred by all the members
that should be returned...leading me to think I'm close, just not quite
there!

Would appreciate any help. Thanks all  =)


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Can't create/write to file (more info)

[Marko Palikko]

Wow,

Quick response... You guys ( gals) are Great !!

All files /var/lib/CRdb/* (Database Directory) are 777 (CHMOD) 
and  ownership mysql
All files /var/lib/mysql/mysql/* are 777 as well.

hmm. ( Very Puzzled )

Also the file   #sql-6c4_a.frm  in the error message does not exist.

 >Failed to save field : SQL alter table ZControl add pid 
tinyint(4) >failed : './CRdB/#sql-6c4_a.frm' (Errcode: 13)

Thanks Again,

Marko Palikko
[EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: need SQL assistance with a few selects MORE INFO

[Jay Blanchard]

[snip]
2. The date of max disksize and the date of min disksize...in one query...if
that's possible.
[/snip]

mysql> select RunDate,
-> MAX(IF(ClientName = 'ABC INC', DiskSize, '')) AS ABC,
-> MAX(IF(ClientName = 'Eat at Joe', DiskSize, '')) AS Joe,
-> MAX(IF(ClientName = 'The Hop', DiskSize, '')) AS Hop,
-> MAX(IF(ClientName = 'Razoo', DiskSize, '')) AS Razoo
-> from tblBAR
-> group by RunDate
-> order by DiskSize DESC;
++--+--+--+---+
| RunDate| ABC  | Joe  | Hop  | Razoo |
++--+--+--+---+
| 2002-07-12 | 3.0  |  |  |   |
| 2002-07-04 |  |  |  | 2.6   |
| 2002-07-13 | 1.8  | 2.0  |  |   |
| 2002-07-11 | 1.2  | 1.8  |  |   |
| 2002-07-17 |  |  | 1.1  | 1.1   |
| 2002-07-14 |  | 0.8  |  |   |
| 2002-07-08 |  |  | 0.6  |   |
++--+--+--+---+
7 rows in set (0.00 sec)

This requires that you know each client. If you look at column ABC and go
down, the first value is the MAX disk size, go left to find the date this
occured. Look at column Hop and go down to the first value, that is the MAX,
go left to find the date this occured.

mysql> select RunDate,
-> MAX(IF(ClientName = 'ABC INC', DiskSize, '')) AS ABC,
-> MAX(IF(ClientName = 'Eat at Joe', DiskSize, '')) AS Joe,
-> MAX(IF(ClientName = 'The Hop', DiskSize, '')) AS Hop,
-> MAX(IF(ClientName = 'Razoo', DiskSize, '')) AS Razoo
-> from tblBAR
-> group by RunDate
-> order by DiskSize;
++--+--+--+---+
| RunDate| ABC  | Joe  | Hop  | Razoo |
++--+--+--+---+
| 2002-07-08 |  |  | 0.6  |   |
| 2002-07-14 |  | 0.8  |  |   |
| 2002-07-17 |  |  | 1.1  | 1.1   |
| 2002-07-11 | 1.2  | 1.8  |  |   |
| 2002-07-13 | 1.8  | 2.0  |  |   |
| 2002-07-04 |  |  |  | 2.6   |
| 2002-07-12 | 3.0  |  |  |   |
++--+--+--+---+
7 rows in set (0.00 sec)
This is still calcing MAX, but since there is ORDER BY DiskSize you can take
the DESC (descending) attribute out and reading the table is the same. The
first value down the column is the MINIMUM, go left to find the date this
occured.

HTH!

Jay



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Some more info on what I don't have.

[Sherwin T. Ang]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hello Louise,

Well first of all is that, did you change host providers? well if so,
have you made a backup/dump of your database in your old host? if so,
are u sure that your new host supports PERL DBI which is needed for
you to do database connections via Perl (i am concluding it's perl
coz you mentioned cgi)  

If you are all in luck and still have the old server running, you can
try phpMyAdmin and use it to dump the database into a text file, then
on your new host, install phpMyAdmin too and then restore the
database into the new site.  Just ask your new provider for the
username, password and maybe the mysql port if ever they changed it.

You can get a copy of phpMyAdmin at
http://www.phpwizard.net/projects/ it's written in PHP though, but
you can use the tool for the database migration.

Regards,

Sherwin T. Ang
Web Technical Administrator / Programmer
Alchemy Solutions
http://www.alchemy.com.ph
Creative. Technology.

Tridel Technologies, Inc.
7th Floor Hanston Building
Emerald Ave., Ortigas Center
Pasig City
Philippines

Tel: (632) 634-5141/ (632) 634-5140 Local 1040
Fax: (632) 634-5139

- - Original Message - 
From: "Louise" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 21, 2002 12:20 AM
Subject: Some more info on what I don't have.


> The site is a search engine site similiar to ooh-canada.com (not
> that I am plugging their site...lol) but it is the best way to
> describe mine. I have adcycle on it- that doesn't work.
> I have link sql which doesn't work.
> There is e-classifieds that doesn't work.
> Subscribe Me pro doesn't work
> Auto rank, auto post, web now doesn't work.
> Even the links on it don't work. 
> I can't get into any admin for any of the above stuff. Virtually I
> have only a site that is a mess. And so am I...
> I sure do hope that someone can help. I don't think it is a big
> problem but some thing that I have not done in my illiterate mind.
> Like the wrong linking or like that. Thanks for listening..
> Louise
> 

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBPJp+iHHqbCYZYnEDEQJyoQCeNCIOjV+R8FhDP7AeR4GQng+vnFwAmwR/
8X4zTk7ZR0zqiC7yTNum4gE6
=MlAV
-END PGP SIGNATURE-




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Some more info on what I don't have.

[Louise]

The site is a search engine site similiar to ooh-canada.com (not that I am plugging 
their site...lol) but it is the best way to describe mine.
I have adcycle on it- that doesn't work.
I have link sql which doesn't work.
There is e-classifieds that doesn't work.
Subscribe Me pro doesn't work
Auto rank, auto post, web now doesn't work.
Even the links on it don't work. 
I can't get into any admin for any of the above stuff. Virtually I have only a site 
that is a mess.
And so am I...
I sure do hope that someone can help. I don't think it is a big problem but some thing 
that I have not done in my illiterate mind. Like the wrong linking or like that.
Thanks for listening..
Louise

More info on mysqlbinlog strangeness

[Wendell Dingus]

I've been using mysqlbinlog to capture a file of inserts/updates/deletes on
numerous servers since the early 3.23.x days. I have 3.23.46-max on a pair
of servers now though where it is exhibiting some strange behavior. Based on
some emailed suggestions I've tried leaving off the "-uroot -ppassword"
parameters and also tried a binary from an older release of MySQL (3.23.39
which works fine on another server with .39 of MySQL running).

The server I'm testing on right now has system-bin.001 and system-bin.002
files where I stopped/started the server without a flush. The first file
logged basically nothing and I see a "rotate to server-bin.002" line when I
dump it so the files obviously have internal links to each other (which I
didn't know previously). Anyway, the server is 3.23.46-max and I am using
InnoDB tables on this server which I am NOT using on any of the other
numerous servers which are acting more the way I think they should. Some
details:

.46 binlog binary without -uroot: Running it against the .001 log file shows
the contents of that file only. Does not link to .002 but does give the #
prompt back as soon as it finishes.

.46 binlog binary with -uroot: Links to .002 and shows me everything logged
from both files and hangs and never (waited 5+ minutes) gives back the #
prompt.

.39 binlog binary without -uroot: Same as .46 version above

.39 binlog binary with -uroot: Same as .46 version above but errors and
drops back to a # prompt perhaps 2 minutes later. Gives error "ERROR: Error
reading packet from server:"

At this point I will experiment with processing the .001, .002, .003 ...
files individually in turn without providing the -uroot -ppassword
parameters.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

More info

[Alexander Barkov]

Sorry, It was a little mistake in my previous letter.

"mysqladmin create databases" does not output any
error messages, however it does not create database
"databases".

However, "mysqladmin drop databases" produce this:


/usr/local/mysql/etc/ access.grant > mysqladmin drop databases
Dropping the database is potentially a very bad thing to do.
Any data stored in the database will be destroyed.

Do you really want to drop the 'databases' database [y/N]
y
mysqladmin: drop of 'databases' failed;
error: 'You have an error in your SQL syntax near 'databases' at line 1'


Regards.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Some more info about backup.

[Heikki Tuuri]

Hi!

>With mysqldump which uses the following query to do this:
>
>SELECT * INTO OUTFILE '/spylog/test/g00hits.txt' FROM g00hits
>
>It takes:
>real1m23.177s   (first time)
>real1m20.934s   (second time)

The dump speed is 45000 rows or 5 MB per second. I think best disks
today can write 10 MB/second. Thus for the dump the disk and the CPU
are about equal bottlenecks.

>mysql> load data infile '/spylog/test/g00hits.txt' ignore into table g00hits;
>Query OK, 3722867 rows affected (8 min 35.73 sec)
>
>mysql> load data infile '/spylog/test/g00hits.txt'  ignore into table g00hits;
>Query OK, 3722867 rows affected (3 min 35.26 sec)

What was the difference between the first run and the second run? Why is
the time in the second run only 1/2 of the first run?

In the second run you load 15000 rows per second, or
1.5 MB/s, which sounds a reasonable speed, since your rows are much
bigger than the rows in my test. Thus there is no performance bug
indicated by these numbers. The question is why your original test
took 40 minutes, though on a different computer.

In my test I was able to load 45000 8-byte rows per second,
which makes an input speed of 400 kB per second, much smaller than
the disk read speed. Thus we see that loading of data is CPU-bound
even on the fastest available processors, if we do not need to do
random disk accesses in building the indexes.

As a conclusion, are these numbers not satisfactory? You can dump
tables at about the same speed as the disk can write, and you can
import 50 million rows or 5 GB per hour.

Regards,

Heikki

At 09:38 PM 6/2/01 +0400, you wrote:
>Hello mysql,
>
>  I'm repeating my test's now with more information and on more
>  powerfull maching with no load now, this should give more accurate
>  results.
>  The machine is Dual PIII-750/1GB RAM
>
>  I'm trying the following table  structure:
>
>CREATE TABLE g00hits (
>  id int(10) unsigned NOT NULL auto_increment,
>  counter_id int(10) unsigned NOT NULL default '0',
>  visitor_id int(10) unsigned NOT NULL default '0',
>  server_id smallint(5) unsigned NOT NULL default '0',
>  ip int(10) unsigned NOT NULL default '0',
>  ts timestamp(14) NOT NULL,
>  method_id tinyint(3) unsigned NOT NULL default '0',
>  http_ver_id tinyint(3) unsigned NOT NULL default '0',
>  page_id int(10) unsigned NOT NULL default '0',
>  referer_page_id int(10) unsigned NOT NULL default '0',
>  status smallint(5) unsigned NOT NULL default '0',
>  bytes int(10) unsigned NOT NULL default '0',
>  browser_id mediumint(8) unsigned NOT NULL default '0',
>  language smallint(5) unsigned NOT NULL default '0',
>  local_visitor_id bigint(10) unsigned NOT NULL default '0',
>  process_time int(10) unsigned NOT NULL default '0',
>  proxy_software_id mediumint(8) unsigned NOT NULL default '0',
>  proxy_client_ip int(10) unsigned NOT NULL default '0',
>  auth_user_id int(10) unsigned NOT NULL default '0',
>  flag int(10) unsigned NOT NULL default '0',
>  session_id int(10) unsigned NOT NULL default '0',
>  doc_type smallint(5) unsigned NOT NULL default '0',
>  online_users smallint(5) unsigned NOT NULL default '0',
>  src_id int(10) unsigned NOT NULL default '0',
>  PRIMARY KEY  (counter_id,ts,id),
>  KEY visitor_id (visitor_id)
>) TYPE=MyISAM PACK_KEYS=1 DELAY_KEY_WRITE=1;
>
>which has:
>mysql> select count(*) from g00hits;
>+--+
>| count(*) |
>+--+
>|  3722867 |
>+--+
>1 row in set (0.01 sec)
>
>MYD file takes 300MB, text output 400MB
>
>With mysqldump which uses the following query to do this:
>
>SELECT * INTO OUTFILE '/spylog/test/g00hits.txt' FROM g00hits
>
>It takes:
>real1m23.177s   (first time)
>real1m20.934s   (second time)
>
>The backup table for the same table takes:
>
>first time:
>mysql> backup table g00hits to '/spylog/test';
>+--++--+--+
>| Table| Op | Msg_type | Msg_text |
>+--++--+--+
>| la00.g00hits | backup | status   | OK   |
>+--++--+--+
>1 row in set (22.60 sec)
>second time:
>
>mysql> backup table g00hits to '/spylog/test';
>+--++--+--+
>| Table| Op | Msg_type | Msg_text |
>+--++--+--+
>| la00.g00hits | backup | status   | OK   |
>+--++--+--+
>1 row in set (21.34 sec)
>
>
>Well. We have 4 times difference here, which is a bit strange as I
>would expect the disk speed should be the limit here, but not
>converting the rows in text format, which is in this case done at
>speed of 45000rows/second, which is not really much I think for this
>type of operation. Hope mysql does not use strcat to form the strings?
>
>
>Well. Let's try to do the restore:
>mysql> restore table g00hits from '/spylog/test';
>+--+-+--+--+
>| Table| Op  | Msg_type | Msg_text |
>+--+-+--+--+
>| test.g00hits | res

Some more info about backup.

[Michael Widenius]

Hi!

> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:

Peter> Hello mysql,
Peter>   I'm repeating my test's now with more information and on more
Peter>   powerfull maching with no load now, this should give more accurate
Peter>   results.
Peter>   The machine is Dual PIII-750/1GB RAM



Peter> With mysqldump which uses the following query to do this:

Peter> SELECT * INTO OUTFILE '/spylog/test/g00hits.txt' FROM g00hits

Peter> It takes:
Peter> real1m23.177s   (first time)
Peter> real1m20.934s   (second time)

Peter> The backup table for the same table takes:

Peter> first time:
mysql> backup table g00hits to '/spylog/test';
Peter> +--++--+--+
Peter> | Table| Op | Msg_type | Msg_text |
Peter> +--++--+--+
Peter> | la00.g00hits | backup | status   | OK   |
Peter> +--++--+--+
Peter> 1 row in set (22.60 sec)
Peter> second time:

Peter> Well. We have 4 times difference here, which is a bit strange as I
Peter> would expect the disk speed should be the limit here, but not
Peter> converting the rows in text format, which is in this case done at
Peter> speed of 45000rows/second, which is not really much I think for this
Peter> type of operation. Hope mysql does not use strcat to form the strings?

No, we are not using buffering for this.

I would guess that the speed difference would come from this:

- When you do BACKUP TABLE, the time you measure is just the time it
takes to copy the old file to the Linux internal disk buffer;  As Linux is
delaying the actual flush to disk until later, you will not see this.

- When doing SELECT * INTO OUTFILE, you are mostly measuring how long
  it takes to convert a LOT of numerical data to strings before
  writing this to disk.

  The speed ratio between copying 4 bytes and converting an int to
  string more than explains the time difference.

To get exact measurements of what is going on, you need a test where
the file is bigger than your memory!


Peter> Well. Let's try to do the restore:
mysql> restore table g00hits from '/spylog/test';
Peter> +--+-+--+--+
Peter> | Table| Op  | Msg_type | Msg_text |
Peter> +--+-+--+--+
Peter> | test.g00hits | restore | status   | OK   |
Peter> +--+-+--+--+
Peter> 1 row in set (1 min 31.16 sec)

Peter> and again:

mysql> restore table g00hits from '/spylog/test';
Peter> +--+-+--+--+
Peter> | Table| Op  | Msg_type | Msg_text |
Peter> +--+-+--+--+
Peter> | test.g00hits | restore | status   | OK   |
Peter> +--+-+--+--+
Peter> 1 row in set (1 min 30.41 sec)

mysql> load data infile '/spylog/test/g00hits.txt' ignore into table g00hits;
Peter> Query OK, 3722867 rows affected (8 min 35.73 sec)

mysql> load data infile '/spylog/test/g00hits.txt'  ignore into table g00hits;
Peter> Query OK, 3722867 rows affected (3 min 35.26 sec)

Peter> So it seems like cache really matters here, this would indicate bad
Peter> disk access way as this difference is to huge and is not found with
Peter> backup/restore table.

It could also be that Linux did a sync during the test.

Peter> Now without ignore:

mysql> load data infile '/spylog/test/g00hits.txt'  into table g00hits;
Peter> Query OK, 3722867 rows affected (3 min 34.75 sec)

Peter> So it seems like it does not really matter.

Ignore has identical speed as an insert, if there isn't a duplicate
key.

Peter> Well let's drop all indexes and try to load data fastest way ?

mysql> load data infile '/spylog/test/g00hits.txt'  ignore into table g00hits;
Peter> Query OK, 3722867 rows affected (1 min 56.16 sec)
Peter> Records: 3722867  Deleted: 0  Skipped: 0  Warnings: 0

mysql> load data infile '/spylog/test/g00hits.txt'   into table g00hits;
Peter> Query OK, 3722867 rows affected (1 min 56.38 sec)
Peter> Records: 3722867  Deleted: 0  Skipped: 0  Warnings: 0

mysql> alter table g00hits add primary key(counter_id,ts,id),add key(visitor_id);
Peter> Query OK, 3722867 rows affected (1 min 54.38 sec)
Peter> Records: 3722867  Duplicates: 0  Warnings: 0

Peter> So it does not give any improvement do add keys after loading date, it
Peter> seems to be allready optimal.

When you do a LOAD DATA to an empty file, MySQL will first insert the
data and the unique keys and then create the other keys in a batch..

Peter> So the diference in restore speed is about 3 times, which is not
Peter> really expected, but a bit better then I reported before, but anyway I
Peter> can't understand so huge difference for load data then text file fits
Peter> to cache or does not. Well may be it was because of some other random
Peter> events - I was not able to reproduce so slow speed anymore.

Peter> also look at the difference of vmstat between restore and load

Some more info about backup.

[Peter Zaitsev]

Hello mysql,

  I'm repeating my test's now with more information and on more
  powerfull maching with no load now, this should give more accurate
  results.
  The machine is Dual PIII-750/1GB RAM

  I'm trying the following table  structure:

CREATE TABLE g00hits (
  id int(10) unsigned NOT NULL auto_increment,
  counter_id int(10) unsigned NOT NULL default '0',
  visitor_id int(10) unsigned NOT NULL default '0',
  server_id smallint(5) unsigned NOT NULL default '0',
  ip int(10) unsigned NOT NULL default '0',
  ts timestamp(14) NOT NULL,
  method_id tinyint(3) unsigned NOT NULL default '0',
  http_ver_id tinyint(3) unsigned NOT NULL default '0',
  page_id int(10) unsigned NOT NULL default '0',
  referer_page_id int(10) unsigned NOT NULL default '0',
  status smallint(5) unsigned NOT NULL default '0',
  bytes int(10) unsigned NOT NULL default '0',
  browser_id mediumint(8) unsigned NOT NULL default '0',
  language smallint(5) unsigned NOT NULL default '0',
  local_visitor_id bigint(10) unsigned NOT NULL default '0',
  process_time int(10) unsigned NOT NULL default '0',
  proxy_software_id mediumint(8) unsigned NOT NULL default '0',
  proxy_client_ip int(10) unsigned NOT NULL default '0',
  auth_user_id int(10) unsigned NOT NULL default '0',
  flag int(10) unsigned NOT NULL default '0',
  session_id int(10) unsigned NOT NULL default '0',
  doc_type smallint(5) unsigned NOT NULL default '0',
  online_users smallint(5) unsigned NOT NULL default '0',
  src_id int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (counter_id,ts,id),
  KEY visitor_id (visitor_id)
) TYPE=MyISAM PACK_KEYS=1 DELAY_KEY_WRITE=1;

which has:
mysql> select count(*) from g00hits;
+--+
| count(*) |
+--+
|  3722867 |
+--+
1 row in set (0.01 sec)

MYD file takes 300MB, text output 400MB

With mysqldump which uses the following query to do this:

SELECT * INTO OUTFILE '/spylog/test/g00hits.txt' FROM g00hits

It takes:
real1m23.177s   (first time)
real1m20.934s   (second time)

The backup table for the same table takes:

first time:
mysql> backup table g00hits to '/spylog/test';
+--++--+--+
| Table| Op | Msg_type | Msg_text |
+--++--+--+
| la00.g00hits | backup | status   | OK   |
+--++--+--+
1 row in set (22.60 sec)
second time:

mysql> backup table g00hits to '/spylog/test';
+--++--+--+
| Table| Op | Msg_type | Msg_text |
+--++--+--+
| la00.g00hits | backup | status   | OK   |
+--++--+--+
1 row in set (21.34 sec)


Well. We have 4 times difference here, which is a bit strange as I
would expect the disk speed should be the limit here, but not
converting the rows in text format, which is in this case done at
speed of 45000rows/second, which is not really much I think for this
type of operation. Hope mysql does not use strcat to form the strings?


Well. Let's try to do the restore:
mysql> restore table g00hits from '/spylog/test';
+--+-+--+--+
| Table| Op  | Msg_type | Msg_text |
+--+-+--+--+
| test.g00hits | restore | status   | OK   |
+--+-+--+--+
1 row in set (1 min 31.16 sec)

and again:

mysql> restore table g00hits from '/spylog/test';
+--+-+--+--+
| Table| Op  | Msg_type | Msg_text |
+--+-+--+--+
| test.g00hits | restore | status   | OK   |
+--+-+--+--+
1 row in set (1 min 30.41 sec)

mysql> load data infile '/spylog/test/g00hits.txt' ignore into table g00hits;
Query OK, 3722867 rows affected (8 min 35.73 sec)

mysql> load data infile '/spylog/test/g00hits.txt'  ignore into table g00hits;
Query OK, 3722867 rows affected (3 min 35.26 sec)

So it seems like cache really matters here, this would indicate bad
disk access way as this difference is to huge and is not found with
backup/restore table.

Now without ignore:

mysql> load data infile '/spylog/test/g00hits.txt'  into table g00hits;
Query OK, 3722867 rows affected (3 min 34.75 sec)

So it seems like it does not really matter.


Well let's drop all indexes and try to load data fastest way ?

mysql> load data infile '/spylog/test/g00hits.txt'  ignore into table g00hits;
Query OK, 3722867 rows affected (1 min 56.16 sec)
Records: 3722867  Deleted: 0  Skipped: 0  Warnings: 0

mysql> load data infile '/spylog/test/g00hits.txt'   into table g00hits;
Query OK, 3722867 rows affected (1 min 56.38 sec)
Records: 3722867  Deleted: 0  Skipped: 0  Warnings: 0


mysql> alter table g00hits add primary key(counter_id,ts,id),add key(visitor_id);
Query OK, 3722867 rows affected (1 min 54.38 sec)
Records: 3722867  Duplicates: 0  Warnings: 0

So it does not give any improvement do ad

RE: more info on a re-install nightmare

[richard]

re: my last email on a failed mySQL database install
sorry !

forgot hte os etc...

OS : RedHat 7.0
running on a Del CPi laptop with 128MEG ram, 4GIG Hd, pentII 266 CPU.


Richard
[EMAIL PROTECTED]
www.stirlingbrig.com
Stirling Brig - Music to Live to

"Great spirits have always encountered violent opposition from mediocre
minds."
  -- Albert Einstein


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

GROUP BY gives inconsistent .. (more info)

[James Treworgy]

By the way, if I rewrite the SQL without calculated fields, e.g.
instead of defining @MyYear, @StartMonth, and @EndMonth as variables
but rather duplicating the SQL to create a MyYear (and the others) column
and then inside the larger formula for Period, it works.

-- Jamie

The following statement:

SELECT Date, @MyYear := year(Date) AS MyYear, @StartMonth := 
floor((month(date)-1)/3)*3+1 AS StartMonth,
@EndMonth := floor((month(date)-1)/3)*3+3 AS EndMonth,
@Period := 
concat(left(monthname(concat('1-',@StartMonth,'-2000')),3),'-',left(monthname(concat('1-',@EndMonth,'-2000')),3),'
 ',year(date)) AS Period,
@Pgroup := CONCAT(@MyYear,@StartMonth,@EndMonth),
Avg(Operator_Courtesy) AS Courtesy,
avg(Operator_Knowledge) AS Knowledge,
avg(Operator_Etiquette) AS Etiquette,
avg(Overall_Impression) AS Overall FROM tbl_PhoneTester GROUP BY Period

gives incorrent and inconsistent results.  Server 3.23.31.

...



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

sometimes hanging query - more info

[Karl Sloth]

y fast. 
I just have not been able to track down what causes this query to be so
slow at times and very fast at others.

MySQL version: 3.23.32
OS: SuSE Linux (2.2.10 kernel)
System: PIII w/ 256Mb RAM

Let me know if more info is required

TIA.

-karl

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: wait_timeout? More Info.

[Patrick Meyer]

Primarily the database serves the web server so it is always the same host.
The database may vary, but some more than others.  I feel confident that
some path through an ASP either crashes or the connection close command is
never reached or does not exist.   However, I would think that the timeout
would still kill those they are sleeping... for days.

BTW, I am running 2.23.32 on Win2K.

I have been trying to come up with an easy way to know which ASP has the
error in it.  Only thing I can think of is to create dozens of usernames and
use a different one in each file ick... that will take some time.

[EMAIL PROTECTED]


- Original Message -
From: "Jeremy D. Zawodny" <[EMAIL PROTECTED]>
To: "Meyer, Patrick" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, February 01, 2001 2:48 AM
Subject: Re: wait_timeout?


> On Tue, Jan 30, 2001 at 12:26:34PM -0600, Meyer, Patrick wrote:
> >
> > I am slowly gaining connections to the database that just sleep.  I
> > know these can arise from not closing the database.  I am accessing
> > it via MyODBC from Active Server Pages.  However, I set wait_timeout
> > to 3600... I have some that have been there for days... just
> > sleeping.  Why doesn't MySQL disconnect them from the timeout?
> > Maybe I just don't understand wait_timeout.
>
> That's odd.
>
> I haven't had the need to use wait_timeout, so I can't say what you
> should expect. But I'd expect that it should work as documented.
>
> Do they appear to have anything particular in common? Same
> host/user/db?
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 328-7878Fax: (408) 530-5454
> Cell: (408) 439-9951
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php