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 version. Probably is not much relevant any more.
--
Peter Zaitsev, CEO, Percona Inc.
Tel: +1 888 401 3401 ext 501 Skype: peter_zaitsev
24/7
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 Expert
MySQL Performance Blog
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
MySQL
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
or via triggers.
How can I ensure isolation for queries
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
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 their application.
--
Peter Zaitsev, MySQL Performance Expert
MySQL
412922528564
-/+ buffers/cache: 5403722576052
Swap: 1020088 20548 999540
Peter Zaitsev wrote:
Hi,
I'm not on the MySQL list so let me write to you directly.
Are you using MyISAM Tables ?
Yes. I am using the default format.
How does SHOW CREATE TABLE
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, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
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 Engineer
Come to hear my talk at MySQL UC 2005 http://www.mysqluc.com/
MySQL AB
--
Peter Zaitsev, Senior Performance Engineer
Come to hear my talk at MySQL UC 2005 http://www.mysqluc.com/
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
exact same hardware. Thoughts?
-J
--
Peter Zaitsev, Senior Support Engineer
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives
--
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.mysql.com/[EMAIL
regards,
Bostjan Skufca
system administrator
Domenca d.o.o.
Phone: +386 4 5835444
Fax: +386 4 5831999
http://www.domenca.com
--
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
'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.com/uc2004/
--
MySQL General Mailing List
For list
and the .MYI is only 3GB and the .MYD is 12GBnot
a good sign.
Check myisam_max_sort_file_size, myisam_max_extra_sort_file_size and
myisam_sort_buffer description and values.
You shall be able to make Repair happening by Sort unless it is unique
index, which is much faster.
--
Peter Zaitsev
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: http://lists.mysql.com/mysql
To unsubscribe:http
/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)
http://www.mysql.com/uc2004/
--
MySQL General Mailing
)
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
Want to swim
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/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Peter Zaitsev [EMAIL PROTECTED
privelege.
So ISPs should be only happy with this change :)
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Peter Zaitsev [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Moscow, Russia
___/ www.mysql.com
are able to create small repeatable case you may send it in the mail.
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Peter Zaitsev [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Moscow, Russia
, visit https://order.mysql.com/?ref=mpza
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Peter Zaitsev [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Moscow, Russia
___/ www.mysql.com M: +7 095 725 4955
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 backup
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
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 update
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
.
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 problem once - then having many active connections (and
so threads) mysql speed may degrade a lot because of scheduling and
convergency problem
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,
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
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 deleted the
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
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) the
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 limit
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
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 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 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:
l/var\-DSHAREDIR=\/usr/local/mysql
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 just fine with glibc 2.2.4 on a current
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
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
½ found
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 |
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:
maindb:/spylog/mysql/logs # date
Tue Aug 7 13:31:56 MSD 2001
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 seems like you made an incomportable changes in 3.23.40 without
Peter taking a time
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
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 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,
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
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 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 -
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
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 21:24:05 MSD
Peter 2001 i686 unknown
Peter SUSE 7.1 (GLIBC 2.2.x)
Peter
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 table
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 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 which
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/Linux 2.4.2 glbc 2.1.3
Peter I had the follow
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
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
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
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
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 database to
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
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 if your
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 run
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 recovery speed.
In my case the data
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 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 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
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+ of the
support 4GB+ files?
Sander -Original Message- From: Peter Zaitsev [mailto:[EMAIL PROTECTED]]
Sent: 22 February 2001 19:52 To: [EMAIL PROTECTED] Subject: Innobase
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
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
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 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
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
Peter
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 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 realy may deadlock
SM sometimes, and the funny thing
Hello Miguel,
Wednesday, February 07, 2001, 5:52:50 AM, you wrote:
MAS I have made the following table on Win2000 machine:
C:\mysql\binmysql
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;' or
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
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 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 table on BDB tables:
Peter `CHECK TABLE' only works
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:
Hello Michael,
Tuesday, January 23, 2001, 2:02:33 AM, you wrote:
Peter I saw this many times on different machines and this sequince never
Peter resolves itself ( the locks never disapears). Always the only way to
Peter fix this is to kill one of the queries. I killed query #16 and
Peter
Hello bugs,
Linux. Mysql 3.23.30 (also checked with 3.23.25). Problem appears with
repear table as well as myisamchk.
The problem is quite strange. Then repair table or myisamchk repears
the table, which is empty it grows a index file until it reaches
it's limit 2GB. And then it says
88 matches
Mail list logo