-Original Message-
From: michael_wu[吳宏達]
Sent: Tuesday, May 25, 2004 3:08 PM
To: '[EMAIL PROTECTED]'
Subject: RE: create database in specified character set
Many thanks! I had downloaded V4.1.1 and created a database in utf8
character set.
I successfully created a table and inserted r
Got an offline answer, so I'm all set. Gotta love SQL.
for posterity...
Try:
SELECT cn.name, cd1.desc ,cd2.desc
FROM contact AS cn, codes AS cd1 codes AS cd2
WHERE cn.city = cd1.code AND cn.state = cd2.code
given:
CREATE TABLE `codes` (
`id` int(11) NOT NULL auto_increment,
`code` varchar(16) d
well, that explains it.
Many thanks!
-- -
Louie Miranda
http://www.axishift.com
- Original Message -
From: "Terry Riley" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 25, 2004 3:35 PM
Subject: Re: field = order, data not inserting?
> Probable cause: 'order' is a reserv
Probable cause: 'order' is a reserved word in MySQL (as used in 'order
by').
Terry
--Original Message-
> I have a field named "order" i think im missing something obvious, but i
> cant find it.
> When i insert something on the field order via PHP, no data on all of my
> field
On 24 May 2004, at 6:05 pm, Gilbert Wu wrote:
Hi All,
The dump file is a 4Gytes text file. Could find an editor able to look
at the content of the file. Hence, I had to write a little Perl
program (something I haven't done for 5 years). I discovered the line
that caused a syntax error wheneve
I've been trying to learn how to make a form that
visitors can use to add, delete or modify information
on a MySQL table. I made such a form that worked when
I first jumped into MySQL a few weeks ago, but now I
can't seem to recreate it.
I'm following a tutorial at
http://hotwired.lycos.com/webmon
For posterity (ie the archives) there's a comma missing in the FROM line:
FROM contact AS cn, codes AS cd1, codes AS cd2
Roddie Grant
on 25/5/04 8:25 am, Greg Willits at [EMAIL PROTECTED] wrote:
> Got an offline answer, so I'm all set. Gotta love SQL.
>
> for posterity...
>
> Try:
> SELECT cn
Hi,
I am working with PHP and the PEAR Nested Set class.
There is the following table structure:
id parent_id order_num level left_id right_id name
5 5 1 1 1 10 Root A
7 7 1 1 1 4 Root B
6 5 1 2 2 5 Sub1 of A
1 5 2 2 6 9 Sub2 of A
2 5 1 3 3 4 Child of Sub1
3 5 1 3 7 8 Child of Sub2
4 7 1 2 2 3 S
> id parent_id order_num level left_id right_id name
> 5 5 1 1 1 10 Root A
> 7 7 1 1 1 4 Root B
> 6 5 1 2 2 5 Sub1 of A
> 1 5 2 2 6 9 Sub2 of A
> 2 5 1 3 3 4 Child of Sub1
> 3 5 1 3 7 8 Child of Sub2
> 4 7 1 2 2 3 Sub of B
>
> When this tree is outputed as a menu structure it looks correct. I just
Here is a methodology i use
action=update&ID=1
action=insert
action=edit
on delete if the delete button is pressed that is $_POST['delete'] it will
delete the entry
i use a switch statement on the action request
> -Original Message-
> From: David Blomstrom [mailto:[EMAIL PROTECTED]
>
I need to get a debtors summary from the info in my database. What I need
is the sum of amounts invoiced for each person from the invoice table, and
the sum of amount paid from the payments table again by person.
What I have so far is:
create temporary table debtors
select people.surname, peop
Hi,
I have just inherited a ticketing system that uses MySql from an
employee that just left the company and I am a newbie to mysql. I cannot
seem to be able to get into the mysql console to do anything.
I have tried commands such as mysql -q etc and no joy. I get a command
not found when enterin
On May 25, 2004, at 4:00 AM, Enda McGahern - Ireland wrote:
I have just inherited a ticketing system that uses MySql from an
employee that just left the company and I am a newbie to mysql. I
cannot
seem to be able to get into the mysql console to do anything.
I have tried commands such as mysql -
Hello,
I'm hoping this is the correct list to post my question ( I was also considering mysql
internals), if not
accept my apologies.
I wish to write a mySQL extension, that will do some filtering on all data before it
is send out to the
requesting clients. Is there an API that will allow me to
On Tue, 25 May 2004 11:50:11 +0100, Paul Owen <[EMAIL PROTECTED]> wrote:
> What I have so far is:
> from people, invoice, payments
> where people.pid=invoice.pid
> and people.pid=payments.pid
> group by people.pid;
Though it doesn't fix the problem you're asking about, I wanted to
note that you'
> http://localhost/geowebworks/php/exp3.php?CCode=caf
>
> That looks right; caf (for "continent-Africa") is the
> value for the CCode field on the Africa row. But if I
> type something in the form and press submit, the
> change isn't reflected in my MySQL table.
My thought is that the tutorial us
>$sql = "UPDATE Continents SET
> CCode='$CCode',Name1='$Name1',Type1='$Type1',Group='$Group',Hemisphere='$Hemisphere',ID1='$ID1'
Also, this has a pretty severe logic flaw. If someone changes the
CCode field, this sql statement won't function as desired. :)
Ryan Fox
--
MySQL General Maili
Hey group,
I am in need of some suggestions. I am a senior programmer for a
fortune
500 where we mostly use Oracle and MS SQL Server. However, a project
came
along and no one wanted to spend more money on Oracle or SQL Server
licenses
so I suggested MySQL and to my surprise they let me set it up
> of data. How big of a DB can MySQL handle? After two days of running
> there
> are 2,160,000 or so records in the database.
Size of database is generally limited by available diskspace.
MyISAM tables are stored in seperate files per table, so the filesystem
might initially limit the size since
Dear List,
I am working on a database of electronic compositions (and installations
etc.) and currently have, amongst others, the following tables:
ARTIST(_id_,...)
SCORE(_id_,_artist_id_,...)
COMPOSITIONS(_id_,_score_id_,...)
INSTALLATIONS(_id_,_score_id_,...)
PERFORMANCES(_id_,???)
The PERFOR
It does not have to use an index because you have not supplied row
restriction criteria. An index is being used to relate the two tables.
-Original Message-
From: Daniel Cummings
To: [EMAIL PROTECTED]
Sent: 5/24/04 6:05 PM
Subject: Understanding Explain in 4.1
These are two simple stock q
You probably don't have to worry about hitting MySQL limits. Everything
I've read and heard say you hit OS limits first.
For full text searches, you definitely want to use match/against. If
you are only interested in one months worth of data, are you deleting
"old" records on a regular basis
Hi Richard,
Can you make a relationship between COMPOSITIONS and INSTALATIONS? If so,
then you make a relationship between COMPSOTIONS_ONSTALATIONS and
PERFORMANCES.
Laercio.
-Original Message-
From: Richard Lewis [mailto:[EMAIL PROTECTED] On Behalf Of Richard Lewis
Sent: terça-feira,
> >
> > I have a web app to allow admins to search this table. Any searches by
> > MsgDate, MsgTime, MsgPriority or MsgHostname or any combination of them
> > runs
> > pretty fast. When I try to do a search against MsgText, it takes quite
> > a
> > while. I originally tried INSTR(), however
-Original Message-
From: Jigal van Hemert [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 25, 2004 7:56 AM
To: [EMAIL PROTECTED]
Subject: Re: FULLTEXT and large database
> > Using Match() Against() showed the Kiwi_MsgText FULLTEXT index
getting
> > used.
>
> Correct. Full text indexes can
Hi All,
Whats the fastest way to speed up inserts?
I have a table which I insert into once a week (about 20-30k Rows)
And select from all the time...
Is the only way to speed up inserts to remove indexes?
And to speed up selectes, ...add the indexes again?
Regards,
Amit
--
MySQL General Mailing
well, you could try mass insertion... instead of inserting each row one by
one
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Use:
ALTER TABLE DISABLE KEYS
... inserts here
ALTER TABLE ENABLE KEYS
mirza
[EMAIL PROTECTED] wrote:
Hi All,
Whats the fastest way to speed up inserts?
I have a table which I insert into once a week (about 20-30k Rows)
And select from all the time...
Is the only way to speed up inserts to re
From: "James Drabb" <[EMAIL PROTECTED]>
> From: Jigal van Hemert [mailto:[EMAIL PROTECTED]
> So is there any way to efficiently search a TEXT field of 5 million rows
> for exact phrases? In this case the MsgText field contains a
> descriptive
> error message that the admins want to search for to h
That fixed it, Thanks!
-Original Message-
From: Mirza [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 25, 2004 7:46 PM
To: [EMAIL PROTECTED]
Subject: Re: Speeding up Inserts
Use:
ALTER TABLE DISABLE KEYS
... inserts here
ALTER TABLE ENABLE KEYS
mirza
[EMAIL PROTECTED] wrote:
> Hi Al
At 08:55 AM 5/25/2004, you wrote:
Hi All,
Whats the fastest way to speed up inserts?
I have a table which I insert into once a week (about 20-30k Rows)
And select from all the time...
Is the only way to speed up inserts to remove indexes?
And to speed up selectes, ...add the indexes again?
Regards,
Select count(distinct("field")) from "table" where field >= 0 ?
-Original Message-
From: Laercio Xisto Braga Cavalcanti
[mailto:[EMAIL PROTECTED]
Sent: Monday, May 24, 2004 11:18 PM
To: 'John Nichel'; 'MySQL List'
Subject: RE: Query question
You can do:
Select count(distinct("field"))
[EMAIL PROTECTED] wrote:
> Whats the fastest way to speed up inserts?
> I have a table which I insert into once a week (about 20-30k Rows)
> And select from all the time...
>
> Is the only way to speed up inserts to remove indexes?
> And to speed up selectes, ...add the indexes again?
>
Take a l
I should have mentioned,
I get data in a text file, Pipe Seperated, Double Quotes Qualifiers,
Eg.
"col1"|"col2"|"col3"
I tried Load Datafile,
Didn't work for me,
It skips an additional left most character from Col1,
So I get 'ol1' instead of 'col1'
..so as of now, I
michael_wu[吳宏達] wrote:
> Many thanks! I had downloaded V4.1.1 and created a database in utf8
> character set.
> I successfully created a table and inserted rows of data with VARCHAR
> columns into the table through the SQL pad.
> With the Control Center GUI, I can see the result. It seems the da
You may try increasing your sort_buffer_size and key_buffer_size, see
if that speeds up the searching and sorting.
On May 25, 2004, at 9:54 AM, James Drabb wrote:
When I run a FULLTEXT search and view the process list of MySQL in
MySQL,
I see in the state column that MySQL is "sorting results" wh
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 25, 2004 8:52 AM
To: [EMAIL PROTECTED]
Cc: James Drabb; [EMAIL PROTECTED]
Subject: Re: FULLTEXT and large database
> One thing that ocurs to me is that, if you are using it for syslog
type
> data, the
-Original Message-
From: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 25, 2004 9:50 AM
To: James Drabb
Cc: Jigal van Hemert; [EMAIL PROTECTED]
Subject: Re: FULLTEXT and large database
> You may try increasing your sort_buffer_size and key_buffer_size,
> see if that speeds up
"James Drabb" <[EMAIL PROTECTED]> wrote on 25/05/2004 16:30:07:
> The text 'May' is in the column, yet I get no rows returned? The admins
> are looking
> to be able to search for an arbitrary string in the MsgText field that
> can be anywhere
> in the field not just at the beginning. So
We downloaded 4.1.1a build, but all the new APIs for transaction and
prepared statements are missing from the libmysql.dll. Is there a build for
4.1.x that we can use to test these APIs? Thanks.
_
MSN Toolbar provides one-click ac
Using PHP i'm not able to insert a binary variable into a field of type
mediumblob of mysql.
The command I've used is:
$cfg_Query = "Insert into (operazioni, datacreazione) Values
('".$contents."', Now())";
$result = mysql_query($cfg_Query, $conn)
where $contents is the binary variable.
Can an
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Harald Fuchs
Sent: Tuesday, May 25, 2004 11:18 AM
To: James Drabb
Subject: Re: FULLTEXT and large database
> > I seem to get inconsistent results when using the FULLTEXT index
> > speed-wise on 3 million+ rec
I am trying to programatically connect to my DB, but I
am not sure what the connection string should be. I am
using this statement:
conn =
DriverManager.getConnection("jdbc:mysql://localhost/test?user=scott&password=cuatro");
I am getting this exception message:
database_test.DBConnector
S
try adding a
Class.forName("com.mysql.jdbc.Driver").newInstance()
before DriverManager.getConnection(...
It should register the mysql jdbc driver.
> -Messaggio originale-
> Da: Scott D. Spiegler [mailto:[EMAIL PROTECTED]
> Inviato: martedi 25 maggio 2004 18.37
> A: [EMAIL PROTECTED]
>
Hi there,
I'm getting a strange behaviour when returning a value from my user defined
function. When I print the return value inside of the function, I get one
answer (the correct one), however mysql reports a different value all together.
Is this my programming error or a mysql bug?
Here's wha
-Original Message-
From: Scott D. Spiegler [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 25, 2004 11:37 AM
To: [EMAIL PROTECTED]
Subject: Unable to Programatically Create DB Connection
> I am trying to programatically connect to my DB, but I am not sure
what
> the connection string should
Hi Scott,
You must register the driver first. Example :
import com.mysql.jdbc.Driver;
...
public Connection getConnection () throws SQLException {
DriverManager.registerDriver (new Driver());
Connection conn = DriverManager.getConnection
(
Scott D. Spiegler said:
> I am trying to programatically connect to my DB, but I
> am not sure what the connection string should be. I am
> using this statement:
>
> conn =
>
> DriverManager.getConnection("jdbc:mysql://localhost/test?user=scott&password=cuatro");
>
> I am getting this exception me
Hi everyone,
I am trying to set up database replication, and would like to know if I
can store just a subset of data in the slave DB. Anyone has any insight?
Thanks in advance,
Callan
signature.asc
Description: This is a digitally signed message part
What do you mean by storing a subset? Are you only wanting to replication a
portion of the tables? If so, you can configure the master to ignore certain
databases or you can configure the slave to apply updates for certain
databases/tables or prohibit the master from replicating certain
databases/t
Hi Victor,
Thanks for your reply. Yes, I did mean to only replicate certain tables,
so your answer fits to a tee. Thanks!
On Wed, 2004-05-26 at 01:12, Victor Pendleton wrote:
> What do you mean by storing a subset? Are you only wanting to replication a
> portion of the tables? If so, you can conf
Mysql is not sorting 200 rows, its sorting the entire found set and
then returning the first 200 rows after it's sorted properly. So if
your search found 2 million matches, it's going to sort the 2 million
records, then return the first 200 records. Specifying a limit saves
times on I/O sin
Is there an aggregate function that multiplies column values just like SUM()
adds them?
For instance, if "SELECT value FROM data" returns three values 2, 3, and 4,
then "SELECT PRODUCT(value) FROM data" would return 24, which is 2 * 3 * 4.
Thanks!
---
Fyodor Golos
Stockworm, Inc.
Query:
insert into
MIS.simcard(ID,ShipID,Service_Provider,SN,v1,v2,f1,d1,puk1,puk2,pin1,pin
2,TwoStage,Status,DateAssigned,DateDisabled,UserID)
VALUES('NULL', '6889927707', '1', '8988169214000421398', '881621456175',
'', '', '881693156175', '62982149', '', '', '', '1307', '1',
'1085508771',
Set the fieldtype to 'bigint'
It's the limit on int
"Jeff McKeon" <[EMAIL PROTECTED]>
05/25/2004 02:29 PM
To: <[EMAIL PROTECTED]>
cc:
Subject:Very Strange data corruption
Query:
insert into
MIS.simcard(ID,ShipID,Service_Provider,SN,v1,v2,f1,d1,puk1,
Three tables:
computers (Describes computers)
users (Describes users)
comp-user-link (Links users to computers in a 1 user to many computers
relationship)
Could someone offer advice on how to construct a select statement to
show which users aren't in the comp-user-link table? Sort of the reve
From: Jeff McKeon [mailto:[EMAIL PROTECTED]
> Query:
>
> insert into
> MIS.simcard(ID,ShipID,Service_Provider,SN,v1,v2,f1,d1,puk1,puk
> 2,pin1,pin
> 2,TwoStage,Status,DateAssigned,DateDisabled,UserID)
> VALUES('NULL', '6889927707', '1', '8988169214000421398',
> '881621456175',
> '', '', '88169
No there is not. Two options could be to either create an UDF or use a
programming language.
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 5/25/04 1:25 PM
Subject: is there a PRODUCT() or MULTIPLY() aggregate function?
Is there an aggregate function that multiplie
Jeff,
You are trying to exceed the limits of the INTEGER column. INTEGERs top out
at 2GB-1 (or 2147483647). May I suggest you change your table to use a
larger integer type like BIGINT. With BIGINT fields you can go all the way
to 9223372036854775807.
MySQL will give you the nearest possible num
If you are using a version that supports sub-selects you could perform a
subquery.
Otherwise,the solution depends on your primary keys.
SELECT u.*
FROM users u
LEFT OUTER JOIN
comp-user-link c
ON u.userID = c.userID
WHERE c.userID IS NULL
-Original Message-
From: Brad Tilley
To: [EMAIL PRO
Actually the Field type is fine. It was user input error. The person
who created the ship ID added an extra digit, normally they are only 9
digits long. I didn't catch it until I looked at a list of all the
ShipID's together and then it stuck out like a sore thumb.
Thanks for all the explanatio
Brad,
This is also a design issue. Generally when designing tables to support a
one-to-many relationship, you put a pointer field in the "many" table and
load it with the ID value of the "one" that it relates to. In this case you
would want a nullable field like "users_id" on your computers table
I should better describe the tables:
computers has 'comp_id' as its primary, unique key.
users has 'user_id' as its primary, unique key.
comp-user-link has two (and only two fields) that are *never* null:
'comp_id' (which must be unique), and 'user_id'
Every computer is linked to a user... the pro
Victor-
It's a little misleading. It looks like it's going to do a full table scan
of the Monday table.
Dan
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 25, 2004 6:18 AM
To: 'Daniel Cummings '; '[EMAIL PROTECTED] '
Subject: RE: Understanding E
I am trying to come up with a query that takes two tables, one with
non-split-adjusted historical stock prices, and one with information on
splits, for instance:
CREATE TABLE quotes (
symbol VARCHAR(127)NOT NULL,
dateDATENOT NULL,
quote FL
MySQL really should throw an exception/error rather than just quietly
trim your data and accept it. When your data is critical, and your
business depends on it, you can't have bad data quietly going into the
database.
David.
Mike Johnson wrote:
From: Jeff McKeon [mailto:[EMAIL PROTECTED]
Que
Brad Tilley wrote:
I should better describe the tables:
computers has 'comp_id' as its primary, unique key.
users has 'user_id' as its primary, unique key.
comp-user-link has two (and only two fields) that are *never* null:
Except within the context of a left join.
Every user in a left join mat
Victor & Shawn,
Thanks for the select info and the relationship info. Both of your
examples worked.
The reason we designed a separate linking table is that we wanted to
always keep the computers separate from the users. A container of users
and a container of computers with a linking table join
giovanni cordeschi wrote:
Using PHP i'm not able to insert a binary variable into a field of type
mediumblob of mysql.
The command I've used is:
$cfg_Query = "Insert into (operazioni, datacreazione) Values
('".$contents."', Now())";
$result = mysql_query($cfg_Query, $conn)
It doesn't appear the
It is going to do a full table scan of the Monday table trying to return all
rows that are in the Friday table. You have restriction criteria outside of
your join.
-Original Message-
From: Daniel Cummings
To: 'Victor Pendleton'; [EMAIL PROTECTED]
Sent: 5/25/04 2:05 PM
Subject: RE: Underst
Ah yes, thank you Gerald.
I didn't understand this until now. I guess I should say that 'by
design' the linking table will never contain a null, but the left join
changes that. Thank you for pointing that out.
gerald_clark wrote:
Brad Tilley wrote:
I should better describe the tables:
computers
So you do have two ways to associate users with computers. One is directly
on the computers table and the other is through the link table. That leaves
me with two questions to answer:
Question 1) Are there any users that do not have an ID in the user_id
field on the computers table?
Question 2)
Brad Tilley wrote:
I should better describe the tables:
computers has 'comp_id' as its primary, unique key.
users has 'user_id' as its primary, unique key.
comp-user-link has two (and only two fields) that are *never* null:
'comp_id' (which must be unique), and 'user_id'
Every computer is linked t
From: David Griffiths [mailto:[EMAIL PROTECTED]
> MySQL really should throw an exception/error rather than just quietly
> trim your data and accept it. When your data is critical, and your
> business depends on it, you can't have bad data quietly going
> into the
> database.
Someone correct m
We are running 3.23.58 on Solaris 8 and seeing the following problem.
Periodically, mysqld gets into a state where we can't query just one
table in all of our DBs--queries just hang. Restarting mysqld always
fixes the problem, but a SIGKILL is required to stop it.
Could this be something is corru
> -Original Message-
> From: David Griffiths [mailto:[EMAIL PROTECTED]
> MySQL really should throw an exception/error rather than just quietly
> trim your data and accept it. When your data is critical, and your
> business depends on it, you can't have bad data quietly going
> into th
David Griffiths wrote:
MySQL really should throw an exception/error rather than just quietly
trim your data and accept it. When your data is critical, and your
business depends on it, you can't have bad data quietly going into the
database.
David.
Mike Johnson wrote:
A value is not valid just
You are beyond the realm of SQL. What you would need for something like
this is a dynamically-generated case statement that would apply different
multipliers based on the date of the quote you are trying to adjust. For
those quote values that exist BEFORE multiple splits you must adjust by the
PRO
CLASSIFICATION: UNCLASSIFIED
who knows
-Original Message-
From: Mike Johnson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 25, 2004 12:26 PM
To: David Griffiths; [EMAIL PROTECTED]
Subject: RE: Very Strange data corruption
From: David Griffiths [mailto:[EMAIL PROTECTED]
> MySQL really sh
I really thought that MySQL tried to produce MySQL cluster for common
hardware and with the design principle; more nodes with common hardware,
insted of few nodes with extreme hardware. That to get higher
availability (Much like the GFS (Google File System)). If the memory
usage (RAM) as I have
What does show processlist return when this is happening? Is anything being
logged to the error log?
-Original Message-
From: Brandon Metcalf
To: [EMAIL PROTECTED]
Sent: 5/25/04 2:33 PM
Subject: DB hanging
We are running 3.23.58 on Solaris 8 and seeing the following problem.
Periodically,
It's best practice to write unit tests for all your code, with
calculated data to show what you expect. That data then gets compared to
what is actually generated and if there is a discrepency, then you have
a bug somewhere.
But the reason modern databases have foreign keys, primary keys,
not-
David Brodbeck wrote:
The client software ought to be range-checking the data before sending
it to
the database. If the client isn't even doing that kind of minimal-effort
check, how likely is it to be checking for exceptions?
That's not to say that an error or exception is a bad idea, but MySQL
At 09:32 AM 5/25/2004, [EMAIL PROTECTED] wrote:
I should have mentioned,
I get data in a text file, Pipe Seperated, Double Quotes Qualifiers,
Eg.
"col1"|"col2"|"col3"
I tried Load Datafile,
Didn't work for me,
It skips an additional left most character from Col1,
So I g
What error message are you getting or how are you verifying that the data is
not loading correctly?
-Original Message-
From: giovanni cordeschi
To: [EMAIL PROTECTED]
Sent: 5/25/04 11:23 AM
Subject: Problem while insert binary
Using PHP i'm not able to insert a binary variable into a field
V == [EMAIL PROTECTED] writes:
V> What does show processlist return when this is happening? Is anything being
V> logged to the error log?
Nothing in the error log, but here's the output from show processlist:
mysql> show processlist;
+-+--++---
Brandon Metcalf wrote:
We are running 3.23.58 on Solaris 8 and seeing the following problem.
Periodically, mysqld gets into a state where we can't query just one
table in all of our DBs--queries just hang. Restarting mysqld always
fixes the problem, but a SIGKILL is required to stop it.
Have you t
The client software ought to be range-checking the data before sending it to
the database. If the client isn't even doing that kind of minimal-effort
check, how likely is it to be checking for exceptions?
Not sure what you code in, but in Java, you *HAVE* to catch
SQLExceptions (or throw them
m == [EMAIL PROTECTED] writes:
m> Brandon Metcalf wrote:
m> > We are running 3.23.58 on Solaris 8 and seeing the following problem.
m> > Periodically, mysqld gets into a state where we can't query just one
m> > table in all of our DBs--queries just hang. Restarting mysqld always
m> > fixes
David Griffiths wrote:
I'm not sure what the sql standard says on the matter, but Oracle, DB2
and Postgres would through an exception. In fact, there is a page on
MySQL "gotachs" to document MySQL behaviour when it differs
significnatly from other databases (like the first datetime field in a
t
This complicates the database. This discussion has come up hundreds of
times on this list.
NULL/NOT-NULL is a basic check, and by saying NOTNULL, you're telling
mysql to fail it.
Same thing with Syntax checks, they're just that.
The different INT fields are provided to make the database more e
I need to prepare some sql scripts which take parameters... how can I do?
For example, suppose I want to have a sql script to create a new user granting to him
some privileges and inserting its name in some application specific tables
--
MySQL General Mailing List
For list archives: http
David Griffiths wrote:
But the reason modern databases have foreign keys, primary keys,
not-nulls, check constraints and data-metadata (char(5), INT, BIGINT,
etc) is to prevent bad data from going in.. If no exception is thrown
because you are trying to put a BIGINT into an INT, then why throw o
How big is this table?
Do you run maintenance on this table?
What does the show index for this table look like?
-Original Message-
From: Brandon Metcalf
To: Victor Pendleton
Cc: '[EMAIL PROTECTED] '
Sent: 5/25/04 2:56 PM
Subject: RE: DB hanging
V == [EMAIL PROTECTED] writes:
V> What do
V == [EMAIL PROTECTED] writes:
V> How big is this table?
It has 7325 rows.
V> Do you run maintenance on this table?
Not regularly. I just ran myisamchk against it and here's what I got.
I'm not sure if this is useful since there are current connections:
Checking MyISAM file: /home/cmvobad
From: Steve Meyers [mailto:[EMAIL PROTECTED]
> David Griffiths wrote:
> > I'm not sure what the sql standard says on the matter, but
> Oracle, DB2
> > and Postgres would through an exception. In fact, there is
> a page on
> > MySQL "gotachs" to document MySQL behaviour when it differs
> > sig
a LEFT JOIN should do the trick
something like this:
SELECT users.user_id
FROM users
LEFT JOIN comps_users_link ON
(users.user_id=comps_users_link.user_id)
WHERE comps_users_link.computer_id IS NULL
olinux
--- Brad Tilley wrote:
> Three tables:
>
> computers (Describes computers)
> use
If you want to check a table while the database is being used I suggest
using mysqlcheck instead of myisamchk. The table is `relatively small. I
would suggest running an optimize table or an analyze table to reestablish
the cardinality.
-Original Message-
From: Brandon Metcalf
To: Victor
Jonas Oreland wrote:
Hi Daniel,
Daniel Ek wrote:
I really thought that MySQL tried to produce MySQL cluster for common
hardware and with the design principle; more nodes with common
hardware, insted of few nodes with extreme hardware.
we do.
I will probably never work for a company that can aff
I finally got my PHP add/edit form to work. While
working on it, it occurred to me that I could use it
to post and modify more than bits of data in tables. I
could use it to make pages that people with no web
design skills can add articles to.
Most of my post focuses on PHP; my main question
regar
1 - 100 of 125 matches
Mail list logo
