I now have multiple installations running on the same machine, and am also using
mysqld_multi. However, even though it's working, there's one thing I don't
understand. Why does the [mysqld_multi] section have to contain the pointers to
mysqld and mysqladmin? It seems to me that it should just
We have successfully (and easily) installed multiple versions of MySQL on
Windows and are now trying to do the same on Linux.
We have a Fedora machine successfully running 4.1, but we want to add 5.0 to
it as well. We installed 4.1 with RPM, so it put a bunch of MySQL files all
over the place.
I
I really like the Certification Study Guide we just ordered last week.
Great info that I'd wish I had when I started. I have no plans to take the
test, but I love the way the info is presented and the questions at the end
help ensure I "got it."
Lou
- Original Message -
From: "Bartis, Ro
Ah, the symbolic links.. Forgot about them... Thanks.
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "Lou Olsten" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, June 08, 2004 3:49 PM
Subject: Re: Moving tables to different
In the High Performance MySQL book, on page 124, the author suggests:
"If you have all your MySQL data on a single disk, you can try moving pieces to
another disk. If the majority of activity is focused on a small group of tables,
consider moving them to a separate disk."
How do you accomplish
---
From: "McKeever Chris" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 04, 2004 8:39 PM
Subject: Re: Backing Up a Database
>
>
> On Fri, 4 Jun 2004 18:16 , Lou Olsten <[EMAIL PROTECTED]> sent:
>
> >For the time I've been te
For the time I've been testing, I've used the procedures outlined in the help to take
my backups, which entails doing a FLUSH TABLES WITH READ LOCK in my MySQL monitor,
then going to a shell prompt and executing the mysqldump utility, then issuing the
UNLOCK TABLES from my MySQL monitor.
Now I'
David,
Think of users as the concatenation of the user and the host from which the
user is connecting. That's why in your GRANT statement, you will see the
'user'@'host' semantic employed.
When you say 'localhost' you're telling MySQL that the user you are
specifying is connecting from the local
>From the docs at: http://dev.mysql.com/doc/mysql/en/CREATE_DATABASE.html
"Databases in MySQL are implemented as directories containing files that
correspond to tables in the database. Because there are no tables in a
database when it is initially created, the CREATE DATABASE statement only
create
If I understand the docs correctly, I can use a config file on my client machine for
the given mysql client apps such as the mysql command line tool.
What if I'm using a 3rd-party app? Will the libraries somehow know to read the config
file or would the app have to take manual steps to do it?
Trying to install MySQL 4.1.1 Max binary using MySQL-Max-4.1.1-0.i386.rpm onto Linux
Fedora version. When I do, I get the following failed dependencies:
libcrypto.so.0.9.6 is needed by MySQL-Max-4.1.1-0
libssl.so.0.9.6 is needed by MySQL-Max-4.1.1-0
libstdc++-libc6.2-2.so.3 is needed by MySQL-Ma
Can you use the actual IP address and get it to work? If so, then ping
localhost and ping tux and make sure the IP that you believe it should be is
actually being returned.
Lou
- Original Message -
From: "Timothy Waters" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 18,
Is there a way to set this dynamically?
Thanks,
Lou
Hi.
- Original Message -
From: "Hans-Peter Grimm" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 14, 2004 2:53 AM
Subject: Comments/questions on "High Performance MySQL"
>
> Hi,
>
> I just finished reading "High Performance MySQL". Congratulations to the
> authors, it's a
Need someone with some insight or experience with InnoDB (Heikki?? :-)
1) According to a book I'm reading (High Performance MySQL) InnoDB uses MVCC,
effectively allowing readers to not block writers. In Oracle (with which I am more
familiar) this is accomplished via rollback segments, and now,
Pachev" <[EMAIL PROTECTED]>
To: "Lou Olsten" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, May 11, 2004 5:01 PM
Subject: Re: Saving PDF's as Blobs
> Lou Olsten wrote:
> > What SQL statement can I use to insert a PDF into a BLOB column? I
don&#x
What SQL statement can I use to insert a PDF into a BLOB column? I don't want a
pointer to the file, I want the actual file stored as a BLOB.
Thanks!
Lou
al Message -
From: "Bart Nessux" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 10, 2004 8:07 PM
Subject: Re: Validation/Linking Table Question
> Thanks Lou, I'll give this a go!
>
>
> >From: "Lou Olsten" <[EMAIL PROTECTED]>
> &
Assuming that your pre 4.1, meaning that you can't use a subquery this
will do it, BUT comp_id must be set to allow NULLS for this to work
otherwise the optimizer will handle it differently
(http://dev.mysql.com/doc/mysql/en/LEFT_JOIN_optimisation.html). It is
legal to create a primary key on
: Re: Blocking Selects with LOCK TABLES
> "Lou Olsten" <[EMAIL PROTECTED]> wrote:
> > According to the docs
(http://dev.mysql.com/doc/mysql/en/LOCK_TABLES.html)
> > :
> > If a thread obtains a READ lock on a table, that thread (and all other
threads) can only
&g
According to the docs (http://dev.mysql.com/doc/mysql/en/LOCK_TABLES.html) :
If a thread obtains a READ lock on a table, that thread (and all other threads) can
only read from the table. If a thread obtains a WRITE lock on a table, only the thread
holding the lock can read from or write to the ta
See below
- Original Message -
From: "Jeremy Smith" <[EMAIL PROTECTED]>
To: "[EMAIL PROTECTED] Mysql. Com" <[EMAIL PROTECTED]>
Sent: Sunday, May 09, 2004 9:31 PM
Subject: Transaction question - no rollback needed?
> Does it make sense to use a transaction just for the row locking
propert
The backslash (\) is an escape character
(http://dev.mysql.com/doc/mysql/en/String_syntax.html).
So to enter a backslash into a text field, you would have to say:
txtSceneFile = "C:\\Data\\test\\foo\\bar.lws".
Lou
- Original Message -
From: "Steve Pugh" <[EMAIL PROTECTED]>
To: <[EMAIL P
<>
Very much. Thanks to all who responded.
http://ciips.ee.uwa.edu.au/~morris/Year2/PLDS210/hash_tables.html was
helpful as well.
Lou
- Original Message -
From: "Andy Ford" <[EMAIL PROTECTED]>
To: "Lou Olsten" <[EMAIL PROTECTED]>
Cc: <[EMAIL PR
This one is more curiosity than a problem.
I have read the docs about HASH indexes and how they are used, but I'm just wholly
unfamiliar with WHAT a HASH index is. I'm only familiar with the term 'hash' as it
relates to encryption. What exactly IS a hash index?
Just curious,
Lou
ECTED]>
Sent: Tuesday, May 04, 2004 5:25 AM
Subject: Re: Query Log
> "Lou Olsten" <[EMAIL PROTECTED]> wrote:
> > I'm pretty sure that the answer to this is "No, you cannot" but I
figured I'd check
> > anyway...
>
> > As I go back t
>From the docs: "If there are random insertions into or deletions from the indexes of
>a table, the indexes may become fragmented."
How can I go about determining if my indexes are, in fact, fragmented?
Thanks,
Lou
>From the docs, it says:
"You can use innodb_tablespace_monitor to check the integrity of the file space
management inside the tablespace files. "
Does this mean that it is part of the SHOW INNODB STATUS command or is this something
separate?
Thanks,
Lou
This is not a question, rather just some information I wanted to post in case someone
else hits it and searches the lists.
I do a lot of straight command line connecting using the mysql.exe client for windows.
Aside from my other challenges with getting users set up properly, I ran into another
I'm pretty sure that the answer to this is "No, you cannot" but I figured I'd check
anyway...
As I go back through my query log, I'd like to know the user that issued the
statement. If the user is still connected, I can cross reference it with the SHOW
PROCESSLIST ID, but if they have signed o
, we definitely will have
tighter security. Right now I'm just laying the groundwork and educating
everyone (scary thought) so we can move to production with as little pain as
possible.
Thanks again.
Lou
- Original Message -
From: "Michael Stassen" <[EMAIL PROTECTED]>
ing
unique to that box.
Lou
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "Lou Olsten" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, April 29, 2004 5:21 PM
Subject: Re: Creating Users and Passwords
> In the last
I thought I had a handle on this, but now I'm all screwed up.
MySQL 4.1.1a-alpha-max-debug-log
Windows 2000 Server
I'm trying to create a user roby with a password of 'foo' with access to everything.
Here's what happens:
- Sign in as root on the local host.
- GRANT ALL PRIVILEGES ON *.* TO rob
Paul, please see below...
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Lou Olsten" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, April 29, 2004 1:00 PM
Subject: Re: [client] var not working
> At 12:22 -0400 4
old true? SHOW VARIABLES? I noticed that SET
FOREIGN_KEY_CHECKS doesn't appear in the SHOW VARIABLES list. The only
place I found it was by querying @@session.FOREIGN_KEY_CHECKS.
Thanks,
Lou
- Original Message -----
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Lou Olsten&
hen I try to connect after that, I get an:
"ERROR: unknown variable 'foreign_key_checks=0'.
I then tried using:
set variable=foreign_key_checks=0
...but got the same result.
Is there a list of variables that I *can* use in the [client] section, or am I just
doing something
If I'm using mysqldump to dump a database with referential integrity in place, does
MySQL build the information in such a way that the referenced tables are loaded first
to avoid invalid inserts into a table with a foreign key in place? I'm trying to find
an option for mysqldump, and the closes
Jeff,
I'm in the process of working with some grants, so I tried the following and
it worked fine.
grant all privileges on *.* to sec5 identified by 'sec' with grant option;
SHOW GRANTS FOR sec5 produced the following:
mysql> show grants for sec5;
+--
e out the difference
between that number and the 17,490,512 shown by the SHOW INNODB STATUS
command This is one example of my frustration trying to understand the
memory constructs and how they are interrelated.
Thanks,
Lou O.
- Original Message -----
To: "Lou Olsten" <[EMAIL
I'm trying to get a handle on the entire memory structure used by MySQL. I'd like to
be able to see the total memory used by the entire MySQL instance, and then a
breakdown of what is going on within that aggregate allocation. For example, I'd like
to see how much memory is devoted to the quer
Per one of my last posts on searching... I can't find the meanings for these
variables. I've tried a general google search with no luck. Anyone got any ideas?
convert_character_set
error_count
slave_compressed_protocol
sql_big_tables
sql_low_priority_updates
sql_max_join_size
sql_slave_skip_cou
Thanks for your suggestion of searching the docs offline. I already had the
HTML ones on my laptop, so it was a small step.
Lou
- Original Message -
From: "Donny Simonton" <[EMAIL PROTECTED]>
To: "'Lou Olsten'" <[EMAIL PROTECTED]>; <[EMAIL
I use the online docs extensively as I am still very much in learning mode with MySQL.
However, I've been frustrated recently because it appears I cannot search for an
EXACT string literal, which brings me back a ton of hits I don't want. For example,
I'm trying to search for the dynamic syste
timed out.
15 *** Request timed out.
- Original Message -
From: "Lou Olsten" <[EMAIL PROTECTED]>
To: "Yves Goergen" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, April 21, 2004 9:14 AM
Subject: Re: MySQL Web
I have not been able to access the mysql.com server for about a day and a
half now from my office. From home, it's fine. There have been rare
occasions in the past when our provider had dropped (or very slow)
connectivity with certain nodes on the Internet. My understanding there is
limited, but
I've found two methods that both seem to work fine (on 4.0.18) for setting dynamic
variables:
mysql> set @@session.autocommit=0;
mysql> set session autocommit=0;
Which is the preferred (latest) method? Is one eventually going to be deprecated?
Thanks,
Lou
; 4.0.10 < 4.0.18
>
> 4.0.3 != 4.0.30
>
> -Original Message-
> From: Lou Olsten [mailto:[EMAIL PROTECTED]
> Sent: Monday, April 19, 2004 1:44 PM
> To: [EMAIL PROTECTED]
> Subject: Getting an older version of MySQL
>
>
> Hi,
>
> I'm currently runnin
Hi,
I'm currently running some instances of 4.0.18. I read the following in the docs:
<>
But when I look at the downloads page, I only have options for 4.0.18 (production) or
4.1.1 (alpha).
How do I upgrade my 4.0.18 to 4.0.3 or whatever the latest 4.0.x might be?
Thanks,
Lou
When I do a FLUSH LOGS my bin log does increment and a new one is created.
My query log does not behave this way, however. Just the bin log. It
creates files with the .00x extension where "x" is an incremental number.
Lou
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To:
n my sales database? Or do I have to loop
through each table with the SHOW INDEXES command? That's one example of what I'm
talking about.
Thanks so much for the help.
Lou Olsten
[EMAIL PROTECTED]
50 matches
Mail list logo
