Hi,
I'm doing research on DBMS recently and have found
some bugs in mysql's source codes.I think it will be
more convenient to point out them directly than using
mysqlbug.The following are my finds.
mysqladmin -version output:
mysqladmin Ver 8.22 Distrib 3.23.44, for pc-linux-gnu
on i686
Copyr
/* [EMAIL PROTECTED] [[EMAIL PROTECTED]] writes: */
>I just wanted to know what Database does Yahoo Uses..
>
Perhaps this will provide you more of what you'd like to know...
http://www.mysql.com/articles/us/yahoo_finance.html
--
do svidaniya,
~mitch
-
On Friday, 28. June 2002 05:54, Arul wrote:
Hi,
>
> Just was curious to know...
> I saw a posting by one of the guys here that Yahoo uses MySQL.
> Is this true..
> Any idea how many MySQL servers does Yahoo Use amd for which domain they
> use MYSQL.
http://www.mysql.com/articles/us/yahoo_finance.
Hey Mike
I just wanted to know what Database does Yahoo Uses..
Not the OS
:)
-Arul
- Original Message -
From: "mos" <[EMAIL PROTECTED]>
To: "Arul" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, June 28, 2002 11:05 AM
Subject: Re: Does Yahoo Use MySQL?
> At 10:54 PM 6/27/200
At 10:54 PM 6/27/2002, you wrote:
>Hi
>
>Just was curious to know...
>I saw a posting by one of the guys here that Yahoo uses MySQL.
>Is this true..
>Any idea how many MySQL servers does Yahoo Use amd for which domain they use
>MYSQL.
>
>-Arul
Arul,
How much hoo could a Yahoo hoo
At 09:46 PM 6/27/2002, you wrote:
>hi,
>I had installed mysql 4.0 in win 2000.
>I used Command Prompt to connect to mysql and do all the sql query there.
>It is often/normal that we can make mistake in the typing.
>When i encounter this typing error,the mysql just like 'hang' it there.
>In order t
Hi,
I have a packet coming to the my-sql-server
port 1433.
I need a pointer about how to decode and understand
what that packet is.
The data in binary is:
121034001506101b01201c0c302804800ffc20004d5353514c5365727665
7208130
I would like to understand the content according to th
Hi
Just was curious to know...
I saw a posting by one of the guys here that Yahoo uses MySQL.
Is this true..
Any idea how many MySQL servers does Yahoo Use amd for which domain they use
MYSQL.
-Arul
-
Before posting, please ch
> Not sure there is much more metadata in an XML database than in a data
> database.
In a standard database, the data and metadata are stored separately, not so with XML.
When the next new "latest and greatest" thing
comes along, you'll have to strip all that metadata out of your data. It also
On Fri, 28 Jun 2002 10:46:40 +0800
"lorenzo.kh" <[EMAIL PROTECTED]> wrote:
> mysql> select * from mytable' ( I key in ' instead of ; )
> '>
> '> ?
> '> what the key should i use to reset this?
> '>
> '>
> '>
> '>
> '>
just type another ' and close with ;
hi,
I had installed mysql 4.0 in win 2000.
I used Command Prompt to connect to mysql and do all the sql query there.
It is often/normal that we can make mistake in the typing.
When i encounter this typing error,the mysql just like 'hang' it there.
In order to solve this,the only way i know is pres
The following is a neutered version of the query I am trying to run:
SELECT TableA.Field1, TableA.Field2, TableA.Field3, TableB.Field4,
TableA.Field5, TableC.Field6, TableA_1.Field3, TableB_1.Field4
FROM (TableB INNER JOIN ((TableA INNER JOIN TableA AS TableA_1 ON
(TableA.Field1 = TableA_1.Field1
On Thu, 27 Jun 2002 17:37:24 -0700
Patelli Paolo <[EMAIL PROTECTED]> wrote:
> mysql> SHOW MASTER STATUS;
> ++--+--+--+
> | File | Position | Binlog_do_db | Binlog_ignore_db |
> ++--+--+-
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: my
If:
An XML database is analogous to a "pure data" database
Then:
An XML document is the analog of a table
XML Entities are analogs of columns
XML Attributes are analogs of column properties (aren't these "metadata"?)
So:
Not sure there is much more metadata in an XML database than in a data
data
At 21:33 -0400 6/27/02, MikeParton wrote:
>Would be interesting to hear from Peter on why he feels the urge to store
>XML docs in MySQL (or, better said: I would be interested in hearing what
>he is trying to accomplish and why he...or someone...feels XML stored in a
>relational database is the w
At 15:15 -0400 6/27/02, walt wrote:
>On Thursday 27 June 2002 02:30 pm, Mike(mickalo)Blezien wrote:
>> Walt,
>>
>> Use Perl's 'undef' for NULL values.
>>
>> $quoted_some_variable = undef;
>>
>> now the $quoted_some_variable will be a null value.
>>
>> >>On Thu, 27 Jun 2002 12:50:55 -0400, wal
Would be interesting to hear from Peter on why he feels the urge to store
XML docs in MySQL (or, better said: I would be interested in hearing what
he is trying to accomplish and why he...or someone...feels XML stored in a
relational database is the way to go).
mysql, sql, xql, xquery, query
All depends on what you're trying to accomplish and the drivers behind the
path you wish (or need or have been mandated) to take.
Having said that, I make no claims with respect to the smartness of others
(I find I too often question that in myself to serve as a judge of others).
Nice little phi
> On the other hand, proclaimed "native" XML databases (eg, Software AG's
> Tamino, Ixiasoft's TEXTML) store the "XML-wrapped" data in the database...no
> need to wrap and unwrap the metadata, document/data structure from the data.
Isn't that more than a bit stupid? Databases are for storing dat
On Thu, Jun 27, 2002 at 08:16:52PM -0400, MikeParton wrote:
>
> On the other hand, proclaimed "native" XML databases (eg, Software
> AG's Tamino, Ixiasoft's TEXTML) store the "XML-wrapped" data in the
> database...no need to wrap and unwrap the metadata, document/data
> structure from the data.
T
On the other hand, proclaimed "native" XML databases (eg, Software AG's
Tamino, Ixiasoft's TEXTML) store the "XML-wrapped" data in the database...no
need to wrap and unwrap the metadata, document/data structure from the data.
- Original Message -
From: "Ed Carp" <[EMAIL PROTECTED]>
To: "
> I am looking at a project using XML to import and export data into MySql
> directly or using php. The datasets are quite large (40-50 million records)
XML is a metadata technology - you wrap data in XML. You don't use XML to import or
export data. You don't store XML in a
database, you store
On Thu, Jun 27, 2002 at 05:21:55PM -0400, [EMAIL PROTECTED] wrote:
> I've found a few useful commands for the MySQL Monitor:
>
> SHOW PROCESSLIST;
> SHOW VARIABLES;
>
> Is there anything else I can use to track user usage loads?
Have a look at mytop:
http://jeremy.zawodny.com/mysql/mytop/
Hi,
I'm trying to replicate a db.
I'm running MySQL 3.23.49a-log on a linux box as master and MySQL 3.23.49-log
on Solaris as slave.
I copied the data on the solaris box and I modified the cnf files.
The slave error message is the following:
020627 16:04:35 Slave: Failed reading log event, r
Ignoring the limit problem for just a moment, what are the performance
characteristics? Does this form have a less steep rows vs. time curve?
As for the limit problem, that sounds a bit like a bug in MySQL and should
be addressed as such.
-JF
> -Original Message-
> From: MySQL List [ma
On Thursday, 27. June 2002 21:26, [EMAIL PROTECTED] wrote:
Hi,
> I apologize for not being more specific. The query that is taking too long
> is :
> SELECT * FROM Stories WHERE UCASE(Path) LIKE 'toUpper(path)%';
> Path is a 255 char field with an index on it. path is variable passed in.
> Thanks
On Tue, Jun 25, 2002 at 06:52:36AM -0700, Zachary Denison wrote:
> Hi,
>
> I have setup successfully a mysql master / slave configuration
> however I would like to setup a system whereby updates could be
> performed on either system and then propagated to the other server
> (a master/master conf
Hi,
Can someone tell me which query would be faster with say 1000 rows:
SELECT * FROM table ORDER BY RAND() LIMIT 3;
or SELECT * FROM table;
then use php to get 3 random rows from the returned data?
-
Before posting, please
I tried this, but it seems to be ignoring the LIMIT 3, since it is returning
all the rows.
> Try:
> SELECT RAND() AS r, * FROM table ORDER BY r LIMIT 3;
>
> Off the top of my head, I'd guess that the reason for the slowdown has to
do
> with MySQL doing a new RAND() call for every comparison in t
Hello.
I'm new to this list.
My company runs a MySQL server(3.23.42), PHP, and Apache on a single 1Ghz PIII
server for our webhosting customers. Most of our customers don't use it. However,
we do have a few largish bulletin board(usually w-Agora) sites that do use MySQL.
Recently, our serve
MySQL has xml support...have you looked at the docs at mysql.com for
anything that might help you input the data directly...
B i g D o g
- Original Message -
From: "Peter Lovatt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, June 27, 2002 3:03 PM
Subj
Hi
I am looking at a project using XML to import and export data into MySql
directly or using php. The datasets are quite large (40-50 million records)
I haven't used XML before.
Does it take long to work out how to use php/XML? Are there any problems
working with large datasets?
Thanks
Peter
Hi all,
I am using MySQL (version 3.23.51-max-log). I have a problem with locking.
Let's assume that we have 2 connections (Conn1 and Conn2) and table test:
CREATE TABLE `test` (
`id` int(3) NOT NULL auto_increment,
`name` char(10)
On Thu, 27 Jun 2002, jason wesley upton wrote:
> Date: Thu, 27 Jun 2002 14:05:34 -0500
> From: jason wesley upton <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: MySQL Question involving AUTO INCREMENT and PRIMARY IDs. - sql
>
> EXPLANATION:
>
> here's the pertinent piece of my sql creat
On Thu, Jun 27, 2002 at 04:21:43PM +0200, Sander Pilon wrote:
>
> It has not been for us. Replication, query cache and fulltext stuff
> is borked. But, it's an alpha. Alpha's aren't supposed to be stable.
What replication problems have you seen?
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technic
Hi,
My system architecture is:
SunOS bigfoot 5.6 Generic_105181-30 sun4u sparc SUNW,Ultra-1
Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.6/3.0.2/specs
Configured with: ../configure --with-as=/usr/local/bin/as
--with-ld=/usr/local/bin/ld : (reconfigured) ../configure
--with-as=/
>[EMAIL PROTECTED] wrote:
>Henry, can you repeat it with binaries from MySQL site?
Unfortunately, no. This database server runs a very high traffic website, so I
can't easily (nor do I want to) start changing the mysql version and causing
alot of (or any) downtime. Except for this random and m
That is a difference in the behavior of
isam and myisam tables.
jason wesley upton wrote:
>EXPLANATION:
>
>here's the pertinent piece of my sql create statement:
>
>ID INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (ID));
>
>i have used this create statement numerous times without this "problem". in
Hi
A few thoughts. I am not an expert on this kind of use, so there may be
others with better suggestions :)
If every search is different then your search efficiency is critical. If you
fulltext index the field then it should help.
If not then what about indexing the text document words. You s
the question:
I am trying to use the C API to insert floating (4 byte) point data into a
mysql table. It is very desirable to put the data in as the binary
representation and not as a sprintf family converted string (to maintain
precision & improve performance). My initial attempt is below - pe
[EMAIL PROTECTED] writes:
> >Description:
>
>I have the max_user_connections set to 150 on every one of my servers but a
>single user is still able to use up to 250 connections. (max_connections=250)
>
> >How-To-Repeat:
>
>execute a huge query then send 250 updates
You brought it up.
You made the comparison.
Give us a break.
Dave Morse wrote:
>Looks like you want to bring up something that doesn't have anything to
>do with the original question which is your perogative. But please
>don't compare MySQL with Oracle and mainstream SQL RDBMSs. Give us a
>bre
shutdown the mysqld, move the data direectory,
and set up a symbolic link.
Rahadul Kabir wrote:
>Hi,
>I have MySQL3.23.47 running on a Cobalt RaQ4 System. The mysql
>installed datadir turned out to be /var/lib/mysql. /var directory has
>it's own partition (/dev/hda3) and total space available i
EXPLANATION:
here's the pertinent piece of my MySQL create statement:
ID INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (ID));
i have used this create statement numerous times without this "problem". in the past,
let's say i inserted 3 entries: A, B, and C. their IDs were 1,2, and
3. then i del
You could look into parted to resize partitions or copy the db to the
desired directory and restart the damon with safe_mysqld
--data-dir=/where/u/moved/db/to. I believe you'll also need to copy
over the mysql database to the new location as well or mysql will fail
to start. first, note your per
I apologize for not being more specific. The query that is taking too long
is :
SELECT * FROM Stories WHERE UCASE(Path) LIKE 'toUpper(path)%';
Path is a 255 char field with an index on it. path is variable passed in.
Thanks again.
Jeremy Beha
- Original Message -
From: "Benjamin Pflugman
On Thursday 27 June 2002 02:30 pm, Mike(mickalo)Blezien wrote:
> Walt,
>
> Use Perl's 'undef' for NULL values.
>
> $quoted_some_variable = undef;
>
> now the $quoted_some_variable will be a null value.
>
> >>On Thu, 27 Jun 2002 12:50:55 -0400, walt <[EMAIL PROTECTED]> wrote:
> >>
> >>I'm in the
> Hi!
>
> - Original Message -
> From: "Wan YU" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.mysql
> Sent: Thursday, June 27, 2002 8:25 PM
> Subject: BUG REPORT FOR MYSQL
>
>
> > Hi,
> >
> > I'm doing research on DBMS recently and have found
> > some bugs in mysql's source codes.I
You can try two easy things...
Truncate table table_name (this happen to be syntax of sql server, you
can check if Mysql supports it)
Second you can drop table and generate it again.. :)
Roma
-Original Message-
From: César Aracena [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 27, 20
Hi.
On Thu 2002-06-27 at 13:35:28 -0400, [EMAIL PROTECTED] wrote:
> I am currently using mysql 4.01 with caching for web page serving. I
> pull several records out with a like statement on a text field. The db
> consists of about 200,000 records right now and it is using 100% of the cpu
> whe
Hi Guys,
MySQL wont start it says 'Security' error cannot
start mysql. Read the MySQL manual on security to
start the server as a root. What is the problem here??
I cannt seem to figure out it was working fine
sometime ago. This is urgent please help.
-SS
=
The only person in the world wh
Mike,
Thanks for the suggestions. First the good news. MySQLFront seems to work
fine based on the limited testing I've done thus far.
The bad news is that even after expanding the width of the DOS window I get
the same results whenever the varchar(255) event column is selected. At
least I
At 12:35 PM 6/27/2002, you wrote:
> I am currently using mysql 4.01 with caching for web page serving. I
>pull several records out with a like statement on a text field. The db
>consists of about 200,000 records right now and it is using 100% of the cpu
>when the search is ran.
> Since thi
EXPLANATION:
here's the pertinent piece of my sql create statement:
ID INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (ID));
i have used this create statement numerous times without this "problem". in the past,
let's say i inserted 3 entries: A, B, and C. their IDs were 1,2, and
3. then i delet
Hi,
Is there a quicker way to get a selection of random rows than RAND()?
I basically use:
SELECT * FROM table ORDER BY RAND() LIMIT 3;
But I find that as the # of rows increases in table, it keeps taking longer
and longer to get a result back. And I am talking a large increase,
basically 50 row
>Description:
When running a select that will take a long time due to the "order by" at the
end mysql still keeps the table locked during the ordering.
After it gets the result set is should unlock the table during the ordering
phase
>How-To-Repeat:
Iss
>Description:
I have the max_user_connections set to 150 on every one of my servers but a
single user is still able to use up to 250 connections. (max_connections=250)
>How-To-Repeat:
execute a huge query then send 250 updates separately to that same table.
>Fix:
Walt,
Use Perl's 'undef' for NULL values.
$quoted_some_variable = undef;
now the $quoted_some_variable will be a null value.
>>On Thu, 27 Jun 2002 12:50:55 -0400, walt <[EMAIL PROTECTED]> wrote:
>>I'm in the process of re-writing 100+ perl CGIs written for oracle to mysql.
>>
>>Does anyone
>Description:
The following query results in a different # of rows if the sql_big_tables is
set to 1:
select count(incidents.ref_no) from incidents, labels where incidents.ref_no like
'020531%' group by labels.label, incidents.ref_no;
The query seems unusual because it was a lot mor
Hi,
I have MySQL3.23.47 running on a Cobalt RaQ4 System. The mysql
installed datadir turned out to be /var/lib/mysql. /var directory has
its own partition (/dev/hda3) and total space available is 194MB. As My
databases are growing and Im out of space now on the /var directory.
I am thinking I
Looks like you want to bring up something that doesn't have anything to
do with the original question which is your perogative. But please
don't compare MySQL with Oracle and mainstream SQL RDBMSs. Give us a
break.
> -Original Message-
> From: Andrew Houghton [mailto:[EMAIL PROTECTED]]
Never mind. He says with his head hung low "I'm an idiot!"
I was populating a the table for someone else and didn't notice that one of
the fields was an auto-inc. Skipped that field and surprise...everything
worked fine.
Thanks for the help. Next time I will remember to pull one body part out of
Hi all. I have multiple tables in which I need to delete rows from the
beginning. I have them stored with an auto_increment id but I don't want
the records to start from 5 but from 1... is there a way to use
something like ALTER TABLE tablename AUTO_INCREMENT = 1; but also that
will make the count
With linux you would:
Add /usr/local/lib to your /etc/ld.so.conf file and run ldconfig.
Sun should have something similar.
[EMAIL PROTECTED] wrote:
>>Description:
>>
> what do I have to do to get configure to use correct gcc options like:
>-I/usr/local/include -R/usr/local/lib ???
>
>I u
I am currently using mysql 4.01 with caching for web page serving. I
pull several records out with a like statement on a text field. The db
consists of about 200,000 records right now and it is using 100% of the cpu
when the search is ran.
Since this is a critical function, it is ran on al
Hi,
It seems you have to install zlib-1.1.4 on your system.
Regards,
Jocelyn
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 27, 2002 5:40 PM
Subject: configure won't configure
> >Description:
> what do I have to do to get configure to use
Hi,
I try to use mysqlgui menu : Commands -> Tables -> Edit Table or Create Tables and
nothing happens.
Do you have any clue ?
Thank you for your kind support
Best Regards
Jerome AVEZOU
-
Before posting, please check:
ht
I'm in the process of re-writing 100+ perl CGIs written for oracle to mysql.
Does anyone know how to get the dbh->quote(some_value) function in perl to
return the string "NULL" if some_value is empty. Currently its returning
'' (2 ticks) and when you update a numeric column, it sets the value to
Hi,
I've currently my website and two forum which runs with MySQL 4.0.2
flawlessly (and which a huge number of visitors for one of my forum).
mysql> \s
--
mysql Ver 12.10 Distrib 4.0.2-alpha, for pc-linux-gnu (i686)
Connection id: 125151
Current database:
Current user:
Heikki,
Thanks for the patch. As I'm going on vacation tomorrow, I'll give it a
try next week and let you know if I find anything.
--shak
Heikki Tuuri wrote:
>Hi!
>
>It turned out that the bug indeed was connected with a 32-bit signed integer
>wrap-over if the buffer pool on a 32-bit compute
I noticed ... but he was somehow able to get on the list to post his
message!
-Original Message-
From: Roma Gupta [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 27, 2002 9:13 AM
To: 'Gerald Jensen'; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Stored procedures
I think you didn't
Dave,
The language that the server is written in is irrelevant. Oracle, SQL
Server, Sybase and most other databases are written in C and Java developers
do business in them just fine. That's why JDBC is for. Many legacy systems
are written in C, C++, or other language. That is another area wh
I just tried to do this on my MySQL server (version 3.23.51-max-log). It
works fine.
Mikhail.
- Original Message -
From: "Anil Garg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 27, 2002 4:59 PM
Subject: Lost Connection to mysql server during query
> Hi,
> Here is
[snip]
UPDATE t3 set t3.mynewfield = t1.mynewfield IN SELECT t1.mynewfield FROM t1,
t2, t3 WHERE t1.mynewfield = "1" and t2.t1id=t1.t1id and t2.t3id=t3.t3id;
and I getting:
ERROR 1064: You have an error in your SQL syntax near 'SELECT t1.mynewfield
from t1, t2, t3 WHERE t1.mynewfield = "1" at lin
On Thu, 27 Jun 2002, Gerald Jensen wrote:
> Yes ... we all know that stored procedures have not been implemented in
> MySQL.
I thought as much but just wanted rapid confirmation.
> Sorry to be so terse, but this is about the umpteenth posting of this same
> question this week ... doesn't anyb
I am fairly new to this, so please bare with me on this.
I am designing a database that stores information about the computers I
manage, and am developing a PHP front end to add, view, and edit information
about the computers. One issue I ran into is designing the hard drive
information. Some com
It makes sense to many, or most, I'd say. Oracle produces clients in a
variety of languages. So does every major database vendor. There is
zero import in the difference between the languages a server and client
are written in.. it's all a network protocol, for God's sake, so who
gives a dam
Hi,
I'm doing research on DBMS recently and have found
some bugs in mysql's source codes.I think it will be
more convenient to point out them directly than using
mysqlbug.The following are my finds.
mysqladmin -version output:
mysqladmin Ver 8.22 Distrib 3.23.44, for pc-linux-gnu
on i686
Copyr
On Thu, 27 Jun 2002, Benjamin Pflugmann wrote:
> On Thu 2002-06-27 at 16:33:43 +0530, [EMAIL PROTECTED] wrote: >
>> But Still Noone have throwed some light on the Date when MySql 4.0
>> Release will be made formally which could enable me to use the Unions
>> Can anyone in this group please let m
>Description:
what do I have to do to get configure to use correct gcc options like:
-I/usr/local/include -R/usr/local/lib ???
I use following options:
./configure --prefix=/home/mysql --with-unix-socket-path=/var/tmp/mysql.sock
--with-low-memory --with-mit-threads=yes --enable-thread-
[EMAIL PROTECTED] wrote:
>>Does anyone else feel that lack of support for subqueries is the number 1
>>deficiency in MySQL? I'm not sure why support for subqueries is being
>
>
> Actually, I am much more eagerly waiting for views and Unicode
> support that sub-selects, although of course these
You can bind mysqld to a specific address using
mysqld --bind-address=IP-ADDRESS
Nilesh Shah wrote:
> We are setting up three MySQL server (on separate machines) with one
> master and two slave servers. All the machines has two network
> interface. We want to create Private network between three
Yes, I agree sub-queries should be the highest priority with the next
release judging from the e-mails going around at the moment.
This was the first problem I found in my first day using MySQL. I don't
understand with all the versions that have been released of MySQL since 1996
why they neglect
Thanks all
-Original Message-
From: Joseph Bueno [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 27, 2002 10:56 AM
To: Nilesh Shah
Cc: [EMAIL PROTECTED]
Subject: Re: Multiple Network Interface
Nilesh Shah wrote:
> We are setting up three MySQL server (on separate machines) with one
> ma
In the last episode (Jun 27), Marek Wysmulek said:
> Dear all.
>
> (Debian 2.4.19, mysql.2.23)
>
> I'm sorry if case was discussed btu : can someone show me the
> documentation or articles about cpu comsumption being done by mysql
> server or/and clients. Or should I look for load balancing guid
At 7:12 -0700 6/27/02, Dave Morse wrote:
>NO - mine is a honest question. An "open source" server in C and a
>client in Java makes sense, I guess to some.
I guess I'm not sure why it wouldn't make sense. If you're running a
Web browser that's written in Java, do you require a Web server to be
Hi all,
I'm trying to update a table from another table. There are three tables
involved t1, t2 and t3. Table t1 and table t3 have the data table t2 holds
the relationships, ie t2 looks like this:
t2id tinyinit
t1id tinyinit
t3id tinyinit
This is the update statment i'm trying:
UPDATE t3 s
Hi,
Here is a strange problem!!
I created a table by the following qurey:
CREATE TABLE 1_polls (
id int(11) unsigned NOT NULL auto_increment,
question varchar(128) NOT NULL default '',
active tinyint(1) unsigned NOT NULL default '1',
sortorder int(11) NOT NULL default '0',
module_id in
Nilesh Shah wrote:
> We are setting up three MySQL server (on separate machines) with one
> master and two slave servers. All the machines has two network
> interface. We want to create Private network between three machines only
> to route replication traffic.
>
> Can MySQL use multiple network
Hi guys,
Does anyone know any sources on good DBA procedures for MySQL specifically?
Or a source for MySQL DBA scripts that might do some of the following tasks?
- check if mysqld is up and running and email a user if it is
- a script to give process/connection information (I'd like more info t
Hi,
Of courseanyway MySQL don't use directly network interfaces.This is a
Kernel "job".
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
-
At 09:28 AM 6/26/2002, you wrote:
>I recently installed MySQL on a computer running Windows 2000 and
>have been working through the tutorial session in the manual. All
>went well until I created the second (event) table. While I believe
>that all the data in the table is correct, any query which
Hi,
It's seems to be bug try to rare the frequency of the command
("show") which is send to the mysqld.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMA
>Description:
mysql-server cannot start on netbsd 1.6BETA1
>How-To-Repeat:
upgrade to netbsd 1.6; cd /usr/pkgsrc/databases/mysql-server; make install
>Fix:
no fix
>Submitter-Id:
>Originator:Charlie &
>Organization:
>MySQL support: [none | licence | email suppor
> When I run this comman I insert 253 records into ur_rights. If I runn the
> comman without the insert statement it returns 33,483 records.
As result of insert command you have to receive stat info like this:
---
Records: 100 Duplicates: 0 Warnings: 0
---
Which values do you ha
got it thank everybody for the help... it is appreciated...
--
On Thu, 27 Jun 2002 15:13:31
Peter Lovatt wrote:
>[mysqld]
>datadir=/var/lib/mysql
>tmpdir=/home/mysql_temp
>
>HTH
>
>Peter
>
>---
>Excellence in internet and open source software
>-
> -Original Message-
> From: Daniel Koch [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 27, 2002 13:11
> To: Arul
> Cc: MySQL
> Subject: Re: MYSQL 4.0
>
>
> Arul wrote:
>
> >Hi
> >
> >Any idea when MySQL 4.0 stable release will be made..
> >As of now only Alpha is released..
> >
>
I think you didn't notice. He cannot access Mysql website from UK :)
-Original Message-
From: Gerald Jensen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 27, 2002 9:16 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Stored procedures
Yes ... we all know that stored procedures
NO - mine is a honest question. An "open source" server in C and a
client in Java makes sense, I guess to some.
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 26, 2002 5:37 PM
> To: Dave Morse; 'Arul'; [EMAIL PROTECTED]
> Cc: 'MySQL'
> Subjec
1 - 100 of 159 matches
Mail list logo
