Re: Poor InnoDB Performance

DuffMan, I assume you are running 4.0.14? What is your Linux version? Please post the whole output of SHOW INNODB STATUS\G Are you using the MySQL query cache? Remember that any insert, update, or delete invalidates it. To test the impact of fsync(), try running with innodb_flush_log_at_trx_comm

RE: DB creation

The WinMySqladmin is not used to create, remove or query a database. Your system is (or appears to be) working fine, In order to do this, you have to use the mysql.exe client in the bin directory of mysql (try c:\mysql\bin). This is a "command line" driven system, based on sql If you want to use

Retreiving image files

I used mysql_real_escape_string() to insert jpg image file into database. Now how do i check whether it got stored in proper format?? I tried to retriev that image file using SELECT * INTO OUTFILE FROM IMGTABLE; But it says cannot open image file as it contains errors. How do i retrieve the i

Re: Bookmarks

At 7:04 +0500 7/24/03, Shahid M. Syed wrote: > At 8:45 +0500 7/23/03, Shahid M. Syed wrote: >Hello > >Does any version (production or future) of mysql supports Bookmarks? What is "Bookmark" capability in a database context? You can use the Bookmark property to set a bookmark (Bookmark: A prope

Re: mysqladmin: connect to server at 'localhost' failed

Check the sysntax! It should be mysqladmin -u root -p shutdown (If u r shutting down the server) You should provide the password if you have one for the root user. >>> Saravanan Kulandaivelu <[EMAIL PROTECTED]> 7/23/2003 3:21:59 PM >>> Hi, I am getting the following error: mysqladmin: connect

mysqladmin: connect to server at 'localhost' failed

Hi, I am getting the following error: mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' if some one knows the answer . Pl. let me know. Thanks, Saravanan K

Q: DB creation

Situation: I just installed MySQL 4.0.14 on my Windows XP, the very first time. The server daemon seems started running well. Now, I want to create a new database. However, in the WinMySqlAdmin 1.4 tool, upon right clicking, in the dropdown list there are no "create database, create ..." items, o

Does mysql save to a temp file??

In the later part of June a new Linux Mysql server was installed. While mysqld was still running, the data folder was moved to a different volume and a soft link to the new location was put in it's place. I know, bad idea, but everything seemed to work fine, so I didn't think anything of it.

Re: [MP2] Placing Apache::RequestRec & Apache::RequestIO & APR::Table use statements in startup.pl

On Wed, Jul 23, 2003 at 08:31:21PM -0700, Jamie Krasnoo wrote: > Will placing Apache::RequestRec & Apache::RequestIO & APR::Table in > startup.pl to load them up for multiple handlers have any bad side > effects? I noticed that when I load them via startup.pl the handlers > that use them don't comp

Re: MySQL on a website

i think your answer lies at http://www.brinkster.com I remember they have various plans ( paid one ) but they also have a free plan, u have to check up whether they give for MYSQL or not. Regards Neeraj - Original Message - From: Daniel Glenfield To:

[MP2] Placing Apache::RequestRec & Apache::RequestIO & APR::Table use statements in startup.pl

Will placing Apache::RequestRec & Apache::RequestIO & APR::Table in startup.pl to load them up for multiple handlers have any bad side effects? I noticed that when I load them via startup.pl the handlers that use them don't complain that they don't have the use statements within the module code and

Re: Re-attaching DB to mysql

Hi Hendrik, not sure if you have already received an answer, so please ignore if you are already back on track ;-) I did not find which OS you are using , but under Linux/Unix you would need to change the ownership back to the user "mysql" and the group "mysql" before you can use the copied da

Re: HELP WITH mySQL!!!

Hi Michael, I a not 100% sure if I understood you correctly, but what you want to do seems to be better made in the application itself, rather then the SQL code. However you can use ALIASES together with the GROUP BY function and specify 2 columns (Cars and COUNT(Monthofyear) which should list

Re: Restrict UPDATE without WHERE

Hi Mohammad, I am sorry I am not usre what exactly you are after, but you could use, HAVING or LIMIT to restrict an UPDATE statement. Best regards Nils Valentin Tokyo/Japan 2003年 7月 24日 木曜日 05:29、Mohammad Khan さんは書きました: > Is there any way to restrict UPDATE without a WHERE clause? > > > Mohamm

Re: JDBC 3.08 nightly snapshot from 7/23/2003

Hi Mark, I use the the MySQL versions as provided from www.mysql.com. The drivers are taken from the daily snapshot and/or from www.mysql.com. Let me know if you need more information. Best regards Nils Valentin Tokyo/Japan 2003年 7月 23日 水曜日 23:44、Mark Matthews さんは書きました: > -BEGIN PGP SIGNE

Re: Bookmarks

Shahid M. Syed wrote: At 8:45 +0500 7/23/03, Shahid M. Syed wrote: Hello Does any version (production or future) of mysql supports Bookmarks? What is "Bookmark" capability in a database context? You can use the Bookmark property to set a bookmark (Bookmark: A property of a Record

RE: RES: What is a good benchmark?

Had Free Time.. hehe.. (MORE included I'm Still Slowest!! Where's HyperThreading??) P4 2.4GHz (1GB RAM) 0.53 (on Win2K) Maybe cpu no loaded?? 2x Athlon2100(2GB RAM) 0.54 <--FASTEST -> Tuning parameters below AMD 1900+ (512RAM) 0.61 AMD 1666Mhz(1GB RAM)0.64 P4 2*2.8(2GB RAM)

Re: Bookmarks

> At 8:45 +0500 7/23/03, Shahid M. Syed wrote: > >Hello > > > >Does any version (production or future) of mysql supports Bookmarks? > > What is "Bookmark" capability in a database context? You can use the Bookmark property to set a bookmark (Bookmark: A property of a Recordset object or a form tha

Poor InnoDB Performance

I converted 3 of 30 MyISAM tables to InnoDB. Since then I have been constantly reaching my limit of 100 connections because Selects on the InnoDB tables are slow. If I cut off traffic and execute a SELECT, it takes less than 0.01 seconds. If a execute the exact same query again with traffic, it ta

RE: RES: What is a good benchmark?

Had Free Time.. hehe.. AMD 1900+ (512RAM) 0.61 P4 2*2.8(2GB RAM) 0.66 P4 2GHz(? RAM) 0.86 P4 1.8G(512 RAM)0.91 1G Mac Pbook(1GB RAM) 1.07 AMD 1GHZ1.21 Celeron 733(win2k) 1.63 P3 850Mhz 1.91 G3 333Mhz

RE: How do I show column names in php?

I think you want the column headers right?? Header1 header2 header3 << this is what you want right? data1 data2 data3 data4 data5 data6 echo ''; for ($k = 0; $k < sizeof($l_row) ; $k++) { echo "\t" . ''; echo mysql_field_n

Looking up duplicate record or adding new unique record

CREATE TABLE tbllayer ( LayerID int(11) NOT NULL default '0', LayerSize int(11) NOT NULL default '0', IceTypeID int(11) NOT NULL default '0', Fingerprint char(16) binary default NULL, PRIMARY KEY (LayerID), UNIQUE KEY Fingerprint (Fingerprint), KEY IceTypeID (IceTypeID) ) TYPE=MyISAM

Replication/Synchronization Scheme

I have a MySQL master server; it has some tables from a database that needed to be replicated once a day by some slave server, through a dial-in connection. How do you think is the best way to do that? Is the replication scheme in MySQL manual safe enough to do this? Anybody want to share some e

RE: Restrict UPDATE without WHERE

--i-am-a-dummy ref: http://www.mysql.com/doc/en/mysql.html oO..\/ peace James -Original Message- From: Mohammad Khan [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 1:29 PM To: [EMAIL PROTECTED] Subject: Restrict UPDATE without WHERE Is there any way to restrict UPDATE withou

read-only 'Process_priv' privilege?

Greetings: Long time reader, first time poster. Here we go: ==Specific question: Does there exist in MySQL a privilege configuration which will allow an account to issue `SHOW MASTER STATUS` and `SHOW SLAVE STATUS`, but will disallow the running of any other commands (such as `KILL`)? ==Efforts

Re: Subselect in 4.0.12-max with --new option / Max Date

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 22 July 2003 22:28, [EMAIL PROTECTED] wrote: > Sorry I completely forget the query: > SELECT * FROM Kardex WHERE Fecha IN (SELECT maxfecha FROM fechas) > P.D. Im using 4.1 alpha version for win32 OK, something is still missing. I went to

Re: Create Temporary Table

For what it's worth, I get the same problem with 4.0.13, and have posted the same question a few times with no response. It works fine at the command line, but not through the mysql++ API. It doesn't work on my home/work machines (both running XP), though my colleague doesn't experience the problem

Re: Didn't find any fields in table 't_table'???

Thanks for your help. I found that the permissions to the files were wrong and I had to restart mysql. I also needed to repair t_table to get things back to normal. I was scared I lost my data, but only for a second :-). Regards, Jake Johnson [EMAIL PROTECTED] _

RE: Why is this query not working?

> I am running php 4.2.2 and mysql 3.23.54. This is a PHP question, not mySQL. > This is my query: > > $sql = "SELECT MAX(esn) FROM address"; // line 37 > $max_esn_result = mysql_query($sql) or print mysql_error(); // line > 38 > $max_esn = mysql_result($max_esn_result,$i,"esn

RE: large mysql/innodb databases

>>Power problems are handled by our colo facility, we want to quickly restore for most hardware problems (disk/machine failures). Just have multiple inexpensive fully replicated servers with failover built into the application layer (that's what we do) - Individual machines can go down and the se

Re: Is it necessary to compress tables?

> > Since I received no responses, maybe someone can take a moment to > > explain why this is such a stupid question. > > Maybe not stupid, but definitely "please see the manual" questions. > > Answers to Question 1: > http://www.mysql.com/doc/en/DELETE.html > http://www.mysql.com/doc/en/Optimisati

Re[2]: Is it necessary to compress tables?

Jim, >> Does MySQL automatically handle deleted row cleanup, or is it necessary to >> periodically do this manually for tables with a lot of deletions? If it's >> manual, what are the SQL commands to do this? Depends on which storage engine you are using. If you are using InnoDB tables, there's

Re: Is it necessary to compress tables?

In the last episode (Jul 23), Jim McAtee said: > > Does MySQL automatically handle deleted row cleanup, or is it > > necessary to periodically do this manually for tables with a lot of > > deletions? If it's manual, what are the SQL commands to do this? > > > > Also, what happens when changes are

RE: large mysql/innodb databases

We don't expect recovery to be shorter than the time it takes for the hardware to copy the data over. Restoring from tape should be a solution that is only needed in the case of a severe problem. Power problems are handled by our colo facility, we want to quickly restore for most hardware problem

Why is this query not working?

I am running php 4.2.2 and mysql 3.23.54. This is my query: $sql = "SELECT MAX(esn) FROM address"; // line 37 $max_esn_result = mysql_query($sql) or print mysql_error(); // line 38 $max_esn = mysql_result($max_esn_result,$i,"esn"); // line 39 This is the error I get:

Software Application Engineer WANTED (MySQL focus)

I know this is not related to MySQL questions, but we are looking for a savvy PHP/MySQL guru to fill a position at my organization. The job description and requirements are below. Strong English communication skills and relocation to upstate NY are a must for this position. Software Applicati

Re: Is it necessary to compress tables?

Since I received no responses, maybe someone can take a moment to explain why this is such a stupid question. - Original Message - From: "Jim McAtee" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 23, 2003 1:28 PM Subject: Is it necessary to compress tables? > Does M

RE: large mysql/innodb databases

Hi, I'm afraid that with that amount of data and having a few huge constantly updated tables will result in huge restore times for disaster recovery (just untaring/copying backups of the magnitude of terabytes back to the live environment will take hours and hours..) You're talking "massive enter

Re[2]: Can run two versions of MySQL in Windows 2000?

Degan, jumping in to try and solve some problems that look pretty obvious to me ... > #options for default service (mysqld2) > (mysqld2) It should be [mysqld2], not (mysqld2). > basedir = c:\4.1 Alpha\mysql As Paul pointed out, the blank in the path name is likely to cause problems (see below)

Updating a nested set

I'm basing some work on Joe Celko's excellent idea of using nested sets to represent an organizational structure as opposed to an adjacency list. By and large it's a great idea, but not without its pitfalls. I'm writing now to ask your collective opinion of the best practice. I've got my nested se

RE: large mysql/innodb databases

The data is constantly updated. There are 3 or 4 huge tables, and several smaller tables. We would love to have an incremental solution that is *guaranteed* to be correct, but we haven't found a way to do that, so what we've been thing is we'd do a complete snapshot once a week, and do incrementa

Master/Master Asynchronous replication

Currently we have a web based application that is mostly reads (4:1 r/w). It is using a single MySQL database server. Is there any way to have two database servers in a master/master configuration such that writes to either database server are replicated to eachother. Basically even thoug

Re: Didn't find any fields in table 't_table'???

Jake Johnson wrote: How do I fix this error? My tables have data. But they probably are not owned by mysql. Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rim

Restrict UPDATE without WHERE

Is there any way to restrict UPDATE without a WHERE clause? Mohammad Khan Software Engineer Legal Computer Solutions, Inc. 107 Union Wharf Boston, MA 02109 http://www.lextranet.com (617) 227-4469 x 212

RE: large mysql/innodb databases

Hi, We have similar numbers here. A couple of questions: - are they logfiles that could be rolled over on a daily basis or are they constantly updated huge tables? - is the type of backup you want incremental or a daily/weekly snapshot one? - do you have a requirement for the speed of restore

Re: large mysql/innodb databases

At 03:08 PM 7/23/2003, you wrote: I was wondering if anyone had any experience with setting up large and fairly high performance databases. We are looking at setting up databases with each machine having somewhere between 500 gigs and 2 terabytes along with a slave box and we'd like to backup ever

Re: mysql stops processing

Joe, - Original Message - From: "Joe Shear" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, July 23, 2003 11:23 PM Subject: Re: mysql stops processing > > > On Wed, 2003-07-23 at 13:11, Heikki Tuuri wrote: > > Joe, > > > > - Origin

RE: mysql stops processing

Hi, I believe that MySQL v4 has a superuser privilege level that keeps a connection available even when the regular connections are all used up just for diagnosis/killing etc... May want to try that to get your processlist too. Cheers, Andrew -Original Message- From: Joe Shear [mailto:

Re: mysql stops processing

On Wed, 2003-07-23 at 13:11, Heikki Tuuri wrote: > Joe, > > - Original Message - > From: "Joe Shear" <[EMAIL PROTECTED]> > To: "Heikki Tuuri" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Wednesday, July 23, 2003 11:03 PM > Subject: Re: mysql stops processing > > > > Unfortuna

RE: Re-attaching DB to mysql

The mysqldump you use doesn't include the "create databease" so you'll need to create the henrik DB on the new install. If you keep running it over and over, it will keep inserting the same records over and over again and you'll end up with duplicates. The thing to do is start with an empty db (cal

Re: mysql stops processing

Joe, - Original Message - From: "Joe Shear" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, July 23, 2003 11:03 PM Subject: Re: mysql stops processing > Unfortunately, we haven't been able to connect to the database because > of the ma

large mysql/innodb databases

I was wondering if anyone had any experience with setting up large and fairly high performance databases. We are looking at setting up databases with each machine having somewhere between 500 gigs and 2 terabytes along with a slave box and we'd like to backup everything to tape at a minimum of onc

RE: Re-attaching DB to mysql

And from the MySQL docs: --clip MySQL Version 3.23 supports tables of the new MyISAM type and the old ISAM type. You don't have to convert your old tables to use these with Version 3.23. By default, all new tables will be created with type MyISAM (unless you start mysqld with the --def

RE: Re-attaching DB to mysql

Thanks for the reply. I started a mysql v3 on a new system with the old "backup" data directory and type: mysqldump -p henrik > henrik.sql This dumps the DB? To restore, I move henrik.sql to the current 4.0.14 server and type: mysql -p henrik < henrik.sql except it complains the DB does

Re: mysql stops processing

Unfortunately, we haven't been able to connect to the database because of the maxed out connections. This happens so fast that the maxed out connections is usually the first sign. I've been hesitant to start the monitor, since this has only been happening once every couple days. It's been becomi

RE: Re-attaching DB to mysql

Hi, If that backup uses the old ".ISD & .ISM" architecture then I would install an old version of MySQL, copy these files into the data dir of that installation and mysqldump them to a file ready for import into your new MySQL v4 install. I'm not aware of any scripts to just munge the old style d

Re: mysql stops processing

Joe, - Original Message - From: "Joe Shear" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Wednesday, July 23, 2003 10:40 PM Subject: RE: mysql stops processing > hi, > > We're pretty careful about preventing that. Also, no queries are moving > forward, no inserts, update

HELP WITH mySQL!!!

UGHH HELP!! I need to write a sql statement that will take the data from my table and use it as column headers. For example, If I have a field named GoLiveDate and a field called Qty and a field called Cars: Cars | Qty | GoLiveDate == CarA | 5 | 7/21/2003 CarA | 10

RE: mysql stops processing

hi, We're pretty careful about preventing that. Also, no queries are moving forward, no inserts, updates, or selects, even the ones on tables that are only a mixture of inserts and selects. joe On Wed, 2003-07-23 at 12:02, Andrew Braithwaite wrote: > Hi, > > I don't know what type of applicat

error loading mod_auth_mysql

Hi All, I am running mysql-3.23.52 on OS X (10.2.6) and I'd like to install the mod_auth_mysql module for a job I'm working on that used it under a different platform. I compiled the module using: apxs -c -D APACHE1 -L/usr/local/mysql/lib/ -I/usr/include/mysql/ -lmysqlclient -lm -lz m

RE: Can run two versions of MySQL in Windows 2000?

My responses are "parenthesied" in the text below. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 2:56 PM To: Degan, George E, JR, MGSVC Cc: [EMAIL PROTECTED] Subject: RE: Can run two versions of MySQL in Windows 2000? At 13:01 -0500 7/23/0

Is it necessary to compress tables?

Does MySQL automatically handle deleted row cleanup, or is it necessary to periodically do this manually for tables with a lot of deletions? If it's manual, what are the SQL commands to do this? Also, what happens when changes are made to a field definition? From, say, int to smallint, or tinyin

RE: Re-attaching DB to mysql

Copy of the data files :-( - Henrik -Original Message- From: Andrew Braithwaite [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 2:04 PM To: 'Henrik Schmiediche'; 'Mysql' Subject: RE: Re-attaching DB to mysql Is the backup a mysqldump or a copy of the data files? Andrew

RE: What is a good benchmark?

At 01:45 PM 7/23/2003, you wrote: >Is it me or do these dual athlons seem rather responsive! Yay!! I win (so far... heh)! Beat you by a nose. (Of course I had to run it 2 or 3 times to shave a couple hundreds of a second off the times) A single P4 2.4 Ghz 1g RAM running MySQL 4.1.0 Alpha running

RE: Re-attaching DB to mysql

Is the backup a mysqldump or a copy of the data files? Andrew -Original Message- From: Henrik Schmiediche [mailto:[EMAIL PROTECTED] Sent: Wednesday 23 July 2003 19:48 To: 'Mysql' Subject: Re-attaching DB to mysql Hello, I have a backup of a mysql v3.0.18 DB. I need to extract on

Re: What is a good benchmark?

I got disappointing results compared with the ones posted here:with a dual xeon 2Ghz, 2GB ram, freebsd 5.1, mysql mysql> SELECT BENCHMARK(100,ENCODE("hello","goodbye")); +--+ | BENCHMARK(100,ENCODE("hello","goodbye")) | +---

RE: mysql stops processing

Hi, I don't know what type of applications are using your database but if I had to guess at the problem, I would guess that you have a very slow query which runs every now and again that is locking up certain tables/records causing all the other queries to queue up and eventually running out of co

RE: Can run two versions of MySQL in Windows 2000?

At 13:01 -0500 7/23/03, Degan, George E, JR, MGSVC wrote: SETUP Windows 2000, Version 5.0 (build 2195, Service Pack 2) (In case it matters, I have about 20 GB available on my 40GB hard drive and 192MB of RAM) SETTINGS Prior to attempting to put on the second server, I wasn't using any options, wh

Re-attaching DB to mysql

Hello, I have a backup of a mysql v3.0.18 DB. I need to extract one of the DB's from that backup and place it into my current production v4.0.14 mysql DB. Can this be done? How? Sincerely, - Henrik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To un

mysql stops processing

Hi, Has anyone ever had any problems with MySQL w/ all InnoDB tables just stop processing queries? There doesn't seem to be any pattern to it, it happens at times of relatively high load (load avg of 4 on a dual proc) but the CPUs still have plenty of idle time, and the disks aren't maxing out.

RE: What is a good benchmark?

>Is it me or do these dual athlons seem rather responsive! Yay!! I win (so far... heh)! I ran it on one of our servers (not idle... running apache w/ CGIs and db calls ~ 140,000 scripts/day ) We are using as many tricks as we can. 0. mysql 4.0 binary from mysql.com 1. we set the n

RE: What is a good benchmark?

I get the following on dual Athlon MP 1666MHz 1GB RAM which is 40% cpu loaded mysql> SELECT BENCHMARK(100,ENCODE("hello","goodbye")); +--+ | BENCHMARK(100,ENCODE("hello","goodbye")) | +--+ |

RE: Difficult count query?--nevermind, I found the answer...

select bc_post.*, count(bc_message.message_to) responses from bc_post left join bc_message on bc_post.post_id = bc_message.message_topostid and bc_post.user_id = bc_message.message_to where bc_post.post_status = '1' and bc_post.user_id = '1' group by bc_post.post_id > -Original Message-

Difficult count query?

I have two tables: bc_post and bc_message. This is what I have so far: select bc_post.*, count(bc_message.message_to) responses from bc_post left join bc_message on bc_post.post_id = bc_message.message_topostid where bc_post.post_status = '1' and bc_post.user_id = '1' group by bc_post.post_id T

Re: What is a good benchmark?

Dual P3 933, 2 gig RAM, IDE RAID-5 +--+ | BENCHMARK(100,ENCODE("hello","goodbye")) | +--+ |0 | +--+ 1 row in set (1.40

Re: What is a good benchmark?

Is it me or do these dual athlons seem rather responsive! I use mySQL 4.0.13 running on FreeBSD 4.8. Pentium 4 2.8Ghz 2GB DDR400 1 row in set (0.7 sec) | (0.68 sec) | (0.68 sec) Andrew. - Original Message - From: "Christopher Knight" <[EMAIL PROTECTED]> To: "Mysql" <[EMAIL PROTECTED]>

RE: Can run two versions of MySQL in Windows 2000?

SETUP Windows 2000, Version 5.0 (build 2195, Service Pack 2) (In case it matters, I have about 20 GB available on my 40GB hard drive and 192MB of RAM) SETTINGS Prior to attempting to put on the second server, I wasn't using any options, which was logging me in as [EMAIL PROTECTED] (or more likel

RE: Database Admin

Ratmil Check out the free dbTools at http://www.dbtools.com.br/EN/ Freddie -Original Message- From: Ratmil Torres [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 23. Juli 2003 14:22 To: [EMAIL PROTECTED] Hi, I just installed MySQL. Does anybody know where to manage the databases, create, e

RE: What is a good benchmark?

1 row in set (0.54 sec) 2x Athlon2100 2GB Ram Linux 2.4.20 -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 9:34 AM To: Mysql Subject: What is a good benchmark? I ran this benchmark on my pIII 500 and was wondering what everyone else was ge

RE: What is a good benchmark?

personal Win98 Duron650 128MB Mysql 4.0.13 - 1.37 sec busy server Redhat 7.0 Celeron 333 380MB Mysql 3.23.54 - 3.11 sec > -Original Message- > From: Jake Johnson [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 23, 2003 5:34 PM > To: Mysql > Subject: What is a good benchmark? > > >

RE: What is a good benchmark?

On my P3 600MHz 256MB RAM, Redhat 8: 1 row in set (2.01 sec) >>> "Hubbard, Dan" <[EMAIL PROTECTED]> 07/23/03 11:39AM >>> On my 2 * 2.8Ghz 2GB RAM, Redhat 8: mysql> SELECT BENCHMARK(100,ENCODE("hello","goodbye")); +--+ | BENCHMARK(100,ENCODE("hel

EXPLAIN - Question..

Hello everyone. I have copied the results from and explain on a query that I want to use. And I am wondering if anyone could tell me if these results are bad or good? If everything below is coming up garbled for you I will basically I am using 7 tables and the rows for 6 of the seven are 1 and t

Re: Bookmarks

At 8:45 +0500 7/23/03, Shahid M. Syed wrote: Hello Does any version (production or future) of mysql supports Bookmarks? What is "Bookmark" capability in a database context? Regards Shahid M. Syed Karachi, Pakistan http://members.tripod.com/shahid_syed -- Paul DuBois, Senior Technical Writer Ma

Re: RES: What is a good benchmark?

> On my p4 2gig > > mysql> SELECT BENCHMARK(100,ENCODE("hello","goodbye")); > +--+ > | BENCHMARK(100,ENCODE("hello","goodbye")) | > +--+ > |0 | > +--

Re: What is a good benchmark?

+--+ | BENCHMARK(100,ENCODE("hello","goodbye")) | +--+ |0 | +--+ 1 row in set (1.91 sec) PIII 850, with 1GB Ram. ---

Create Temporary Table

Hello, Mysql Version 4.0.11a-gamma When I try and run the following query create temporary table russ1 as select rcust.* from rcust; and I receive the error message: Error Code : 1044 Access denied for user: '[EMAIL PROTECTED]' to database 'customer' (0 ms taken) I can run the

RE: Can run two versions of MySQL in Windows 2000?

At 6:32 -0500 7/23/03, Degan, George E, JR, MGSVC wrote: I'm sorry, I'm very new at this. I only downloaded the live version last week. Where do I find the setting you are referring to? By attempt to run the servers, perhaps this is a correct answer to your question: I am only using this for le

mysqlcc not coming up in Windows XP

I am trying to run MySQLcc(0.9.2) on Windows XP. When I try to bring it up I get an hourglass for a second, then nothing happens. Has anyone had similar issues or any ideas as to what could cause this? Thanks (mysql, query) Scott Pippin [EMAIL PROTECTED]

Re: **Checking For Modified Rows**

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 23 Jul 2003 13:27:53 +0100, Kevin Gale wrote: >I need to replicate data (approx. 10,000 records) from a mySQL database into >a different (non mySQl) database automatically on a regular basis. I have no >control over the mySQL server (apart fro

Didn't find any fields in table 't_table'???

How do I fix this error? My tables have data. Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. -- MySQL General Mailing

RES: What is a good benchmark?

Hello Guys, AlphaServer EV6 processor 500mhz/1Gm memory with Linux mysql> SELECT BENCHMARK(100,ENCODE("hello","goodbye")); +--+ | BENCHMARK(100,ENCODE("hello","goodbye")) | +--+ |

Fwd: Mysql primary, foriegn and composite keys. Please advise

Note: forwarded message attached. __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com--- Begin Message --- Hi All, I have a database consisting of 2 tables. patient_info ( Patient Information ).

Selecting Date Time field, difference in minutes

Hello all, I wonder if is there any way to select from a table all the records which has a Date Field that is at least five minutes old? In other words, I have a table with a date field and I need to select all the records that are older than five minutes, has their date field updated before f

RES: What is a good benchmark?

Hello Guys, I have Risc/AlphaServer ES40 with processor EV6 500mhz running RedHat 7.2/Mysql. Could you please send me Bench test ? I like to try tks, Julio -Mensagem original- De: Bryan Koenig [mailto:[EMAIL PROTECTED] Enviada em: quarta-feira, 23 de julho de 2003 11:46 Para: [EMAIL PR

Re: mysqldump isn't working anymore

Still the same problem, but I am still able to select from the DB using mysql. Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Par

Re: What is a good benchmark?

On my 1Ghz Mac PowerBook with 1GB RAM using version 4.0.13 with OS 10.2.6 mysql> SELECT BENCHMARK(100,ENCODE("hello","goodbye")); +--+ | BENCHMARK(100,ENCODE("hello","goodbye")) | +--+ |

RE: What is a good benchmark?

Xserve 1ghz - 1.08 sec G3 333mhz - 2.78 sec - John On my p4 2gig mysql> SELECT BENCHMARK(100,ENCODE("hello","goodbye")); +--+ | BENCHMARK(100,ENCODE("hello","goodbye")) | +--+ |

RE: What is a good benchmark?

On my 2 * 2.8Ghz 2GB RAM, Redhat 8: mysql> SELECT BENCHMARK(100,ENCODE("hello","goodbye")); +--+ | BENCHMARK(100,ENCODE("hello","goodbye")) | +--+ |0 | +-

Re: What is a good benchmark?

Celeron 733 Windows 2000 MySQL 3.23.56-nt 1.63s 1.58s 1.58s Athlon 1GHz Debian 3 inside VMWare 3 (WinXP) MySQL 4.0.14 1.21s 1.22s 1.18s -yves -Ursprüngliche Nachricht- Von: "Bryan Koenig" <[EMAIL PROTECTED]> An: <[EMAIL PROTECTED]> Gesendet: Mittwoch, 23. Juli 2003 16:45 Betreff: RE

RE: What is a good benchmark?

On my 1.8GHz p4 with 512Gig of RAM I get: mysql> SELECT BENCHMARK(100,ENCODE("hello","goodbye")); +--+ | BENCHMARK(100,ENCODE("hello","goodbye")) | +--+ |0 |

  1   2   >