requires updates to be
serializable to work.
>
>
> Can give problems for portable applications if you port from MySQL-4.0 to
> later
>
> What's the meaning about this sentence?
>
>
>
This means you can run into the problems if you upgrade from MySQL 4.0 to
later ve
Ed Pauley II wrote:
Continuent's m/cluster will not work for me as it does not allow
replication across a WAN. We have an offsite backup that needs to be in
the replication (2-way to make switching back and forth easy) chain. I
am thinking of a master, slave setup at each location where
On Mon, 2006-08-07 at 09:49 +0100, Lexington Luthor wrote:
> Peter Zaitsev wrote:
> > Hi,
> >
> > One of approaches is to have "shadow" MyISAM table in addition to your
> > Innodb table to perform full text search, which you can update in bulks
>
ize which is 16M by default.
I would be very careful using blobs larger than 100MB. MySQL will need
some 3 times of this size of memory allocated on the server for blob
processing.
--
Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
My
"shadow" MyISAM table in addition to your
Innodb table to perform full text search, which you can update in bulks
or via triggers.
You also can try sphinx: http://www.sphinxsearch.com/ which works with
any storage engine and also much faster.
--
Peter Zaitsev, MySQL Performance
ight want to kick it up.
For very basic setup you even can use DNS for load balancing, which does
not solve many of the problems describe.
The same kind of simple load balancing is build in MySQL JDBC Driver.
In general everyone seems to implement something on their own, working
well for the
--+--++-+
>
> #>free
> total used free sharedbuffers cached
> Mem: 3116424 3110228 6196 0 412922528564
> -/+ buffers/cache: 5403722576052
> Swap: 10
binary compiled on SuSE SLES is known to crash on RH AS
in some cases.
We have great adoption of opteron platform among our customers with
great success rate, so I'm quite surprised by extent of problems you're
having.
--
Peter Zaitsev, Senior Performance Engineer
MySQL AB, w
h I assume means I'm now running deadline. Is there any other way
> > to find out?)
> >
> > And no performance diff. Note that you're benchmarks only show a 20M
> > addition overhead. We're about 60x too slow for these drives so I'm not
>
he line
(16K for Innodb tables)
The thing is by default many RAID controllers would put cacheline size
= stripe size, some may not even allow to change it.
If it is the case MySQL will have to read a lot of unnecessary data
which will kill performance.
--
Peter Zaitsev, Senior Performance E
n_MANY_tables 59 1110 10
>
>
> Column A is MySQL 3.23.58
> Column B is MySQL 4.0.15
> Column C is MySQL 4.0.16
> Column D is MySQL 4.0.17
> Column E is MySQL 4.0.20
>
>
> The biggest problem is the create set. That's a HUGE difference in the
>
new test cases
--
Peter Zaitsev, Senior Support Engineer
MySQL AB, www.mysql.com
Meet the MySQL Team at User Conference 2004! (April 14-16, Orlando,FL)
http://www.mysql.com/uc2004/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
ese (and other) differences come from?
>
>
> PS: I would be very pleased if I could see hardware description / my.cnf /
> sql-bench results from you to see if I am on the right way and how much
> headroom do I still have. (Currently my "run-all-tests" script finishes wit
;
> I get - Unknown system variable 'lower_case_table_names'
>
This is startup option. Did you use it as such (in my.cnf) ?
--
Peter Zaitsev, Senior Support Engineer
MySQL AB, www.mysql.com
Meet the MySQL Team at User Conference 2004! (April 14-16, Orlando,FL)
http://www.mysql.c
ou shall be able to make Repair happening by Sort unless it is unique
index, which is much faster.
--
Peter Zaitsev, Senior Support Engineer
MySQL AB, www.mysql.com
Meet the MySQL Team at User Conference 2004! (April 14-16, Orlando,FL)
http://www.mysql.com/uc2004/
--
MySQL General Mailing List
says 31: http://www.mysql.com/information/crash-me.php?res_id=49 ,
> search for "tables in join".
One can get 63 by Recompiling MySQL if it helps.
--
Peter Zaitsev, Senior Support Engineer
MySQL AB, www.mysql.com
Meet the MySQL Team at User Conference 2004! (April 14-16, Orlando,FL)
t backup.
As Innob has versioning these selects will not lock anything.
--
Peter Zaitsev, Senior Support Engineer
MySQL AB, www.mysql.com
Meet the MySQL Team at User Conference 2004! (April 14-16, Orlando,FL)
http://www.mysql.com/uc2004/
--
MySQL General Mailing List
For list archives:
ter this month)
Ranger could you please send to Ram our current version ?
You can also try OSDB - AS3AP implementation in C.
P.S For benchmarks issues it is better to use [EMAIL PROTECTED]
list which is dedicated for this purpose.
--
Peter Zaitsev, Full-Time Developer
MySQL AB, www.mysql.com
I would recommend you to posting your message to most appropriate
mailing list instead of both. Many users are subscribed to both mailing
list and they will get your message twice.
--
MySQL 2003 Users Conf. -> http://www.mysql.com/events/uc2003/
__ ___ ___ __
/ |/ /_ __/
if you need user which can
see all databases you can grant him SHOW_DATABASE privelege.
So ISPs should be only happy with this change :)
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Peter Zaitsev <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL A
source of the problem and if problem persist upload them into secret
directory at ftp://support.mysql.com
If you are able to create small repeatable case you may send it in the mail.
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Peter Zaitsev <[EMAIL PROTECTED]>
/ /|_/
read large volumes of data across server farm.
I hope this solutions will help you. I'm sure you're going to
benchmark them. Could you please post results into the list so all
customers will see which benefit they may get.
--
For technical support contracts, visit https://order.m
Hello Adriano,
Friday, March 29, 2002, 11:38:32 PM, you wrote:
As I remember there are max_allowed_packet options exists both for
client and server. You may wish to try to raise both of them.
AM> I've been using a perl script to insert a very large blob (up to about 8
AM> MB) into a DB succes
Hello Jeremy,
Friday, March 29, 2002, 3:10:35 AM, you wrote:
>> Also a good thing with DRBD you will not have to store and track
>> replication log files and the setup will not require to take MySQL
>> down to copy the snapshot of database.
JZ> Why would you need to take down MySQL for a back
Hello Tab,
Friday, March 29, 2002, 10:05:20 PM, you wrote:
Which table type do you use ? Well if you do not know it's probably
MYISAM. In this case you may use BACKUP TABLE to make a quick
consistent backup of the table. If you want to have consistent
snapshot of several tables you may use "loc
Hello Michael,
Friday, March 29, 2002, 10:22:27 PM, you wrote:
MZ> Hello all,
MZ> sorry, if I nerve you with a problem, which is allready known -
MZ> I didn't find appropr. info in the FAQs (or was too stupid to look
MZ> at the right place?)
MZ> Trying database replication with cross-wise upda
hread package. Therefore this
packages are not quite well tested with mysql yet.
SI> - Sam.
SI> On Monday, March 11, 2002, at 06:06 AM, Peter Zaitsev wrote:
>> Hello Michael,
>>
>> Monday, March 11, 2002, 3:38:28 PM, you wrote:
>>
>>
>> I had a close proble
Hello Jens,
Wednesday, March 27, 2002, 2:43:22 PM, you wrote:
We have tried to use DRBD with MySQL/EXT3/NFS and some other
applications. Generally it works rather good, showing rather nice
performance.
The only problem we had was problem with EXT3 corruption, which was in earlier
(2-3 months)
Hello mysql,
I've found benchmark for MySQL on Linux with NGPT - the Solaris-like
pthread compatible threads for Linux, the stable version 1.2.0 of
which just was released.
The user tested mysql server from binary distribution vs self
compiled with NGPT. 2.4.19-pre3 kernel was used.
Hello mysql,
Some time ago I wrote about slow down of mysql with large number of
threads, which is quite common in Linux-Apache-Mysql-PHP enviroment.
The test was simulating the worst case of concurrency - all the
threads are modified global variable in a loop 500 times in
total, u
Hello Michael,
Monday, March 11, 2002, 3:38:28 PM, you wrote:
I had a close problem once - then having many active connections (and
so threads) mysql speed may degrade a lot because of scheduling and
convergency problem. This does not explain the mysql lock itself, but
may be the reason (i.e t
Hello Heikki,
Saturday, January 05, 2002, 11:55:02 PM, you wrote:
>>Hello mysql,
>>
>> I'm using mysql 3.23.47 with Innodb and trying to play around with
>> replication. The replication options are default.
>>
>> I got one table content occasionally deleted on slave, and note what
HT> Who
Hello mysql,
I'm using mysql 3.23.47 with Innodb and trying to play around with
replication. The replication options are default.
I got one table content occasionally deleted on slave, and note what
this did not stop the replication: The inserts are successfully
passed, therefore the u
Hello Sinisa,
Wednesday, January 02, 2002, 6:21:59 PM, you wrote:
No. This happens then mysql is completely restarted.
I Understand this should not happen but somehow it does.
>> I've found the following problem often happens to me:
>> Then mysqld restarted unclear (sigsegv or server reset) t
Hello mysql,
I've found the following problem often happens to me:
Then mysqld restarted unclear (sigsegv or server reset) the mysql
client library may hang during the automatic reconnect. The backtrace
is similar to this and does not changes other time (at least 2 hours
is not enough for it)
Hello mysql,
Running Linux 2.4.x SMP/innodb.
This query works OK.
mysql> explain SELECT cp.counter_id, tg.tbl, cs.host
-> FROM counter.table_groups AS tg, counter.counterproperty AS cp, counter.servers
AS cs
-> WHERE tg.tblid=cp.tblid AND tg.server=1 AND cs.SERVER_ID=tg.server lim
Hello Heikki,
Wednesday, November 21, 2001, 8:34:13 PM, you wrote:
I see some more users are interested in optimize table to work.
Why don't you just map OPTIMIZE TABLE to ALTER TABLE for INNODB tables
so user may not care about table type, there currently one should
check the table type and use
Hello mysql,
Could anyone tell me if heap tables are cyrrently working with
replication.
As I remember some time ago you might get problems then server
restarts (so empty it's heap tables) there fore slave does not and
so it gets dublicate key errors on inserts to this tables, which is
Hello mysql,
Hello mysql,
I'm quite lucky with providing with bad tables which does not repear
properly or having other strange behavior.
Here is one more:
mysql 3.23.42
gnome:~ # mysqldump -d layers_st57 g01kw_engines
# MySQL dump 8.16
#
# Host: localhostDatabase: layers_st57
#--
Hello Trond,
Thursday, August 23, 2001, 8:01:33 PM, you wrote:
TEG> Peter Zaitsev <[EMAIL PROTECTED]> writes:
>> I'm trying to compile mysql 3.23.41 with recent glibc 2.2.4 but this
>> somehow does not work with the following diagnose:
TEG> It builds ju
Hello Sinisa,
Thursday, August 23, 2001, 3:42:53 PM, you wrote:
SM> Peter Zaitsev writes:
>> Hello mysql,
>>
>> I'm trying to compile mysql 3.23.41 with recent glibc 2.2.4 but this
>> somehow does not work with the following diagnose:
>>
>>
Hello mysql,
I'm trying to compile mysql 3.23.41 with recent glibc 2.2.4 but this
somehow does not work with the following diagnose:
l/var\""-DSHAREDIR="\"/usr/local/mysql/share/mysql\""
-DHAVE_CONFIG_H -I../bdb/build_unix -I../innobase/include
Hello mysql,
I was trying to load very huge (5GB 45mil rows) to the text dump in
sorted order (according to primary key).
The problem is mysql somehow does not wants to scan the table by
primary key to produce sorted output row by row, but prefers to use
filesort which would take quite
Hello ½ÉÃ溸,
Friday, August 10, 2001, 2:27:56 PM, you wrote:
DISABLED means you're running with --skip-innodb AFAIK :)
½> Hi everyone.
½> I uninstalled mysql and reinstalled using --with-innodb configuration.
½> After install completed, I entered the command mysqladmin variables and
½> foun
) Plain .40 with new INNODB with doublewrite -> This binary shiftes
the time.
Could you Heikke please check if you have something similar ?
MW> Hi!
>>>>>> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter>> Hello mysql,
Peter>> It s
the wrong time ?
SM> Peter Zaitsev writes:
>> Hello mysql,
>>
>> It seems like you made an incomportable changes in 3.23.40 without
>> taking a time to write a release note :(
>>
>> The mysql 3.23.39 used the system timezone by default:
>>
>
Hello mysql,
It seems like you made an incomportable changes in 3.23.40 without
taking a time to write a release note :(
The mysql 3.23.39 used the system timezone by default:
maindb:/spylog/mysql/logs # date
Tue Aug 7 13:31:56 MSD 2001
| transaction_isolation | READ-COMMITTE
Hello Jamie,
Tuesday, July 17, 2001, 7:40:03 AM, you wrote:
If I'm not mistaken this was other bug. At least I remember I've
reported really same looking bug which make sometimes mysql hang after
optimize or repair table (may be alter table also had it).
JM> I've been experiencing a simmilar p
Hello Denis,
Tuesday, July 10, 2001, 12:51:40 PM, you wrote:
If I'm not mistaken the problem is - conflicting transactions which
you have here. I'm really not shure INNODB dead lock detection is
quite fine graned. Also it's shurely may roll back more long running
transaction. But anyway you
Hello Michael,
Wednesday, July 04, 2001, 1:49:25 AM, you wrote:
MW> Next time the table gets corrupt, please upload a copy to 'secret'
MW> before you repair it so that I can take a look at this when I come
MW> back.
OK.
MW> Do you have anything in the logs about the table being automaticly re
Hello mysql,
It seems like if load data infile initiated to dammaged table
sometimes after repair it does not unblock itself:
maindb:/spylog/db/tmpd # mysqladmin processlist | grep -v Sleep
++--++---+-+---+--+
Hello Michael,
Thursday, June 28, 2001, 11:41:57 PM, you wrote:
I'm getting this again and again with two tables which are used in
quite the same fation - some selects, often updates, rare inserts, no
deletes:
mysql> repair table counter.quickstat;
+---++--+-
Hello Michael,
Thursday, June 28, 2001, 1:52:09 PM, you wrote:
MW> Hi!
>>>>>> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter>> Hello monty,
Peter>> after upgrading mysql 3.23.36 to mysql 3.23.29 I started to get a
Peter>>
Hello mysql,
Resently MYSQL have introduced transaction support, which at least
in INNODB allows to make consistent backup/recovery. The bad thing
about this is - MYSQLDUMP does not support anything about this, so I
had to done the same things buy hands.
The Idea is quite simple - to
Hello mysql,
I'm planing to use transactions in application written in PHP, which
of course uses pconnect to optimize perfomance.
Few time ago I had to stop using "lock tables" as this lead to
locked system then somehow the php script was aborted before unlock
tables.
With transacti
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
Hello mysql,
Today I played a little bit with two different ways of backup -
first one is to use BACKUP TABLE (which works for myisam only) and
the second one is SAVE DATA/LOAD DATA.
In both cases if I'm not mistaken the file is wrote by mysqld server
so there is no communication overh
Hello Michael,
Thursday, May 31, 2001, 11:19:03 PM, you wrote:
MW> Hi!
>>>>>> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter>> Hello bugs,
Peter>> mysql 3.23.38
Peter>> Linux diamond 2.4.4.SuSE-12-4GB-SMP #8 SMP Sat May 19
Hello mysql,
I'm testing BDB tables in mysql to find out i'll be able to use
them in my application.
I was testing how does big tables work with BDB and so created table
which is about 10GB in size. I could easy make it with multiple
inserts from test-insert, so the problem with inse
Hello mysql,
Currently mysql waits until disk space freed for myisam tables for
all situations exept of repair and optimize.
Even more table is marked as crashed and will not repair
automatically even after disk space freed.
This situation is not really good thing i think, as if r
Hello Heikki,
Wednesday, May 16, 2001, 4:01:26 PM, you wrote:
HT> Andreas,
HT> sorry, it is the default MySQL behavior to create a MyISAM table if
HT> another handler is not present.
HT> There was a long thread of emails between MySQL developers if MySQL
HT> should give an error message if a t
Hello mysql,
It seems like mysql sometimes tries to hard to repair the table with
myisam tables with fixed row format.
I've had a chance to several times found data in one of the tables
completely destroyed - the data looked like random.
mysql> select * from g01layers_stat_cities limit
Hello mysql,
Any ideas how this may happen:
Mysql version 3.23.37, auto recovery turned on.
mysql> check table layers_st50.g00stat_sitepaths;
+---+---+--++
| Table | Op| Msg_type | Msg_text
Hello Michael,
Sunday, April 08, 2001, 4:21:18 AM, you wrote:
Peter>> No it's not but it has just a couple of collisions per 100.000
Peter>> records.
MW> The problem with a not unique key is that MySQL will do an extra check
MW> if it should use the key during the optimization stage. If the
Hello Michael,
Saturday, April 07, 2001, 3:14:42 AM, you wrote:
MW> Hi!
>>>>>> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter>> Hello mysql,
Peter>> I made one more test of mysql perfomance.
Peter>> PIII-700/768Mb/L
Hello Tim,
Saturday, April 07, 2001, 3:21:52 AM, you wrote:
>> The reason singly queries are slower are of course that the
>> initialization phase (reading the data from a socket, parsing,
>> locking, checking which keys to use) is about half of the query time.
>>
>> Peter> Heikki made tests
Hello mysql,
I made one more test of mysql perfomance.
PIII-700/768Mb/Linux 2.4.2 glbc 2.1.3
I had the followings table with 12.000.000 rows (well I checked
this with 1 rows as well but the speed does not differs much)
in it and I checked how fast I can select data by hash ke
Hello mysql,
I've resenty tried to becnhmark mysql in really simple case.
I need to select indexes really fast so I did "select * from pages
where hash=11" there was a key on hash and the query returned only
one row. The query was constant and server ad no other load.
I've run this on
Hello ,
Few time ago I've started to get the following problems, which several
times allready lead to data lost for me.
Here is the example:
I found the followings in my application error log:
Query - #1017 [opal.local] - Can't find file: 'g04stat_languages.MYD' (errno: 2)
select visitors,loa
Hello mysql,
Resently I've found a problem when I was trying to upgrade from
3.23.32 to 3.23.36, well I had a same problem then tried to upgrade
to 3.23.33 so decided to wait a bit, but now i think I should check
more about this.
The problem is the followings: Sometimes then I rename a
Hello Heikki,
Monday, March 19, 2001, 4:40:30 PM, you wrote:
>>Also the problem with innobase_flush_log_at_trx_commit=0 should be
>>there is no guarantie the last transaction commited will be on it's
>>place if the power would be lost. Also I don't know is it possible in
>>this case for databa
Hello Greg,
Sunday, March 18, 2001, 9:29:45 PM, you wrote:
>> The only problem I see here - i don't know how innobase/bdb will
>> handle tables without primary key... i think perfomance should not be
>> so good as with myisam. Still there is a possibility to load all data
>> to myisam and then
Hello Christian,
Sunday, March 18, 2001, 12:22:44 PM, you wrote:
>>
>>If you are going to be committing on every record, you'll want your
>>tablespace and logfile directories on separate disks to avoid
>>thrashing. If you only have one disk and don't care if you lose the
>>last few transactions
Hello Andreas,
Saturday, March 17, 2001, 6:36:17 PM, you wrote:
AV> I noticed that in 3. and 4. the machine load was constantly at 100% during
AV> the inserts.
AV> but during index recreation the load springs wildley between 0 and 100%, so
AV> the machine is not maxed out in terms of CPU utili
Hello Greg,
Saturday, March 17, 2001, 3:31:53 AM, you wrote:
GC> It would be very handy if Innobase (and the GEMINI when it comes along)
GC> where to support mysqldump in the standard way, as I assume it works as
GC> such and I and many others would have to change thier backup scripts.
GC> Del
Hello Michael,
Wednesday, March 14, 2001, 4:41:21 PM, you wrote:
Peter>> Well I tried to do so but still it takes an amount of time to add the
Peter>> indexes...
Peter>> I think the good Idea would be to add to mysqldump an option to create
Peter>> the table without index, then insert all data
Hello Heikki,
Finally I was able to check the innobase tables included into mysql
3.23.34. Well first several times I was quite happy about them, but
later understud that this is because option --create-options is
broken :)
So now I must say On my system innobase seems to work as bad
Hello Dan,
Tuesday, March 13, 2001, 6:37:16 PM, you wrote:
DN> In the last episode (Mar 13), Peter Zaitsev said:
>> Well guys mysqldump have one serious problem - the speed.
>>
>> The backup speed is quite upsetting and loads system much, but the
>> worst thing is re
Hello Heikki,
Monday, March 12, 2001, 11:51:54 PM, you wrote:
HT> Hi Peter,
HT> and sorry that this response to your Big Mail comes some 12 days late.
HT> We have put together the release 3.23.34a and that has occupied
HT> my mind.
No Problem. At least the progress is going :) I'll try to test
Hello Heikki,
Tuesday, March 13, 2001, 1:31:04 AM, you wrote:
HT> Joshua,
>>I hope you can also use MySQL dump, in which case, you don't have to shut
>>down, right?
HT> yes, you can use mysqldump without shutting down. It did not come to my
HT> mind that actually mysqldump is a kind of online
Hello Sinisa,
Thursday, March 01, 2001, 3:42:46 PM, you wrote:
SM> > I'm not really shure if this is a bug or correct behavior, but still
SM> > it leads to toe problems in this case:
SM> >
SM> > insert into g02layers_stat_hits set counter=1, type=1, page_group=1;
SM> > ERROR 1062: Duplicat
Hello mysql,
Mysql 3.23.32 running on Linux.
I've got a table with auto_increment command stuck, well this is no
problem there is a record in this table with MAX_UINT value.
I'm not really shure if this is a bug or correct behavior, but still
it leads to toe problems in this case:
insert int
Hello Mike,
Wednesday, February 28, 2001, 3:55:35 AM, you wrote:
You should know what you can't do direct comparasions between float
number and float const as the number really stored in a database can
be slightly different i.e
355.619
M
Hello Heikki,
Monday, February 26, 2001, 5:08:52 PM, you wrote:
HT> Hi!
HT> There were more questions about Innobase:
>>Here is the comming question - can you speak some more about apace
>>allocation consepts used in innobase. For example how would it like to
>>work with huge number (10.000+ o
ation (i.e several tablespaces
with external mirroring) it will be hard to recover.
Other question - files sizes. Does innobase itself support 4GB+ files?
>>Sander> -Original Message-> From: Peter Zaitsev [mailto:[EMAIL PROTECTED]]
>> Sent: 22 February 2001 19:52> To:
Hello mysql,
Today I got a chance to compile mysql 3.23.34 with innobase, so
althought it's not out yet I'll give some of my comments
The version I'm speaking about got from work.mysql.com
1) It does not even configure then trying to configure
--with-innobase-db the problem is autocon
Hello Heikki,
Monday, February 19, 2001, 5:24:10 PM, you wrote:
HT> Peter,
HT> I guess you mean the source tree at www.bitkeeper.com? The interface
HT> file ha_innobase.cc can be found there, but not yet the Innobase
HT> source, I think. Then it cannot yet be compiled from the source tree,
HT>
Hello mysql,
Good day.
I'm now trying to build mysql 3.23.34 aviable in bitkeeper tree, to
get a chance to check innobase table handler before release is out,
to make chance for release to be more stable :)
Currently I have the following problem - innobase is allready in
tree but con
Hello monty,
I'm trying to use merge table for logging - to have a possibility to
Rotate log files and to quickly delete old data - for this I'm goint
to setup a number of merge tables where each contains data for one
day, and the inserts are done to the last table using real table
name
Hello Michael,
Friday, February 09, 2001, 3:48:53 AM, you wrote:
Peter>> as you see here one thread is doing repear as this happened after
Peter>> mysqld crash, but note first insert query in system lock state (I've
Peter>> saw several queries at this place, but all of them spent in system
Pet
Hello mysql,
1) Today I tried to reload my tables with backuing up and recovering
whole database by mysqldump - it seems like it does not work -
mysqld crashed during loading data back even after I've removed all
bad tables and bdb logs to have a clean system.
This looks like the same
Hello Michael,
Thursday, February 08, 2001, 1:58:24 AM, you wrote:
Peter>> I've done mysqladmin "flush logs" and then copied the .frm and .db
Peter>> files into other database directory - and the bug was unable to be
Peter>> repaired.
MW> I assume you mean 'unable to be repeated' ?
Yes of co
Hello Miguel,
Wednesday, February 07, 2001, 5:52:50 AM, you wrote:
MAS> I have made the following table on Win2000 machine:
C:\mysql\bin>>mysql
MAS> Welcome to the MySQL monitor. Commands end with ; or \g.
MAS> Your MySQL connection id is 3 to server version: 3.23.30-gamma
MAS> Type 'help;'
Hello mysql,
mysql 3.23.32 + BDB 3.2.3h
mysql> select * from layers_la00.g03last_hit;
+++-+++
| updated| counter_id | stat_id | lasthit_ts | lasthit_id |
+++-++
Hello Sinisa,
Sunday, February 04, 2001, 3:15:21 PM, you wrote:
SM> Peter Zaitsev writes:
SM> > Hello Andreas,
SM> >
SM> > Thursday, February 01, 2001, 7:42:31 PM, you wrote:
SM> >
SM> >
SM> > I must confirm the problem with table locks. Mysql r
Hello Andreas,
Thursday, February 01, 2001, 7:42:31 PM, you wrote:
I must confirm the problem with table locks. Mysql realy may deadlock
sometimes, and the funny thing is the solution to this case is to kill
the oldest locked thread waiting this condition - afterwards
everything resolves. So th
Hello monty,
It seems like something changed in 3.23.31 and 32 in auto_repair
there.
I see on many servers after crash (i've resently got unexpected
powerdown for 10 of my machines so it worked like a good testcase) I
got tables failed to be repaired (or well selects fail on them)
28.Jan 12:26:
Hello Michael,
Friday, January 26, 2001, 12:20:43 AM, you wrote:
MW> Hi!
>>>>>> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter>> Hello monty,
Peter>> As I remember according to documentation MYSQL should support check
Peter>
Hello monty,
As I remember according to documentation MYSQL should support check
table on BDB tables:
`CHECK TABLE' only works on `MyISAM' and `BDB' tables. On `MyISAM'
tables it's the same thing as running `myisamchk -m table_name' on the
Hello monty,
I'm using mysql 3.23.32 on linux and it looks like there is a
problem with check/auto-recovery left:
On many of my servers I find the above in a log file:
24.Jan 23:45:07 : pid:1412 counter:32256 AllInOne MySqlEr
Query - #1034 [tor.local] - Incorrect key file for table: 'g09
1 - 100 of 104 matches
Mail list logo
