http://www.youtube.com/watch?v=b2F-DItXtZs
LOLercopter.
"For the purposes of the exam, which I think the original question related
to, I would say you have to accept mysql's interpretation of 'network
interface' as being a port, socket, pipe etc. Thats what it says in the
study guide and the reference manual and thats what they are going to test
you on.
First to help people join the discussion, the guilty paragraph of
certification study guide 42.1
--
Each server must have its own network interfaces, including the TCP/IP
port, the named pi
Andy,
Like I said, I would like to hear what others think and I'd be
particularly interested in some comment from within MySQL.
For the purposes of the exam, which I think the original question related
to, I would say you have to accept mysql's interpretation of 'network
interface' as being a por
Quoting John Daisley :
I would say in terms of the MySQL server the interface is either a TCP/IP
Port, a Named Pipe, shared memory or a UNIX Socket. Depending on the host
operating system it can use any of those interfaces but each instance must
have its own interface.
Just to chip in on th
Claudio,
Nobody is arguing, its a discussion list not an arguing list and this is a
good discussion to have on here. Im very interested in seeing what others
have to say about this but here is how I interpret it (based on my 18
years of IT experience which includes many years working with MySQL
in
John,
I don't want to argue too much on this but I'd also like the opinion of the
big heads in MySQL
I think there's no grey area here.
An interface is an interface and can be of any type and supporting any
protocol(TCP/IP on ethernet card, UDP idem. DSL on WAN card, PPP on POTS
modem)
A port is
An interface by definition is a point of interconnection.
Maybe its a bit of a grey area where the interpretation can be different
depending on whether you think in terms of hardware or software.
Its the port which is used to communicate with the MySQL (or indeed any
other) server software so the
Hi Claudio,
I don't think its your English, I agree with you that its not just
confusing it is wrong.
"Each server must have its own network interface"
At least for my 10 years experience in IT and UNIX I would understand
network interface as physical network interface unless specified a
Hi John,
So according to this interpretation a port IS a network interface,
it means that I have thousands of network interfaces on my servers?
I never thought of a port as a network interface,
I always thought of it as an attribute(address of an application on the
host) of the tcp/ip protocol,
tra
I think you are confusing a network
interface (such as a
tcp port) with a
physical network device (such as a LAN card).
For me the study guide is correct.
> I succesfully install multiple instances on the same host since many years
> (good old 3.23),
> my rule of the game is: different os user, di
I succesfully install multiple instances on the same host since many years
(good old 3.23),
my rule of the game is: different os user, different os user homedir,
different my.cnf (with different port/socket)
and start the server ecluding the possibility to read other than its own
my.cnf with --def
I just got an email from MySQL concerning web seminar. Since I'm deaf I
would like to attend, is there any accomodations that I can use to get in
touch? There is a "Video Relay Interpreting" service online and am wondering
if MySQL could use that service?
--
Please avoid sending me Word or
feeling regarding whether
it will scale to a hundred million images? It's not a Wall Street
bank, so the typical transaction will be under a hundred dollars.
We'll have somewhere between 10-100 million records describing basic
digital rights of media files.
Ideally the code would be opt
Hello,
I am working on a website for a client which is basically biological
database, and some have pictures, I am not allowed to give more out. It will
be stored in MySQL.
Basically the client says there are about 500 million different items of
data, which each holds about 10 small text f
Yes, I increased this to 512M, as suggested in another answer, and the
perfomance improved dramatically. Thanks for the tip.
Jeremy Zawodny wrote:
>On Mon, Sep 23, 2002 at 07:25:17AM -0500, Chris Stoughton wrote:
>
>
>>Joseph,
>>
>>Thanks for the quick answer.
>>
>>Very nice to know that add
On Mon, Sep 23, 2002 at 07:25:17AM -0500, Chris Stoughton wrote:
> Joseph,
>
> Thanks for the quick answer.
>
> Very nice to know that adding an index forces a rebuild of all indices!
> (Side note -- I was going to configure the database with a minimal set
> of indices, and then watch to see
Joseph,
Thanks for the quick answer.
Very nice to know that adding an index forces a rebuild of all indices!
(Side note -- I was going to configure the database with a minimal set
of indices, and then watch to see how people use the database, and then
add indices on popular columns.)
I did
Chris Stoughton wrote:
> I have a table with a few million rows, wth 633 columns. I want to
> create 10 inidices on this table, six single-column and four two-column
> inidices. The database will be loaded once and remain static, and
> queried many times. Please note that this is a "small" p
I have a table with a few million rows, wth 633 columns. I want to
create 10 inidices on this table, six single-column and four two-column
inidices. The database will be loaded once and remain static, and
queried many times. Please note that this is a "small" prototype for
the actual databa
Hi !
What is the usual approach when its needed to scale a mysqlserver. Of
course 1 server can be extended and upgraded in a number of ways. But is
it possible to have a cluster of server who works together and share the
load? So servers can be taken in and out of the cluster without much
work
>We are performing some rather extensive data collection (measurements) and
>are attempting to come up with the most sane storage mechanism to
>facilitate offline (Igor, MatLab, Custom Apps) and online (less complex
>web based solutions) analysis tools. The problem resides in the amount of
>data
In the last episode (May 15), Seth Northrop said:
> We are performing some rather extensive data collection
> (measurements) and are attempting to come up with the most sane
> storage mechanism to facilitate offline (Igor, MatLab, Custom Apps)
> and online (less complex web based solutions) analys
We are performing some rather extensive data collection (measurements) and
are attempting to come up with the most sane storage mechanism to
facilitate offline (Igor, MatLab, Custom Apps) and online (less complex
web based solutions) analysis tools. The problem resides in the amount of
data coll
hey..
thanks for the info...
This is the my.cnf file that i'm using -
[mysqld]
skip-locking
set-variable= key_buffer=640M
set-variable= max_allowed_packet=10M
set-variable= table_cache=640
set-variable= sort_buffer=6M
set-variable= record_buffer=6M
set-variable= t
> We've had fairly bad luck with Linux 2.2.X and SMP for any kind of high-end
> system. The DAC 960 SCSI controllers proved to be fairly problematic in this
> environment. Sometimes updating the drivers helps. We have a couple of
> systems that run much better when we do not use one of the C
: <[EMAIL PROTECTED]>
Sent: Tuesday, March 13, 2001 4:15 PM
Subject: Scale/load for mysql
> Ok i know I've seen this somewhere but i can't find the specifications on
> how much mysql can handle. I'm going to be developing a program for my
> company which may require a rath
Ok i know I've seen this somewhere but i can't find the specifications on
how much mysql can handle. I'm going to be developing a program for my
company which may require a rather large amount of records and i just need
to know the maximum capacity of mysql. Thanks for pointing me in the write
d
I've posted a few times about problems with index corruption,
problems with inconsistent select results using indexes, and
problems with hanging count(*) and distinct(*) on indexes.
No good suggestions were provided other than upgrade to 3.23.34,
(which I am loath to do unless I understand why),
On Saturday 10 March 2001 22:16, Justin wrote:
> Well thats good to know.. although this is sustained 24x7x365
>
> linux 2.2.14-5.0smp, uptime 170 days but e2fsk ok's the
> the database partition, which is a mirror.
>
> in an attempt to get stability, I've been running on the official
> 3.22.32 my
Justin writes:
> Thank you Sinisa,
>
> I actually did try the upgade, but rapidly reverted due to errors
> such as these:
>
> mysqld got signal 11;
> stack range sanity check, ok, backtrace follows
> 0x812cfea
> 0x809f541
> 0x809da87
> :
> :
> etc
>
> AND...
>
> read_const: Go
Thank you Sinisa,
I actually did try the upgade, but rapidly reverted due to errors
such as these:
mysqld got signal 11;
stack range sanity check, ok, backtrace follows
0x812cfea
0x809f541
0x809da87
:
:
etc
AND...
read_const: Got error 127 when reading table ./
read_next_with_key: Got erro
Justin wrote:
>
> What is your key buffer size?
mysql> show variables;
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id:47881
Current database: *** NO ONE ***
|
| key_buffer_size
Justin writes:
> What is your key buffer size? In my case, key buffer size is set
> to 384mb .. and mysqld starts out small, perhaps 18mb and grows
> within a day to 100mb, and within a few days to pretty much 300+mb
> ..so it is doing what one would expect it to.
>
> The other mem paramet
What is your key buffer size? In my case, key buffer size is set
to 384mb .. and mysqld starts out small, perhaps 18mb and grows
within a day to 100mb, and within a few days to pretty much 300+mb
..so it is doing what one would expect it to.
The other mem parameters combine in ways explained in
I have a server that averages 256 queries/sec.
It maxes out at 1187 queries/sec.
It averages about 100 threads and maxes out at about 300.
I've never experienced the problems below with corrupted tables, but I
have been experiencing an interesting problem lately.
Normally the server uses about 20
On Sun, Mar 11, 2001 at 01:16:20AM -0500, Justin wrote:
>
> Well thats good to know.. although this is sustained 24x7x365
My average rate over the last 67 days is about 52/second. In reality
we have some periods of much higher load (several hundred per second)
and some of much lower load. It is j
Well thats good to know.. although this is sustained 24x7x365
linux 2.2.14-5.0smp, uptime 170 days but e2fsk ok's the
the database partition, which is a mirror.
in an attempt to get stability, I've been running on the official
3.22.32 mysql binary for a month now .. it hasn't helped.
Typically
On Sat, Mar 10, 2001 at 06:41:20PM -0500, Justin wrote:
>
> Today I was having more index corruption problems.. the fact that it
> typically happens on the *biggest* and *busiest* tables leads me to
> believe that the request rate on my database might be right off the
> scale co
Today I was having more index corruption problems.. the fact
that it typically happens on the *biggest* and *busiest* tables
leads me to believe that the request rate on my database
might be right off the scale compared to other users, who are
not reporting corruptions nearly as often.
My
Linux is a *nix...
Your best bet would be replication which would allow you to have several
copies of the database one for writting and many for reading.
see REPLICATION in the online manual.
Alternatively if your databsae is read-only and you have some high-speed
network file system then you
Is it possible to run one MySQL server on more than one Linux box ?
and is this good, or should we put it on Unix machines ? We prefer Linux as
it is free :)
-
Before posting, please check:
http://www.mysql.com/manual.php
42 matches
Mail list logo
