mysqld_multi

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

Multiple MySQL Versions on Same Linux Box

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.

Re: Recommendation on god MySQL books

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,

Moving tables to different disks (High Performance MySQL)

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

Re: Moving tables to different disks (High Performance MySQL)

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 disks (High Performance MySQL) In the last

Re: Backing Up a Database

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 testing, I've used the procedures outlined in the help to take my backups, which entails

Backing Up a Database

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

Re: Username/Password Basics

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

Re: location of created database

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 creates

Client Apps Using a Config File

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?

Problem Installing MySQL Max

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

Re: using host name option

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, 2004

Re: Comments/questions on High Performance MySQL

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 great book and

--default_table_type

Is there a way to set this dynamically? Thanks, Lou

InnoDB Questions

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,

Re: Saving PDF's as Blobs

] 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't want a pointer to the file, I want the actual file stored as a BLOB

Saving PDF's as Blobs

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

Re: Validation/Linking Table Question

- 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] Reply-To: Lou Olsten [EMAIL PROTECTED] To: Bart Nessux [EMAIL PROTECTED],[EMAIL

Re: Transaction question - no rollback needed?

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 properties,

Blocking Selects with LOCK TABLES

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

Re: Blocking Selects with LOCK TABLES

Looks like it's a query cache issue. In this case you get result from the cache. That was it. THANKS - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 10, 2004 1:20 PM Subject: Re: Blocking Selects with LOCK TABLES Lou

Re: Validation/Linking Table Question

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: Hash Index

Hope this helps 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 PROTECTED] Sent: Wednesday, May 05

Re: Query Log

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 through my query log, I'd like to know the user that issued the statement. If the user is still connected, I can

Hash Index

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

4.0 mysql client vs 4.1 installation

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

innodb_tablespace_monitor

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

InnoBD Index Fragmentation

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

Query Log

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

[client] var not working

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 wrong. Thanks, Lou

Re: [client] var not working

PROTECTED] To: Lou Olsten [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, April 29, 2004 11:21 AM Subject: Re: [client] var not working At 10:38 -0400 4/29/04, Lou Olsten wrote: Per a response from Victoria (thanks, BTW!) I see that I can reload my InnoDB RI's data by turning off SET

Re: [client] var not working

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/29/04, Lou Olsten wrote: Thanks, Paul. You appear

Creating Users and Passwords

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

Re: Creating Users and Passwords

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 episode (Apr 29), Lou Olsten said: I thought I had a handle

Re: Creating Users and Passwords

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] To: Lou Olsten [EMAIL PROTECTED] Cc: [EMAIL

Restoring a db with RI enforced

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

MySQL Memory Structure

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

Re: MySQL Memory Structure

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 PROTECTED] Sent: Tuesday, April 27

Re: Still getting problems creating a new super user on version 4 under WinXP

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;

Re: Searching the Docs

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 PROTECTED] Sent: Wednesday, April 21, 2004 4:51 PM

Undocumented Dynamic Variables

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

Re: MySQL Website

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,

Re: MySQL Website - TRACERT

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 Website I have not been able to access the mysql.com

Re: Searching the Docs

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

Setting Dynamic Variables

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

Getting an older version of MySQL

Hi, I'm currently running some instances of 4.0.18. I read the following in the docs: Beginning with MySQL 4.0.3, many server system variables are dynamic and can be set at runtime using SET GLOBAL or SET SESSION. You can also select their values using SELECT. But when I look at the

Re: Getting an older version of MySQL

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 running some instances of 4.0.18. I read the following in the docs: Beginning with MySQL 4.0.3, many server system

Re: about flush logs

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:

Getting Aggregate Object Data

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]