RE: Search Engine type search

I'm using ASP (VB Script) at the moment for my webpages. From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE: Search Engine type search Date: Wed, 23 Aug 2006 16:36:19 -0400 That's a tough one. Basically, you need a spell checker plug-in for your application,

RE: SOS

Hi Lian, I am going to take a guess that your full execution line looks as follows: $mysql -u root -h localhost -p yourpwd If this is true then MySQL will give you prompt: $Enter password: yourpwd And the mysql will return $Error 1049(42000) Unkown database 'yourpwd' This happens because,

Re: table sizes, rolling data.

You could accomplish this with a trigger on the table - on INSERT, execute a DELETE statement. http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html You would need to find a way to identify which is the bottom record to be deleted ... I might use an ID column, and consider the

Table permissions - before the table is created?

Can the mysql administrator grant permissions on a table in an existing database if that table doesn't exist yet? This is part of planning for an upgrade to an existing application. The mysql administrator won't be there when I add the table to the existing database and I don't have grant

Re: Table permissions - before the table is created?

Chris Jones wrote: Can the mysql administrator grant permissions on a table in an existing database if that table doesn't exist yet? This is part of planning for an upgrade to an existing application. The mysql administrator won't be there when I add the table to the existing database and I

Re: Degrading write performance using MySQL 5.0.24

On Wed, 2006-08-30 at 08:31 -0700, Phantom wrote: We have an application that stores versioned data in MySQL. Everytime a piece of data is retrieved and written to, it is stored in the database with a new version and all old versions are subsequently deleted. We have a request rate of 2

Re: Table permissions - before the table is created?

Thanks for that. Will create the two tables ahead of time which won't affect the existing application. At 11:57 30/08/2006, [EMAIL PROTECTED] wrote: Chris Jones wrote: Can the mysql administrator grant permissions on a table in an existing database if that table doesn't exist yet? This is

RE: Degrading write performance using MySQL 5.0.24

I see the same type of slow downs using 5.0.18 I am using load data in file to load CSV files. with clean tables, I see fairly quick inserts (ie instant) 2006-08-30 12:07:15 : begin import into table1 2006-08-30 12:07:15: end import into table1 records (10962) From earlier this morning,

query cache question

Hi, I just turned on the query cache by modifying its size and limit and restarting the server. However queries aren't being stored to it: Variable_name Value Qcache_free_blocks 1 Qcache_free_memory 10477008 Qcache_hits 0 Qcache_inserts 0 Qcache_lowmem_prunes 0

Re: Table permissions - before the table is created?

If you are manually editing the grant tables, don't forget to FLUSH PRIVILEDGES after you add the new tables. Steve Musumeche CIO, Internet Retail Connection [EMAIL PROTECTED] Chris Jones wrote: Thanks for that. Will create the two tables ahead of time which won't affect the existing

Re: query cache question

Could you post an example of a query you are expecting to be cached? On Wed, 2006-08-30 at 11:43 -0500, Mazur Worden, Kathy wrote: Hi, I just turned on the query cache by modifying its size and limit and restarting the server. However queries aren't being stored to it:

Re: Degrading write performance using MySQL 5.0.24

On Wed, 2006-08-30 at 09:34 -0700, Phantom wrote: Here is the schema for the table are generate Sequence Numbers needed per item and the table that actually stores the data : CREATE TABLE SEQUENCE_NUMBER ( USER_KEY VARBINARY(255) NOT NULL, SUBKEY VARBINARY(255)NOT NULL,

Starting a Second Server under Mac OS X 10.3.9

I'm trying to get a second server running using mysql 4.1.15 on Mac OS X 10.3.9. I have one server running as my main development server, and would like a second to use for testing alternate DB Schema. I've followed the instructions in the manual section 5.12.2 'running multiple servers on

RE: query cache question

Maybe that's my issue, I had though the type of query would not matter. I've run simple queries in query browser like this: Select * from table t; And refreshed web pages hit about a hundred times a day containing counting queries like this: select count(BuildingInfo.deliverycode) AS 'Total'

Re: query cache question

What else would prevent queries from getting into the cache? Anything with NOW() in it or any of it's related functions... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: query cache question

Those queries look just fine to me. Could you output the result of the following: SELECT @@global.query_cache_size; On Wed, 2006-08-30 at 12:27 -0500, Mazur Worden, Kathy wrote: Maybe that's my issue, I had though the type of query would not matter. I've run simple queries in query browser

RE: Degrading write performance using MySQL 5.0.24

What type of data are you inserting? What storage engine are you inserting into? What is the average row size? On Wed, 2006-08-30 at 12:32 -0400, George Law wrote: I see the same type of slow downs using 5.0.18 I am using load data in file to load CSV files. with clean tables, I see

Re: SOS

Did you try : mysql -u root -h localhost (Without the -p) Root is passwordless after installation unless you changed it. On Tuesday 29 August 2006 11:28, 李彦 wrote: Dear Sir: I have some problems with mysql 5.0 binary source in Linux(RedHat).I'm able to startup the mysql process. But

RE: Degrading write performance using MySQL 5.0.24

data is all alphanumeric - any char fields are all fixed lengths, no varchars Name: table1 Engine: MyISAM Version: 10 Row_format: Fixed Rows: 330344 Avg_row_length: 624 Data_length: 206134656 Max_data_length: 2680059592703 Index_length:

RE: query cache question

The output of that query is: @@global.query_cache_size 10485760 Kathy Mazur Worden Prairie Area Library System -Original Message- From: Jay Pipes [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 30, 2006 12:42 PM To: Mazur Worden, Kathy Cc: mysql@lists.mysql.com Subject: RE: query

How to draw data model diagrams from existing schema?

I've spent the last month building a fairly elaborate database with lots of foreign keys. I want to draw a diagram that maps the relationships between all the tables, but I haven't found any software that can do that. Does anyone have any suggestions? I want to draw a picture with a box for

RE: Degrading write performance using MySQL 5.0.24

Hi! Could you please post a SHOW CREATE TABLE table1 \G thanks! On Wed, 2006-08-30 at 14:32 -0400, George Law wrote: data is all alphanumeric - any char fields are all fixed lengths, no varchars Name: table1 Engine: MyISAM Version: 10 Row_format: Fixed

Re: How to draw data model diagrams from existing schema?

Try to use DBDesigner, you´d get it from www.fabforce.net Matthew Wilson [EMAIL PROTECTED] escreveu na mensagem news:[EMAIL PROTECTED] I've spent the last month building a fairly elaborate database with lots of foreign keys. I want to draw a diagram that maps the relationships between all

RE: Degrading write performance using MySQL 5.0.24

Jay, Here you go - at least according to mysqldump CREATE TABLE `table1` ( `start_time` char(19) default NULL, `start_time_epoch` int(10) default '0', `call_duration` char(9) default NULL, `call_source` char(15) default NULL, `call_source_q931sig_port` int(5) default '0',

limit clause on join results

Hi all, I'm trying to show pages of results in a web app, 30 items per page. But my main query is a join, and I can't use a simple limit clause to return the 30 items (with the desired offset), because the join is between two tables with a one-to-many relationship, and I want 30 of the objects

RE: How to draw data model diagrams from existing schema?

Automatically? Don't know. I did it by hand using Dia, a free alternative to MS Visio. It was tedious. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: news [mailto:[EMAIL

RE: query cache question

Please show the output of: SELECT @@global.query_cache_type; and then: SHOW GLOBAL STATUS LIKE 'Qc%'; Thanks! On Wed, 2006-08-30 at 13:43 -0500, Mazur Worden, Kathy wrote: The output of that query is: @@global.query_cache_size 10485760 Kathy Mazur Worden Prairie Area Library System

RE: query cache question

@@global.query_cache_type ON Variable_name Value Qcache_free_blocks 1 Qcache_free_memory 10477008 Qcache_hits 0 Qcache_inserts 0 Qcache_lowmem_prunes0 Qcache_not_cached 20318 Qcache_queries_in_cache 0 Qcache_total_blocks 1 Thanks -Original Message- From:

MyISAM Performance for fixed row_format

The documentation for 4.1 says that changing to a row_format of fixed will increase disk look up. I did this with several tables where a query was taking about 3 minutes. I expected (from the doc and past experience) for the query to run in about 1 to 1 ½ minutes. Instead it now takes about

Re: How to draw data model diagrams from existing schema?

Excuse me, if he wants to do the reverse proccess, really it doesn´t do. Jerry Schwartz [EMAIL PROTECTED] escreveu na mensagem news:[EMAIL PROTECTED] Automatically? Don't know. I did it by hand using Dia, a free alternative to MS Visio. It was tedious. Regards, Jerry Schwartz Global

RE: Degrading write performance using MySQL 5.0.24

Well, clearly you've got a denormalized schema here, but I'll assume you will be normalizing this after the import? I hope so. Having a PK of CHAR(50) / INT will lead to poorer performance than a simply incrementing integer key. Additionally, it seems all the fields are NULLable, which wastes

RE: How to draw data model diagrams from existing schema?

Use MySQL Workbench: http://dev.mysql.com/downloads/guitools/ On Wed, 2006-08-30 at 15:11 -0400, Jerry Schwartz wrote: Automatically? Don't know. I did it by hand using Dia, a free alternative to MS Visio. It was tedious. Regards, Jerry Schwartz Global Information Incorporated 195

RE: query cache question

Ah, I think I may have figured it out... Are you using prepared statements? If so, doing that prevents the query cache from caching the resultset entirely. On Wed, 2006-08-30 at 14:17 -0500, Mazur Worden, Kathy wrote: @@global.query_cache_type ON Variable_name Value Qcache_free_blocks

Connecting mySQL to ColdfusionMX7

All, I am having difficulties getting the Coldfusion Administrator to establish a database connection to a database called accounting that I created using the command line utility. Any help would be very appreciated This is the error that CF is throwing: Connection verification failed for

RE: query cache question

Actually no, I'm not using any prepared statements. But thanks for the pointer on that. -Original Message- From: Jay Pipes [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 30, 2006 2:24 PM To: Mazur Worden, Kathy Cc: mysql@lists.mysql.com Subject: RE: query cache question Ah, I think

RE: How to draw data model diagrams from existing schema?

Hello, Check out MySQL Workbench (Part of the MySQL GUI Tools Bundle) if you haven't already done so: http://dev.mysql.com/downloads/gui-tools/5.0.html Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc -Original Message- From: news [mailto:[EMAIL PROTECTED] On Behalf Of Matthew

Some non-transactional changed tables couldn't be rolled back

Hi all... i'm developing an aplication and i'm need to use begin, commit, rollback, but when i try to use rollback i get a warning | Warning | 1196 | Some non-transactional changed tables couldn't be rolled back | this is what i did mysql begin; Query OK, 0 rows affected (0.00 sec) mysql

Re: table sizes, rolling data.

If you use an auto_increment column (e.g. id int auto_increment) then your trigger could do something like this: DELETE FROM table WHERE id new.id - 100; On Aug 30, 2006, at 3:49 PM, Dan Buettner wrote: You could accomplish this with a trigger on the table - on INSERT, execute a DELETE

Group By question

I have a table of people with one of the fields being the email address. I would like to query all rows that have more than one person with the same email address. For example if the data were like this... A [EMAIL PROTECTED] B [EMAIL PROTECTED] C [EMAIL PROTECTED] D [EMAIL PROTECTED] E

Re: Group By question

Chris, I would like to query all rows that have more than one person with the same email address. select id,count(emailaddr) as howmany from tbl t1 join tbl t2 using(emailaddr) group by id having howmany1; PB - Chris W wrote: I have a table of people with one of the fields being

Mass E-mail Options

Again, I know this is not necessarily a MySQL specific question, and sorry for getting off target, but this is a pretty smart and experienced bunch, and I'm sure that someone out there will be able to help me. We have a web application in which we have a mass e-mail function. It allows the

Re: Mass E-mail Options

Again, I know this is not necessarily a MySQL specific question, and sorry for getting off target, but this is a pretty smart and experienced bunch, and I'm sure that someone out there will be able to help me. We have a web application in which we have a mass e-mail function. It allows the

Complex SQL for multiple joins

Hi, For my current website project I'm developing a fine-grained access control system. I have the schema mostly worked out, although it will be having additional data added to parts of it later. For the record, I have 6 tables: users (contains all my individual users) usergroups (contains all

Re: installing mysql

jagdish gunjal wrote: i m upgrading mysql from 3.23 to 4.1.8. there was packge conflict for so many files like /etc/my.cnf Also i installed shared-compat for removing such problems. Is there any solution? Can you provide us with more about your environment? Also, have you

Mysql 5.x Solaris 8 crashes?

We've been running mysql 4.1.11 on our sparc solaris 8 (it's a 12 proc Sun 4800) for over a year without problems, but we just ran into a known innodb bug, so I decided to upgrade to 5.x. I tried the regular 5.0.24 SPARC 64-bit Solaris 8 package, the 5.0.24 debug package, the 5.1.11 package,

Re: Some non-transactional changed tables couldn't be rolled back

obed wrote: Hi all... i'm developing an aplication and i'm need to use begin, commit, rollback, but when i try to use rollback i get a warning | Warning | 1196 | Some non-transactional changed tables couldn't be rolled back | Transactions only work for table types that support them. MyISAM is

Re: How does the federated engine table work

wangxu wrote: How does the federated engine table work when the query statement include a join substatement, it joins a local table with innodb engine and a federated table. How does the server deal with the query substatement like this? Have you taken a gander at the documentation?

Drupal and MySQL

Has anyone heard of drupal breaking under a minor upgrade from Mysql 4.1.1X to 4.1.2X ? I have a weird one. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives:

Re: MySQL App development

[EMAIL PROTECTED] wrote: Is there anything called MySQL application development environment guide, as it is there DB2 (IBM) which explains how to work with MySQL and C++ together? Can you show me what DB2 does that's different from our C++ API? Or can I refer DB2 App guide? No -- Colin

Re: MyISAM Performance for fixed row_format

Boyd Hemphill wrote: The documentation for 4.1 says that changing to a row_format of fixed will increase disk look up. I did this with several tables where a query was taking about 3 minutes. I expected (from the doc and past experience) for the query to run in about 1 to 1 ½ minutes.

Re: MySQL+OpenVPN

Asif Lodhi wrote: Hi, Can anyone on this list tell me _how_ i can connect to my MySQL-5.0.22 server running on Windows-XP-SP2 using OpenVPN on Windows? It looks like a good VPN/SSL implementation. once you've got the VPN connection, just the usual: mysql -uUser -hHost -pPass How your VPN

Re: Connecting mySQL to ColdfusionMX7

Ruth wrote: All, I am having difficulties getting the Coldfusion Administrator to establish a database connection to a database called accounting that I created using the command line utility. Any help would be very appreciated This is the error that CF is throwing: Connection

Re: Drupal and MySQL

Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem wrote: Has anyone heard of drupal breaking under a minor upgrade from Mysql 4.1.1X to 4.1.2X ? No, upgrading between versions should be OK. Want to provide the exact version numbers, in the /rare/ event that the ABI

Re: MySQL 5.1

Logan, David (SST - Adelaide) wrote: Hi! Does anybody have any idea when 5.1 may come to General Release? I am particularly interested in MySQL Cluster as I have several databases (around 50) totalling 26Gb and would like to consider moving to this version because of the Cluster Disk Data

Re: Support for JDBC 4.0?

Steven Buroff wrote: Does anyone know if there are plans to add support for JDBC 4.0 to the java connector? I'm particularly interested in support for the Connection.createQueryObject(Class cls) method. Its mostly already there in the trunk, and keep in mind that JDK-6 (w/JDBC-4) isn't even

Re: Drupal and MySQL

On Thu, Aug 31, 2006 at 09:52:37AM +1000, Colin Charles wrote: Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem wrote: Has anyone heard of drupal breaking under a minor upgrade from Mysql 4.1.1X to 4.1.2X ? MySQL 4.1.18 to 4.1.21 No, upgrading between versions

Re: Drupal and MySQL

Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem wrote: On Thu, Aug 31, 2006 at 09:52:37AM +1000, Colin Charles wrote: Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem wrote: Has anyone heard of drupal breaking under a minor upgrade from

mysql-bin.00000X

there are ton of these files in my mysql data directory on fedora core 5 they are about a GB a piece. it appears that they are snapshots or some kind of log file. what is creating these files?

Re: Connecting mySQL to ColdfusionMX7

Ruth divulged the following in an email dated 8/30/2006 11:58 AM : All, I am having difficulties getting the Coldfusion Administrator to establish a database connection to a database called accounting that I created using the command line utility. Any help would be very appreciated

RE: mysql-bin.00000X

Hi Tanner, These are the binary logs. Look in your my.cnf file or check your system variable ( do this ) mysql show variables like '%log%'; and see if you have log-bin enabled. These are generally used for recovery from the last full backup (similar to logical/redo logs in other technologies)

Re: mysql-bin.00000X

Tanner Postert wrote: there are ton of these files in my mysql data directory on fedora core 5 they are about a GB a piece. it appears that they are snapshots or some kind of log file. what is creating these files? http://dev.mysql.com/doc/refman/5.1/en/binary-log.html -- MySQL General

Re: Mass E-mail Options

Again, I know this is not necessarily a MySQL specific question, and sorry for getting off target, but this is a pretty smart and experienced bunch, and I'm sure that someone out there will be able to help me. We have a web application in which we have a mass e-mail function. It allows the

Re: Mass E-mail Options

At 18:32 2006-08-30 -0700, Scott Haneda wrote: I would also try to unorder the email addresses, so that large groups of yahoo and aol etc emails do not hit the outbound queue at the same time. They tend to look down on that activity, and throttle you back, making it take even longer to get your

Re: Mass E-mail Options

You might put special-case conditons on specific domains, but actually, you're much better off ordering by domain because your server will end up sending _ONE_ message addressed to whatever number of recipients at that domain. If your list is truely massive, your MTA may be incapable of

Re: Mass E-mail Options

I would also try to unorder the email addresses, so that large groups of yahoo and aol etc emails do not hit the outbound queue at the same time. They tend to look down on that activity, and throttle you back, making it take even longer to get your messages out. You might put special-case

Re: Mass E-mail Options

At 22:22 2006-08-30 -0500, Philip Hallstrom wrote: But some providers will block based on number of recipients per message... so don't go crazy sending one message to 50,000 aol addresses, etc... Which is why you'd have conditions for special-case domains, which I *DID* point out in my post,