: gerald_clark [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 11:12 AM
To: Jason Hall
Cc: '[EMAIL PROTECTED]'
Subject: Re: Tables/Index Crashing?
Power failure/unplug/turn-off server.
kill -9
OS crash.
Operating handheld radios next to the server.
I am sure others can come up
What are some of the reasons why table/index key crashes?
sql, query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thre
ngs no results. I have to CTRL C to exit out.
when i do this
select blobcolumn from table
where id = 3232
> i get returned records
There's about 1.3 million records in this table.
what is the problem. Can any one Help?
thanks
sql
que
Where can i find documents with the description of mysql error code returned
by the mysql daemon?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list arc
only
states that 17 connections is used.
I also ran mysqladmin processlist to see how many processes are running and
it's only one.
Is there a bug.
I am using MySQL 3.22.32
Any ideas?
_____
Jason Hall
Senior Integration Analyst
ATT Canada | AES | Managed Ho
I am using mysql 3.23.41
The tables are set to MyISAM.
Table "A" i having problem with has 1.4 million records.
When i perform a mysqldump it hangs on this table but dumps other tables.
Also when i do a select * from table it hangs. But if i do select count(*)
from table a get a result.
The fiel
I've had a similar error when creating innodb tables, using a 4.0.1 client,
and a .47 server, if I loaded my create statement from a text file, the
innodb table wouldn't create. Change the type to myisam and it worked fine.
If I wound up creating it line by line, it worked fine. This might g
I'll add my voice especially on the local file. many times I have wanted to
be able to skip creating the file on the server, then having to scp it to my
local box.
On Tuesday 11 December 2001 02:09 pm, you wrote:
> Hi,
>
> I would like to request the addition of the following features to the
>
Well, I can't currently link you to the systems I'm mentioning, but we have
performed several restore's from dumps in the last several weeks on my
current project (due to some really messed up hardware). Considering the
fact that the db's are a little over 20gb, I consider them pretty large, a
allrighty, for you perl/mysql folks here is the trouble I'm having.
I'm tyring to do a transaction in mysql/innodb in perl with the following
basic flow
eval{
Insert my first record
get the insert_id
(using $sth->{mysql_insert_id})
now perform other insert
> I think it would be more useful to work on the main branch and add extra
> value to it, such as Heikki has done. That way all users of MySQL can
> benefit from your fixes, etc.
IMHO I think this would be best too, I know I would like both the
newer/forthcoming features in the 4.x branch, but
elect possibilities
from table.field
Then fetch that into an array/arrayref...
Jason Hall
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
Sorry to say I can't help but am really interested in the resolution.
If it helps the brains at all, I experience the same thing on the
following system.
mandrake 8
kernel 2.4.3
ReiserFS (mysql data on scsi drive, rest on an IDE)
mysql .37 binary (couldn't get the source to compile)
seems to have
Aaron Weiker wrote:
> For some reason I don't think this was understood of what I said earlier.
>
> THE "DATABASE" ISN'T RESPONSIBLE FOR XML
>
> But, just because the database isn't responsible doesn't mean that the
> application is responsible for generating XML.
>
> > to put this wrapper o
14 matches
Mail list logo
