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
Claudi
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:
**
> Id: 30399
> User: root
> Host: localhost
> db: this would be my DB
> Command: Sleep
> Time: 0
> State:
> Info: NULL
>
> ----
t
> > *** 2. row ***
> > Id: 30399
> > User: root
> > Host: localhost
> > db: this would be my DB
> > Command: Sleep
> > Time: 0
> > State:
> > Info: NULL
> >
> ---
; Id: 30399
> User: root
> Host: localhost
> db: this would be my DB
> Command: Sleep
> Time: 0
> State:
> Info: NULL
> ------
> ---
>
> What I&#
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 examp
TED]
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-
mple 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 4000
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.
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
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,
-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 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 ex
anks
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
culate 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
>
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_P
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(som
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 =
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
ANA
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 n
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
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]
Su
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 kn
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 F
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, ope
) [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
ruary 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 sh
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\apa
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 Pa
-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 testca
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, op
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
nt: 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 rec
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 wrot
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
P
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) LI
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 'Stin
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.
-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 downgra
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 conta
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
incur
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),
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 ea
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 t
[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', Di
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
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
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
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
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 1
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
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
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 encounter
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 statemen
nd 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 man
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
56 matches
Mail list logo
