hashes the password entered in the same way MySQL hashes a password (or
abandon the use of servlet auth :-)
Any clues?
John Kemp,
Director, Software Development
Streetmail Inc.
http://www.streetmail.com
-
Before posting, please
Hank,
1. RH 7.1 supports files > 2GB if you choose the Enterprise/SMP flavour
(you'll be asked to choose which install you want to pursue when you put
the install CD in) No kernel re-compile needed.
2. MySQL will support large files. Also, if you use Innodb tables, many
of the large file conce
Kevin,
The Mysql documentation suggests you use no more than 75% or 80% of
physical memory to allocate for key_buffer. As Heikki and Jeremy
confirmed for me this week, sort_buffer and record_buffer are the ones
that grow per thread - Heikki suggested 1Mb for each of those. Using
swap as RAM (
ll be
re-used as they are let go by other queries. This can be very good for
performance.
Hope that's helpful,
John
John Kemp,
Director, Software Development
Streetmail Inc.
Mitch Fournier wrote:
> Hi,
>
> i've been googlizing for a while now and can't find a strai
omething about tuning MySQL :).
>
> Best regards,
>
> Heikki Tuuri
> Innobase Oy
> ---
> Order technical MySQL/InnoDB support at https://order.mysql.com/
> See http://www.innodb.com for the online manual and latest news on InnoDB
>
> Jeremy Zawodny wrote in message .
390Mb, so I'm finding it hard to believe
it's going to scale that badly right now. We "only" have 4Gb memory on
our linux-based database machine right now - should I be upgrading? ;-)
Does anyone have any information that either supports or refutes the
statement above? I'
show tables will get you a list of tables. To get the schema of tables
type 'describe '
J
Bret Ewin wrote:
> I need to know how to get a list of all the tables in a database. In Oracle
> you could "select OWNER, TABLE_NAME from ALL_TABLES" to get a list of all
> tables and their schemas. How d
Walt,
It'll go to the database_machine_name.err file on that machine.
John
Weaver, Walt wrote:
> Heikki,
>
> I must be missing something really simple here, but I can't get the InnoDB
> Monitor to work. I created the innodb_monitor table with "create table
> innodb_monitor(a int) type=innodb;
To see stats on a table from mysql itself:
show table status from database-name like 'table-name' ;
You'll see stats about the number of rows, and the amount of free space
(for an Innodb table) also what table type is used for that table.
John
Rutledge, Aaron wrote:
> One final question, and
y better (fewer complaints!)
Thanks again,
John Kemp
Director, Software Development
Streetmail
Heikki Tuuri wrote:
> John,
>
> did you configure innodb_buffer_pool_size and InnoDB log files big? Look at
> the online manual on the recommended sizes.
>
> If the table is very big, then U
I am also in the process of altering tables from MyISAM to INNODB. I
have one big problem - a very large table (> 5 million rows) with 5
indices/indexes on it, including a couple that are UNIQUE but with NULL
values allowed. Creating the last of these indices is taking an absurd
amount of time
Heikki,
Thanks very muich for the explanation. That's an interesting question
for the connection modules in Apache/PHP/DBI etc. Perhaps this is a
problem with the way the connections are opened by those programs. I
hadn't thought of that, so it would definitely be a good thing to test
before
Walt,
Yup, we use Innodb with 3.23.46 on Linux 2.4.2. I can't tell you whether
things are better than they were on 2.2 kernels but we're updating
tables just about that quickly I'd say. Largest table we have is a log
table which has 50 million rows in it so far. Thanks to Innodb row
locking,
l transaction-oriented RDBMS's work this way.
> Oracle certainly does. You need to do an explicit commit or rollback to
> release the lock. (or close the cursor, etc.)
>
> Unless, of course, autocommit is on.
>
> --Walt Weaver
> Bozeman, Montana
>
> -Original
Heikki,
Hmm. That's interesting. So if you do a single command, say
INSERT INTO Table1 (X, Y, Z) VALUES ( A, B, C) ;
You actually need to write (I'm not sure of the exact transactional
syntax for Mysql) -
BEGIN ; --begin a transaction
INSERT INTO Table1 (X, Y, Z) VALUES ( A, B, C) ;
COMMIT ;
Hi SAm,
I actually had a similar problem myself, but was unable to prove it was
the persistent connection itself causing this. I'm wondering if this
means that INNODB thinks that a connection that is now 'sleeping' (ie.
where a connection was created, used, but is now unused but still open)
m
There are a couple of potential things you could change.
Dan,
1. On the MySQL end, there is a configuration value or two for timing
out sleeping MySQL queries - by default the timeouts are set to be 8
hours. You can make the timeouts less in my.cnf - However, be careful.
You may have connecti
on at
www.mysql.com/doc for more info) Perhaps your databases and
configuration aren't in /usr/local/mysql/var? BUt look for the error
file first. That should tell you something useful.
John
John Kemp,
Director, Software Development
Streetmail Inc.
Mike Blain wrote:
> I keep trying to sta
ld, a
unique index would seem to be no good. But it seems that generally
accepted practice is to allow NULL in a UNIQUE index.
In which case, how can I get my UNIQUE index with NULLs to work with Innodb?
Or is this a B U G?
John Kemp
Director, Software De
19 matches
Mail list logo