Did you configure MySQL and run the
/usr/local/mysql/scripts/mysql_install_db to initialize your data
directory?
- Gabriel
On May 10, 2004, at 5:21 PM, Tim Jarman wrote:
I have an iBook G4 running MacOS X.3 on Darwin 7.0. I downloaded and
ran the
binary installer (mysql-standard-4.0.18.pkg
I'm not sure what's going on with our replication. Everything was
working fine, then all of a sudden it stopped. I did STOP SLAVE; RESET
SLAVE; LOAD DATA FROM MASTER and it completed after a few minutes, but
when I checked SHOW SLAVE STATUS it no longer had any information about
the master. I
Why doesn't the MySQL binary distribution include the shared libraries?
(At least, the Mac OS X version does not) I'd prefer to use this
distribution, but I have to roll my own in order to get shared libs to
use with PHP, Perl (for mytop), etc.
- Gabriel
--
MySQL General Mailing List
For list
2GB was the per-process memory limit in Mac OS X 10.2 and earlier. 10.3
increased this to 4GB per-process. I've gotten MySQL running with 3GB
of RAM on the G5 previously.
This is an excerpt from a prior email to the list from back in October
when I was first testing MySQL on the G5:
Have you run mysql_install_db? Does the mysql user have full
permissions (read, write, execute) on the mysql data directory you
created with mysql_install_db?
- Gabriel
On Dec 20, 2003, at 9:00 AM, Jon Pearse wrote:
... you can tell that this isn't going my way at all ...
I've got mysqld
There's actually a MySQL Database Appliance out there. Have you looked
at that yet?
http://pogolinux.com/mysql/index.html
You could run MySQL on any number of different machines. Intel, Athlon,
PowerPC, etc. Linux, FreeBSD, Windows, Mac OS X.
- Gabriel
On Dec 7, 2003, at 4:41 PM, Defryn, Guy
On Dec 2, 2003, at 3:48 PM, Ari Davidow wrote:
We have just put up a new MySQL 3.23.x on a modest Sun V120 with 1GB
RAM and a few gig of hard disk space. We're running Solaris 2.8.
Why are you using an old version of MySQL? MySQL4.0 is the recommend
production version currently.
We seem to be
Here are benchmarks for an optimized build of MySQL 4.0.16: (used
-mpowerpc-gpopt and -mpowerpc64 gcc arguments)
alter-table: Total time: 18 wallclock secs ( 0.03 usr 0.06 sys + 0.00
cusr 0.00 csys = 0.09 CPU)
ATIS: Total time: 19 wallclock secs ( 8.65 usr 8.40 sys + 0.00 cusr
0.00 csys
I've got two database servers in production, one of which is a master
for a handful of tables and the other is a slave for these few tables.
I want to add an additional slave server without taking down the master
to create a snapshot. Is it possible to just setup the replication for
the slave
In order to make sure of a multi-column index, you have to order the
WHERE clauses in the same order as the columns in the index. Since you
query Realm first, then AcctStartTime, then AcctStopTime, MySQL would
use an index on those columns in that order. You can either add a
differently
InnoDB as well, or if you use InnoDB tables only, then
you should give innodb_buffer_pool_size a good portion of your RAM, and
perhaps 16-32MB or so for innodb_additional_mem_pool_size.
- Gabriel
On Friday, November 7, 2003, at 06:32 PM, Jan Pieter Kunst wrote:
At 13:21 -0500 07-11-2003, Gabriel
On Friday, November 7, 2003, at 09:05 AM, David Steinbrunner wrote:
The Mac was HFS+ journaled. Disk: the stock Apple-supplied one. The
Linux machine was a default SuSE 8.0 installation. ext2 as the
filesystem? No idea about journaling. No SCSI or RAID, just an
internal IDE disk. Both machines
On Friday, November 7, 2003, at 03:06 AM, Jan Pieter Kunst wrote:
Hardware: 1.8 GHz G5 with 1GB RAM
Panther (Mac OS X 10.3) doesn't have the sudden slowness in the
'insert' test that Jaguar (Mac OS X 10.2) has. Total time for Panther
is faster than total time for Jaguar (5561.00 secs vs.
We've been using PHP 4.3.x and MySQL 4.0.x for a few months now on our
production systems and had encountered only one problem unrelated to
PHP (an issue where LOAD DATA FROM MASTER would wipe out all of the
tables in the database, even if it was just using wildcard replication
for a few
On Friday, November 7, 2003, at 01:21 PM, Hugh Beaumont wrote:
Hi List,
I've searched the archives and the web many times in the past for
answers to the following
questions but never really got a complete understanding of what is
going on. Hopefully someone on
the list will be able to take
On Thursday, November 6, 2003, at 11:38 AM, Jan Pieter Kunst wrote:
I'd be curious what kind of numbers Panther shows. Once I get my
xServe setup, just arrived, I'll try running some tests myself.
I just installed Panther on my G5 at home. Unfortunately, for some
reason I can't get the Perl
No, files can be bigger than 2GB. In OSX prior to Panther there is a
2GB per-process memory limit though. Then again, on anything other than
the PowerMac G5 this doesn't matter because the G5 is the only Mac that
can hold more than 2GB of RAM.
- Gabriel
On Tuesday, November 4, 2003, at 04:42
If you are referring to the dbx database abstraction layer extension
for PHP, it is literally just a C-level wrapper for the database
extensions it supports. If PHP's MySQL extension supports
asynchronous table updates, then dbx will. What exactly are these
asynchronous table updates anyways?
I'm not entirely sure what to do about the slow insert results, they
are the slowest part no matter how you configure it, it seems. I've
attached some benchmark results I ran on a dual 2GHz G5 for comparison.
Both MyISAM and InnoDB.
Here are the insert results though:
MyISAM:
insert: Total
FYI, I've found 'iostat' to be quite useful in monitoring the drive
transfer rates while benchmarking in OSX. Then again, in Panther all
you really need to do is pop open Activity Monitor (formerly Process
Viewer) which now has some nifty graphing for system status: cpu, disk,
ram activity and
Are you using Panther client or server? my.cnf is usually in /etc. Have
you run mysql_install_db yet?
- Gabriel
On Wednesday, November 5, 2003, at 05:57 PM, Nestor Florez wrote:
Hi guys,
I just was given the OK to play with a new server running
Mac OS X (Panther)
When I give the command (it
Any package that is installed in OSX leaves a receipt behind. Look in
/Library/Receipts/. Each package leaves a directory in there. In each
package's directory is a .bom file. Usually it's something like
/Library/Receipts/PackageName.pkg/Contents/Archive.bom or
On Tuesday, November 4, 2003, at 11:25 AM, Harald Fuchs wrote:
In article [EMAIL PROTECTED],
Mark Lubratt [EMAIL PROTECTED] writes:
I'm considering using the raw tablespace from InnoDB for a project I'm
working on. I noticed a couple of years ago that there were reports
of tablespace corruption
On Tuesday, November 4, 2003, at 07:58 AM, Leo Huang wrote:
In InnoDB documentation, it suggests to add another file ibdata2 to
get higher performance. Can I do that now, after I have created the
ibdata1 and used it for a while?
How exactly does this increase performance? Will InnoDB store some
Interestingly enough, when I configure 4.0.16 like this it builds ok:
./configure --prefix=/usr/local --sysconfdir=/ --enable-shared
--with-server-suffix=-imax-G5 --with-mysqld-user=mysql --with-comment
--with-query-cache --without-docs --with-innodb
--enable-thread-safe-client --with-bench
On Thursday, October 30, 2003, at 08:19 AM, Leonardo Rodrigues wrote:
My question are: are these commands similar to VACUUM? What´s the
difference? How can I run on InnoDB?
I don't know much about PostgreSQL, so I'm not sure. If you describe
what VACUUM does, I may be able to help explain how
source='sort.c' object='sort.o' libtool=no \
depfile='.deps/sort.Po' tmpdepfile='.deps/sort.TPo' \
depmode=gcc3 /bin/sh ../depcomp \
gcc -DHAVE_CONFIG_H -I. -I. -I.. -I./../include -I../include -O3
-DDBUG_OFF -c `test -f sort.c || echo './'`sort.c
/bin/sh ../libtool --mode=link gcc -O3
On Monday, October 27, 2003, at 07:45 AM, Chris Nolan wrote:
2. I personally use ReiserFS for all of my stuff, most of which is
based upon InnoDB. One thing you have to remember is that InnoDB
treats the space inside the tablespace as a Berkeley Fast
Filesystem-style space, using the
FYI, PHP will automatically convert the data type to an integer if to
use increment it like that. Just like if you had $var = 123; and then
did $var .= foo it would be converted into the string 123foo. If
you're still unable to change the value of $myrow, then I would consult
the PHP mailing
I thought I read a message on this list that said you can't use full
text indexes with InnoDB yet. Can anyone confirm that?
- Gabriel
On Thursday, October 23, 2003, at 11:50 AM, Travis Reeder wrote:
I'm sure this has been asked before, but after seeing some benchmarks,
it looks like using
On Tuesday, October 21, 2003, at 12:48 PM, Rainer Sip wrote:
I'm running a community site (Xoops) on Mysql 4.0.14.
I found that the speed of my site is slow during peak hours, when
there are 450 concurrent uers hanging on the site. Mytop showed that
the queries per second maxed at 500. I
Someone recently asked about Gemini tables on this list and it got me
curious about what ever happened to that technology... NuSphere still
seems to exist, and they still sell their PHPEd product along with the
NuSphere Technology Platform which appears to contain a build of
MySQL. Did they
Well, even if you don't find an alternative for that syntax, you could
always do the date subtraction in application space and make the query
like this:
SELECT * FROM myTable WHERE date_field = '2003-10-12'
- Gabriel
On Tuesday, October 21, 2003, at 05:49 PM, DevList wrote:
Does anybody
FYI, as I stated in a previous email, INSERT . ON DUPLICATE KEY
UPDATE is only available in MySQL 4.1+, which is still in
development and not recommended for production use.
- Gabriel
On Friday, October 17, 2003, at 04:04 AM, Director General: NEFACOMP
wrote:
The REPLACE
Agreed. Most emails are sent to the list in plain text format, which
does not include and font or style information. You could do that with
HTML formatted emails, but I imagine a large number of people would
dislike reading HTML email if their mail client cannot render it.
- Gabriel
On
I think the closest you can get is something like this:
SELECT YEAR(TheDate) AS Year,MONTH(TheDate) AS
Month,CustomerName,CustomerID,SUM(Revenue*Quantity) AS Revenue
FROM rev
GROUP BY Year, Month
ORDER BY Year,Month,CustomerID
A table with this data:
Or you could just do one simply query as I explained previously,
retrieve the data in PHP, and group it by date rather than spending the
same time in PHP generating a massive, inefficient query (and if you
have a large number of customers, you won't generate a query larger
than the maximum
will be a simple multi-dimensional array with a
minimal SQL
query and minimal application code.
Jeff
-Original Message-
From: Gabriel Ricard [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 1:47 PM
To: Jeff McKeon; [EMAIL PROTECTED]
Subject: Re: Challenging query
Or you could just do one
.
Jeff
-Original Message-
From: Gabriel Ricard [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 2:11 PM
To: Jeff McKeon
Cc: [EMAIL PROTECTED]
Subject: Re: Challenging query
On Thursday, October 16, 2003, at 02:04 PM, Jeff McKeon wrote:
Do this query:
SELECT YEAR(TheDate
On Thursday, October 16, 2003, at 01:36 PM, Jeremy Zawodny wrote:
On Wed, Oct 15, 2003 at 06:35:03PM -0400, Gabriel Ricard wrote:
On Wednesday, October 15, 2003, at 03:10 PM, Jeremy Zawodny wrote:
I'd be interested to know if you can get a test running that uses
either a key_buffer
I am currently testing this on a new dual 2GHz G5 with 4GB of RAM.
Seems pretty nice so far. I've loaded up a copy of our production
database (4GB of data for real estate web sites) and moderate property
search queries of ours run much faster than on our dual G4 MDD
PowerMac. I guess we're
wrote:
Wow, new dual processor G5... behaviordrool/behavior
How are the bulk operations performing?
-Original Message-
From: Gabriel Ricard [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 15, 2003 11:05 AM
To: [EMAIL PROTECTED]
Subject: Re: Anyone using MySQL 4.x on Apple's G5?
I am
You can do it exactly like that, or you could use the IN() syntax if
you have a large number of values to check.
SELECT * FROM list WHERE name IN('$this1', '$this2', '$this3')
- Gabriel
On Wednesday, October 15, 2003, at 04:16 PM, Mike At Spy wrote:
How could I write a statement that uses
On Wednesday, October 15, 2003, at 03:10 PM, Jeremy Zawodny wrote:
I'd be interested to know if you can get a test running that uses
either a key_buffer or an innodb_buffer_pool in the 3.5GB range.
Interestingly enough, I can't seem to get MySQL to use more than 2GB of
RAM.
I get errors like
I've just finished reading through most of the MySQL Enterprise
Solutions book by Alexander Pachev and I think you might want to take
a look at it. There is a section that deals with testing and MySQL
benchmarking tools.
These tools are available in the mysql/sql-bench (if your MySQL was
So, we just got this handy dandy new G5 with 4GB of RAM and I'm trying
to get it to store as much of our 4.3GB database in RAM as possible.
I've tuned most of the usual parameters (query cache, tmp table size,
sort buffer, key buffer, record buffer, table cache, myisam sort
buffer, etc.) but
Is there any way to see what MySQL is storing in memory? Like, for
instance, what is stored in the query cache, or at least what tables
have data stored in the query cache, and how much they have stored?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
the replicated tables?
Gabriel Ricard
iMaxSales.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Gabriel Ricard
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED
Core MySQL
ISBN: 0130661902
http://shop.barnesandnoble.com/booksearch/isbnInquiry.asp?isbn=0130661902
[EMAIL PROTECTED] wrote:
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 25 March 2002 07:59
To: Sean O'Donnell
Subject: Re: InnoDB books
Your message
of 3.23.50 or .49a, whichever is more stable, on
OS X soon. So if there isn't one available then I guess I'll build it
myself. Are there any known issues with building these versions on Mac OS X?
Thanks,
Gabriel Ricard
-
Before
We've been using MySQL 3.23 in OSX on our production servers for about 6
months now. The system was in development for over a year prior to that.
We have a legacy application in RealBASIC (it's not my fault!) that uses
ODBC to issue numerous REPLACE queries to the database on an hourly
basis
Since when?
Even if Oracle was free, it would still take a bit of convincing for me
to want to switch from MySQL. Unless of course they decided to port to
OSX and release that for free, oh and while they're at it, cut out all
the Java garbage that has no business residing in a database.
As long as you've got a fat pipe on both ends speed could be ok. But,
then again, you never know. Some backhoe in Nebraska could cut your sweb
server off from your database.
Of course you'll want it to be secure as well. MySQL 4 has support for
SSL. I suppose you could setup an ssh port
to 3.23.49(a?), or if I should just download
the source and build it myself?
Thanks,
Gabriel Ricard
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
enough, using LIMIT 1 in the query did speed it up,
so it only took 0.01 seconds, however, using EXPLAIN with that query
showed that it wasn't using the index at all. That really confuses me...
- Gabriel Ricard
_
Do You Yahoo!?
Get
? Is it
perhaps because of where the records are situated on the hard disk (seek
times)? Is it maybe a caching issue?
Thanks for any help.
- Gabriel Ricard
-
Before posting, please check:
http://www.mysql.com/manual.php
key_buffer is 384M, table1.MYI is 17.5MB.
Jeremy Zawodny wrote:
On Mon, Mar 18, 2002 at 11:39:09AM -0500, Gabriel Ricard wrote:
Greetings,
We're running MySQL 3.23.47 on MacOS X 10.1.2. We've got a rather large
table ( 200,000+ records, 120+ columns) and some simple queries on that
table have
I'd highly recommend just downloading the binary distribution from
mysql.com. Works great for me.
Jim Weber wrote:
Friends,
I am trying to install MySQL on a Powerbook G$ running Mac OS 10.1.3
and am having problems. I've followed your instructions and installed
Fink but when I go to
59 matches
Mail list logo
