On Friday 16 December 2005 00:34, Stephen Cook wrote:
> I got one from mysql@lists.mysql.com, and one from [EMAIL PROTECTED]
>
> And my filters remove anything that isn't from one of the mailing lists
> I subscribe to.
Did the spam actually come through the list, or did it just fake the From to
m
I found a log error after turning on warning running the server manually:
051215 17:32:42 [Warning] Aborted connection 3961 to db: 'db' user:
'user' host: `client' (Got timeout reading communication packets)
Any idea what this error is ? the interfaces show no errors from a
network perspect
NO,no.
I want to say,if i my funciton is a non-deterministic function.But i define
then function with "deterministic" option.
for example:
-
create function test()
return int
DETERNINISTIC
routine_body
---
Thanks, this and the from ISC Edwin Cruz helped, it what I was wanting.
Payne
Sameer wrote:
Payne wrote:
Hi,
I having a problem doing a simple count with the way date is format
2005-12-11 21:49:36, what I am wanting to do is a simple count where
it only returns just the date. What do i ne
Payne wrote:
Hi,
I having a problem doing a simple count with the way date is format
2005-12-11 21:49:36, what I am wanting to do is a simple count where
it only returns just the date. What do i need to do to get it where is
(2005-12-11) and for that matter switch the date to us format. Here
on 12/15/05 4:51 PM, Payne at [EMAIL PROTECTED] wrote:
> Hi,
>
> I having a problem doing a simple count with the way date is format
> 2005-12-11 21:49:36, what I am wanting to do is a simple count where it
> only returns just the date. What do i need to do to get it where is
> (2005-12-11) and f
Hi,
I having a problem doing a simple count with the way date is format
2005-12-11 21:49:36, what I am wanting to do is a simple count where it
only returns just the date. What do i need to do to get it where is
(2005-12-11) and for that matter switch the date to us format. Here the
sql state
Hi Stephen,
Unfortunately this is not a moderated list. Basically anybody can join,
send an email and then vanish. Nothing much to be done about it. I would
however note, this is only about the third time in a couple of years
listening that I've seen anything.
Regards
David Logan
Database Admini
I got one from mysql@lists.mysql.com, and one from [EMAIL PROTECTED]
And my filters remove anything that isn't from one of the mailing lists
I subscribe to.
Daniel Kasak wrote:
Stephen Cook wrote:
What's the deal with SPAM on the list?
I don't see any. Maybe my spam filter is better than
Gleb,
I watched the server during this error, the server continued to run...
it didnt crash... and no warning or logged error?
Regards,
Doug
Doug Dalton wrote:
Gleb Paharenko wrote:
Hello.
Check that MySQL doesn't die during the query. See:
http://dev.mysql.com/doc/refman/5.0/en/gone-a
Oops, forgot ',' at the end of the 3rd line.
> Try this:
>
> CREATE TABLE tablename (
> `id` mediumint(9) NOT NULL auto_increment,
> `name` varchar(50) NOT NULL default ''
> PRIMARY KEY (`id`)
> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
>
>> Greetings,
>>
>> I have a bunch of names and addres
Try this:
CREATE TABLE tablename (
`id` mediumint(9) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default ''
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
> Greetings,
>
> I have a bunch of names and addresses that I am adding to MySql
> database. I would like to auto
Try this:
CREATE TABLE tablename (
`id` mediumint(9) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default ''
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
> Greetings,
>
> I have a bunch of names and addresses that I am adding to MySql
> database. I would like to auto
Gleb Paharenko wrote:
Hello.
Check that MySQL doesn't die during the query. See:
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
Gleb,
I should mention that I get no log errors and I even have it set to warn
does this mean mysql could die and not log the error? I have gone
th
Howdy all.
I need to define a cursor in a stored procedure but I
don't know what the nature of the select statement is
going to be until runtime. I need to do something like
the code below:
IF (INSTR(city_name, ',') > 0) THEN
DECLARE cur_neighborhood CURSOR FOR
SELECT DISTINCT neighborhood
On Wednesday 14 December 2005 16:31, Joseph Alotta wrote:
> Greetings,
>
> I have a bunch of names and addresses that I am adding to MySql
> database. I would like to automatically assign a unique sequence
> number to each person. Is there a way to do this easily?
>
> idname
> 1 bob jones
Greetings,
I have a bunch of names and addresses that I am adding to MySql
database. I would like to automatically assign a unique sequence
number to each person. Is there a way to do this easily?
idname
1 bob jones
2 larry smith
3 henry rogers
Thanks for you help,
Jo
Hi all,
The documentation states: "MySQL has two Unicode character sets. You
can store text in about 650 languages using these character sets."
and goes on to show collations for UCS-2 and UTF-8. Does that mean
that UTF-16 and UTF-32 are not supported in MySQL (aside from MaxDB
supporting UTF-1
Hello.
Check that MySQL doesn't die during the query. See:
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
oug Dalton wrote:
> I am running mysql 4.1.13 on Suse 10 and I get an error on a simple
> select query, I have checked the threads on lost connection and my
> connection
Hello.
In my opinion, master shouldn't have any problems, but slave can have
different data than master.
>What would happen if i call a non-deterministic function that have been
>declared deterministic.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
Thi
Hello.
> server version: 4.0.18-log ( I know it's old but we can't update for
>the moment )
MySQL shouldn't die even under huge load, it is bad that you can't
update, and work with old version which has lots of bugs. Do you have
a stack trace in the error log? Please, resolve and send it
Hello.
Have you used bulk inserts or single line inserts?
In case of single inserts check your tests with bulk inserts
and increase the max_allowed_packet (both for server and client).
PgmHelmi wrote:
> So no answer is an answer too!
>
> As nobody wants to answer me, I have to suppose t
Hello.
In my opinion, a lot of depends on your table structure and
InnoDB settings. You can get a number of rows proceed during conversion
using 'SHOW INNODB STATUS'. In such a way you determine an average
speed.
Nathan Gross wrote:
> Hi;
> Is there a formula I can go by in order to
Hello.
In your query BENCHMARK() doesn't execute the query, it is
passed just like a string to the second argument of the BENCHMARK().
Raimundo Sierra wrote:
> It is not clear to me what benchmark really does. Example:
>
> SELECT SQL_NO_CACHE * FROM mytable where myVarcharRow like 'som
Hello.
Please, could you provide the CREATE statement for you tables
and describe the relationships between their fields (it will
be good if you include sample data as well).
Matthew Batt wrote:
> Hi
>
> I need to update the 'products_id' field (shown below) by copying data
> from
>
> Roberto Rodriguez Garrido wrote:
>
> > MySQL hangs every 30 minutes, it start to make a big process and when I
> make a
>
> > show variables I get that values:
I don't use Linux myself but I read a post on the Postgres list a while back
about the Linux Out-of-memory Process Killer. This needs
Hi;
Is there a formula I can go by in order to estimate how long it would
take to change over from innodb to myisam. Say for a 100meg file, a 5
gig table, etc.
Thank you;
-nat
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[
Dilipan,
can you please post the complete .err log that also contains information
about the crashes. If there are stack traces, please resolve them.
The workload inside InnoDB does not look that big if what you have posted is
a typical SHOW INNODB STATUS\G. Is that the case?
What does 'top'
I'm trying to think of the ways I can accomplish having a master
database of countries and states/provinces that I can reference in
several other databases.
I'd like to have a table of countries available for selection by the
users in a web app, but I'm not sure of the best way to then allow t
Hi I need some optimization help.
I currently have this query "SELECT COUNT(*) as count,sum(p.amt) as
total,p.batch,m.username,m.id,p.method,DATE_FORMAT(p.occur, '%M %d, %Y') as
dateBought FROM pay p LEFT JOIN members m ON m.id=p.mid WHERE
p.method!='none' AND p.method!='' GROUP BY p.batch ORDE
The document says it evaluates the 'expr', so I'm guessing it is only
function calls and arithmetic evaluation. Although I have tried selects
without any luck. It could probably be documented a little more clearly,
or event better yet...a supported feature.
Ed
-Original Message-
From: Rai
Hi. If you place these documents in the appropriate directory on the
remote machine, a directory in which they can be served over the internet,
then you should be able to link to them using a hyperlink reference (i.e.
http://). The other option is to have PHP grab these documents for you
using
On Thursday 15 December 2005 15:01, Darrell Troth wrote:
> I am designing an intranet for a law firm. Everything works fine. My
> problem is that they need to include the documents that are relative to
> specific cases in their database. These documents are on a different
> computer and I cannot fi
I am designing an intranet for a law firm. Everything works fine. My problem
is that they need to include the documents that are relative to specific
cases in their database. These documents are on a different computer and I
cannot find how to link to them at their current location. I have found ho
Hello.
In what section of my.ini have you put default_character_set? You have
had to put it into [client] sections. Check that your program reads my.ini.
>Now,i use default_character_set=utf8 in my.ini.
>When i restart my server,"character_set_database" and
>"character_set_server" c
This should be working.
You can respond directly to me with schema and SQL that you are using and I
can try to reproduce in-house.
Thanks,
Jonathan Miller
Austin, Texas USA
Senior Quality Assurance Developer
MySQL AB www.mysql.com
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /
/ /
Hi Cory - nice to see a fellow Lasso user here!
I've not use transactions myself but I think you might be having a problem with
autocommit.
http://dev.mysql.com/doc/refman/5.0/en/commit.html
HTH,
James Harvard
At 12:44 am -0700 15/12/05, Cory @ SkyVantage wrote:
>I have a transaction that is ve
Hi
I need to update the 'products_id' field (shown below) by copying data from
a separate table but I can't use the 'UPDATE' query as each 'product_id'
entry relates to a specific 'products_model' row.
id / assembly_no / products_id / products_model
1 / 2313 / *** / CASEACERENTRY2
2 / 2313 /
Hi all,
We have a MySQL server used for a queueing system. It worked fine so far
but now we are experiencing some load problems couple with crashes.
The load ( around 5-7 ) is due, according to vmstat, to processes
waiting for the CPU. And it makes sense because the CPU is used 100%
most of
Hi,
I am using Mysql
4.1.15(mysql-standard-4.1.15-sun-solaris2.8-sparc-64bit)on
a solaris machine. My application is running on
weblogic8.1 sp2.
I have configured the mysql connection pool on
weblogic and tested from configuration wizard. I am
facing issues when connecting to Mysql pool from my
> I execute follow procedure:
>
> ---
> create procedure test_transation_rollback()
> begin
>start transaction;
>create table t_34d (c1 int,c2 char(30));
>rollback;
> end
> -
I execute follow procedure:
---
create procedure test_transation_rollback()
begin
start transaction;
create table t_34d (c1 int,c2 char(30));
rollback;
end
After execut
> I create a table using the follow statement:
>
>CREATE TABLE test_check(NO_W_ID int ,NO_D_ID int,MM int,CT int,CHECK(MM
> 3));
>
> But server allow a insert statement as follow,why?
>
>insert into test_check values(1,1,1,1);
Because MySQL does not support CHECK constraints.
Yes, it pa
Hi
Thanks for the test, I try it and could get it worked ... so I dig a little
deeper and found that I had defined a unique index on data ! and doing
something like concat(data, ' copy') in the insert query solved the problem !
Thanks a lot for helping !
François
> -Original Message-
44 matches
Mail list logo
