Benchmark differences: Mac OS X - Linux

e, the Mac is more than twice as slow. Below are the benchmark results for both machines, and the my.cnf I used. I was wondering if there is something I can do, configuration-wise, to do something about those very slow 'inserts' (and 'updates') on the Mac? Thanks in advance for

Re: Benchmark differences: Mac OS X - Linux

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 module DBD::mysql to install (using CPAN, had no problems doing this in

Re: Mysql on panther

[MySQL won't start] Maybe this knowledge base article is useful: JP -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Benchmark differences: Mac OS X - Linux

Jeremy D. Zawodny: > I was wondering if there is something I can do, configuration-wise, to do something about those very slow 'inserts' (and 'updates') on the Mac? Thanks in advance for any insight, Did it appear to be disk or CPU bound? Sorry, newbie here. I don't know how I can tell. The RU

Re: Benchmark differences: Mac OS X - Linux

I just installed Panther on my G5 at home. Unfortunately, for some reason I can't get the Perl module DBD::mysql to install (using CPAN, had no problems doing this in Jaguar) so I can't run the benchmark suite for now. JP I had similar issues, but I was also using a custom build of MySQL, wh

MySQL benchmarks on the G5: Jaguar vs. Panther

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. 6770.00 secs). 'Insert' is faster on Panther than on Jaguar (3316 secs v

Re: MySQL benchmarks on the G5: Jaguar vs. Panther

I was wondering if you had journaling turned on in Panther and not in Jaguar? I'm not sure if it would have any effect on selects, I would think it would slow down inserts not selects. You notice the CPU breakdown is different. Journaling was turned on in both cases. JP -- MySQL General Mailin

Re: MySQL benchmarks on the G5: Jaguar vs. Panther

t-variable = write_buffer=2M If you have any advice on what I could change here to get faster selects, I'm all ears. Thanks in advance, Jan Pieter Kunst -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: phpmysql(which array function?)

Trying to solve a phpmysql array problem. Let's say I have a table in mysql format Column1 Column2 dog brown cat white cat black cat mixed pig black pig brown What kind of (query, array function, loop, etc...) should I use to produce an html output

Re: regexp with - '-' or "-" like phone numbers e.g: d-dd-d dd-dd-d ddd-dd-d dddd-dd-d

because '-' is understood as "from" - "to" e.g a-z, 0-9, etc., Escape the '-' with a backslash: '\-' JP -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL benchmarks on the G5: Jaguar vs. Panther

If you're using only MyISAM tables for your data, then key_buffer should generally have as much RAM as it can have (up to the point where it makes sense, i.e., only has much RAM as is needed to store your index data). myisam_sort_buffer_size ought to be about 1/4 of your RAM. I re-ran the bench

Re: Database Dump

At 14:13 +0200 15-11-2003, Davut Topcan wrote: > I have just started working on MYSQL. Can ne one help on How to take a database Backup? Backup; shell # mysqldump table > table.sql I use a command-line PHP script (-rwx--, owned by root, executed with a cron job) to backup MySQL databases.

Which one of these two queries would be fastest?

Assuming everything is properly indexed. (1) INSERT INTO my_table_1 (field1, field2) SELECT DISTINCT field1, field2 FROM my_table_2; or (2) INSERT IGNORE INTO my_table_1 (field1, field2) SELECT field1, field2 FROM my_table_2; Is there anything to say about this in a general sense, or does it al

Which one of these two queries would be fastest?

Assuming everything is properly indexed. (1) INSERT INTO my_table_1 (field1, field2) SELECT DISTINCT field1, field2 FROM my_table_2; or (2) INSERT IGNORE INTO my_table_1 (field1, field2) SELECT field1, field2 FROM my_table_2; Is there anything to say about this in a general sense, or does it al

Too many connections

to do in the MySQL layer of the server to mitigate this problem? I was thinking of a setting like 'database xxx can have only n percent of the maximum number of connections at any given time', but such a setting doesn't seem to exist. Any ideas? Thanks, Jan Pieter Kunst -- MySQL

Optimizing server variables for unindexed queries

ne in that case? I can think of these: sort_buffer, tmp_table_size, perhaps read_rnd_buffer_size? Do these make sense? Any other ideas? Thanks, Jan Pieter Kunst -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Optimizing server variables for unindexed queries

LIKE '%...%', most of them also having an ORDER BY. Both MyISAM and InnoDB tables. What would be the best server variables to tune in that case? I can think of these: sort_buffer, tmp_table_size, perhaps read_rnd_buffer_size? Do these make sense? Any other ideas? Thanks, Jan Pieter Kunst -- MySQL

Re: OS X and MySQL table corruption...

Hello, We have been running MySQL (about 50 databases, some medium-sized, some small, mix of MyISAM and InnoDB) on Mac OS X Client for more than a year (currently 10.3.8 with MySQL 4.1.10) and I have never seen any corrupt tables. We use only the MySQL-provided packages for our binaries. Maybe th

4.1.11 and 5.0.3 on Mac OS X 10.3

Greetings, Is there a problem with MySQL 4.1.11 and 5.0.3 on Mac OS X 10.3? The 10.3 versions on the download pages are still at 4.1.10a and 5.0.2. Thanks, Jan Pieter Kunst -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

mysqld_multi at startup on Mac OS X not working

vious 'normal shutdown'. Any ideas? I would think that there should be no difference between executing mysqld_multi from a root shell and executing it at startup time, but apparently it's not the same. Thanks in advance, Jan Pieter Kunst -- MySQL General Mailing List For list a

Re: How to call mysql_insert_id

On Apr 11, 2005 10:50 PM, Siegfried Heintze <[EMAIL PROTECTED]> wrote: > * In MySQL - mysql_insert_id() > > How do I call this function? I was hoping I could use SQL such as "SELECT > mysql_insert_id() FROM XYZ" but I discovered that does not work. I'm using a > mixture of java and perl. I

Re: How to call mysql_insert_id

On Apr 12, 2005 1:37 AM, Siegfried Heintze <[EMAIL PROTECTED]> wrote: > Thanks, JP. > And will this work for multi-threaded, multi-user applications? > Siegfried Yes: "The last ID that was generated is maintained in the server on a per-connection basis. This means the value the function returns t

bulk_insert_buffer_size

ariable previously > was named myisam_bulk_insert_tree_size. I take this to mean that bulk_insert_buffer_size has no bearing on InnoDB tables, only on MyISAM tables. Is this correct? Thanks in advance, Jan Pieter Kunst -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub

bulk_insert_buffer_size and InnoDB

ariable previously > was named myisam_bulk_insert_tree_size. I take this to mean that bulk_insert_buffer_size has no bearing on InnoDB tables, only on MyISAM tables. Is this correct? Thanks in advance, Jan Pieter Kunst -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub

Re: MySQL 4.1.12 has been released

2005/5/16, Matt Wagner <[EMAIL PROTECTED]>: > Hi, > > A new version of MySQL Community Edition 4.1.12 Open Source database > management system has been released. It is now available in source and > binary form for a number of platforms from our download pages at > http://dev.mysql.com/downloads/ a

Re: Convert subquery

2005/5/17, Kristen G. Thorson <[EMAIL PROTECTED]>: > I am moving some code that was developed against MySQL 4.1 to a server > with 3.23, and I have one query that uses a subquery. I'm having a bear > of a time wrapping my mind around how to convert this. The original > query is this: > > SELECT

Re: Convert subquery

2005/5/17, Kristen G. Thorson <[EMAIL PROTECTED]>: > I actually had something similar to this at one point, but I never got it > working. Your query returned 148 rows, which I can tell you right away > can't be right since there are only 130 items in `page`. I believe the > problem is that it do

Re: OS X binary

2005/5/22, Dan <[EMAIL PROTECTED]>: > I just installed the 5.0.4 binary for OS X. > Where's the client? Most likely in /usr/local/mysql/bin/. Just add that to your $PATH. JP -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[E

Problem connecting to MySQL 4.0.23 with MySQL Administrator 1.0.21 (Mac OS X)

93) I can connect with MySQL administrator 1.0.9 beta. I'm guessing the administrator 1.0.21 is explicitly asking for a 4.1 specific server variable and the 4.0 server doesn't understand it. Is there any way around this, or is there a fix planned? Thanks in advance Jan Pieter Kunst -- M

Re: Change on LEFT JOIN ON syntax in 5.x?

On 2/20/06, Eric Persson <[EMAIL PROTECTED]> wrote: > Hi, > > I have a query which works fine for me in my 4.1 environment, but when > moved to the 5.0.18 environment, it fails with the result below: > > mysql> SELECT r.uid, u.username, u.image_type, count(id) AS antal, > s.timestamp FROM recruits_

Tuning server variables

roughly the same, to set innodb_buffer_pool_size larger than key_buffer_size. 2) Assume that there are many "LIKE '%...%'" queries being performed on the server. Variables to (carefully) tune in this case would be read_buffer_size and read_rnd_buffer_size. Does this make sense? Than

MySQL 5.0.19 on Mac OS X 10.4 PowerPC

Greetings, Are there going to be binaries of MySQL 5.0.19 for Mac OS 10.4 PowerPC? That particular platform (mine) is still at 5.0.18 on the download page. Thanks, Jan Pieter Kunst -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: How to move the MySQL data directory?

On 5/2/06, Yves Goergen <[EMAIL PROTECTED]> wrote: But upgrading MySQL like installing it after MySQL's guide brings a problem: I'd need to move the data directory to the new programme directory every time. That is what I do. I find it easier than moving the data directory to a non-standard lo

Re: FULLTEXT search result requirement

2005/8/11, Eric Jensen <[EMAIL PROTECTED]>: > I am looking into using the FULLTEXT search features for our FAQ > system. Problem is the 50% limitation. We aren't going to have > thousands of questions or articles, so the odds of most of the > questions/articles matching is high and a desireable e

Re: config diff: query time went from 70 mins to 20 seconds

On 10/1/05, David Sparks <[EMAIL PROTECTED]> wrote: > Here is a config diff that made mysql usable again. As the database > grew in size, buffer sizes in the config were increased to try to boost > mysql performance. > > Unfortunately it didn't work as expected. As the config was tweaked, > mysql

Re: PHP4 or PHP5?

On 12/12/05, Peter M. Groen <[EMAIL PROTECTED]> wrote: > Ehm.. To be blunt... 40 TABLES??? You call that small? What on earth are you > going to store. I don't see why 40 tables is such a big deal? Normalizing data usually results in more (but smaller) tables and crosstables. If you are working w

Mac OS X PowerPC 64 bit

Dear mysql-ers, It seems that the Mac OS X PowerPC 64 bit version of the MySQL Community server is no longer available. Now I'm wondering which version I should use on a G5 PowerMac. PowerPC 32 bit or Universal? Thanks for any insights. Jan Pieter Kunst -- MySQL General Mailing List For

Fwd: Killing resource hogs - automatically

2008/1/23, Martijn van den Burg <[EMAIL PROTECTED]>: > Hi, > > My DEV server is used by many people creating apps throughout the > company. Consequently, I have no insight in the efficiency or quality of > their SQL. This is an accepted state of affairs. > > However, 'developers' have repeatedly ma

Re: Killing resource hogs - automatically

the host (Linux) > level? > > > Martijn > > > -----Original Message- > > From: Jan Pieter Kunst [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, January 23, 2008 14:09 PM > > To: Martijn van den Burg > > Subject: Re: Killing resource hogs - automatical

Re: Become mysql user

On 8/21/06, Chris White <[EMAIL PROTECTED]> wrote: On Monday 21 August 2006 08:40 am, Karl Larsen wrote: > I think I need to su - mysql and it askes for a password. What is > that password? If you're root you don't need to enter a password. If you can't become root then the system admin has

Re: A join I can not figure out

On 10/8/06, Critters <[EMAIL PROTECTED]> wrote: Hi, I am certain this is possible with a single query, but I have had not joy looking on google or using trial and error in MySQL... Table1: id, name Table2: id,member1,member2 In "Table2" the member1 and member2 are the ID's from "Table1" Table1

Re: How to pronounce MyISAM and InnoDB

2007/1/7, js <[EMAIL PROTECTED]>: Hi list, Sorry for this silly question but I've been always had trouble pronouncing "MyISAM" and InnoDB. How do you pronunce them? Thanks in advance. When I'm speaking Dutch (which is most of the time) I say My-ee-sahm Inno-day-bay JP -- MySQL General Mail

implementation of SELECT ... ORDER BY RAND() LIMIT 1

2007/2/7, Jos Elkink <[EMAIL PROTECTED]>: Hi all, I have a question about the combination of RAND and LIMIT 1. If I have a query like: SELECT ... ORDER BY RAND() LIMIT 1 with the ... replaced with a normal query on one table. How is this implemented? Is this optimized for the fact that it onl

5.0.37 for Mac OS X 10.4 64 bit

Dear MySQL'ers, Any chance that MySQL for OS X 10.4 64 bit will be updated to 5.0.37? It's still at 5.0.27. Thanks, Jan Pieter Kunst -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]