On Wed, Sep 29, 2004 at 05:24:42PM -0500, Qunfeng wrote:
Hi,
I am running 4.1.0-alpha on a linux machine. When I use mysqlimport to load
a big data file (~7 Gb), I get an error mysqlimport: Error: The table
'mytable' is full, when using table: mytable.
I guess the table is too big. Is
On Wed, Sep 22, 2004 at 01:52:36PM -0400, Debbie L wrote:
We are looking at a disk subsystem for a high transactional
application. And management wishes
to use disk appliance (IPStore or NetAPP).
Does anyone know if placing the mysql MYISAM and INNODB datafiles on
IPStore or NetApp disk
On Wed, Sep 22, 2004 at 02:22:59PM -0400, Debbie L wrote:
Your right, I shouldn't say supported... Is it a wise to put
datafiles on a disk appliance? Coming from other database
background, it is not wise to do such a thing and will cause
problems when the disk appliance has problems.
Well,
On Fri, Sep 17, 2004 at 04:01:53PM +0300, Egor Egorov wrote:
Jeremy Zawodny [EMAIL PROTECTED] wrote:
I can verify that a quad opteron 2.2 runs about a million times
better than a quad xeon 3.06. The opteron can handle more than 3
gigs of memory which is a 32 bit limitation. Right now
On Wed, Sep 15, 2004 at 11:27:55AM -0700, Sanjeev Sagar wrote:
Hello All,
I am trying to install DBIx::DWIW but giving me following error.
No such file `DBIx-DWIW-0.41.tar.gz'
I am trying to install from CPAN
cpan install DBIx::DWIW
Could not fetch
On Wed, Sep 15, 2004 at 01:10:35PM -0700, Sanjeev Sagar wrote:
I am trying on cpan.yahoo.com and it's giving me following error
The requested URL /authors/id/J/JZ/JZAWODNY/DBIx-DWIW-0.41.tar.gz was not found on
this server.
Hmm.
wget
On Wed, Sep 15, 2004 at 01:44:21PM -0700, Sanjeev Sagar wrote:
Thanks !
I am trying to run make test but it's giving me following error
[EMAIL PROTECTED] DBIx-DWIW-0.41]# make test
PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/lib -Iblib/arch test.pl
1..1
# Running under perl version 5.008 for
On Mon, Sep 06, 2004 at 12:48:37PM -0700, Miles Keaton wrote:
If my company wants to get the best-performing fastest platform for a
MySQL server, what would it be these days? Opteron? Dual? Quad?
And on a related note...
If a 64-bit CPU, then I'm assuming it would need an operating
On Tue, Sep 14, 2004 at 03:05:07PM -0500, Donny Simonton wrote:
I can verify that a quad opteron 2.2 runs about a million times
better than a quad xeon 3.06. The opteron can handle more than 3
gigs of memory which is a 32 bit limitation. Right now in my quad
opteron we have 32 gigs of
On Tue, Sep 14, 2004 at 02:31:54PM -0700, Brian Abbott wrote:
Do you guys have metrics on this that you would be willing to share? We
are looking at upgrading to the Opteron (from the Xeon) at the moment.
Any information would be very helpful.
I don't have any yet but should in a week or two.
On Fri, Jul 23, 2004 at 05:37:08PM +0200, crandler wrote:
Hello,
the following problem occurs when I want to configure MySQL 4.1:
Building aclocal.m4
Running autoheader to build config.hin
Running autoconf to build configure
645046
644916
Building RPC client/server files
Building tags
On Sat, Aug 14, 2004 at 03:01:06PM -0700, Demetrios Stavrinos wrote:
Kernel panic: Fatal exception in interrupt...In Interrupt handler - not
syncing
message appears when the mysql-max stop is issued. Other than that everything
works. I changed hardware (everything new) and re-installed Linux
On Fri, Aug 13, 2004 at 01:19:14AM -0500, Donny Simonton wrote:
There is only one thread for replication on the slave. It does one
step a time. If you use mysqlbinlog on one of your binary files on
your master, you will see exactly how it all works.
No, there are 2 threads: the IO (or
On Thu, Aug 05, 2004 at 12:19:37PM +0900, Evgeny Chuykov wrote:
Good day.
From these sources:
http://jeremy.zawodny.com/blog/archives/000458.html
http://dev.mysql.com/doc/mysql/en/FreeBSD.html
Jeremy is using -O -march=pentiumpro and
MySQL AB -O2 -fno-strength-reduce.
Does anyone
On Thu, Aug 05, 2004 at 12:36:55PM +0100, Naran Hirani wrote:
Hi,
I'm using a single shared user-login for a web-based application to
my mysql database - is there a way of including some information at
connect time or during processing that would show up when issuing
`show processlist'?
On Thu, Aug 05, 2004 at 10:27:54AM -0500, Sashi Ramaswamy wrote:
Hi,
All of a sudden the memory used by mysql threads has gone up. Each thread is
consuming about 20 M of RAM. My databases are really small and usage is not
very intense. Tables in the database are of type INNODB. MySQL
On Wed, Aug 04, 2004 at 04:32:42PM +0300, Egor Egorov wrote:
Sergei Golubchik [EMAIL PROTECTED] wrote:
We're upgrading from 3.23.58 to 4.0.20 and found that that although the
ALTER test results of sql-bench had been greatly improved, CREATE has
shown nasty performance degradation. Just
On Tue, Aug 10, 2004 at 02:12:50PM -0700, Haitao Jiang wrote:
Hi,
I just wondering if there is a list of important features or bug fixes
comparing these two versions. We are debating whether to go one or the
another. Also, when is the 4.1.4 going to come out? Is it still beta?
Sure there
On Tue, Aug 10, 2004 at 11:40:28AM +0200, Jigal van Hemert wrote:
How efficient is InnoDB with searching in such sets? Will it use an index or
must it perform a full table search?
Are there alternatives which are more efficient regarding search speed?
Sets result in table scans if they're
On Thu, Aug 05, 2004 at 11:27:40AM -0700, Haitao Jiang wrote:
Hi,
I have a 3GB index which includes a fulltext index on 2 columns. I
wanted to drop this fulltext index from the table, but it took
forever. Why it is so slow? Is it because MySQL basically go through
the index file (there is
On Tue, Aug 03, 2004 at 11:16:43AM -0600, Michael Gale wrote:
Hello,
I am new to mysql and am in the middle of upgrading our mysql
server to the latest release. Upon viewing our currently data
directory I noticed a large amount of hostname-bin-### files.
Some of hostname-bin-###
On Tue, Aug 03, 2004 at 01:08:58PM -0400, [EMAIL PROTECTED] wrote:
I agree with David. If there is no present way to recover unused
InnoDB tablespace, then we (as a community) seriously need to create
a tool to do just that. How have we gone so long without it?
Because it's just not a
On Tue, Aug 03, 2004 at 11:11:52AM -0700, Jon Drukman wrote:
We were having terrible problems with a master/slave setup. The
master does a huge amount of writes, and the slave simply started
lagging behind, despite both machines being identical hardware-wise.
This made the application
On Tue, Aug 03, 2004 at 12:44:05PM +0530, [EMAIL PROTECTED] wrote:
Hi Friends:
We are using mysql version 4.0.17 on Linux with a master and a single
slave both running on the same node.
We have encountered a problem in replication in the following scenario:
First the slave got
On Fri, Jul 30, 2004 at 11:46:02AM -0500, Pete Harlan wrote:
On Thu, Jul 29, 2004 at 06:26:23PM +0300, Egor Egorov wrote:
...
No. I've forgot to tell that the -Max binary is linked dynamically
because it uses SSL.
Is there a reason the SSL libraries can't also be linked statically?
I
On Fri, Jul 23, 2004 at 01:44:16PM -0400, Michael Sleman wrote:
Does MyISAM lock the whole table when doing SELECTs?
Yes, each client obtains a read lock on the table for a SELECT query.
How about if there are several processors? Is there locking?
It's no different with multiple CPUs.
Jeremy
On Sun, Aug 01, 2004 at 08:42:50PM +0300, Issac Goldstand wrote:
I just set up another reeplication slave for one of my servers - it's not
something new to me. I'm using 4.1.3-beta on a new server which will
eventually take over as the master. I set up a server id, did change
master to...
On Mon, Jul 26, 2004 at 01:26:15PM -0500, gerald_clark wrote:
Steve Richter wrote:
exactly! Is Linux distributed under the same type of license as MySql? If
I sell software that runs on linux I dont have to give away my code, right?
To use my software you first have to install no charge
On Mon, Jul 26, 2004 at 05:43:58PM -0400, Steve Richter wrote:
looks like the answer is no. As soon as fee based software touches the
mysql install on the PC, the user is obligated to pay the $250. At least I
guess it is the user who has to pay.
So a copy of MySQL on Windows is free until
On Mon, Jul 26, 2004 at 11:49:02PM -0500, mos wrote:
At 04:43 PM 7/26/2004, you wrote:
looks like the answer is no. As soon as fee based software touches the
mysql install on the PC, the user is obligated to pay the $250.
Actually I believe the MySQL 4.x license is more stringent than
On Mon, Aug 02, 2004 at 09:24:59AM -0700, Marc Slemko wrote:
I believe that MySQL AB is deliberately vague and confusing on their
licensing page to try to get people to buy mysql licenses. All
their words there don't matter though, what matters is the actual
license. It would, however, be
On Tue, Jul 20, 2004 at 04:18:42PM +0800, [EMAIL PROTECTED] wrote:
I am new to MaxDB and clustering. It seems that both products provide
enterprise features and high availability.
Is clustering replacing MaxDB?
What are the difference between them?
Are they targeting different users?
Based
On Mon, Aug 02, 2004 at 03:11:10PM -0500, mos wrote:
At 03:41 AM 8/2/2004, Jeremy Zawodny wrote:
I bet it depends on the country. In the USA, companies are considered
singular legal entities. Internal distribution is aking to giving
copies to yourself.
The GPL doesn't restrict
On Sun, Aug 01, 2004 at 09:22:21AM -0700, bruce wrote:
hi...
i'm testing an app where i want a parent app to create the mysql db
connection link/handle, and basically pass this handle off to child
procesess. is there any reason why this can't be done? are there any
examples of this already
On Sun, Aug 01, 2004 at 01:42:24PM +0200, Marc wrote:
I use Mysql with JBOSS as applicationserver.
i have strange response-time differences, which i can't explain.
1) after reboot the computer, it takes about 300ms to read 12 entities (cmp,
read ahead, 2 rows each entity) One entity is
On Thu, Jul 29, 2004 at 08:10:42PM -0700, Ginger Cheng wrote:
Hello, mysql Gurus,
Because of disk space issues, the data dir of my mysql DB is somewhere
else other than /var/lib/mysql. I did not link /var/lib/mysql to the real
data dir though. It works OK until I want to use perl DBI
On Mon, Jul 26, 2004 at 04:09:51PM -0400, Charles Sprickman wrote:
I have a quick question about how programs linked against the mysql C
libraries handle the following:
-assume three mysql hosts, say 10.0.0.2, 10.0.0.3, and 10.0.0.4
-assume a dns name db.example.com that returns the
On Tue, Jul 20, 2004 at 10:57:02AM -0700, Nathan wrote:
Hi,
Does anyone know of any written stats on how much overhead for CPU/
Disk IO replication has for a single master and a single slave? I
am looking for any detailed stats on the proformance issues
associated with replication.
On Mon, Jul 19, 2004 at 07:52:01PM -, Aman Raheja wrote:
Hello
I executed a query on my server
mysql select count(*) from mytab where change 2004070100
And another
mysql select count(*) from mytab where change 2004070100
Would like to mention, the table is 240
On Tue, Jul 13, 2004 at 11:23:03AM -0400, Marc Knoop wrote:
Jeremy Zawodny writes:
The web servers record web metrics to local mysql databases. I would
like those local databases to be consolidated onto the DEPOT [as three
separate DBs].
You cannot do that.
snip
You'd need
On Tue, Jul 13, 2004 at 06:11:22PM -0700, Carl Edwards wrote:
Hello,
I found a question about Oracle 2 MySQL replication in the
archive on Sep. 2001 but no mention since?
We have a department using Oracle 8.1.7 and I'm running MySQL
4.0 and neither of us wants to change :-)
I could
On Mon, Jul 12, 2004 at 03:49:33PM -0400, Marc Knoop wrote:
I have 4 servers in my environment:
DEPOT - master server
WWW1 - web server #1
WWW2 - web server #2
WWW3 - web server #3
The web servers record web metrics to local mysql databases. I would like
those local databases
On Mon, Jul 12, 2004 at 10:14:09AM +0800, Linda wrote:
Hi Jeremy,
I didn't find any resouce limit but the performace is very bad. Do you have
any suggestion how to tune the solaris to provide the better performance for
Solaris?
Well, MySQL doesn't just randomly slow down. There's either a
On Wed, Jul 07, 2004 at 06:23:45PM +0800, Linda wrote:
Hi,
My old mysql is 3.23.56 on RedHat9(Intel). After moving mySQL to
Solaris 9 (Sun F280R/2GB Memory) and upgrading mySQL to 4.0.20, I
got a lot of complaints about the performance for select and
update. Have anyone can tell me if there
On Thu, Jul 08, 2004 at 09:23:17PM +0300, Egor Egorov wrote:
Jeremy Zawodny [EMAIL PROTECTED] wrote:
So I haven't really done much to optimize things, as this seems like a
fairly light load. I'm running 4.0.20 on FreeBSD 4.8 (port build w/Linux
Threads).
Reliability
On Wed, Jul 07, 2004 at 07:42:46PM +0200, Luis Mediero wrote:
Hi,
I would like write a script to purge every nigth the master log with a cron
process. I need do it every nigth after load a lot of data into the master.
I know if i do 'show master status' i can see the file_name of the
On Wed, Jul 07, 2004 at 07:11:17PM +0300, Egor Egorov wrote:
Jeremy Zawodny [EMAIL PROTECTED] wrote:
So I haven't really done much to optimize things, as this seems like a
fairly light load. I'm running 4.0.20 on FreeBSD 4.8 (port build w/Linux
Threads).
Reliability
On Tue, Jul 06, 2004 at 05:07:24PM +0300, Egor Egorov wrote:
Charles Sprickman [EMAIL PROTECTED] wrote:
So I haven't really done much to optimize things, as this seems like a
fairly light load. I'm running 4.0.20 on FreeBSD 4.8 (port build w/Linux
Threads).
Reliability and performance
On Tue, Jul 06, 2004 at 12:48:39PM -0400, Charles Sprickman wrote:
On Tue, 6 Jul 2004, Egor Egorov wrote:
Charles Sprickman [EMAIL PROTECTED] wrote:
So I haven't really done much to optimize things, as this seems like a
fairly light load. I'm running 4.0.20 on FreeBSD 4.8 (port build
On Tue, Jul 06, 2004 at 02:29:16PM -0400, Charles Sprickman wrote:
On Tue, 6 Jul 2004, Jeremy Zawodny wrote:
Do you have a summary of the poor performance somewhere? Or at least
a sense of where you think the bottleneck is?
The best I can tell you is that mysql + moderate qmail load
On Wed, Jul 07, 2004 at 12:05:01AM +0200, Schalk wrote:
Hey there!
Does anyone know where I can find information regarding connecting MySQL and
a Point of Sale device?
I suspect it'd depend on the device in question...
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
On Tue, Jul 06, 2004 at 03:40:02PM -0700, Ron Gilbert wrote:
I am going to upgrade my MySQL server from 3.23 to 4.1, but I have a C
program that needs to continue to connect to the new server, and it
can't be recompiled. Is the old API 100% backwards compatible with a
4.1 server? I assume
On Tue, Jul 06, 2004 at 04:26:04PM -0400, Charles Sprickman wrote:
On Tue, 6 Jul 2004, Jeremy Zawodny wrote:
On Tue, Jul 06, 2004 at 02:29:16PM -0400, Charles Sprickman wrote:
On Tue, 6 Jul 2004, Jeremy Zawodny wrote:
Do you have a summary of the poor performance somewhere
On Tue, Jul 06, 2004 at 08:05:43PM -0400, Charles Sprickman wrote:
On Tue, 6 Jul 2004, Jeremy Zawodny wrote:
procs memory pagedisks faults cpu
r b w avmfre flt re pi po fr sr da0 md0 in sy cs us sy
0 13 0 782108 61388
On Fri, Jul 02, 2004 at 10:27:04AM -0700, David Griffiths wrote:
Sorry - didn't read your email closely enough. The Windows version is
not native - runs under Cygwin. Is there a version of Cygwin for the
Itanium 2?
The Windows version of MySQL doesn't require Cygwin.
Jeremy
--
Jeremy D.
On Thu, Jul 01, 2004 at 11:34:29AM +0800, MaFai wrote:
Dear, [EMAIL PROTECTED],
We have set up 1 master and 4 slave as replication.
Sometime,the slave need 4~10 minutes to synchronize the data with master
database.
Do any way to tune the performance?
Or any other way to
On Tue, Jun 29, 2004 at 10:57:41PM -0700, Bruce Dembecki wrote:
So I have a question for those who understand developer speak and MySQL
builds and so on...
Apple announced their new OS earlier this week, including this information
on the improvements to 64 Bit version using the G5 processor:
On Wed, Jun 30, 2004 at 11:52:32PM +0200, Jocelyn Fournier wrote:
Hi,
4.1.3 is labeled beta in the bktree.
So I assume 4.1.3 will be beta when it will be released ;)
And that looks to be soon, based on the commits I've seen.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux
On Tue, Jun 29, 2004 at 08:46:35PM -0400, Alejandro Heyworth wrote:
Eric,
I'm looking for a way to eliminate the construction, transmission, and
parsing of the long multi-row INSERT queries that we are issuing from our
client app. Since we are inserting 200k rows a shot, we're looking for
On Tue, Jun 22, 2004 at 01:34:39PM -0400, Aram Mirzadeh wrote:
We have an internal SNMP monitoring system that is monitoring about
10,000 devices. Each device is pinged then pulled for about an
average of 25-30 elements. Each of the ping results and elements
are then stored in text file,
On Mon, Jun 28, 2004 at 09:21:04PM +0100, Andrew Pattison wrote:
By default MySQL flushes keys to disk with every INSERT, hence the
performance degredation with performing several single INSERTs one after the
other. The following extract from the MySQL documentation hints at one way
of
On Wed, Jun 23, 2004 at 11:36:52AM -0400, Alejandro Heyworth wrote:
Does anyone know when INDEX DESC will be implemented?
I'm storing time values and want to access the data from the most recent
time value without sorting the result set.
Why is sorting required at all? Indexes *are* sorted
On Wed, Jun 23, 2004 at 02:28:15PM -0500, gerald_clark wrote:
I suspect he is refering to 3.23's inability to use an index on a ORDER
BY xxx DESC
In other words ancient history :-)
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] |
On Mon, Jun 21, 2004 at 06:57:51PM +0200, Leonardo Francalanci wrote:
I'm doing some tests on a 16.000.000 rows table.
Doing a simple SELECT SUM(MYFIELD) FROM MYTABLE I noticed
that disks are at 0.1%, while cpu arrives up to 80%.
How is that possible? My HDs are IDE. MySql has around
30Mb of
On Mon, Jun 21, 2004 at 07:10:59PM +0200, Leonardo Francalanci wrote:
Hard to say, but in a table scan the CPU does have a lot of work to
do. It needs to do about 16,000,000 comparisons (based on your info).
Why comparison? It's a sum...
Oh. You didn't say thta. :-)
And the table is
On Mon, Jun 21, 2004 at 07:37:50PM +0200, Leonardo Francalanci wrote:
Oh. You didn't say thta. :-)
Well, I wrote
Doing a simple SELECT SUM(MYFIELD) FROM MYTABLE I noticed
but don't worry ;)
Oh. Damned Mondays. I never liked 'em. :-(
How much RAM does your machine have? If it's
On Tue, May 18, 2004 at 10:56:14PM +0200, Mark wrote:
Mihail Manolov wrote:
Release 4.0.20 is mainly a bugfix release, but there are also some
important functional changes. Release 4.0.19 was completely skipped
over because Bug #3596 might have caused segmentation faults on some
On Fri, May 14, 2004 at 01:40:37PM +1000, Chris Nolan wrote:
Jeremy Zawodny wrote:
I think that the problem is that it's *not* a 64 bit OS. It's just an
Intel 32bit box with 4GB of memory. And sine MySQL doesn't do PAE,
it'll never see that extra memory.
Didn't InnoDB gain PAE
On Fri, May 14, 2004 at 02:16:05PM +1000, Chris Nolan wrote:
Jeremy Zawodny wrote:
On Fri, May 14, 2004 at 04:38:56AM +0200, Lorderon wrote:
Will MyISAM support transactions in the future versions? Is it
possible?
It's possible, but I don't see it happening for quite a while
On Fri, May 14, 2004 at 03:10:05PM -0400, Jim wrote:
Hi List,
What are some issues relating to using OPTIMIZE TABLE and replication?
Does running OPTIMIZE TABLE on a master DB cause the optimizations to be
passed on to the slaves?
It does not. The command doesn't replicate.
--
Jeremy D.
On Fri, May 14, 2004 at 03:26:28PM -0500, Donny Simonton wrote:
Actually, if you are using 4.1.1 optimize table does get passed to the
slave. This is from the 4.1.1 change log.
ANALYZE TABLE, OPTIMIZE TABLE, REPAIR TABLE, and FLUSH statements are now
stored in the binary log and thus
On Fri, May 14, 2004 at 04:29:29PM -0500, Dan Nelson wrote:
In the last episode (May 14), Jeremy Zawodny said:
On Fri, May 14, 2004 at 03:26:28PM -0500, Donny Simonton wrote:
Actually, if you are using 4.1.1 optimize table does get passed to
the slave. This is from the 4.1.1 change log
On Thu, May 13, 2004 at 10:21:15AM +0200, JFL wrote:
The InnoDB storage engine can use raw disks without a filesystem.
Would that be the fastest possible setup?
Probably, yes.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] |
On Thu, May 13, 2004 at 10:28:26AM +0200, JFL wrote:
I need to restore 20 gigabytes of binary logfiles.
What should I do in order to get the job done as quickly as possible?
I am considering this:
mysqlbinlog --database=mydb logfiles | mysql -f
There is a faster way, but it is
On Thu, May 13, 2004 at 11:00:17AM +0200, JFL wrote:
I've been told that InnoDB on a raw partition is the fastest setup.
Actually, you've been told that it's probably the fastest.
To setup my system for this, could I create a partition called /innodb
and adjust the my.cnf like this?
On Thu, May 13, 2004 at 11:16:18AM -0400, Peter J Milanese wrote:
Does the filesystem matter as much as disk throughput? I'd imagine that
is where the bottleneck would be, at least as I've seen...
Throughput or seek time?
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine,
On Thu, May 13, 2004 at 10:16:52PM +0200, Jacob Friis Larsen wrote:
I need to restore 20 gigabytes of binary logfiles.
What should I do in order to get the job done as quickly as possible?
There is a faster way, but it is rather tricky.
4.0 slave can be tricked into thinking that
On Thu, May 13, 2004 at 04:51:27PM -0700, Dathan Vance Pattishall wrote:
-Original Message-
From: Tim Cutts [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 13, 2004 7:11 AM
To: MySQL List
Subject: Re: InnoDB filesystem
On 13 May 2004, at 3:34 pm, Dan Nelson wrote:
On Fri, May 14, 2004 at 04:38:56AM +0200, Lorderon wrote:
Will MyISAM support transactions in the future versions? Is it
possible?
It's possible, but I don't see it happening for quite a while...
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] |
On Wed, May 12, 2004 at 12:39:59PM -0500, Chris W wrote:
I thouught I read somewhere a while back that MySQL was working on an
option to create a MySQL partition so as to avoide all OS filesystem
overhead to speed things up and I think to save a small bit of over
head. Is this true?
The
On Wed, May 12, 2004 at 04:11:41PM -0400, Tucker, Gabriel wrote:
Sorry for the second post, I realized that my first post might not be clear...
I want the failover and the switch from read-only to non
read-only to be dynamic, no downtime.
You can't do that. The read-only setting cannot be
On Wed, May 12, 2004 at 01:38:04PM -0400, Shayne Paddock wrote:
In section 16.7.5 in the mysql manual it says that you can setup
replication with InnoDB tables on the master to MYISAM tables on the
slave. While I have proven this to be true, it does not warn you that
if in your Master's
On Wed, May 12, 2004 at 02:50:55PM -0700, Larry Lowry wrote:
Well I'm trying to move to MySQL from the MS SQL Server
world. Most data elements are easy except for the uniqueidentifier.
In the MySQL world what is the preferred/best way to store a
uniqueidentifier? The easiest would just be
On Tue, May 11, 2004 at 09:26:57AM +0700, Winner H Manurung wrote:
Dear All,
I was an Oracle dba, now my new company want to use Mysql 4.0.18. Does
anybody here has experience of running multiple mysqld (i.e. multiple
instance on one machine). Is it stable and totally independent to each
On Thu, May 06, 2004 at 11:29:18AM -0600, Alfredo Cole wrote:
El Jue 06 May 2004 11:05, escribió:
On Thu, May 06, 2004 at 06:55:38AM -0600, Alfredo Cole wrote:
At the time I wrote Chapter 8 of High Performance MySQL, I tried to
discuss the available options:
On Thu, May 06, 2004 at 06:55:38AM -0600, Alfredo Cole wrote:
Hi:
I would like to add an identical server to the one I already have: Double Xeon
processors, 4 Gb RAM and RAID 5 (Hardware) HD's. I would also like to cluster
them using OpenMosix, but I'm told that MySQL 4.0 will not take
On Thu, May 06, 2004 at 10:12:19AM -0700, William Wang wrote:
Hi everyone,
Please help.
I have MySQL server running on host A in US and I am
using it on host B in Europe. Every query takes about
0.3 seconds.
Now I want to do update db with 5000 updates. So I put
all the UPDATES
On Wed, May 05, 2004 at 06:44:09PM +0200, Mechain Marc wrote:
Hello,
Why such a SQL request running well on the master is not correctly replicated on the
slave,
set @providerId='012345';
insert into DATA_TYPE values (1,@providerId,'DATA_TYPE',1);
Here is an extract of the Slave
On Wed, May 05, 2004 at 03:25:14PM +0100, Nick A. Sugiero wrote:
Hi,
I recently installed MySQL on a Windows 2003 Server last night to pull some
stats from a online game I run, however everytime a query is sent to the
database it uses 100% cpu causing a 100% cpu spike for a breif second -
On Tue, May 04, 2004 at 02:44:26PM -0700, Ron Gilbert wrote:
I am wondering what the best backup strategy is for my database.
The database is used to store a very large number of binary files,
ranging from a few K to 20MB's. The database stores thousands of these
files. I can not put
On Wed, May 05, 2004 at 02:00:31PM -0300, Leonardo Javier Belén wrote:
Hi folks,
Is there a way to make mysql sgml aware or any plan to do it in the near
time?
I think the answer is no but I don't really know what that question
means. Can you elaborate?
Jeremy
--
Jeremy D. Zawodny
On Wednesday, May 5, 2004, at 11:48 US/Pacific, Atle wrote:
What versions are you seeing this on? We've seen it exclusively on
3.23.58, with or without LinuxThreads enabled.
Various versions of 4.0.xx.
We don't run 3.23.xx much of anywhere anymore.
Jeremy
--
MySQL General Mailing List
For list
On Wed, May 05, 2004 at 10:53:13AM -0400, Pete McNeil wrote:
Hello folks,
I'm usinng MySQL 4.0.17.
I have a table something like:
RuleID int,
GMTBase datetime,
Credited bigint,
...
I have an index built on GMTBase.
I have rougly 8 million rows.
GMTBase stores a datetime for the
On Wed, May 05, 2004 at 01:07:58PM -0400, Luis R. Rodriguez wrote:
Hello,
I am wondering if anyone is currently working on a two way replication
lock protocol. If so, what's the status. I understand there's little
gain in having two way replication but -- I am just curious.
What exactly
On Wed, May 05, 2004 at 03:44:00PM -0400, Luis R. Rodriguez wrote:
On Wed, May 05, 2004 at 12:01:27PM -0700, Jeremy Zawodny wrote:
On Wed, May 05, 2004 at 01:07:58PM -0400, Luis R. Rodriguez wrote:
Hello,
I am wondering if anyone is currently working on a two way replication
On Thu, May 06, 2004 at 09:55:30AM +1000, Daniel Kasak wrote:
Hi all.
My boss just pulled the power on our MySQL server.
Yes, I've already thanked him.
It's a 4.0.18 server, with MyISAM tables and InnoDB tables, running on a
2.6.5 kernel and XFS filesystem.
The XFS recovery proceeded
On Tue, May 04, 2004 at 12:36:19PM -0700, Max Clark wrote:
Can't create a new thread (errno 35). If you are not out of
available memory, you can consult the manual for a possible
OS-dependent bug
I am running FreeBSD 4.9 with Mysql 4.0.18 compiled with Linux
Threads. I am running large
On Mon, May 03, 2004 at 12:39:48PM -0500, Boyd E. Hemphill wrote:
My boss says that if you do a select statement against a table the
result set always comes back in the same order. I say that this is a
myth and that the result is random, except when some ordering is
specified in the SQL
On Mon, May 03, 2004 at 05:56:03PM +0200, Hans-Peter Grimm wrote:
Hi,
I think there is
1) a problem with FLOAT recommendations in PROCEDURE ANALYSE
2) a minor problem with CREATE TABLE(f FLOAT(negative_value,...))
I think that there is maybe:
3) a bug in PROCEDURE ANALYSE that you should
to find much else. I am under the
impression that I should be using innodb tables instead of myisam, and I
am sure there are a slew of other things that I could tune. Is there a
site/document dedicated to this? My copy of high performany mysql by
Jeremy Zawodny is in the mail, so any help
1 - 100 of 1672 matches
Mail list logo