Quoting Jerry Schwartz :
-Original Message-
From: Jacob Steinberger [mailto:trefal...@realitybytes.net]
I have a requirement to keep track of a set of data, and all changes
that might occur. In order to do this, for each field of the data set,
I've created a table that keeps track o
I found an answer without having to worry about complicated SQL
statements - it's more about managing the tables than the SQL.
Jacob
Quoting Jacob Steinberger :
I have a requirement to keep track of a set of data, and all changes
that might occur. In order to do this, for each field o
ersion = ( select max(version) from
serviceseqnum where record_id = rsi.record_id ) ) from record_set_id )
from record_set_id as rsi
... especially when trying to get a dozen values strung together so
they appear as one record.
Is there a better way to handle these queries that I'm just no
I apologize for asking this question.
I am somewhat confused by Microsoft's Licensing and I personally can not
justify to senior management why
MS SQL should be procured instead of procuring software more urgent
requirements.
I had the not so bright idea that maybe a MS SQL emulator or
compatibili
Hi,
Could someone please help me to get rid of "Using temporary; Using filesort"
from the following SQL statement?
SELECT a.document_id AS id, attr_name AS name, attr_value AS value, attr_order
AS ord FROM attributes a INNER JOIN status s ON (a.document_id = s.document_id)
WHERE update_flag
I have a table:
Id |path1 | display| value
1 | ostype | os|windows
1 | ostype | ver |NT4
2 | ostype | os | linux
2 | ostype | ver | RHEL 5.4
That I would like to tranform into
Id | os| ver
1 |windows | NT4
2| linux |RHEL 5.4
Thank you,
Raymond
smime.p7s
server but would 4.1.5 -> 4.1.14 make that big of a difference?
Thanks in advance,
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-Original Message-
From: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 06, 2006 10:24
To: Jacob, Raymond A Jr; mysql@lists.mysql.com
Subject: Re: Adding and Removing tables from MERGE tables dynamically
I've got a similar setup, total records across about 8 tables ho
Problem: I use two applications one called snort, the client that
inserts data into eleven(11) tables.
The other application BASE joins the tables into one table. When the
tables become 4GB in size,
deleting records for one month becomes unbearably slow(20-30days). The
search(Select ) is slow too
Thank you,
raymond
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 13, 2006 18:07
To: Jacob, Raymond A Jr
Cc: mysql@lists.mysql.com
Subject: Re: I ran of disk space running optimize on table Now I can
not open "data.MYI"
Hmmm. Do
Now, I when I do a desc on data table, I get the error
ERROR 1016 (HY000): Can't open file: 'data.MYI' (errorno: 144).
As I recall I ran:
optimize data;
The Optimize command did not complete the error as I recall was /var
filesystem full.
Running the following commands:
ls data.*
data.MYD
When I try to retrieve all rows in the event table that are in a
particular range and then
try to determine if the cid is in the data table the join takes
forever.
So I tried just tried adding the table to see if the where clause was
slowing things down. Below is a portion on my session.
mys
It appears that every time I start query the event or the data table
gets Locked.
Could this have any affect on why it takes so long to delete records.
Grasping at straws,
Thank you,
Raymond
mysql> show processlist;
+-+---+---+---+-
Could the problem the Locked data table in this case?
mysql> show processlist;
+-+---+---+---+-+---
-+--+---
---+
| Id | User | Host
I started the operation below on Friday at 1300hrs EST
DELETE data
FROM data, event
WHERE data.cid = event.cid
AND event.timestamp < "2006-05-01"
It is now Sunday 22:00hrs EST and the operation is still running.
Question: Should it take this long to delete 7.5 million records from a
4.5GB
T
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Friday, July 07, 2006 15:48
To: Jacob, Raymond A Jr
Cc: mysql@lists.mysql.com
Subject: Re: How does one speed up delete.
Raymond, I would expect that adding an index on 'cid' column in your
'sidte
Env: Freebsd 6.0
MySql 4.1.18
Mem: 1GB(?) can not tell without rebooting
Disk Avail: 4GB
Problem: the table data is 4.5GB.
I created a temporary table sidtemp in the database snort by typing:
CREATE TEMPORARY TABLE sidtemp
SELECT cid FROM event
WHERE timestamp < '2006-05-01';
Query OK, 7501376
Thanks again,
raymond
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 05, 2006 14:54
To: Jacob, Raymond A Jr
Cc: mysql@lists.mysql.com
Subject: Re: Temporary table ERROR 1109 (42S02) where are temporary
tables kept?
Jacob, Raymond A Jr wrote
Thank you,
I was definitely on the wrong track on this one.
I annotated your commands to make sure that I understood what they
were doing. Are my comments correct?
---
You have the wrong syntax. You can't mention a table in the WHERE
clause that wasn't in the FROM clause. Try
DELE
I ran the following commands:
USE snort;
CREATE TEMPORARY TABLE sidtemp SELECT cid FROM event WHERE timestamp <
'2006-05-01';
...
SELECT count(*) from sidtemp;
count(*)
7501376
DELETE FROM data WHERE data.cid = sidtemp.cid;
ERROR 1109 (42S02): Unkown table 'sidtemp' in where clause
SHOW ta
Baisley [mailto:[EMAIL PROTECTED]
Sent: Friday, June 30, 2006 8:49
To: Jacob, Raymond A Jr; mysql@lists.mysql.com
Subject: Re: Client still reports table full
Wow, I'm really sorry about that. Left out a zero. I should stop
answering questions before the holiday weekend.
I was suggesting a
]
Sent: Thursday, June 29, 2006 17:55
To: Jacob, Raymond A Jr
Cc: mysql@lists.mysql.com
Subject: Re: Client still reports table full
I'm not sure that avg_row_length has a bearing on your problem right now
... the output of show table status you posted earlier shows that you
have:
current
y, June 29, 2006 15:53
To: Jacob, Raymond A Jr; mysql@lists.mysql.com
Subject: Re: Client still reports table full
Oops, left out an important part. You should change the Avg_row_length
also.
ALTER TABLE AVG_ROW_LENGTH = 50
You need to specify an average row length if you have dynamic length
fie
Yesterday:
I ran the following command:
ALTER TABLE data max_rows=1100
Today:
The client still reported table is full.
I rebooted the client and stopped and started the mysql server.
I still get the table is full error on the data table.
I ran the command:
\ echo "SHOW TABLE STATUS LIKE 'da
thank you,
raymond
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 28, 2006 16:07
To: Jacob, Raymond A Jr; mysql@lists.mysql.com
Subject: Re: Sorry for the dumb question how do I fix table is full?
I agree it's not very clear. I think Br
ci | NULL || |
+--++-++-++-
+-+--
+---++-+
-++--
-+--++-+
1 row in set (0.07 sec)
mysql>
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 28, 2006
Environment: Freebsd 6.0
Mysql : mysql Ver 14.7 Distrib 4.1.18, for porbld-freebsd6.0 (i386)
using 5.0
On the client, I get /var/log/messages, I get the errors:
kernel: 9643D22706C
and
database: mysql_error: The table 'data' is full SQL=INSERT INTO data
(sid,cid,data_payload) VALUES"
I hav
Thank you
Raymond
that did the trick.
-Original Message-
From: Gary Richardson [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 03, 2006 14:39
To: Jacob, Raymond A Jr
Cc: mysql@lists.mysql.com
Subject: Re: Can I delete old -bin.x files in order to free up some
space?
I believe the
-Original Message-
From: Gary Richardson [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 03, 2006 14:10
To: Jacob, Raymond A Jr
Cc: mysql@lists.mysql.com
Subject: Re: Can I delete old -bin.x files in order to free up some
space?
Yes you can. Be sure not to delete the one the
I have not been monitoring my databases now I am using a 100% disk space.
thank you,
Raymond
Should this worry me:
060331 10:34:24 [Warning] Aborted connection 244161 to db: 'cyrus'
user: 'cyrus' host: `debpro' (Got an error reading communication
packets)
/Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
After a 23days of running mysql, I have a 3GB database. When I use an
application
called base(v.1.2.2) a web based intrusion detection analysis console, the
mysqld utilization
shoots up to over 90% and stays there until the application times out or is
terminated.
Question: Have I made some err
Is there any way I can do a content analysis with MySQL?
I need to find text in a database that have similarity.
/Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have three(3) instances of an application inserting data into a MYSQL (4.X)
database. I have to change the password.
I would like to know, if I can change the password of the application on the
server without disrupting existing
connections then modify the password in the startup file for the
with 2G ram.
Thanks for any help.
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Wednesday 06 July 2005 11:42 am, Keith Ivey <[EMAIL PROTECTED]> wrote:
> Jacob S. Barrett wrote:
> > I have a column of type UNSIGNED INT which holds a 32bit counter. When
> > the value of the field exceeds 2147483647 (signed max) the value of MAX
> > on the colum
something
wrong, is this a bug? I would rather not store a 32bit counter as a 64bit
value, but I need the MAX function to work so in the mean time I will convert
all these fields to BIGINT.
Thanks,
Jake
--
Jacob S. Barrett
Chief Technology Officer
PogoZone LLC
email: [EMAIL PROTECTED]
web
> Check if problem remains with official binaries.
I will. My schedule won't allow it right now, but I will get to it soon.
Thanks,
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> Normally such different behavior for same queries is
> weird. Do you use an official binaries or from Debian?
I use those from Debian:
http://packages.debian.org/testing/misc/mysql-server-4.1
Thanks,
Jacob
> Jacob Friis Larsen <[EMAIL PROTECTED]> wrote:
>
> >> Che
> Variables are net_read_timeout and net_write_timeout :
I don't think I can use net_read_timeout to timeout a query.
"Net Read Timeout: The time required in seconds to wait for more data
from a connection before aborting the read."
Jacob
--
MySQL General Mailing List
For l
On 5/20/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> There is a variable called --network-timeout ! You can set it to 300 (5
> minutes, etc.).
SET SESSION network-timeout=120;
ERROR 1193 (HY000): Unknown system variable 'network'
How should I use network-timeout?
T
ut = 300;
Thanks,
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> Check with SHOW PROCESSLIST in what state your query hangs.
It hangs while sending data. I only ask for 7 rows, and normally this
goes very fast.
Have a nice weekend.
Thanks,
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:h
Hello.
Is there a way to have MySQL give up on a query after a certain length of time?
I use Debian Linux Sarge, MySQL 4.1 and Php 5.
Sometimes I have queries that take forever although the same query
returns fast at other times.
Thanks,
Jacob
--
MySQL General Mailing List
For list archives
running: mysql Ver 12.22 Distrib 4.0.23, for Win95/Win98(i32) downloaded from
www.devside.net/web/servers/free/download.
When I run a script with the following commands I get sql syntax errors:
Create table 'test' ( 'helper' varchar(22) )
ENGINE=MYISAM DEFAULT CHARSET=latin1;
I get a sql error
Does such a JOIN exist that can create a pivot table?
Thank you:
182361 by: Dan Bolser
182362 by: Peter Brawley
Now I must go into my cave and meditate on these queries: Ommm,Ommm,...Ommm :-)
raymond
Question: I frequently would like to summarize the results of my query in
heiarchical layout also
known as a Pivot table.
Here is an example of what I would like output. NULL will be printed as a space
when output.
sum of broken| source of | qty |reseller of |qty |customer with |qty
that it is
running ok, but I'll check next time.
Thanks,
Jacob
> Jacob Friis Larsen <[EMAIL PROTECTED]> wrote:
>
> > I use Debian Sarge as my Linux distribution on two servers who replicate
> > MySQL.
>
> > Every time I upgrade the MySQL package my repl
I use Debian Sarge as my Linux distribution on two servers who replicate MySQL.
Every time I upgrade the MySQL package my replication dies.
Any ideas why?
Thanks,
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
How does one insert records based on some kind of meta data or key in
particular table belonging to a merge table?
I have a network logging program and would like to partition the table so that
analysts can query certain tables belonging
to the merge table instead of the whold table to corelate e
What are the implications of setting the "--bdb-no-sync" flag when
using the BDB storage engine. I haven't found alot of documentation on
this in the docs or via google.
Does this mean that after every transaction, sync will not be called?
When will sync be called then?
Will setting this flag l
to ACI semantics. It is then up to the app to
call DB->sync when it wants durability. How does this map to the
BDB/MSQL storage engine?
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Does anyone know if there are any 3rd party shells that can connect to
a mysql server that support aliases, or have any features that can
make working from the console faster?
Thanks!
-Jacob
On Fri, 4 Mar 2005 11:59:56 -0600, jacob martinson
<[EMAIL PROTECTED]> wrote:
> Is it possible
i'll usually pipe mysqldump into gzip if it's a large database, or gpg
if there's sensitive data in it.
-jacob
On Fri, 4 Mar 2005 12:22:08 -0600, jacob martinson
<[EMAIL PROTECTED]> wrote:
> run:
>
> mysqldump --help
>
>
> On Fri, 04 Mar 2005 13:12:
run:
mysqldump --help
On Fri, 04 Mar 2005 13:12:02 -0500, MrExecutive <[EMAIL PROTECTED]> wrote:
> Hello Guys,
>
> I am a newbie to mySQL and im trying to export my database via the
> mySQL Command line but i cant seem to find any good documentation on how
> to do this. More articles are te
Is it possible to setup aliases in the mysql console to cut down on
typing, i.e. instead of having to type out "show tables" I can just
type "\dt" as in postgresql?
Thanks,
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Anyone know what to do when SHOW SLAVE STATUS says:
"Query caused different errors on master and slave."
Master: MySQL 4.1.9-Debian_2-log
Slave: MySQL 4.1.5-gamma-log
Thanks,
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
at runs continually updating those tables with current data.
>
> get it?
I think so :)
Thanks,
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
t could look like this: "SELECT title, desc FROM items WHERE
> > feedid = 25 ORDER BY id DESC LIMIT 10"
>
> I would, however, be seriously concerned about diskspace if a table is adding
> 200 MB a day with no archiving/compression/purges.
What if we use COMPRESS() for the t
> >I'd like to get 100 itemid's for each id.
I guess I could solve my problem with a subselect.
Thanks,
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> >This is my table:
> >
> >CREATE TABLE items (
> > id int(10) UNSIGNED NOT NULL default '0',
> > itemid int(10) UNSIGNED NOT NULL auto_increment,
> > PRIMARY KEY (`itemid`)
> >);
> >
> >I'd like to get 100 itemid's for each id.
> >
> >Is that possible. If so, please show me how.
> - you have i
This is my table:
CREATE TABLE items (
id int(10) UNSIGNED NOT NULL default '0',
itemid int(10) UNSIGNED NOT NULL auto_increment,
PRIMARY KEY (`id`)
);
I'd like to get 100 itemid's for each id.
Is that possible. If so, please show me how.
Thanks,
Jacob
--
MySQL Gene
On Fri, 28 Jan 2005 11:47:47 +, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> Jacob Friis Larsen <[EMAIL PROTECTED]> wrote on 28/01/2005 11:23:46:
>
> > We have a table that grow by 200MB each day.
> >
> > Should we put data in different tables or is one
We have a table that grow by 200MB each day.
Should we put data in different tables or is one big table just as fast?
We will for new data do select, update and insert and for old data only select.
Any help would be great.
Thanks,
Jacob
--
MySQL General Mailing List
For list archives: http
Is there a workaround for bug 5686?
http://bugs.mysql.com/bug.php?id=5686
We use Debian Linux testing and MySQL 4.1.8
Thanks,
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re-linking
mysql: Symbol `sql_protocol_typelib' has different size in shared
object, consider re-linking
Thanks,
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
table packed by myisampack?
Thanks,
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Jacob Friis wrote:
Is it possible to append rows to a table packed by myisampack?
No, RTFM, "Compressed storage format is a read-only format that is
generated with the myisampack tool."
http://dev.mysql.com/doc/mysql/en/Compressed_format.html
--
MySQL General Mailing List
For list arch
Is it possible to append rows to a table packed by myisampack?
Thanks,
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Are we going to compare these dolphins to the MySQL logo? I hear they saved
us from MSSQL :-)
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
My Bad. I was all into 4.xx and since most of the www.mysql.com references 4.xx I
never thought about
5.0. I appologize for disturbing the list.
thank you,
raymond
-Original Message-
From: V. M. Brasseur [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 31, 2004 18:54
To: Jacob, Raymond A
Firstly,
I do appologize for my ignorance in advance. I read the message regarding PRODUCT()
and
thought to myself:"A perl interpreter can be run in a C program. Some one must have
written
a userdefined function that can execute perl code. Googling I found
http://software.tangent.org/downloa
-Original Message-
From: Jacob, Raymond A Jr
Sent: Monday, August 02, 2004 21:17
To: [EMAIL PROTECTED]
Subject: archive db daily- Rough Draft
I am new to Databases and would appreciate a second set of eyes looking over my sql
script.
The script takes the existing snort database and
memory?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, July 30, 2004 9:03
To: Jacob, Raymond A Jr
Cc: [EMAIL PROTECTED]
Subject: Re: How do you archive db daily?
Why not keep your server running and just use scripted SQL to migrate the records from
one
I am running MySql 3.23.58-1 on a snort database containing IDS alerts.
At 12:00am I would like move the previous day's alerts from four tables to
a backup database named for the previous day.
Has anyone implemented such a backup schedule? And if so can someone
send me a script?
I had the follow
can I improve
my query?
thank you,
Raymond
-Original Message-
From: Raymond Jacob
Sent: Monday, July 26, 2004 19:50
To: Jacob, Raymond A Jr
Subject: query analysis
version: MySQL-Max-3.23.58-1
DESC iphdr;
DESC event;
DESC signature;
DESC acid_event
EXPLAIN
select count(ip_ds
/php.net/mysqli, you can not
include two versions of mysql and mysqli client libraries.
Someone made this work:
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&selm=bqcbqi%2416sr%241%40FreeBSD.csie.NCTU.edu.tw
/Jacob
--
MySQL General Mailing List
For list archives: http://lists.mys
Thanks to everyone who helped me with this. I settled on breaking it down
into area code, exchange and subscriber. This is one of the most generous
lists I've ever had the pleasure of begging for help on.
--
Jacob Elder
--
MySQL General Mailing List
For list archives: http://lists.mysq
On Tue 18 May 02004 at 04:53:52PM -0400, [EMAIL PROTECTED] wrote:
>
> Jacob,
>
> Don't worry about storing the leading the zeroes. Just left pad the
> subscriber column to be 4 digits on output and you should be golden. MySQL
> has a function just to generate left-pa
be stripped off?
>
> -Original Message-
> From: Jacob Elder
> To: Victor Pendleton
> Cc: '[EMAIL PROTECTED] '; ''[EMAIL PROTECTED] ' '
> Sent: 5/18/04 2:11 PM
> Subject: Re: Simple table, 1.7 million rows, very slow SELECTs
>
> On Tu
don't understand why a
btree lookup would be so dramatically slow compared to a linear search with
grep. Would something other than MyISAM be more appropriate here?
The chances of a given row being returned more than once per day is very
small, so caching the result doesn't help a lo
Would it be faster if I broke it into columns for
area code, exchange, and subscriber?
--
Jacob Elder
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
IMARY | 10 | NULL | 1797425 | Using
where; Using index |
+-+---+---+-+-+--+-+--+
1 row in set (0.00 sec)
--
Jacob Elder
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
T
timized the table, but the difference in speed is not signifigant.
Average query times are still between 4.45 and 5.0 seconds.
I've worked with MySQL in the past but never with so many rows. Is 1.7
million a lot for MySQL? Why would this be so much slower than grep?
--
Jacob Elder
--
My
this to take so long? Grepping against a flat text file
representing my data takes a far less than a second. Any thoughts, folks?
--
Jacob Elder
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I need to restore 20 gigabytes of binary logfiles.
What should I do in order to get the job done as quickly as possible?
There is a faster way, but it is rather tricky.
4.0 slave can be tricked into thinking that those binary logs are in
fact the relay logs that it gathered from the master. So we
I'd go with Reiser on SuSE.
What about Reiser on Debian?
Thanks,
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
is appreciated and thanks in advance.
Jacob Joseph.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.588 / Virus Database: 372 - Release Date: 2/13/04
is appreciated and thanks in advance.
Jacob Joseph.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.588 / Virus Database: 372 - Release Date: 2/13/04
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
[EMAIL PROTECTED] wrote:
Did you perform a stack trace?
No, how do I do that?
/Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can someone help me find out what caused this crash?
My system is a Red Hat 7.3 on a HP Netserver LC2000, dual PIII 800mhz
with 2.5G ram. 3 disks in raid 5.
The MySQL database is 4.0.17
040212 19:27:36 read_const: Got error 126 when reading table
./exp4/sql_cache
Number of processes running n
se returns error 127.
How can I correct this? Drop and create is ok and is What I am doing now.
Jacob Joseph
NGL Solutions Pvt. Ltd.
2nd Floor, Thoppil Estate, Janatha Junction,
SA Road, Vyttila,
Ernakulam - 682 019.
Phone: 91-484-2302 385, 2302 386.
Email: [EMAIL PROTECTED]
I have upgraded from MySQL (rpm) 4.1.0 to 4.1.1 and now I see lots of
lines in the error log with:
Unknown character set: 'latin1_swedish_ci'
How can I fix this?
Regards Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
Hello,
I have two tables, A and B, where the entries in B are connected to A through a left
join. Thus there may be several entries in B for each post in A.
Now I would like to select the two latest posts in A and all the corresponding posts
in B. I tried something like SELECT fields FROM A LEF
if it's not you have probably just shamed him into never turning his computer
on again.
Quoting Chris Knipe <[EMAIL PROTECTED]>:
> LOOL! This *IS* a joke right? ;)
>
> - Original Message -
> From: "lateef ayinla" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday,
How can a query like "HANDLER table READ" on a MyISAM table be locked? I
thought the idea of HANDLER table READ was that it couldn't be locked.
Kill 1696313 xxx localhost xxx Query 3 Locked HANDLER questions READ
FIRST WHERE qid = 290184 LIMIT 1
Can i get more speed by disabling InnoDB tables, if I'm only using
MyISAM and HEAP tables?
Any warnings about this?
Regards, Jacob
http://www.sharksforum.com
sql
-
Before posting, please check:
http://www.mysq
If I use UPDATE LOW_PRIORITY, will the client then have to wait for the
update query to finish or not?
Regards, Jacob
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
I am running MySQL database 4.0.4 on a RedHat Linux 7.3 with the
database path being on raid disks and /tmp/ on a non raid disk.
Should the tmpdir be on a raid disk? If so they will be at the same disk
as the database. Is that the best option?
Regards, Jacob
Venlig hilsen
Jacob Friis Larsen
[ JFL WebCom | www.webcom.dk | +45 7027 0767 ]
> -Oprindelig meddelelse-
> Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sendt: 25. november 2002 11:02
> Til: Jacob Friis Larsen
> Emne: Re: UPDATE LOW_PRIORITY database
>
1 - 100 of 169 matches
Mail list logo