Re: Recommendations on new hardware

Yes... OS X 10.4 with a 32 but MySQL binary is stable... it is the combination of 64 bit OS (Tiger), and the 64 bit MySQL binary, and accessing more than 2Gbytes of memory within the mysqld process that blows up the machine. You can also run the 64 bit binary but keep the memory allocation

Re: Questions about last_insert_id() instead of @@IDENTITY

http://dev.mysql.com/doc/mysql/en/insert-select.html There are 2 forms of INSERT INTO statement 1. INSERT INTO tbl_name (...) VALUES(...); 2. INSERT INTO tbl_name (...) SELECT ...; there's no : INSERT INTO tbl_name (...) VALUES(...) SELECT ...; its either ... or in MySQL i.e. aither provide values

Re: Recommendations on new hardware

And one other thing... our smallest load database server was a pair of G4 XServes, running about 300 queries per second, taking 5%CPU on the top display (which on OS X is 5% of one CPU) We ran the same load on a pair of Sun V440 Quad processor with 16Gbytes of memory and it used 30 - 50

Re: Recommendations on new hardware

on 9/7/05 8:42 PM, Bruce Dembecki at [EMAIL PROTECTED] wrote: > Yeah, 64 bit isn't working... we can set the memory partition for > InnoDB to some big number, like say 10G or more (on the 16G Xserves), > and it will launch, so it has 64 bit OS and 64 bit MySQL Binaries... > We get past the first h

Re: Recommendations on new hardware

Yeah, 64 bit isn't working... we can set the memory partition for InnoDB to some big number, like say 10G or more (on the 16G Xserves), and it will launch, so it has 64 bit OS and 64 bit MySQL Binaries... We get past the first hurdle, but in practise it just doesn't run... It works fine unt

Re: Recommendations on new hardware

For hardware we are just assembling generic Athlon 64 boxes. I just put together two Dual core A64 4400+ boxes as web servers, running them as a two node cluster. My new DB box is a Dual core 4400+ with 4gigs of memory and 10k sata drives. I know some folks have had trouble with the 10k drive

Re: Recommendations on new hardware

Scott Haneda wrote: Hello, currently I run mysql 3.x on Mac OS X 10.3. I have about as much ram in the machine as I can, and have tunes it the best I can, however, I still see the performance drop pretty badly at times. After reading this: I s

Total newb at performance tuning mysql

Unless I am totally off base here, the mysql docs tell very little in regards to how to performance tune mysql. So far I have found this article to help: But it still leaves me with a ton of questions. For starters, and d

Re: Recommendations on new hardware

on 9/7/05 2:40 PM, Bruce Dembecki at [EMAIL PROTECTED] wrote: > We're happy with our Mac based MySQL servers in many respects. We've > got some 64 bit issues that are causing a little grief, so we're > looking at our options... Obviously working with Apple and MySQL to > determine the real reason

Re: Recommendations on new hardware

on 9/7/05 11:11 AM, Chris Martin at [EMAIL PROTECTED] wrote: > I'd definitely try those first before forking out 2 grand. Its not that I really have a choice, I do not have a spare mac around, so I need new hardware no matter what. To move OS's on a live mysql server and then get the new one up,

Re: Locking Methods

In the last episode (Sep 07), Rich said: > I started a different thread on this, but then I realized I might not > have to use InnoDB for this. > > Let me explain what I wish to achieve. > > I want to create records in an established table. I then want them > locked (either by locking the whole

Re: Recommendations on new hardware

On Sep 6, 2005, at 11:09 PM, Scott Haneda wrote: After reading this: I suspect OS X is just not going to cut it. So while I think it is beneficial to be open to new things at all times, there are as always two sides to any story. The Ana

RE: Questions about last_insert_id() instead of @@IDENTITY

> it might be best to ask this in the cf forums, however did > you try to separate the statements with a ; ? I haven't tried > 2 query statements for MySQL in cfquery...yet ;-) Also I > believe MySQL 3.23+ supports @@identity Yes I've tried semicolons after the statements, and I've tried setting a

Re: Questions about last_insert_id() instead of @@IDENTITY

On 9/7/2005 1:17 PM Ryan Stille intelligently wrote: > I am migrating from MS SQL Server to MySQL 4.1. > > I have code in my ColdFusion/SQL Server application that went something > like this: > > SET NOCOUNT ON > INSERT INTO TABLE () > SELECT @@IDENTITY AS adid > SET NOCOUNT OFF > > > That

Locking Methods

Hi there. I started a different thread on this, but then I realized I might not have to use InnoDB for this. Let me explain what I wish to achieve. I want to create records in an established table. I then want them locked (either by locking the whole table or by individual record) so that they

Questions about last_insert_id() instead of @@IDENTITY

I am migrating from MS SQL Server to MySQL 4.1. I have code in my ColdFusion/SQL Server application that went something like this: SET NOCOUNT ON INSERT INTO TABLE () SELECT @@IDENTITY AS adid SET NOCOUNT OFF That whole block was processed in coldfusion as a single query. I gave it a name

Re: Getting Record Count w/o doing 2 queries [sorry, left out one major piece of info]

Then eliminate the subquery and SQL_CALC_FOUND_ROWS will be an option for you again. If you would like some help refactoring your query, I volunteer. If I can't help, I know there are several others on the list just as capable as I (or more so). Shawn Green Database Administrator Unimin Corpora

Re: Getting Record Count w/o doing 2 queries [sorry, left out one major piece of info]

Very sorry for having troubled all regarding the seemingly stupid rtfm garnering request for help. But in my attempt to make the question as simple and succinct as possible, i forgot to state one EXTREMELY important chunk of information. I can't use SQLCALCFOUNDROWS because there is a subqry

Re: Recommendations on new hardware

On 9/7/05, Brent Baisley <[EMAIL PROTECTED]> wrote: > As you've probably read in the article, the hardware isn't too bad, > it's OS X that is slowing things down. Interesting article. Helped me make my decision between OS X, and Debian on our xServes. It appears bypassing the gui, and running a st

Re: Recommendations on new hardware

On Wed, 2005-09-07 at 08:30 -0600, Cory Robin wrote: > Brent Baisley wrote: > > > If you do go the new hardware route, I wouldn't go with SCSI is you > > only have $2K to spend. S-ATA2 based drives would give you similar > > performance to SCSI, but at a big cost savings. SCSI's big > > perf

Re: trouble understanding why query is not using the index.

Am I correct in the statment second query is faster? This query gets executed several million times. mysql> explain select A.* from files as A where A.pathref=129286 and version=(select max(version) from files as B where A.pathref=B.pathref); +++---+--+

Re: How concerned should I be about Collation?

Thank you guys so much !!! I found the answer to all my problems regarding charsets with MySQL dumps. Here are the code lines: CREATE TABLE `foo` ( `id` bigint(20) unsigned NOT NULL auto_increment, `foo` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARS

Re: Getting Record Count w/o doing 2 queries.

RTFM - It is online, it has an index, and it is searchable: http://dev.mysql.com/doc/mysql/en/select.html (hint: look for the phrase "how many rows" on this page) If you looked in the index for "rows", you would find the function ROW_COUNT() (which is close but not exactly what you wanted). How

Re: Getting Record Count w/o doing 2 queries.

Hello. You want to check out the FOUND_ROWS() function: http://dev.mysql.com/doc/mysql/en/information-functions.html BTW, similar question was asked recently. pow <[EMAIL PROTECTED]> wrote: > Hi everyone, Im executing the following query: > > SELECT * > FROM > table1 > WHERE >

MySQL Migration 1.14 rc not closing mdb

Is it normal for MySQL migration 1.14 rc to leave MS Access open when it is done with migration (leaving ldb file)? Scott -- Please avoid sending me Word or PowerPoint attachments. See http://www.gnu.org/philosophy/no-word-attachments.html

Re: Recommendations on new hardware

Brent Baisley wrote: If you do go the new hardware route, I wouldn't go with SCSI is you only have $2K to spend. S-ATA2 based drives would give you similar performance to SCSI, but at a big cost savings. SCSI's big performance advantage was in command queueing which SATA2 drives now have.

Re: Recommendations on new hardware

As you've probably read in the article, the hardware isn't too bad, it's OS X that is slowing things down. I would first go the free route. Download YellowDog Linux and install that on your current Mac hardware. That will give you a big boost when the load starts to climb. I've installed Ye

Re: Getting Record Count w/o doing 2 queries.

Just add SQL_CALC_FOUND_ROWS to your select statement: SELECT SQL_CALC_FOUND_ROWS COUNT(*)...; The you can execute a "special" query to figure out how many rows would have been returned without the LIMIT clause. SELECT FOUND_ROWS(); On Sep 7, 2005, at 6:15 AM, pow wrote: Hi everyone, Im exe

Re: Getting Record Count w/o doing 2 queries.

After you execute your select/limit statement you can execute select found_rows() It returns the number of rows thbat the previous query would have returned if the limit wasn't applied. See: http://dev.mysql.com/doc/mysql/en/information-functions.html. Regards, E Hi everyone, Im executing

RE: please help .........very urgent

Hi!! $dbQuery = "select * from table where 1" ; $result = mysql_query($dbQuery) or die("Error trying to execute the query: ".mysql_error()); If(mysql_num_rows($result)<1){ //also: "==0" works echo "NULL"; -Original Message- From: Kane Wilson [mailto:[EMAIL PROTECTED] Sent: Wednes

Re: AES_DECRYPT output

I suppose that you have to change the status to Open, or people suppose that there aren't any changes. It would be nice that it would be tested in ASP.NET because it can be simply a problem with of type conversion in .NET, I haven't see the problem (and I don't work with .NET). M DR wrote: Hi

Locks acquired with get_lock() persisting, even after MySQL thread has exited

Description: We have distributed applications which make extensive use of the get_lock() function to acquire a system-wide lock. Occasionally, all copies of a given application block attempting to acquire a lock on the same lock string. Using is_used_lock() reports

Replication slave fails to start under OSF1 (Tru64)

>Description: I am running a MySQL 4.1.14-standard server on one HP Alpha machine. It is configured to act as a replication master. When I start a replication slave on a different HP Alpha machine, using the same binary distribution, the slave fails. This is part of the slave's error log file:

Re: Sort aborted

Hi, I've tried that there is no problem with that. Mysql creates bigger tmp tables from time to time. We had this problem with a specific query onyl I sad had, as last night I tried again and it worked. Beats me... Server was not rebooted, mysql was not restarted and the available space

Getting Record Count w/o doing 2 queries.

Hi everyone, Im executing the following query: SELECT * FROM table1 WHERE table1.field1 = 'A' AND table1.field2 = 'B' LIMIT 0,10 I also need to get the total record count for the above query, but without the limit clause (limit is for pagination purposes) Is there any way to extract this total

Re: AES_DECRYPT output

Hi, I have reported the bug a while ago, but it seems not all bugs are taken seriously. I reported it and one of the researchers couldn't replicate the problem, so I provided a sample project in ASP.NET where the problem can be seen very easily, but nobody reacted (probably because the status

RE: Date Ranges

---snip-- > Given any two dates, MySQL can tell if a third date is within > that range. > That's easy. > > To actually return a list of all dates between any arbitrary > pair of dates requires some form of loop (v5.0+) or a lookup > into a table populated with all possible dates (any version

`gmake test` probs Solaris9 for M. 4.1.4.

Attempts to do make test prior to installation, to check that I'm installing something workable, give: neelix hgs 63 %> gmake test cd mysql-test; perl mysql-test-run.pl && perl mysql-test-run.pl --ps-protocol No ndbcluster support Killing Possible Leftover Processes Removing Stale Files Installi

Solution: old configuration

Hi all, Thanks for your replies, Found the solution. I had the data directory on another harddisk + did not delete it after the deinstallation. cheers, Thomas t.j. loeffler swiss federal institute of technology department of eart

Re: old settings

Loffler Thomas J. wrote: Hi all, I've installed MySQL db server 4.1.14 + Administrator + Control Center for test purposes on Windows 2003 Server Standard. Then I deinstalled everything, deleted all files which were not deleted by the uninstall process (search for "mysql") + deleted also the en

Re: re:mysqldump: Error 2013

Hello. Have a look here: http://dev.mysql.com/doc/mysql/en/gone-away.html christophe charron <[EMAIL PROTECTED]> wrote: > Hi, > i've got the same kind of problem but not in a dump, in a restore. I > tried to restore it in a MyIsam type table but i have the same error. > Could other se

Re: Why does Mysql use a filesort ?

Hello. > This index is not used at all for the select ? substring(segment_0_sk,1,677) - a function is applied to the indexed column. In my opinion, MySQL isn't so smart to understand that this is a prefix. If you want to order only on the prefix of your text column, think about max_sort_le

Re: old settings

Hello. >"max_question resource exceeded". It is somehow related to the user privileges. See: http://dev.mysql.com/doc/mysql/en/user-resources.html Start mysqld with --skip-grant-tables and fix the user's limits. >Does someone know which files or registry entry/entries must be de

Re: trouble understanding why query is not using the index.

Hello. >>> so why does 'explain select * from files where >>> (pathref,version)=(129286,0);' scan the whole table? It is documented that this syntax can't be optimized yet. See: http://dev.mysql.com/doc/mysql/en/row-subqueries.html Jason Pyeron <[EMAIL PROTECTED]> wrote: > On Tu

Re: please help .........very urgent

Hello. > $dbQuery = results; Have you forgotten to put '$' before the 'results'? Do you have display_errors = On in your php.ini? Kane Wilson <[EMAIL PROTECTED]> wrote: > > > hi , > > I wanted to check the following condition and if it is > success i wanted to display a massag

Re: a confusing error: 111

Try redoing from scratch but this time dont use a client just use command line! > yeah, i can access the database server normally with the client mysql. > it works all right. the point is mysqladmin doesn't work. > > Thank u. > > On 9/7/05, 王静 <[EMAIL PROTECTED]> wrote: > > On 9/7/05, Ben <[EMAIL

Why does Mysql use a filesort ?

Hello, I have the following table: CREATE TABLE `list_datas_1` ( `list_id` bigint(20) NOT NULL, `locale_id` bigint(20) NOT NULL, `record_id` bigint(20) NOT NULL, `segment_0` longtext, `segment_1` longtext, `segment_0_sk` longblob, `segment_1_sk` longblob, KEY `record_id` (`record_

old settings

Hi all, I've installed MySQL db server 4.1.14 + Administrator + Control Center for test purposes on Windows 2003 Server Standard. Then I deinstalled everything, deleted all files which were not deleted by the uninstall process (search for "mysql") + deleted also the entries in the registry which