Anybody know? I tried every version after 5.0.19 and none allow me to do
concurrent inserts/load data into a myisam table, even with the new
force concurrent variable
we are stuck on 5.0.19 for now, any ideas?
matt_lists wrote:
We have been using older versions of mysql without any problem
We have been using older versions of mysql without any problem (5.0.19)
I updated our test server to 5.0.27
senario is.. temp table performs data conversion, master table is never
deleted/updated, only new records insert, insert takes 30-40 minutes for
bulk loads
under old mysql versions we
Would like to see this, there is a TMD temp table created during an optimize
is there any reason read only access cant take place during the optimize
process? Update/delete/insert shouldn't, but read access should be
allowed on myisam
any thoughts on this?
--
MySQL General Mailing List
why did they change this? I reverted everything to 5.0.19 and I'm
using load data infiles again, with zero locking issues
It has always been like that.
load data infile seems to use different logic from replace delayed,
it does not lock at all
What table type do you have in each
Not sure if this is a bug
we are updating a large table with replace delayed from our feeder
systems, 1000 records at a time using limit's on the input data pull
this works great when there's fast selects from the table, while the
insert is going
when a site does a large pull, which can
We did not see this on 5.0.19, with 5.0.24 our backup jobs lock the
tables for selects
the backup takes 3 hours, so the site is down the whole time
I'm using this backup line
mysqldump -d -f --quote-names --skip-add-locks database outfile
mysqldump -t -f --skip-add-locks database outfile
It's not a bug. I guess this is a myisam table?
http://dev.mysql.com/doc/refman/5.1/en/table-locking.html
Any time the table is changed with myisam, the whole table is locked.
That's the way it works.
Innodb doesn't do it this way but it might cause other issues for you.
Try changing the
chris smith wrote:
On 8/23/06, matt_lists [EMAIL PROTECTED] wrote:
We did not see this on 5.0.19, with 5.0.24 our backup jobs lock the
tables for selects
the backup takes 3 hours, so the site is down the whole time
I'm using this backup line
mysqldump -d -f --quote-names --skip-add-locks
chris smith wrote:
On 8/23/06, matt_lists [EMAIL PROTECTED] wrote:
Not sure if this is a bug
we are updating a large table with replace delayed from our feeder
systems, 1000 records at a time using limit's on the input data pull
this works great when there's fast selects from the table
suggestions or does it all seem fine.
CL
matt_lists wrote:
Get used to it, I've got similar tables, mine have less columns, but
more records, my biggest takes a week to restore a mysqldump
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Get used to it, I've got similar tables, mine have less columns, but
more records, my biggest takes a week to restore a mysqldump
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Having trouble building 5.0.x, 4.1.12 builds fine
The very first program to link bombs, I'm thinking some dll is not
registered, or a change in build directions between 4.1.x and 5.0.x the
error is less than helpful, as I'm a dba not a programmer.
Any sugestions? I can build 5.0.3, but not
Ooops, it would help if I put in the error message
Configuration: mysql - Win32 Debug
Linking...
mysqlclient.lib(mf_pack.obj) : error LNK2001: unresolved external symbol
_my_access
../client_debug/mysql.exe : fatal error LNK1120: 1 unresolved externals
currently.
Matt
Gleb Paharenko wrote:
Hello.
SHOW STATUS and a piece of SHOW PROCESSLIST
with slow queries could give additional information,
so the probability of the helpful answer grows.
matt_lists [EMAIL PROTECTED] wrote:
Anybody have any suggested settings for our my.ini ?
4 gig box, running
at tuning the memory on MySQL as well..
HTH
Mark
Mark Leith
Cool-Tools UK Limited
http://www.cool-tools.co.uk
-Original Message-
From: matt_lists [mailto:[EMAIL PROTECTED]
Sent: 28 April 2005 13:57
To: Gleb Paharenko
Cc: mysql@lists.mysql.com
Subject: Re: Maximize mysql ini for 4gig big
Anybody have any suggested settings for our my.ini ?
4 gig box, running windows 2003
peak memory usage for mysql is 1.4 gig currently
using myisam files, lots of little index querys, and some very large
queries at night
615 tables, 88.3 gb of myd, 45.2 gb of myi, 33 of the tables/indexes
break
I'm glad I'm not the only one that thinks the logging in mysql blows chunks
Every other piece
of server software can log it's authentication issues and disposition,
why can't MySQL? Oracle can do this, Postgres, DB2, etc etc etc.
--
MySQL General Mailing List
For list archives:
5.0.2 has a huge bug, you cant use most gui's with it
so all command line
5.0.3 fixes, but I cant get it to compile on vc++ 6.0 always errors out :(
most say use 5.0.1, but that's got a ton of bugs that 5.0.2 fixed
we are patiently waiting for 5.0.3 so we can test out stored procedures
--
MySQL
Jeff Smelser wrote:
On Tuesday 22 February 2005 09:08 am, Johan Jonkers wrote:
I was wondering if there is a way to specify how verbose the logfile
should be in my.cnf. I've tried searching the manual and google, but
have not yet found anything (besides the -v commandline option but thats
not
One restriction is that currently you cannot modify a table and select
from the same table in a subquery. This applies to statements such as
|DELETE|, |INSERT|, |REPLACE|, and |UPDATE|.
Anyboyd know if this will be fixed?
Working around it with a join on itself, is there some reason updating a
matt_lists wrote:
One restriction is that currently you cannot modify a table and
select from the same table in a subquery. This applies to statements
such as |DELETE|, |INSERT|, |REPLACE|, and |UPDATE|.
Anyboyd know if this will be fixed?
Working around it with a join on itself, is there some
Mulley, Nikhil wrote:
Hi All,
I have a table which is being continuosly updated, I just wanted to know how to
output only the last row with the select statement.
can anyone please tell me howto.
thanks,
Nikhil
Do you use a recno?
If you have 4.1 you can use select * from table where recno =
matt_lists wrote:
Anybody have any recommendations for a stored procedure editor/debugger?
We are developing a test program with 5.x.x and procedures to see if
it'll work for us
stuck trying to get variables sorted out, and without a proper
debugger it's extremely hard
thanks in advance
Anybody have any recommendations for a stored procedure editor/debugger?
We are developing a test program with 5.x.x and procedures to see if
it'll work for us
stuck trying to get variables sorted out, and without a proper debugger
it's extremely hard
thanks in advance
--
MySQL General Mailing
Jay Blanchard wrote:
[snip]
No, it isn't ignored...it just returns a FALSE for the IN statement
[/snip]
More info
The word IN is an alias for = ANY. Thus these two statements are the
same:
SELECT s1 FROM t1 WHERE s1 = ANY (SELECT s1 FROM t2);
SELECT s1 FROM t1 WHERE s1 IN
matt_lists wrote:
matt_lists wrote:
Found the problem
now we have this added on a few tables in the dump
DATA DIRECTORY='E:\mysql\data\campbell\' INDEX
DIRECTORY='E:\mysql\data\campbell\'
the restore barfs on this
not sure how to remove this, looking at options now, it only puts
Having a strange bug with nested queries
SELECT A.*, b.*
FROM tablea a WHERE BLAH IN ( SELECT BLAH FROM tableC WHERE c1 = 'c'
AND c2= 'c' );
this works, but it should not
there is no BLAH column in table C
If I change it to this, it works correctly, as far as I can tell, still
working on
matt_lists wrote:
Having a strange bug with nested queries
SELECT A.*, b.*
FROM tablea a WHERE BLAH IN ( SELECT BLAH FROM tableC WHERE c1 =
'c' AND c2= 'c' );
this works, but it should not
there is no BLAH column in table C
If I change it to this, it works correctly, as far as I can tell
Jay Blanchard wrote:
[snip]
SELECT A.*, b.*
FROM tablea a WHERE BLAH IN ( SELECT CORCOL BLAH FROM tableC WHERE c1
= 'c' AND c2= 'c' );
[/snip]
This query is just badly formed, for instance, where is the table
aliased 'b' in your from statement? Are you showing the complete query?
Here's
Jay Blanchard wrote:
[snip]
the bug is, the nested query on the first statement is ignored
[/snip]
No, it isn't ignored...it just returns a FALSE for the IN statement
False should give no records, it's an IN () sense none match the condition
instead it gives me every record?!
--
MySQL General
matt_lists wrote:
Jay Blanchard wrote:
[snip]
the bug is, the nested query on the first statement is ignored
[/snip]
No, it isn't ignored...it just returns a FALSE for the IN statement
False should give no records, it's an IN () sense none match the
condition
instead it gives me every record
Tobias Asplund wrote:
On Tue, 1 Feb 2005, matt_lists wrote:
now we have this added on a few tables in the dump
DATA DIRECTORY='E:\mysql\data\campbell\' INDEX
DIRECTORY='E:\mysql\data\campbell\'
DATA DIRECTORY='E:\\mysql\\data\\campbell\\' INDEX
DIRECTORY='E:\\mysql\\data\\campbell
I've seen this quite a few times, but never been able to reproduce it
properly.
I'm assuming you're running on Windows, correct?
I'd search your dump-file for DATA DIRECTORY the problem on Windows is that
it uses \ instead of / in the path names there, which makes it use it as an
escape
Found the problem
now we have this added on a few tables in the dump
DATA DIRECTORY='E:\mysql\data\campbell\' INDEX
DIRECTORY='E:\mysql\data\campbell\'
the restore barfs on this
not sure how to remove this, looking at options now, it only puts this
on a couple tables, not all of them
--
MySQL
matt_lists wrote:
Found the problem
now we have this added on a few tables in the dump
DATA DIRECTORY='E:\mysql\data\campbell\' INDEX
DIRECTORY='E:\mysql\data\campbell\'
the restore barfs on this
not sure how to remove this, looking at options now, it only puts this
on a couple tables, not all
Having repeatable problems doing restores, 4.1.8 and 4.1.9 both do the
same error
Is there some setting I'm missing?
mysqldump -u username-pPassword --all-databases --quote-names
/intranet/backup/backup.sql
E:\intranet\backupmysql -u xotech -pDaredevil22 -f backup.sql
ERROR at line 2153:
Have a look at your /var/log/messages for messages around the time the
table crashes . It really should not crash this much. Is there a
quota system on your box ? I once had a table marked corrupt and
though I tried hard to find where the problem is, I was not able to.
Eventually, it
matt_lists wrote:
Raj Shekhar wrote:
Mark Maggelet wrote:
Hi,
I have a big table (900k rows, 200M MYD, 200M MYI) with a fulltext
index on it. The table gets corrupted every 1 week or so and I have
to repair it. I've tried upgrading to newer versions of mysql 3
times but the problem persists. I
Raj Shekhar wrote:
Mark Maggelet wrote:
Hi,
I have a big table (900k rows, 200M MYD, 200M MYI) with a fulltext
index on it. The table gets corrupted every 1 week or so and I have
to repair it. I've tried upgrading to newer versions of mysql 3 times
but the problem persists. I think it may have
How does everyone handle antivirus's and file locking issues?
I've been fighting with our sysadmin for weeks, I insist that norton
should not touch our database files, innodb, myd, myi
now it does, and I see corrupt data, and norton will skip files because
it cant get a lock, I dont want to
Those are pretty much standard settings
I had ours set almost exactly like that, and performance was worse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Anil Doppalapudi wrote:
ours is InnoDB. we are not getting any performance problems with the
settings. it is working fine since last 1 Year. to my knowledge due to
myisam type you are getting performance issue.
Thanks
Anil
based on this email list, myisam is prefered for heavy query/index use,
matt_lists wrote:
Can you post your my.ini or my.cnf
sense your restore actually worked
Mine is not swapping, in fact, mysql is only using 610,824 K of ram,
there is still over 1 gig of ram free
Our next server will have 16 gig of ram and quad xeons, I'm going to
completely disable the swap
matt_lists wrote:
matt_lists wrote:
Can you post your my.ini or my.cnf
sense your restore actually worked
Mine is not swapping, in fact, mysql is only using 610,824 K of ram,
there is still over 1 gig of ram free
Our next server will have 16 gig of ram and quad xeons, I'm going to
completely
Which are faster for updates queries?
Our indexes are packed, and run 2-6 gig
I'm having problems restoring tables, takes 3 weeks to restore one large
table, in fact the restore is still going so it may take a month
I was thinking this may be due to the packed fields, and a large primary key
Software Engineer,
Hewlett Packard
--- rob byrne [EMAIL PROTECTED] wrote:
I am trying to load data from a text file into a
table using the Load data
infile statement. No matter how I change data types
I seem only able to load
in the first row of data into the MySQL table and no
more. I have not
mos wrote:
At 12:05 PM 12/13/2004, you wrote:
Is there any way to limit drive usage per thread?
I have a problem where an update thread will use 100 % of the drive,
and simple index searches that should be instant will wait and wait
and wait before responding.
I dont want one user to kill
Are you sure innodb is better for tables larger than 4 gig?
| 12 | xotech | localhost:3115 | finlog | Query | 238224 | copy to tmp
table | alter table bragg_stat engine=innodb pack_keys=0 |
| 14 | xotech | localhost:3356 | NULL | Query | 0 |
NULL |
Can you post your my.ini or my.cnf
sense your restore actually worked
Mine is not swapping, in fact, mysql is only using 610,824 K of ram,
there is still over 1 gig of ram free
Our next server will have 16 gig of ram and quad xeons, I'm going to
completely disable the swap files
--
MySQL
The restore is still running
is this normal? How do you all deal with customers that do not have
their data for almost 3 weeks, and no end in sight
I've had oracle crashes before, the restores were very simple, this is not
I am very disappointed with mysql's performance with files over 5 gig
Anybody know? Or am I dreaming about oracle features that are not in mysql
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Almost all my MYD files are more than 4 gig
I was not aware of this limitation
I tested with InnoDB and found it horribly slow for what we do
Anil Doppalapudi wrote:
check your .myd file size. if table type is myisam and it it is more than 4
GB then convert it to InnoDB.
--Anil
--
MySQL
Need help with mysql restore speed
Table crashed, had to restore from backup, I started the restore 2 weeks
ago, the last change date on the files is the 8th, so mysql has not
wrote data into the files sense then, but it's still running! (or is it?)
the data restore is pretty quick, the index
Dathan Pattishall wrote:
From the brief sound of it your using myISAM, and the query taking the
most time is not indexed or using an index properly.
Alters will lock the table, and once it starts it should finish or your
going to have to recover the table. I suggest taking an outage. If you
can't
Nobody else has problems with restores on 8+ gig tables?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
matt_lists wrote:
Dathan Pattishall wrote:
From the brief sound of it your using myISAM, and the query taking the
most time is not indexed or using an index properly.
Alters will lock the table, and once it starts it should finish or your
going to have to recover the table. I suggest taking
Is there any way to limit drive usage per thread?
I have a problem where an update thread will use 100 % of the drive, and
simple index searches that should be instant will wait and wait and wait
before responding.
I dont want one user to kill everybody else
I'm adding a column to a large table
Gleb Paharenko wrote:
Hello.
I've taken this information from documentation at
http://dev.mysql.com/doc/mysql/en/myisamchk_syntax.html
Did it solve your problem? If didn't, send me you my.cnf file and information
about version of MySQL and operating system.
The docs are old, they changed
Are these critical errors? It keeps on going, saying it's fixing records
I tried doing a check table on the main server, it's been running a week
and who knows how long that'll take
myisamchk -o -p -f --sort_key_blocks=512M - -key_cache_block_size=512M
--read_buffer_size=8M 321st_stat
-
Gleb Paharenko wrote:
Hello.
There is a variable sort_buffer, which you can set with -O sort_buffer=xxxM or
in my.cnf.
myisamchk -o -p -f --sort_key_blocks=512M - -key_cache_block_size=512M
it's no longer -O sort_buffer=xxxM
it's now --sort_key_blocks
and I set it to 512M and it still
ions?
Please see http://dev.mysql.com/doc/mysql/en/News-4.0.18.html :
INSERT DELAYED ... SELECT ... could cause table corruption because
tables were not locked properly. This is now fixed by ignoring DELAYED
in this context. (Bug #1983)
http://bugs.mysql.com/bug.php?id=1983
Obviously I
Also consider buying MySQL support, which will give your requests a bit more
weight.
If that put select into table without locks back into mysql, I would
however, I dont think it will, I've got X dollars for hardware/software
on a given project, my only option is a different database for new
How do I avoid insert locks?
We updated from mysql 4.0.18 to 4.1.7
now all my inserts lock tables, I had 500 asp timeouts within 30 minutes
after installing 4.1.7
I also had over 400 connections to the database, as all the threads were
locked waiting, asp timeout is set to 30 seconds, the
I think I found the problem
all our input files are prepped in a separate table
then insert delayed select * from temptable into production
4.0.18-19 removed this!
I dont know why they would allow insert delayed values, or load data
infile concurrent
but not on a select into table!?
Sucks,
I cant tell if this is a bug or a feature.
Select from table where col 'blah'
I use this all the time with other databases, works great, gives me
everything that's not blah
but in mysql, it wont work if there's null records in the table
I have to do this, select from table where ( col 'blah or
65 matches
Mail list logo