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
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
-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
, Raymond A Jr
Cc: mysql@lists.mysql.com
Subject: Re: Sorry for the dumb question how do I fix table is full?
Raymond, can you post the output of
SHOW TABLE STATUS LIKE 'data';
that should show how big your table is and how big it can be...
Dan
On 6/28/06, Jacob, Raymond A Jr [EMAIL PROTECTED
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
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
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
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
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
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
A Jr
Cc: [EMAIL PROTECTED]
Subject: Re: Is their still any reason why Stored Procedure calls are
not supported in MySql?
Stored procedures are in the works for MySQL 5.0:
http://dev.mysql.com/doc/mysql/en/TODO_MySQL_5.0.html
The manual is your friend.
Cheers,
--V
Jacob, Raymond A Jr wrote
-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
37 matches
Mail list logo