A new server is about to arrive here and will have have 8x15K RPM spindles,
dual Opteron processors and 4GB of RAM, and will have around 100GB of
database (primarily stock market prices) - the SCSI controller will also
have battery-backed RAM too. InnoDB will be used exclusively.
I've searched th
MySQL data files are binary compatible from one machine to another.
Even InnoDB
data files. As long as you are not trying to "upgrade" from version 3.23 to
version 4.1, you are okay with copying the data files from one machine to
another.
--
Partha Dutta
Sr. Consultant, MySQL Inc.
Quoting Chris
I'm not sure what you mean by date *conversions* but the date *functions*
can be found here:
http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html. You will
probably use these for most conversions you attempt.
Rhino
- Original Message -
From: "Robert A. Rawlinson" <[EMAIL PROTEC
Brian Erickson wrote:
>Greetings all,
>
>We are migrating our web site from one server to another and are
>having some issues with transferring our MySQL database. Here's the
>process we're currently using:
>
>1) run mysqldump for each table in our database (i.e. one file for each table)
>2) compr
does anybelly know why the following happens?
i am using macosx 10.4
and ./configure --prefix=/usr/local/mysql
--with-unix-socket-path=/usr/local/mysql/run/mysql_socket
--with-mysqld-user=mysql --with-comment --with-debug
sql_list.h: At global scope:
sql_list.h:401: warning: inline function `ba
Temporary replication comes to mind fs hot copy as well (maybe)
--
Chris.
I love deadlines. I especially love the whooshing sound they make as they
fly by..." - Douglas Adams, 'Hitchhiker's Guide to the Galaxy'
- Original Message -
From: "Brian Erickson" <[EMAIL PROTECTED]>
To:
Greetings all,
We are migrating our web site from one server to another and are
having some issues with transferring our MySQL database. Here's the
process we're currently using:
1) run mysqldump for each table in our database (i.e. one file for each table)
2) compress each file using gzip
3) tra
Hi Mark
You should know that users and passwords are specific to the host where they
are being used.
For instance, if your root password on the server is mypass, and use it to
connect to the mysql server, then it will get accepted.
Now if you use a mysql client on another machine to connect to
Harrison Fisk wrote:
There isn't really any way to "use" concurrent INSERT. It happens
automatically if possible. However there are a few things you can do
to help it along, such as OPTIMIZE after you DELETE large portions of
the table. Also it does have to enabled in LOAD DATA INFILE
manual
Hi,
On May 8, 2005, at 1:47 PM, Kevin Burton wrote:
Harrison Fisk wrote:
aren't loaded into the query cache, they are loaded into the key
cache (key_buffer_size).
Yes... you busted me ! :). I meant to say key cache though.
Alright, I assumed a typo or such.
Not only THAT but it doesn't need to rea
Harrison Fisk wrote:
aren't loaded into the query cache, they are loaded into the key cache
(key_buffer_size).
Yes... you busted me ! :). I meant to say key cache though.
Now assuming that you have the query cache actually being used (the
cache of the actual statement), then normally the SELECT
Hi Kevin,
On May 8, 2005, at 1:07 PM, Kevin Burton wrote:
OK.
Lets take a mythical application. The app is spending about 50% of
its time inserting into table FOO. The other 50% of the time its
spent doing SELECT against the table.
The SELECTs can use an index which is already full loaded into
OK.
Lets take a mythical application. The app is spending about 50% of its
time inserting into table FOO. The other 50% of the time its spent
doing SELECT against the table.
The SELECTs can use an index which is already full loaded into the query
cache. Not only THAT but it doesn't need to re
Hi All,
can ping the server from the client. Am seeing the attempted phpmyadmin
connection from the client via the firewall alert. But, get an error
saying that the client is not allowed to connect to the mysql server.
I'm guessing it's a setting in conf.inc.php..?
$cfg['Servers'][$i]['host'] =
I have read somewhere how to do the conversions but for some reason I
can not find it again. Now I need to do conversions soon. Could someone
direct me to where the documentation is located?
Thanks for any help you can offer.
Bob Rawlinson
--
Robert A. Rawlinson
Felicity Ohio 45120
--
MySQL Gen
I was able to set up a table no problem.
On one of the blobs, it is coming up on the web page like a mess
and not like an interpreted object
as one would expect.
Using Mysql 3.23.58 with php 4.3.9
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:h
As you have already seen, it is pretty difficult trying to count things in
multiple columns. Although it is probably possible to do the counting, it
might require programming logic in order to count for specific values in the
various columns and then store the subtotals for each column so that they
Selon Micha Berdichevsky <[EMAIL PROTECTED]>:
> Hi.
> I have a table that store different items. For each items, I can attach
> up to 5 different textual categories.
> Those categories are free-text, and different columns can have the same
> values (example below).
> I am trying to select the coun
18 matches
Mail list logo
