 | | | MySQL General | | I 'm seeing something that I don 't think should be happening but I 'm
not sure if it 's a MySQL bug.
To allow some of my stored procedures to operate concurrently I make
a temporary memory copy of som I forgot I have two databases snortdb and archive_snortdb with same
schema.
Syslog did not distinguish between the two(2).
Both were suffering from the 4GB limit.
Once I increased max_row the error sOn 7/6/06 Ed Reed <EReed@(protected) > wrote
> Anyone have an idea on this?
Upgrade. Or at least stop repeating the question.
Jochem
--
MySQL General Mailing List
For list archives http //listOn Jun 30 2006 at 10 44 AM Rob Desbois wrote
> That leaves me with ON DUPLICATE KEY UPDATE. It 's not amazingly
> helpful as you have to provide a column to update - however I can
> just say e. >Since one person can be listed in both 1 and 2 in each section (just not
>in the same row) I need to sum up that person 's votes between the two
>columns. I 've tried summing two subqueries but it Cor -
Those numbers are an estimate not a hard number of how many rows
MySQL thinks it will have to exmaine to find what you 're looking for.
They could be different because your compressed table iHow do I call a MySQL stored procedure from an ASP application and get the
value of an Out Parameter?
I 've got the following Stored Procedure defined in my database
DELIMITER $$
DROP PROCEDURE IF Instead of "locking " the table why not just change the privileges for the specific accounts so they have select only privileges?
Then you still of write access through "admin " accounts if need be.
I have been just reading the book and doing the examples and
learning how good MySQL is. I was early asking about Query and now I 'm
doing it like the SQL says to do it. A recient one is like thiMark Steudel wrote
> Is there a way get distinct results between pf and sf?
>
> Select
> pf.name
> sf.name
> From
> tblpropertyfeatures
> tblsuitefeatures
> Inner Join tblfeatures AS pf ON tblpropeHi all
I have a couple of stored procedures where SP1 is calling SP2.
SP2 has a return value which I need for SP1 to continue processing the data.
The relevant bit of SP1 looks like this
mlCountExcellent Dan!
Thanks!
-----Original Message-----
From Dan Buettner [mailto drbuettner@(protected)]
Sent Thu 6/29/2006 4 35 PM
To Jeff
Cc mysql@(protected)
Subject Re MXiabo can you post the output of SHOW CREATE TABLE <table > please?
See http //dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html
which indicates it could be due to how the column was created
I will try REPAIR TABLE data. data.MYD is 4.1G so I am over the 4GB
limit and growing.
I also tried
CHECK TABLE data QUICK
CHECK TABLE data MEDIUM
CHECK TABLE data EXTENDED
They all showed OK.
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 in the table How do I call a MySQL stored procedure from an ASP application and get the
value of an Out Parameter?
I 've got the following Stored Procedure defined in my database
DELIMITER $$
DROP PROCEDURE IFI have a SELECT statement for MS SQL that is
SELECT TOP 1 id FROM menu_links ORDER BY id desc
and need to convert it to MySQL. I cannot find what will do that.
Help is greatly appreciated.
TIA
MiHi Pooly all
Pooly wrote
> Hi
>
> I stumbled on one issue yesterday which took me some time to figure out.
> the table is
> create table tt ( PCname varchar(5) not null default ' ')
> insert Hello Andreas
You could try with this
> insert into table1 (authorid lastname firstname)
> values (nextval( 's_authors ') 'Meyers ' 'Scott ')
INSERT INTO table1(authorid lastname firstname)
VATanner
>I am trying to group my results by the last activity on each row my
query
>looks like this
>select text dt item_id from table
>where ....
>group by item_id
>order by dt DESC
SELECTA specific character that would occupy less space? You mean like using lower case instead of upper case? All characters use the same
amount of space (unless your using Chinese or something).
I don 'tHi
2006/6/28 Chris Sansom <chris@(protected) >
> I 'm sure this is an elementary problem but I can 't get my head round it.
>
> I have two tables pix and sections the relevant bits of which ar If you happen to have "The Practical SQL Handbook " of 1996 it comes
with a DB called bookbiz.sql which was current for MySQL of 1996. A lot
has changed so the file had to be re-written to work oHave your where clause select the customer sort result by autoincrement
column DESC limit 50
Only problem is the order would be the inverse (i.e. last in first
displayed) from your goal. Only way Those do indeed have something to do with replication - they 're a
record of all data manipulation commands (inserts updates deletes
table creates and alters etc). The slaves basically read the
co thank you
raymond
-----Original Message-----
From Dan Buettner [mailto drbuettner@(protected)]
Sent Wednesday June 28 2006 16 07
To Jacob Raymond A Jr mysql@(protected)
Subject Re Sorry Steve
> INSERT INTO master_context_list (Context_ID Target_ID)
> SELECT Context_ID @(protected) targets_list.Target_ID FROM
targets_list
> WHERE Target_ID IN ( SELECT Target_ID FROM #This is a text part of the message.
It is shown for the users of old-style e-mail clients
Only allow your users select rights.
--ja
On Wed 28 Jun 2006 Clyde Lewis wrote
> All
>
> Does MySQL have an option where the database can startup in READ-ONLY
> mode? The idea is to have thMySQL by default limits tables to 4GB it looks like you hit that limit. It 's fairly easy to change that limit ideally when you
create the table. Before MySQL 5.0.6. the default pointer size was 4b |
|
|
