Quoting Jerry Schwartz je...@gii.co.jp:
-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
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 not thinking of?
Jacob
--
MySQL General
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 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
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
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
: 10.0.0.1:60214
db: replication_test
Command: Query
Time: 93
State: Waiting for release of readlock
Info: UPDATE blah SET blah=blah
I know the versions are slightly off between the mysqldump client and
the server but would 4.1.5 - 4.1.14 make that big of a difference?
Thanks in advance,
Jacob
-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 hoovers
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
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
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. Doesn't look pretty
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.
Could the problem the Locked data table in this case?
mysql show processlist;
+-+---+---+---+-+---
-+--+---
---+
| Id | User | Host
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;
+-+---+---+---+-
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
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
-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
'sidtemp' table would
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
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
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
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 minor
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
, 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
fields
]
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 data
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
|| |
+--++-++-++-
+-+--
+---++-+
-++--
-+--++-+
1 row in set (0.07 sec)
mysql
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 28, 2006 12:43
To: Jacob
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 Brent's
I have not been monitoring my databases now I am using a 100% disk space.
thank you,
Raymond
-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 host-bin.x files in order to free up some
space?
Yes you can. Be sure not to delete the one
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 host-bin.x files in order to free up some
space?
I believe
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://lists.mysql.com/[EMAIL
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
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 column returns a negative number.
Possibly
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]
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 list archives: http
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:
Check with SHOW PROCESSLIST in what
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?
Thanks,
Jacob
--
MySQL
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.).
Don't you mean net_read_timeout?
http://dev.mysql.com/doc/mysql/en/dynamic-system-variables.html
SET SESSION net_read_timeout = 300;
Thanks,
Jacob
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
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:http
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
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
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
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
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 replication dies.
Any ideas why?
Thanks,
Jacob
--
For technical
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
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
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]
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 unsubscribe:http://lists.mysql.com
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 telling
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:02 -0500, MrExecutive [EMAIL PROTECTED] wrote
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 to setup
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 unsubscribe:http
= 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 text in old rows?
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
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]
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 General Mailing List
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 id set as the primary
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.
I guess I could solve my problem with a subselect.
Thanks,
Jacob
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
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 big table just as fast?
We will for new data do
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]
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]
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 archives: http
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]
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]
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
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
-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
in 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
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_dst
can not
include two versions of mysql and mysqli client libraries.
Someone made this work:
http://groups.google.com/groups?hl=enlr=ie=UTF-8selm=bqcbqi%2416sr%241%40FreeBSD.csie.NCTU.edu.tw
/Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
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.mysql.com
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]
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
| 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
To unsubscribe:http://lists.mysql.com
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]
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 lot.
--
Jacob Elder
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
?
-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 Tue 18 May 02004 at 02:03:55PM -0500, Victor Pendleton wrote:
From this explain plan
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-padded numbers:
LPAD(subscriber,4
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]
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
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
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
[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]
.
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 unsubscribe:http
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
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, December 22,
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
I have installed the MySQL database 4.0.4 client, but when I look at
phpinfo() I see that it says:
Client API version: 4.0.2-alpha
Why?
Regards, Jacob
-
Before posting, please check:
http://www.mysql.com/manual.php
set-variable= thread_cache=8
# Try number of CPU's*2 for thread_concurrency
set-variable= thread_concurrency=8
If I have 2 CPU's, does the above mean that I should set
thread_concurrency=16 ?
I am using a MySQL database 4.0.4
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
Your message cannot
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
1 - 100 of 164 matches
Mail list logo