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 bi
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.
We
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 di
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
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
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 http://cpan.yahoo.com/authors/id/J/JZ/JZAWODNY/DBIx-D
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 authors/id/J/JZ/JZ
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 tw
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 m
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 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
> Bui
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 Linu
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 re
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 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 the
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 degradat
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. MyS
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 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
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
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 go
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 ba
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 pro
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 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
> >copie
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?
Bas
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,
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 t
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 unt
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
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 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.
Jerem
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?
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 i
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 alr
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 D
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.
O
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
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
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
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 eithe
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 d
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
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
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
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 t
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
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
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 ass
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 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 tha
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.
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
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
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 proces
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
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 Mag
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
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 chan
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 fil
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]> | http://j
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* sor
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?
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
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
> 30
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 s
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 sla
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 re
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.
--
Jerem
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?
> >>
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&
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]> | ht
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 Nelso
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 thin
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, Y
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?
>
> i
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 wa
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]> | http://jere
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
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 co
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 cann
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?
Th
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:
> >
> > http://www.o
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 "UPDA
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 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 pr
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 wonderin
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 exa
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 da
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 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 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
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 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 Sla
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 la
hreads I haven't been able 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
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(,...))
I think that there is maybe:
3) a bug in PROCEDURE ANALYSE that you should report i
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
1 - 100 of 1762 matches
Mail list logo
