From mysql's point of view, localhost and 127.0.0.1 are not the same thing.
When you connect with
mysql -h localhost -u root -p
or simply
mysql -u root -p
(localhost is the default), you are connecting via unix socket, so the
user=root, host=localhost entry is used. When you connect with
On Mon, 02 Aug 2004 17:31:03 -0400
[EMAIL PROTECTED] wrote:
> I am now getting
>
> [EMAIL PROTECTED] Desktop]# mysql -u root -pmypasshere
> ERROR 2002: Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (2)
>
> any thoughts...
>
> once again thanks for the assist
Ryan,
> Here's the problem. I had the site up several days, with everything
> running perfectly. Ordinarily there would be about 11 mysql processes
> running. However, after a few days of running smoothly, the number of
> mysql processes increases to over 170, and the site crashes. Formerly
>
If you want the data in the campaigns table regardless if an entery exists
int he addresses_incampaign table then you should use a LEFT OUTER JOIN.
-Original Message-
From: Scott Haneda
To: MySql
Sent: 8/2/04 7:37 PM
Subject: Cant get this JOIN to work
tSql = "SELECT c.campaign_name, c.id
What does your '/etc/hosts' file contain? Sounds like
it may have the following entry:
127.0.0.1 localhost.localdomain
change it to:
127.0.01localhost
or
Yes, add 'localhost.localdomain' to mysql.user
another option, Why not just SSH to 'daisy' and issue:
shell> mysql -u root -p
a
Depends on what file system you are running that is a ext2 limit if you move
to ext3 or reiser you should be fine. But then a default config on MySQL will run into
a 4.29 Gig limit, which you can change.
Eric Gunnett
System Administrator
Zoovy, Inc.
[EMAIL PROTECTED]
>>> "Shannon R."
Hi, you cant connect to mysql with telnet, the service running in 3306
supports a dbms specific protocol so you need to use the "mysql" command aka
mysql client to connect to mysql and execute any sql query.
Carlos
From: Gonçalo Silva Dias <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>,<[EMAIL PR
supposedly ?, you can check if the mysqld daemon is running with:
ps -ef | grep mysql
if the daemon is running then the error is something else but my first bet
is that is not running.
Carlos
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Carlos Proal <[EMAIL PROTECTED]>
CC: [EMAIL PROTE
Hi folks,
Now that I can connect to my MySQL server using the Unix sockets (e.g.
[EMAIL PROTECTED] ~] mysql -u root
I'm moving on to the next step - connecting via TCP/IP.
Since I don't have physical access to the box (well, I'm just too lazy to walk
down to the basement), I SSH into the box
Is the 2GB filesize limit in linux still there?
Specially in Gentoo and Debian linux?
If so, how can this be addressed when your mysql's
.MYD files reach 2GB?
Is there any way MySQL can split really big .MYD
files?
Regards,
Shannon
__
Do you
-Original Message-
From: Jacob, Raymond A Jr
Sent: Monday, August 02, 2004 21:17
To: [EMAIL PROTECTED]
Subject: archive db daily- Rough Draft
I am new to Databases and would appreciate a second set of eyes looking over my sql
script.
The script takes the existing snort database and
Here is what I am doing now, in mysql 4.x
This gives me a name/id list from a table
SELECT campaign_name, id
FROM campaigns
WHERE user_id = 123;
This will tell me which of the above name/id's are in use in another table.
SELECT distinct(campaign_id)
FROM addresses_incampaign
WHERE user_id = 123
Hi ppl,
Im trying to access to mysql server by telnet. When I do like telnet
localhost 3306 if I write something the error is Bad handshake. Well can
anyone tell me what info do I need to send to the server to establish a
connection with mysql server? So I can execute some queries?
tSql = "SELECT c.campaign_name, c.id
FROM campaigns as c
INNER JOIN addresses_incampaign as i on (c.user_id = i.user_id)
WHERE c.user_id = " & prepSQL(tConn, user_id) & "
GROUP BY c.id";
This works when there is data in the addresses_incampaign table, but when
there is not, it returns nothing, whi
RRD (http://www.rrdtool.org) is a popular tool which sysadmins use to
collect to network stats (among other things)
One of the best thing about RRD is that it only stores X datapoints at
any one time, and also aggregates simple stats about the data, making it
self-archiving. I was wondering if
Yes, extension of file is php and php is running on server.
in my Linux Services... the mysqld entry is missing
i have mysql and that is supposedly running.
- Original Message -
From: Carlos Proal <[EMAIL PROTECTED]>
Date: Monday, August 2, 2004 6:19 pm
Subject: Re: Upgrading mySQL 3.23 to 4.0
>
> The upgrade shutdown the database, i think you m
We're upgrading from 3.23.58 to 4.0.20 and found that that although the
ALTER test results of sql-bench had been greatly improved, CREATE has
shown nasty performance degradation. Just before needing to make the
decision to revert back to 3.23.58, we found a post here where someone
had a similar pr
> When I then ran mysqlshow I only had the test database, not the mysql
> database as the documentation said I should.
>
> I then deleted everything and installed again, and got the same result.
>
> Does this mean the installation has failed ?
When this happens on Linux, it means you're running my
--- Begin Message ---
Long back I had set it and was working that time,For a long time I wasn't working on same, at this point how to check the same, I don't remember, can you guide , please.
How do I check if mysql, php apache are configured, also any GUI graphical user interface for Apache
I am now getting
[EMAIL PROTECTED] Desktop]# mysql -u root -pmypasshere
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
any thoughts...
once again thanks for the assistance
- Original Message -
From: [EMAIL PROTECTED]
Date: Monday, August
At a loss on this one...
- Original Message -
From: [EMAIL PROTECTED]
Date: Monday, August 2, 2004 5:27 pm
Subject: Re: Question
> Yes, extension of file is php and php is running on server.
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
I wound up having to do the following:
[EMAIL PROTECTED] Desktop]# rpm -Uvh MySQL-shared-compat-4.0.20-0.i386.rpm
warning: MySQL-shared-compat-4.0.20-0.i386.rpm: V3 DSA signature: NOKEY, key ID
5072e1f5
Preparing...### [100%]
1:MySQL-sha
My connection to the mysql is correct, that is "host, username, password",
however when I click the link of form so that it will pull out data from
mysql database, I see the php code of the form, any guidance, please.
At 01:58 PM 8/2/2004, [EMAIL PROTECTED] wrote:
Greetings:
I am trying to upgrade to the new version of mySQL on Fedora Core 2
Linux. I have "mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)"
I downloaded the following files:
MySQL-client-4.0.20-0.i386.rpm
MySQL-server-4.0.20-0.i3
On Mon, Aug 02, 2004 at 03:11:10PM -0500, mos wrote:
> At 03:41 AM 8/2/2004, Jeremy Zawodny wrote:
> >
> >I bet it depends on the country. In the USA, companies are considered
> >singular legal entities. "Internal distribution" is aking to giving
> >copies to yourself.
> >
> >The GPL doesn't rest
Hi, John
Thank you for the response.
I chmod for all database files under ./data/, and now
I can update the password for the root user.
Thanks a lot.
Jean
--- John McCaskey <[EMAIL PROTECTED]> wrote:
> Did your client side host change? The user/pass are
> sometimes setup to
> only allow acc
Greetings:
I am trying to upgrade to the new version of mySQL on Fedora Core 2 Linux. I have
"mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)"
I downloaded the following files:
MySQL-client-4.0.20-0.i386.rpm
MySQL-server-4.0.20-0.i386.rpm
and as root ran the following:
[EMAI
- Original Message -
From: "Andrew Dixon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 02, 2004 9:44 AM
Subject: In Statement Help
> Hi Everyone.
>
> I require some help with an IN statement I'm trying to get working. I have
> inherited a database from someone else i
Did your client side host change? The user/pass are sometimes setup to
only allow access from a specific host subnet or single ip address.
John A. McCaskey
-Original Message-
From: Jean Zhong [mailto:[EMAIL PROTECTED]
Sent: Monday, August 02, 2004 1:27 PM
To: [EMAIL PROTECTED]
Subject:
Hello everyone,
I met a strange problem.
I can't log in mysql server using my password
suddently.
I check the modified date of user.MYD & user.MYI in
/usr/local/mysql/data/mysql/ folder. Both of them were
not modified recently. That means I didn't change the
password for mysql server.
Did anyone
> Oops, I lied. :) -Max was built with SSL a long time ago (if I
> remember right), and now it's not. Sorry.
...I noticed this earlier, too.
Note that your website still claims this ("The Max version includes
additional features such as the Berkeley DB storage engine and other
features that have
At 03:41 AM 8/2/2004, Jeremy Zawodny wrote:
On Mon, Jul 26, 2004 at 11:49:02PM -0500, mos wrote:
> At 04:43 PM 7/26/2004, you wrote:
>
> >looks like the answer is no. As soon as fee based software touches the
> >mysql install on the PC, the user is obligated to pay the $250.
>
> Actually I believe
Hi
Just installed myqsl for windows w/ installer and looked in the
directory and found no example ".cnf" files
james
Hi,
It sounds like you are using the default thread library. I would
install MySQL from /usr/ports/databases (WITH_LINUX_THREADS, see
options in Makefile) or barring that try Jeremey's excellent build
recipe at http://jeremy.zawodny.com/blog/archives/000458.html . We
used to have the same pro
i've got one master and one slave. the master is VERY busy, tons of
inserts/updates/deletes all the time. (it's an extremely high traffic
message board system.)
we've got a situation right now where the slave starts lagging WAY
behind the master. it's as if it simply can't run through the bi
You are absolutely right, I was giving the developers too little credit. I
humbly apologize to all who contributed to the query optimizer. It was
never my intent to impugn the fine work that has gone into MySQL, my
optimization strategy is merely a reflection of my own pessimism. Please
forgive
Do you know the ASCII values for the characters that are being turned into
question marks? Are you able to verify that the data is not be imported by
querying the underlying ascii value?
-Original Message-
From: Barry Zimmerman
To: [EMAIL PROTECTED]
Sent: 8/2/04 1:00 PM
Subject: Mysql and
On Tue, Jul 20, 2004 at 04:18:42PM +0800, [EMAIL PROTECTED] wrote:
> I am new to MaxDB and clustering. It seems that both products provide
> enterprise features and high availability.
> Is clustering replacing MaxDB?
> What are the difference between them?
> Are they targeting different users?
Bas
On Mon, Aug 02, 2004 at 09:24:59AM -0700, Marc Slemko wrote:
>
> I believe that MySQL AB is deliberately vague and confusing on their
> licensing page to try to get people to buy mysql licenses. All
> their words there don't matter though, what matters is the actual
> license. It would, however,
Hi,
Hoping that someone can help me, as I have tried everywhere for help and
still cannot get this to work.
I am using MySQL 4.1.1
I have a sql file that contains french accent characters. I have 8 fields in
my database. Now the content of the text file imports into my database, when
I import th
Hi,
Hoping that someone can help me, as I have tried everywhere for help and
still cannot get this to work.
I am using MySQL 4.1.1
I have a sql file that contains french accent characters. I have 8 fields in
my database. Now the content of the text file imports into my database, when
I import th
Hello,
I have a problem.
Lithuanian letters:
ąčęėįšųūž
ĄČĘĖĮŠŲŪŽ
aceeisuuz
What I must use to sort by this ORDER?
When I use
mysql> CREATE TABLE w
(
s VARCHAR(5) CHARACTER SET cp1257 COLLATE cp1257_lithuanian_ci
);
Query OK, 0 rows affected (0.04 sec)
mysql> insert
Anyone know of some decent docs on how CR works with MySQL using ODBC 3.51.
Just installed it today to see what it's like and am finding it cumbersome.
This is most likely due to ignorance rather than the product.
I was expecting to see a list of tables available for reporting when using a
link t
> dear rhino and whil
> thanks for that valuable tip.
> but, dont i have to wory about the repeating id's (are they not
> redundant...) in this table, excuse me if this query looks silly...
>
> PLANT_MOLECULE
> plant_idmolecule_idquantity
> ------
Shawn,
I see what you are saying, but I don't believe it works that way. If that
were the case, putting the condition in the ON clause rather than the WHERE
clause would be at the top of the list of recommended optimizations in the
manual, but it's not. In fact, the manual recommends against i
> i'm getting really confused with how to properly
> allow users to access mysql from other machines.
>
> that is, i tried this as mysql root user:
>
> GRANT SELECT, INSERT, UPDATE, DELETE ON my_sql_db.*
> TO [EMAIL PROTECTED] IDENTIFIED BY 'password';
>
> after this, i can access mysql as 'dbus
Victor Pendleton said:
> What does mysql "show processlist" look like?
>
> -Original Message-
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Sent: 8/2/04 9:16 AM
> Subject: Problem with Mysql 4.0.18 + Debian
>
> Hello:
>
> I posted this before but I have not gotten a response. I hav
On Mon, 2 Aug 2004 01:35:44 -0700, Jeremy Zawodny <[EMAIL PROTECTED]> wrote:
> On Mon, Jul 26, 2004 at 01:26:15PM -0500, gerald_clark wrote:
> >
> > Steve Richter wrote:
> >
> > >exactly! Is Linux distributed under the same type of license as MySql? If
> > >I sell software that runs on linux I do
Is it possible to verify the database backup. Like most machines, that
make backup of files then verify that all of it is backed up without an
error? I use mysqldump to make a backup but I have no idea about the
verify
Thanks,
Scott
How stable is this feature? , i have been using it for a few time and works
fine, but im thinking to move my current productive enviroment this way and
i dont know if its a good choice.
Any advise is appreciated.
Carlos
_
Tired of s
Hi,
I just upgraded to mysql-4.0.20 compiled using gcc-3.3.3. All my C++ DB
interfaces connecting to this mysql database seem to run into a problem -
when I try to disconnect, mysql_close() is called but the program just hangs
there without being able to close the connection. Can someone please ad
Добрый день.
Usually I run configure like this:
./configure \
"--prefix=/usr/local/mysql_4" \
"--without-debug" \
"--with-charset=koi8_ru" \
"--with-extra-charset=koi8_ukr,win1251,win1251ukr" \
"--with-mysqld-user=X" \
--without-berkeley-db \
--without-isam \
--without-innodb \
--enable-thread
- Original Message -
From: vijaya raj
To: Rhino
Sent: Monday, August 02, 2004 9:31 AM
Subject: Re: help-in-normalizing
dear rhino and whil
thanks for that valuable tip.
but, dont i have to wory about the repeating id's (are they not redundant...) in
this table, excuse
What does mysql "show processlist" look like?
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 8/2/04 9:16 AM
Subject: Problem with Mysql 4.0.18 + Debian
Hello:
I posted this before but I have not gotten a response. I have a
Debian
(woody) server running a good s
Andrey Kotrekhov <[EMAIL PROTECTED]> wrote:
> Did you compile mysql from source or you use precompiled binary package?
> I use mysql with different versions of FreeBSD without big problems.
On FreeBSD, you can compile MySQL from ports.
>>> I have several MySQL and FreeBSD installs across a few
What I have here is a database-driven website. In the past, I created a
database and grant privileges to it. Now, I'm creating a carbon copy of
it into another website which will be a test website with a test
database. So, when I try the grant privileges to the test database, it
returned a zero
Hello:
I posted this before but I have not gotten a response. I have a Debian
(woody) server running a good sized database (7.2GB of db files), Mysql
4.0.18. I am running Apache 1.3.29 + perl and using mysql as the
backend. In my.cnf, I have max_connections=300.
Here's the problem. I had th
> On Monday 02 August 2004 02:39, Denis Geser wrote:
> > I am using MySql to store telephone taxes statistics.
> > I have 1 table by month with 60'000 rows each.
> >
> > My problem is that I need some stats for 3 month.
> > For example I need to know the total Time(in second) and total Cost
> > for
Well, giving the rank and getting the ID is simple:
SELECT * FROM RichMan ORDER BY Bucks DESC LIMIT 4,1
That will return 1 record starting at the 4th record.
The first one is a bit tougher. Thinking on it.
On Aug 2, 2004, at 7:23 AM, Horst Jäger wrote:
Hi,
suppose I've got a table "RichMan" with co
Did you compile mysql from source or you use precompiled binary package?
I use mysql with different versions of FreeBSD without big problems.
"adp" <[EMAIL PROTECTED]> wrote:
I have several MySQL and FreeBSD installs across a few different sites, and
I consistently have problems with mysqld. It wil
Have you run an explain before each scenario to see if the access path is
different?
-Original Message-
From: Jeremy Zawodny
To: Marc
Cc: [EMAIL PROTECTED]
Sent: 8/1/04 8:28 PM
Subject: Re: better performance with optimize!?? (jboss)
On Sun, Aug 01, 2004 at 01:42:24PM +0200, Marc wrote:
Hi Everyone.
I require some help with an IN statement I'm trying to get working. I have
inherited a database from someone else in which there is a table with
project information and a field containing which geographic regions the
projects relate. As a single project can relate to multiple geograph
Actually, no, it isn't in memory (except for that breif period of time
before the write cache is committed to disk). You are actually creating a
new, disk-based database and populating it with data.
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"Jacob, Raymond A Jr
Why do I include some WHERE restrictions in my ON clauses and encourage
others to do it, too? Because I believe that the WHERE clause is applied
AFTER the temporary virtual table (the result of applying all of the JOIN
and ON clauses in the full statement) is complete. That is also why I am
su
Wolfgang Riedel <[EMAIL PROTECTED]> wrote:
>>>could someone please tell me which versions of mysql support SSL
>>>connections for both clients and replication slaves?
>>
>> The "-Max" build.
> i'd installed MySQL-Max-4.0.20-0.i386.rpm from download area of
> www.mysql.org, but the server doesn'
Pete Harlan <[EMAIL PROTECTED]> wrote:
>> No. I've forgot to tell that the -Max binary is linked dynamically
>> because it uses SSL.
>
> Is there a reason the SSL libraries can't also be linked statically?
There was some reasons. Afair, MySQL is not the only software which could not
be staticall
Yves Goergen <[EMAIL PROTECTED]> wrote:
>>>I'm using UTF-8 in my newsboard, too, and I have no major problems with
>>>it. UTF-8 doesn't need to be handled as binary, I believe, since all
>>>characters should be in a range over the control characters. Anyone
>>>please correct me, if that's wrong
"mc" <[EMAIL PROTECTED]> wrote:
> Here are the results from my installation... in case you may find them
> useful :)
So it seems that 64bit binaries are also dynamically linked...:(
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensi
Nathan Boeger <[EMAIL PROTECTED]> wrote:
> Its accessed over the net by the web servers. I don't think we would
> have file contentions.
>
> Actually, we just replaced the mysql binary with an older 4.0.16 version
> that we compiled and used before we started to use the 4.0,20-i686-icc.
> Now
Michael Gale <[EMAIL PROTECTED]> wrote:
>
>I have a question about data loading using mysql 4.0.20. If you need to load
> let's say 50,000 items into a database.
> Now 50,000 is not a lot for a DB.
>
> So my question is would it be fast to load the file using the local infile which is
rmck <[EMAIL PROTECTED]> wrote:
> I thought I could wrap this LOAD DATA option in my perl script which could
> speed things up... Any help is great
You can consider using bulk insert.
See http://dev.mysql.com/doc/mysql/en/INSERT.html and note that you can
insert more than a single row at
On Monday 02 August 2004 02:39, Denis Geser wrote:
> I am using MySql to store telephone taxes statistics.
> I have 1 table by month with 60'000 rows each.
>
> My problem is that I need some stats for 3 month.
> For example I need to know the total Time(in second) and total Cost
> for each Number o
"adp" <[EMAIL PROTECTED]> wrote:
> I have several MySQL and FreeBSD installs across a few different sites, and
> I consistently have problems with mysqld. It will begin to eat up all of the
> CPU and eventually become unresponsive (or the machine will just burn). I
> can't seem to manually reprodu
- Original Message -
From: "vijaya raj" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 02, 2004 7:11 AM
Subject: help-in-normalizing
> hi friends
> i am trying to create a data model for my new database.
> i have some problems in normalising my data model.
> i have two
Denis Geser <[EMAIL PROTECTED]> wrote:
> I am using MySql to store telephone taxes statistics.
> I have 1 table by month with 60'000 rows each.
>
> My problem is that I need some stats for 3 month.
> For example I need to know the total Time(in second) and total Cost
> for each Number on a 3 month
"Issac Goldstand" <[EMAIL PROTECTED]> wrote:
> I just set up another reeplication slave for one of my servers - it's not
> something new to me. I'm using 4.1.3-beta on a new server which will
> eventually take over as the master. I set up a server id, did change
> master to... and started the s
> --
> molecule_info
> --
> mol_id
> mol_name
> ---
>
> ---
> plant_info
> ---
> plant_id
> plant_name
>
>
> here, i one mol_name is found in more than one plant_name.
> the
"Shannon R." <[EMAIL PROTECTED]> wrote:
> i'm getting really confused with how to properly allow
> users to access mysql from other machines.
>
> that is, i tried this as mysql root user:
>
>
> GRANT SELECT, INSERT, UPDATE, DELETE ON my_sql_db.* TO
> [EMAIL PROTECTED] IDENTIFIED BY 'password';
Hi,
suppose I've got a table "RichMan" with columns
ID, Name, Bucks
1, 'John', 300
2, 'Joe', 700
3, 'Al', 400
4, 'Fred', 250
5, 'Jim', 480
and I sort them with respect to "Bucks". Then John would be on the first
place because he ist the richest, followed by 'Jim', etc.
Now I'm looking for an SQL-
hi friends
i am trying to create a data model for my new database.
i have some problems in normalising my data model.
i have two tables with many-to-many relation.
how to i normalize them to one-to-many form.
--
molecule_info
--
mol_id
mol_name
Somewhere about Sun, 01-Aug-2004 at 11:31AM -0400 (give or take), Michael Stassen
wrote:
|>
|> Patrick Connolly wrote:
[...]
|> > Looks to me the mysql user should have no trouble with it:
|> >
|> > -rw-rw-r--1 pat pat 332 Jun 28 20:42 Orders.txt
|>
|> Every piece of the p
Jeremy Zawodny <[EMAIL PROTECTED]> wrote on 02/08/2004 09:41:40:
> On Mon, Jul 26, 2004 at 11:49:02PM -0500, mos wrote:
> > At 04:43 PM 7/26/2004, you wrote:
> >
> > >looks like the answer is no. As soon as fee based software touches
the
> > >mysql install on the PC, the user is obligated to pa
Don't I feel stupid. It was the password. I'd actually pasted the password
into both the master and slave (and did it again just in case yesterday), so
I feel quite foolish about that. However, I could swear that at one point
if there was an authentication failure, I'd get some report of a locko
On Mon, Jul 26, 2004 at 11:49:02PM -0500, mos wrote:
> At 04:43 PM 7/26/2004, you wrote:
>
> >looks like the answer is no. As soon as fee based software touches the
> >mysql install on the PC, the user is obligated to pay the $250.
>
> Actually I believe the MySQL 4.x license is more stringent t
On Mon, Jul 26, 2004 at 05:43:58PM -0400, Steve Richter wrote:
>
> looks like the answer is no. As soon as fee based software touches the
> mysql install on the PC, the user is obligated to pay the $250. At least I
> guess it is the user who has to pay.
So a copy of MySQL on Windows is free unt
On Mon, Jul 26, 2004 at 01:26:15PM -0500, gerald_clark wrote:
>
> Steve Richter wrote:
>
> >exactly! Is Linux distributed under the same type of license as MySql? If
> >I sell software that runs on linux I dont have to give away my code, right?
> >To use my software you first have to install no
On Sun, Aug 01, 2004 at 08:42:50PM +0300, Issac Goldstand wrote:
> I just set up another reeplication slave for one of my servers - it's not
> something new to me. I'm using 4.1.3-beta on a new server which will
> eventually take over as the master. I set up a server id, did change
> master to..
On Fri, Jul 23, 2004 at 01:44:16PM -0400, Michael Sleman wrote:
> Does MyISAM lock the whole table when doing SELECTs?
Yes, each client obtains a read lock on the table for a SELECT query.
> How about if there are several processors? Is there locking?
It's no different with multiple CPUs.
Jerem
Thanks very much Michael, you were right.
I spent hours worrying about this yesterday. The documentation implied
that you don't have to log on at all.
Cheers
Dave
> -Original Message-
> From: Michael Stassen [mailto:[EMAIL PROTECTED]
> Sent: 02 August 2004 05:11
> To: Prout,DA,Dave,XS
On Fri, Jul 30, 2004 at 11:46:02AM -0500, Pete Harlan wrote:
> On Thu, Jul 29, 2004 at 06:26:23PM +0300, Egor Egorov wrote:
> ...
> > No. I've forgot to tell that the -Max binary is linked dynamically
> > because it uses SSL.
>
> Is there a reason the SSL libraries can't also be linked statically?
I am using MySql to store telephone taxes statistics.
I have 1 table by month with 60'000 rows each.
My problem is that I need some stats for 3 month.
For example I need to know the total Time(in second) and total Cost
for each Number on a 3 month basis.
Is it possible to do it without creating n
good day all!
i'm getting really confused with how to properly allow
users to access mysql from other machines.
that is, i tried this as mysql root user:
GRANT SELECT, INSERT, UPDATE, DELETE ON my_sql_db.* TO
[EMAIL PROTECTED] IDENTIFIED BY 'password';
after this, i can access mysql as 'dbus
93 matches
Mail list logo
