I have installed the MySQL database 4.0.4 client, but when I look at
phpinfo() I see that it says:
Client API version: 4.0.2-alpha
Why?
Regards, Jacob
-
Before posting, please check:
http://www.mysql.com/manual.php (the
SHOW GRANTS FOR 'repluser'@'replmachine';
yes there is file grant on *.* - i used a simple password to avoid writing
it wrong. as i said, if i connect with mysql client tool from the slave
machine, i CAN login into the master server!
Only the slave can't login into the master server (with the
set-variable= thread_cache=8
# Try number of CPU's*2 for thread_concurrency
set-variable= thread_concurrency=8
If I have 2 CPU's, does the above mean that I should set
thread_concurrency=16 ?
I am using a MySQL database 4.0.4
Regards, Jacob
Hi,
No, you should set it to 4 if you have 2 CPU :) (2*2 ;))
Regards,
Jocelyn
- Original Message -
From: Jacob Friis Larsen [EMAIL PROTECTED]
To: Mysql maillist [EMAIL PROTECTED]
Sent: Monday, November 25, 2002 8:46 AM
Subject: thread_concurrency (Try number of CPU's*2 for
All of the other distribution files on mysql.com are showing version
4.0.5, but the linux RPMs are still at 4.0.4. Are these likely to be
updated to 4.0.5 in the near future?
-
Before posting, please check:
Venlig hilsen
Jacob Friis Larsen
[ JFL WebCom | www.webcom.dk | +45 7027 0767 ]
-Oprindelig meddelelse-
Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sendt: 25. november 2002 11:02
Til: Jacob Friis Larsen
Emne: Re: UPDATE LOW_PRIORITY database
Your message cannot be
I am running MySQL database 4.0.4 on a RedHat Linux 7.3 with the
database path being on raid disks and /tmp/ on a non raid disk.
Should the tmpdir be on a raid disk? If so they will be at the same disk
as the database. Is that the best option?
Regards, Jacob
Jacob,
Monday, November 25, 2002, 12:03:14 PM, you wrote:
If I use UPDATE LOW_PRIORITY, will the client then have to
wait for the
update to finish or not?
Yes, it will wait.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net
If I use UPDATE LOW_PRIORITY, will the client then have to wait for the
update query to finish or not?
Regards, Jacob
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Can i get more speed by disabling InnoDB tables, if I'm only using
MyISAM and HEAP tables?
Any warnings about this?
Regards, Jacob
http://www.sharksforum.com
sql
-
Before posting, please check:
JFL Can i get more speed by disabling InnoDB tables, if I'm only using
JFL MyISAM and HEAP tables?
JFL Any warnings about this?
If your server is need more resources ( memory , etc... ), Yes.
The InnoDB only uses processor if the tables typped InnoDB are used , but the
memory is allocated.
to
The licence in mysql page is obscure for version 4.0
What is a diference of MySQL-Classic and MySQL-Pro ?
When may i use MySQL-Classic ?
When may i use MySQL-Pro ?
My Application is a commercial multi-database , running in mysql and
interbase , in my case , witch these licenceses must i use ?
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 25 November 2002 10:56, Graham Murray wrote:
All of the other distribution files on mysql.com are showing version
4.0.5, but the linux RPMs are still at 4.0.4. Are these likely to be
updated to 4.0.5 in the near future?
Yes, working on
He all,
I have a problem with MySQL ver 3.23.52 on Linux Redhat 8. It is
working successfully on the server, and can response all request
comming on Server. But, when I try to connect to the database thru
any client running on a Windows 2000 (like MySQLAdmin), I can't
connect it.
Firstly, I got
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 25 November 2002 13:53, Dyego Souza do Carmo wrote:
The licence in mysql page is obscure for version 4.0
What is a diference of MySQL-Classic and MySQL-Pro ?
The only difference between those two is InnoDB - MySQL-Classic does not
Hi All.
I have written a SQL script that should retrieve all the rows from a
table that match a value given as parameter by the user.
The script is something like:
SELECT TEST_NAME AS NAME, TEST_DATE
FROM TEST
WHERE TEST_NAME=NAME;
where NAME is the parameter the user should give.
Bonjour,
Vous avez récemment demandé à vous inscrire au groupe
mysql-france. Comme vous êtes déjà membre de ce groupe,
votre demande ne sera pas prise en compte.
Pour toute question sur l'envoi de messages à ce groupe,
veuillez envoyer un e-mail à [EMAIL PROTECTED]
Cordialement,
L'équipe
The licence in mysql page is obscure for version 4.0
What is a diference of MySQL-Classic and MySQL-Pro ?
LG The only difference between those two is InnoDB - MySQL-Classic does not
LG include it, while MySQL-Pro does. Both products are available under a
LG commercial (non-GPL) license only.
mysql reference manual for version 3.23.7-alpha. - ...:ÄúºÃ!
ÆÕ¹âÍøÂç ÐֵܽãÃÃÃÇÈ¥Õâ¸öÍøÕ¾ÇÆһϣ¬Èç¹û¾õµÄ¿ÉÒԵĻ°¾Í×¢²á°É¡£Ç®ÊÇÉÙÒ»µã²»¹ý¶¼
ÊÇʵÔڵģ¬ÎÒÒѵõ½ÁË30¶àÔªÁË¡£
On Fri, Nov 22, 2002 at 08:13:46PM -0500, Philip Mak wrote:
SELECT *
FROM boards
LEFT JOIN boardAdmins
ON boardAdmins.userId = #{userId}
AND boardAdmins.boardId = boards.id
LEFT JOIN boardMembers
ON boardMembers.userId = #{userId}
AND
On Sat, Nov 23, 2002 at 04:37:01AM +0200, Octavian Rasnita wrote:
I can do all the job with Perl, but if the link contains a ? sign, it is
replaced by the string NULL in the MySQL database and the link stored will
be something like:
Just look up $dbh-quote(...) in the documentation.
$URL =
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 25 November 2002 15:03, Dyego Souza do Carmo wrote:
ohhh, i´m sorry , the licences i was confused about are:
MySQL-Standard and MySQL-Pro , not mysql-classic ;)
What are the deferences between mysql-standard and mysql-pro ?
Well, as
Greetings...
I thin you need to look into the enum datatype. It stores data as integer
but when queried it will return data in text.
Rgds
Insane
SQLyog - The Definitive GUI for MySQL
http://www.webyog.com/sqlyog/download.html
- Original Message -
From: Alex Behrens [EMAIL PROTECTED]
You did not run the quote() funcion on $arch.
If $arch contains any special characters, it will break your query.
toby z wrote:
hay guyz
im havin a weired problem
i ve this search query
$srch_qry = select ctnt_inf.* from ctnt_inf .
where (match (firstName ) against (\.$srch.\) .
Alternatively, use the IF() function --
SELECT IF(captain=0, C, ) from stats where captain 0 and number = '23'
group by number;
Or something similar.
Nick
- Original Message -
From: Insanely Great [EMAIL PROTECTED]
To: Alex Behrens [EMAIL PROTECTED]; MYSQL [EMAIL PROTECTED]
Sent:
Hello,
I'm considering building a dual athlon or dual xeon machine.
Which gives better results for mysql queiries using LIKES on
text columns? (under linux)
Currently availabe athlon 2.2 (1.8 ghtz) or Xeon 2.8?
Anyone run any numbrs between the two?
Thanks,
John
In your InnoDB Section you need:
innodb_data_home_dir = c:/mysql/innodbdatapath
set-variable = innodb_mirrored_log_groups=1
innodb_log_group_home_dir = c:/mysql/innodblogspath
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=5M
set-variable =
Here is an example of our data, I had to create 800 web pages for each
organization, I had to make a text file from our DOS database. I am
wondering which program to put the data in. I also checked with our
server, we only have 7 meg. of space which is donated. I know he has SQL
server but won't
Hi
I've got a master database with 2 slaves. I've had them up and running for
quite a while now with no problems, but today I noticed an error - there was
a slave running on the master!
I checked /etc/my.cnf - no mention of slaves (it hadn't been changed for a
good while anyway). I looked
(This is a forward of some private mail with the original poster,
with his permission.)
Date: Sun, 24 Nov 2002 22:59:33 -0500
From: Brian Reichert [EMAIL PROTECTED]
To: Sweethome.co.il Webmaster [EMAIL PROTECTED]
Cc: Brian Reichert [EMAIL PROTECTED]
Subject: Re: MySQL on virtual hosting
On Mon,
From: Norm Lamoureux [EMAIL PROTECTED]
...I had to create 800 web pages...
...make a text file from our DOS database.
I am wondering which program to put the data in.
Hi Norm,
It sounds to me like you are trying to build a data driven web site on a server with
no database available, as
I'm running a query to SUM a Decimal field with the configuration of
DECIMAL(6,2) and I get a result looking like: 56.5515009
How is this possible???
Thank you in advance...
Andrew
-
Before posting, please check:
I am trying to make my perl script fork several processes that all execute
'select' statements on MySQL. I want the statements to happen
concurrently (as I want to monitor the behaviour of MySQL with native ISAM
tables under this concurrent Read access). So I am using 'fork'. However,
I think
From: Andrew Kuebler [EMAIL PROTECTED]
I'm running a query to SUM a Decimal field with the configuration of
DECIMAL(6,2) and I get a result looking like: 56.5515009
Hi Andrew,
I just did this (v 3.23.52):
mysql create table dd ( myfloat decimal(6,2))
mysql insert into dd
In the last episode (Nov 25), Geetika Tewari said:
I am trying to make my perl script fork several processes that all
execute 'select' statements on MySQL. I want the statements to
happen concurrently (as I want to monitor the behaviour of MySQL with
native ISAM tables under this concurrent
From: Geetika Tewari [EMAIL PROTECTED]
...perl script fork several processes...
...I think my 'select' statements are not happening concurrently.
Why do you think that?
---
Rodney Broom
President, R.Broom Consulting
http://www.rbroom.com/
sql
Is anybody else getting this mail when they post?
---
Rodney Broom
President, R.Broom Consulting
http://www.rbroom.com/
sql
- Original Message -
From: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, November 25, 2002 11:15
Subject: mailing
- Original Message -
From: Rodney Broom [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, November 25, 2002 7:28 PM
Subject: Re: mailing list [EMAIL PROTECTED]~{5DWT6/;XPE~}
Is anybody else getting this mail when they post?
yes, it's written in simplified chinese and it simply
My previous question raised some follow up questions, so I am going to
try to clarify now by explaining the root of my problems:
My original (bash) script is the following:
./getTime.pl result.txt
echo started: concurrent.
I'm trying to make what I think is a very simple fulltext index for a
small library catalog, viz:
create table library (
id INTEGER UNSIGNED PRIMARY KEY NOT NULL,
callnumber VARCHAR(8) NOT NULL,
lastname TINYTEXT,
firstname TINYTEXT,
middlename TINYTEXT,
I am creating a search form for the TitleName. When I type in one word it
finds all titles with the one word. If I use two words it doesn't work.
How do I change my select statement to make it work? Thank you.
SELECT *
FROM Titles A, ActorTitle B, Actors C
WHERE A.TitleID=B.TitleID AND
Hi ;
I am usein the following prepared statement:
insertOne = dbConnection.prepareStatement( INSERT INTO appointment
(apptId,providerId,patientId,serviceLocationId, dateTime, assistant,
duration,state,statechange,memo,cancelMemo,dictationMarked, apptSeqId,
clinicId, appSharing) values
I just want to lets you guys know that I have recently setup a forum for
disscusing linux and programming(including MySQL;). Come on and check it out
here
http://www.linuxforum.hopto.org
thanks
_
STOP MORE SPAM with the new MSN
Hamid Amjadi wrote:
Hi ;
I am usein the following prepared statement:
insertOne = dbConnection.prepareStatement( INSERT INTO appointment
(apptId,providerId,patientId,serviceLocationId, dateTime, assistant,
duration,state,statechange,memo,cancelMemo,dictationMarked, apptSeqId,
clinicId,
On Mon, Nov 25, 2002 at 11:51:00AM -0800, Lennart Stevens wrote:
I just want to lets you guys know that I have recently setup a forum
for disscusing linux and programming(including MySQL;). Come on and
check it out here http://www.linuxforum.hopto.org thanks
What's wrong with the 6 million
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
Hey all, I'm having a painful time trying to get
stunnel and mysql to play together. My mysql works
fine locally and remotely until I add stunnel. After
chasing my tail for a week (and drinking a lot on the
weekend) I realized that Mysql is trying to open a
socket on the server machine instead
It funny that you ask me this.
I originally posted a note up on YOUR site that I had the Red hat 8.0
Files up for download on a site that I set up. They became so popular
that I decided to set up a forum to go along with them.
Oh, and no there is nothing wrong with the other sites, but you must
In the last episode (Nov 25), twig les said:
Hey all, I'm having a painful time trying to get stunnel and mysql to
play together. My mysql works fine locally and remotely until I add
stunnel. After chasing my tail for a week (and drinking a lot on the
weekend) I realized that Mysql is trying
At 13:57 -0500 11/25/02, John R Levine wrote:
I'm trying to make what I think is a very simple fulltext index for a
small library catalog, viz:
create table library (
id INTEGER UNSIGNED PRIMARY KEY NOT NULL,
callnumber VARCHAR(8) NOT NULL,
lastname TINYTEXT,
Your index contains a different set of columns than the columns listed
in the match() list. You'll need to create another FULLTEXT index
containing just title and subtitle.
Oh, OK. The manual needs to be corrected.
Regards,
John Levine, [EMAIL PROTECTED], Primary Perpetrator of The Internet
sql,query
At 16:01 -0500 11/25/02, John R Levine wrote:
Your index contains a different set of columns than the columns listed
in the match() list. You'll need to create another FULLTEXT index
containing just title and subtitle.
Oh, OK. The manual needs to be corrected.
Can you be
The question is what does Access do in order to perform subqueries on MySQL via
MyODBC driversince it is obvious that they work?
access contains its own sql engine, so when you
link the mysql tables into it, you were then
running access queries.
What can I do, but I do not want to use
Dear John,
probably the problem does not derive from MySQL, but from the URL encoded
search string, e.g.:
Search for oneword = oneword
Search for two words = two%20words
If you match against two words, there will be no match, as it should match
against two%20words.
I am not informed which
Hi,
I'm trying to build mysql from the development sources (3.23.54,
retreived using bitkeeper) under win2k using cygwin.
Following the instructions in the mysql manual, I'm having a problem
running aclocal:
Dango) aclocal
aclocal: configure.in: 450: macro `AM_PROG_AS' not found in library
If
Hi Norm,
I gather that you are wanting to bring both databases together into a single MySQL
database. In order to do that, you'll have to have the mysql service running on your
web server. (Not actually true, but true enough for this conversation) However, it
sounds to me like you don't have
I wish that was the answer (ego being less important
than sanity). I've put a tcpdump box in the middle
and tcp sessions are going out to the mysql server on
3307 (the creative port I chose for stunnel to use for
mysql) but the session hangs for about a minute after
I send the password. Here are
Your index contains a different set of columns than the columns listed
in the match() list. You'll need to create another FULLTEXT index
containing just title and subtitle.
Oh, OK. The manual needs to be corrected.
Can you be more specific? I thought the manual already stated this.
Hello,
I am relatively new to MySQL though I have database experience.
I have a query that doesn't seem to want to use an index for the first
table despite my indexing several fields. Before I get too far in the
details of the query, here is what EXPLAIN SELECT tells me for the
first
Greetings.
If I have a key on a float and attempt to insert a NaN I get
ERROR 1034: Incorrect key file for table: 'foo'. Try to repair it
if I attempt to update/delete that row.
If I remove the key from the float it seems to behave when I try to
update/delete the row.
Is this a bug / known
Hello,
I have made the mistake and now have no root access to mySQL. Could you
help me, please, to reset the root password.
Regards,
Jacek.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Is there anyway to retrieve mySQL data from JavaScript?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
Hi all.
I am running MySQL-4.0.4 and have just compiled 4.0.5.
On the MySQL website, I found a bit that says:
You can always move the MySQL form and datafiles between different
versions on the same architecture as long as you have the same base
version of MySQL.
So does this mean I can do a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Michael C. Podlesny wrote:
Is there anyway to retrieve mySQL data from JavaScript?
Not directly. There's at least two ways to do it...You can use an
IFRAME, and post/retrieve to your favorite web programming language
which can talk to MySQL, or
I am trying to get my TIMESTAMPE field to auto update (use the current time
for inserts). However it keeps going to all 00, I read the
documentation and it says that is because it is getting an invalid input.
However it also states if you put null in it will work, it does on the
server,
At 19:32 -0600 11/25/02, Ronald Petty wrote:
I am trying to get my TIMESTAMPE field to auto update (use the current time
for inserts). However it keeps going to all 00, I read the
documentation and it says that is because it is getting an invalid input.
However it also states if you put
Hello,
I have been racking my brains out for the last two days trying to get this
thing working..
I am using MS SQL 2000 linking server sp to link to MYSQL
at the moment I am using the generic ole db procider but I want to use the
myoledb provider, but when I go to use it it errors saying cant
Hi,
It is 760 organizations listed, when I said two, I meant that on the WWW
I have over 700 individual web pages that EXCITE does a search for and
my main database in DOS. I don't know whether my server has these
programs, I can check.
Thanks
Norm
Rodney Broom wrote:
Hi Norm,
I gather
Hi folks,
I'm looking for creative ways to setup a replication config that lets me
push all tables to some slaves and only a subset to other slaves. For
this scenario, let's say I have three db servers... One is a master and
gets all updates. One is an update slave, which gets all the master
mysql:ÄúºÃ!±¾ÈË¿ÉÌṩÒÔÏ·þÎñ£º
1¡¢Ó²¼þ¼ÓÃܹ·Æƽ⣻
2¡¢Èí¼þÍêÈ«Æƽ⣻
3¡¢Èí¼þ×¢²á»úÌáÈ¡£»
4¡¢È¥³ýÈí¼þÏÞÖÆ£¨Èç°ÑÍøÂç°æµÄ10Óû§¸Ä³É100Óû§£¬´òÓ¡¹¦Äܵȣ©£»
5¡¢¹úÍâ´óÐÍÊý¾Ý¿âÆƽ⣻
6¡¢Èí¼þ¼ÓÃÜ£»
7¡¢²¿·ÖÒѽâÈí¼þµÍ¼ÛÌṩ£»
8¡¢ÊÖ»ú¶ÌÐÅϢȺ·¢Èí¼þ--ÆóҵȺ·¢°æ ²¢¸½ËÍ×¢²á»ú£»
From: Norm Lamoureux [EMAIL PROTECTED]
...700 individual web pages that EXCITE does a search for...
Are these web pages actual individual files, or are they simply information in a
database someplace that needs to get displayed?
I don't know whether my server has these programs, I can
Yes, again. :( Although reluctantly, I finally decided to upgrade to
3.23.53a (on FreeBSD 4.7R), in the hope to get rid of these annoying errors.
Alas, 6 out of 10 times when I start a MySQL application, I get an error
like this:
DBD::mysql::st execute failed: Lost connection to MySQL server
First rule of JavaScriptis you don't talk about JavaScript!
Second rule of JavaScript is you _don't_ talk about JavaScript!
But seriously, remember that JavaScript has very, very few input/output
functions that can be used outside of a browser. There really isn't a way to
create a JavaScript
Hi!
What is Bengali character set? Does it have a Unicode
mapping table like for example this one:
ftp://ftp.unicode.org/Public/MAPPINGS/ISO8859/8859-1.TXT
Please also send me some links to internet recourses
written in Bengali.
Regards!
Shyamal Banerjee wrote:
Dear sir,
I want to
Hi, I'm new to the list ( mysql) and not sure if there is an archive I can
search so apologies if this has been mentioned earlier. I was hoping someone
might be able to shed some light on a problem I am having:
I'm supporting a mysql 3.23.49 database with one master db (type=BerkleyDB)
and two
Bengali is the script used in many Indian languages, like Hindi.
A search on google turned up a lot of pages written using Bengali, a
good example is http://www.parabaas.com/ and, for example,
http://www.parabaas.com/PB28/LEKHA/bMarkin28.html
Shyamal, if you're a coder, you can add support for
Hello,
I am Miki Tan from Gleneagles Medical Centre.
I am interested in MySQL database development.
1.Can I know with platform is suit for MYSQL ?
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
77 matches
Mail list logo