mysqlMax vs mysql

When installing the mysql4 binary it works fine. When installing the mysql max4 binary I get the following message when I try to run mysqld_safe. I am running linux redhat 9.1. Would anyone know why this is happening? 030728 23:54:57 mysqld started 030728 23:54:58 bdb:

Re: What is a good benchmark?

Now I am running these processes for my mysql serever /bin/sh /usr/local/mysql/bin/safe_mysqld --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/webrt.pid /usr/local/mysql-standard-4.0.13-sun-solaris2.8-sparc/bin/mysqld

Re: What is a good benchmark?

i got 0.96 on a dual XEON 2G 1G ram , its a dell box On Tue, Jul 29, 2003 at 01:41:00AM -0400, Asif Iqbal wrote: Solaris SPARC 420R 4 * 450 MHz, 4GB - 2.93 secs ... Yikes.. Any suggestion on how to improve it ? Get a faster CPU. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux

Re: Master/Master Asynchronous replication

On Mon, 28 Jul 2003 22:23:06 -0700, Jeremy Zawodny used a few recycled electrons to form: | On Wed, Jul 23, 2003 at 04:47:35PM -0400, Joe Gainey wrote: | | 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

using innodb

Hi all, I am trying to use mysql with innodb. After I set it up as follow. The db start failed. I wonder why it failed to use innodb. Does anyone can tell me? OS: redhat 7.2 with kernel 2.4.20-18.7 mysql version: 3.23.56 In mysql.log /usr/libexec/mysqld: unrecognized option

no subject

Hello List; I am developing a php-mysql application for my term project at school and this is where i seem to not going any further. I need to display alll tables that are holding records, so the user can make detailed selection over these tables.Since this is a student-grade database, there

Re: using innodb

On Tue, Jul 29, 2003 at 03:08:42PM +0800, unplug wrote: Hi all, I am trying to use mysql with innodb. After I set it up as follow. The db start failed. I wonder why it failed to use innodb. Does anyone can tell me? OS: redhat 7.2 with kernel 2.4.20-18.7 mysql version: 3.23.56

Re: TRUNCATE problem ...

Rafal, - Original Message - From: Rafal Kedziorski [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Monday, July 28, 2003 6:52 PM Subject: TRUNCATE problem ... hi, I have this table: CREATE TABLE `category_tree` ( `category_tree_id` BIGINT NOT NULL

mysqld stoped abnormally

hello I have a OpenBSD3.3 box ,defautl installed, with mysql-server 4.0.13, the mysql-server runs normally at the beginnig . Trouble come up these days that the mysqld server will down , and will come up sometimes but can not some other times. There's error messages appers that lost

How can I make this query more optimised?

Greetings I have a table with the following table structure - mysql desc email_table; +-+---+---+--+-+-+---+ | Field | Type | Collation | Null | Key | Default | Extra |

subselects or join?

Hi List, My head is not on right today. I have something like this: main_table id namemain_type 1 joe type1 2 johntype2 3 jacktype1 table type1 id_type1id action 1 1 2003-07-01 2 1 2003-08-03 3

RE: no subject

SELECT * FROM TABLE if( mysql_num_rows() == 0) table is empty HTH Peter -Original Message- From: D. K. [mailto:[EMAIL PROTECTED] Sent: 29 July 2003 08:12 To: [EMAIL PROTECTED] Subject: no subject Hello List; I am developing a php-mysql application for my term project at school and

RE: Category System schema

you need at least 3 fields CategoryID ParentID Name CategoryID is the key, and identifies the category ParentID is the CategoryID of the parent category Name is the category name When you add a sub category you set its ParentID to the CategoryID To show all sub categories of CategoryID 99

How To Perfrom Query on Two Tables

Hello All, I need to insert into mm_tagrules table from mm_tag table, in the following way. I am using mysql 4.0.12 version. But Mysql is not supporting subqueries. Can any one help mysql query for the following query. insert into mm_tagrules select ID, 'NIL', 'D' from mm_Tag where

which are the updated column?

HI, is there a way to obtain only the affected columns after an update query? After an update query, that involves 10 columns, I know that only 2 columns are really updated (because the values of the other cols don't change). I need to know the names of that changed cols, for logging purpose.

When mysql ruinned by Disaster

Hello, mysql, We have 1 master and salve in my lan. If the master failed,coze the unrecoverable disaster. At that time,I want to make the slave to be the master instead of the orginial one. Do you agree

utf8 in 4.1 for Windows

I have read in past postings that UTF8 is not yet working with MySQL 4.1 on the Windows build. Can anyone verify this? If it is not yet working, can anyone give an estimate when a build will be available that should work? thanks, Jon

Replication

Hello. I have MySQL 3.23.41 on a RH-7.2 Linux used as local server. I'm trying to replicate the databases from server (192.168.0.1) to another linux PC (192.168.0.3). Following the manual, i grant to the master a user with file privileges, and edit both my.cnf files. The master starts fine but the

affected columns

HI, is there a way to obtain only the affected columns after an update query? After an update query, that involves 10 columns, I know that only 2 columns are really updated (because the values of the other cols don't change). I need to know the names of that changed cols, for logging purpose.

Rebuilding Indexs on tables

Hi, I was wandering is there an easy way to rebuild indexs on tables I have the .frm and .MYD files. I read in the mysql manuals about backup_tables and Restore_table that rebuild the index but is there any other way to rebuild them. I'm using Mysql 3.23.53a on linux 2.1 AS thx Cecil Mnr

Re: Please URGENTLY Romanian charset Collate in MySQL

Iulian, take the source code, go to 'sql/share/charsets' and create your own character set 'romanian.conf' departing from 'latin2.conf' (or whatever is closest to what you need). Regards, Thomas Spahni On Mon, 28 Jul 2003, Primaria Falticeni wrote: Hello, Simply I made a table with romanian

Re: Replication

Hello, Am Dienstag, 29. Juli 2003 11:15 schrieb : Hello. I have MySQL 3.23.41 on a RH-7.2 Linux used as local server. I'm trying to replicate the databases from server (192.168.0.1) to another linux PC (192.168.0.3). Following the manual, i grant to the master a user with file privileges,

Re: How To Perfrom Query on Two Tables

Hi, join two tables in your select. Might look like insert into mm_tagrules select ID, 'NIL', 'D' from mm_Tag left join mm_tagrules on mm_Tag.ID = mm_tagrules.Tagid where mm_tagrules.Tagid IS NULL; Regards, Thomas Spahni On Tue, 29 Jul 2003, jsmurthy wrote: Hello All, I need to

affected columns

HI, is there a way to obtain only the affected columns after an update query? After an update query, that involves 10 columns, I know that only 2 columns are really updated (because the values of the other cols don't change). I need to know the names of that changed cols, for logging purpose.

mysql on SMP CPU under RedHat

Hello! I have a 2xPIV Xeon box under RedHat 8 system and want to use mysql 4.0.14. How I should setting mysql for best perfomance ? -- Mr. Andrew L. Davydov -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Rebuilding Indexs on tables

myisamchk is another option see 4.4.6 Using myisamchk for Table Maintenance and Crash Recovery in the mysql manual - Original Message - From: Cecil Brand [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:30 AM Subject: Rebuilding Indexs on tables Hi, I

Re: affected columns

I haven't seen anything in the mysql manual that will give you that information (to the best of my knowledge). You might have to do a get before the update and compare the fields manually. An elegant solution would be to use table triggers but this functionality is not yet available in mysql.

Re: installation problem Mysql 4.0.13 on Red Hat linux 6.2

rpm -ivt MySQL-server-4.0.13-0.i386.rpm returns Only one major mode may be specified this message is from the rpm utility and means that is it not being used correctly, there is no problem with mysql. maybe just try rpm -i MySQL-server-4.0.13-0.i386.rpm - Original Message -

Re: When mysql ruinned by Disaster

MaFai, But the ip address would change too If this system is running on a LAN why would it be a problem to change the DNS or are you trying to connect other clients (e.g. from the web?) - Andy MaFai wrote: Hello, mysql, We have 1 master and salve in my lan. If the master failed,coze the

Re: mysqld stoped abnormally

powercola [EMAIL PROTECTED] wrote: hello I have a OpenBSD3.3 box ,defautl installed, with mysql-server 4.0.13, the mysql-server runs normally at the beginnig . Trouble come up these days that the mysqld server will down , and will come up sometimes but can not some other times.

Re: affected columns

Wakan [EMAIL PROTECTED] wrote: is there a way to obtain only the affected columns after an update query? Instant answer: no. You could do some selects and compare the difference. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by

Re: mysql on SMP CPU under RedHat

Andrew L. Davydov [EMAIL PROTECTED] wrote: I have a 2xPIV Xeon box under RedHat 8 system and want to use mysql 4.0.14. How I should setting mysql for best perfomance ? First, you should download the official binary release from http://www.mysql.com/ Then, there is nothing so special in

Re: mysqlMax vs mysql

b b [EMAIL PROTECTED] wrote: 030728 23:54:58 bdb: /usr/local/mysql/data/log.01: Permission denied 030728 23:54:58 bdb: PANIC: Permission denied do chown -R mysql.mysql /usr/local/mysql as root. Replace user/group by appropriate. -- For technical support contracts, goto

Re: How can I make this query more optimised?

Try never to use formulas or functions in your WHERE clause, indexing can't be used if you have to perform a function on field data first. It looks like you are trying to filter on the id, so you shouldn't be using concat and substring in your filter. Change you WHERE clause to look like

mysql BUG, again ;)

Hi, I would like to know if you could fix the bug I reported to you some days ago. The error is: ERROR 1030: Got error 139 from table handler after running an update command using several blobs. Now I am using mySql 4.0.15 and Linux. If you try to do the same with mySql

Error code 1064 in another application...

I am running mysql 4.0.13 and using a weblog(Geeklog) to do my web. Using geeklog as been okay until I tried creating moderators to my forum and then I got the following error: 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right

Re: Replication

I give in my slave PC a file privilege in the same user as the master but there is still error in my log file. Deferent these time: Slave: connected to master '[EMAIL PROTECTED]:192', replication started in log 'FIRST' at position 4 Error reading packet from server: Binary log is not open

RE: Select with join query question

This gives the count per job which is always 1. I'm using the 'having' clause which requires the 'status' field in the select list. This makes it difficult to get a total. I'll play with the 'where' clause example to see if that works. Thanks again! -Original Message- From: Bruce

Re: Select with join query question

Richard Bolen wrote: This gives the count per job which is always 1. Oops! Quite right. I don't see a way to get the total off-hand. Bruce -Original Message- From: Bruce Feist [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 7:42 PM To: Richard Bolen Cc: [EMAIL PROTECTED];

text search question

Hi I have a varchar field to search. There are 5k records. I'm using: WHERE name LIKE '%outer banks%' It seems to be very slow. I was reading about full text searches. Maybe I could do something like: WHERE MATCH ('name') AGAINST ('outer banks') I'm looking for a quick way to search. Does

Left Join multiple tables

Hi List Me again. I'm trying to return from multiple tables, the records that have field information_sent between two dates. The tables are all related by means of the id of the entry in the main table, ie.. main id entity_name ... fof id_fof id information_sent ... pub id_pub

Check table wildcard syntax?

I need to do CHECK TABLE on a lot of tables (actually on all tables in several databases), and hoped to do something like mysql CHECK TABLE reports.* which ddn't work. The only thing that seems to work is using cut'n'paste (or some scritpting) to get a comme seperated list. Is there

Re: What is a good benchmark?

In the last episode (Jul 29), Asif Iqbal said: Now I am running these processes for my mysql serever /bin/sh /usr/local/mysql/bin/safe_mysqld --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/webrt.pid /usr/local/mysql-standard-4.0.13-sun-solaris2.8-sparc/bin/mysqld

Re: Check table wildcard syntax?

The recommended way to quickly check all tables is: myisamchk --silent --fast /path/to/datadir/*/*.MYI isamchk --silent /path/to/datadir/*/*.ISM that's from the mysql manual, sectio 4.4.6 Using myisamchk for Table Maintenance and Crash Recovery - Original Message - From: Sigurd

how listen queue size affect MySQL on RedHat

Hi all, i want to know if the system parameter somaxconn affect the capabalities of MySQL to maintain more than five thousands of HTTP connections ? If so , any clarifications may help. think in advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: What is a good benchmark?

On my E420R with 4 x 450MHz and 4 gb mem what mysql variables should I need to play with to improve the following output mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) |

Re: text search question

Since you are putting a wild card at the front of the phrase, indexes can't be used. You definitely want to change that to a full text index if you want to search on words or phrases contained in a field. I use a full text search on a database with 15k records and growing. Each record contains

Re: mysql BUG, again ;)

Dyego, but now it works right. [EMAIL PROTECTED]:~/mysql-standard-4.0.8-gamma-pc-linux-i686/bin perror 139 Error code 139: Unknown error 139 139 = Too big row (= 16 M) The error message text above is wrong, though :). This has nothing to do with 16 MB. You should not put THAT many BLOBs in

Re: Check table wildcard syntax?

Matthew McNicol [EMAIL PROTECTED] writes: The recommended way to quickly check all tables is: myisamchk --silent --fast /path/to/datadir/*/*.MYI isamchk --silent /path/to/datadir/*/*.ISM I thought the recommended way was using CHECK/ REPAIR TABLE from inside mysql for the supported

Re: mysql BUG, again ;)

On Tue, 29 Jul 2003, Dyego Souza do Carmo wrote: I would like to know if you could fix the bug I reported to you some days ago. The error is: ERROR 1030: Got error 139 from table handler after running an update command using several blobs. Now I am using mySql 4.0.15 and

Re: Check table wildcard syntax?

I thought the recommended way was using CHECK/ REPAIR TABLE from inside mysql for the supported backends? Also, (my)isamchk can't be run while the database is running, can it? (I might be confused here) I'm just reading from the manual... it's not totally clear... perhaps someone else will

problem installing mysql

I have tried to install mysql 4.0.14 and previous version on my machine. After installation when I try to run mysql, i get error: Cannot connect to localhost port... my machine is not connected to internet. I also have firewall installed on my machine, but this should not matter. Any

Re: Error code 1064 in another application...

If your query has worked in one account, but not in another, then your 1064 error is probably related to privileges granted to the second account. HTH Ola Ogunneye [EMAIL PROTECTED] 07/29/03 09:08AM I am running mysql 4.0.13 and using a weblog(Geeklog) to do my web. Using geeklog as been okay

Select problem

Hi all, I have a table with the following data: ++---+--+ | lpcval | smiles_id | crhash | ++---+--+ | 0.81 | 996 | 0597b6f84e0feaf9596869284e6e0660 | | 0.86 |

mysql vs mysqlMax

Hi, When installing the mysql4 binary it works fine. When installing the mysql max4 binary I get the following message when I try to run mysqld_safe. I am running linux redhat 9.1. Would anyone know why this is happening? 030728 23:54:57 mysqld started 030728 23:54:58 bdb:

Re: Check table wildcard syntax?

Hi! On Jul 29, Sigurd Urdahl wrote: Matthew McNicol [EMAIL PROTECTED] writes: The recommended way to quickly check all tables is: myisamchk --silent --fast /path/to/datadir/*/*.MYI isamchk --silent /path/to/datadir/*/*.ISM I thought the recommended way was using CHECK/ REPAIR TABLE

Re: Error code 1064 in another application...

Sorry, I maight not have been clear about what I wrote, there is only one user account in mysql and that user is ola, I was saying that username Administrator only exist in Windows 2000 Server and not in MYSQL, and that because each time, I log into the PC as Administrator and not as user ola who

Using data in one table to update data in another table

Hi All, Is it possible in MySQL to use UPDATE to update fields in one table with data from another table? For example, the following code seems to be the answer but fails with a syntax error in MySQL: UPDATE test_demo1.products SET nontaxable=(SELECT IMFSalesTax FROM IDX.InvMasFile); Here

mysql vs mysqlMax

Hi, When installing the mysql4 binary it works fine. When installing the mysql max4 binary I get the following message when I try to run mysqld_safe. I am running linux redhat 9.1. Would anyone know why this is happening? 030728 23:54:57 mysqld started 030728 23:54:58 bdb:

Re: fulltext indexing and query speeds?

Hi! On Jul 29, Niels Larsen wrote: Sergei, I had two columns indexes of type BTREE where the .MYI file was ~5 gb. Then I decided to drop one of them and replace it with a fulltext index. The dropping took 4 hours and fulltext indexing also 4 hours. There were about You should've done it in

RE: Deleting duplicating records

Karam If your installed MySQL version supports sub-query, try this: Delete your_table t where (t.email, t.version) not in ( select s.email, min(s.version) from your_table s group by s.email ) Hope this helps. Lin -Original Message- From: Karam

Basic Database Design Question

Hello, DB novice checking in here with a basic design question. I have a table called 'nms_apps' which stores information about all of our applications which we have developed/maintained for our client. One column which I would like to use is called 'used_by', which would store information

Really slow shutdown with Innodb, db not accessible?

For the last four hours or so, I've been waiting for MySQL (4.0.12 on W2K) to complete a shutdown. The fast shutdown flag is not set (innodb_fast_shutdown=0), so I assume it is doing a purge and merge... but in the meantime, I don't have any access to the server -- clients simply can't connect.

RE: Basic Database Design Question

This is, as you guess, a very basic issue for relational databases. You never want to put multiple entries in one column, as you describe it. That's the scenario in which you create another table and use a key to join the two. For your project, you should have a column in the nms_apps table that

Re: problem installing mysql

Make sure your firewall isn't blocking port 3306 (the default tcp port) on localhost (127.0.0.1). Firewalls DO matter. I have tried to install mysql 4.0.14 and previous version on my machine. After installation when I try to run mysql, i get error: Cannot connect to localhost port... my

mysql4.1 install question

I installed the 4.1 alpha release, which I probably shouldn't have, but I did because the 4.0 was giving me access denied error (before I found your mailing list). However my problem got complicated because I installed this on a server which would eventually be a web mail server. So I

Fw: mysql4.1 install question

the configure command for courier-imap is the ff: ./configure --prefix=/usr/lib/courier-imap --with-authmysql --without-pgsql --with-mysql-libs=/usr/local/mysql/lib --with-mysql-includes=/usr/local/mysql/include the actual errors are the ff: configure: error: --with-authmysql specified but no

Error compiling MySQL 4.0.14 on Slackware GNU/Linux

I'm using Slackware GNU/Linux 9.0 on an Intel PII 266 machine that's SMP capable, but only with one CPU installed, and 64MB of RAM. It's basically a small test system that I play around with in some free time before installing things on my larger systems. I am trying to do a fresh install of

MySQLD Binary Log

We've been using MySQLD for a few years now quite happily. It's amazing how well it performs. However, I have a minor issue, and I'm not sure how to deal with it. I've scoured the manual, searched list archives, the web, etc., and am coming up empty. Somehow, the server is recording the Binary

Re: MySQLD Binary Log

The following is my guess, give it a try if you want: Make sure that in your config file, log-bin isn't present, delete all the log files, as well as the host-bin.index file and restart MySQL. I utilize my log files, so I can't say how to stop them totally. -- Tony Evans Webmaster/DNS

RE: Basic Database Design Question

You could do it many different ways. Here's one that I would consider: Create a table to store the business sections (buss_section) and a table to relate the apps with the business sections (app_buss_section). The design would abstract the app info from its usage and create a manageable table of

Missing row

Hi, small but disturbing oddity, this. I have a simple table: CREATE TABLE musician ( musicianid int(10) unsigned NOT NULL auto_increment, name varchar(60) NOT NULL default '', PRIMARY KEY (musicianid) ) Type=MyISAM; There are 50 or so lines in the table. I inserted 2

batch mode

I am trying to right sql statement on the shell prompt but its not going through. Here is the statement: [EMAIL PROTECTED] usr]# mysql security select * from machine; -bash: select: No such file or directory It is asking for the text file. And it works fine with the text file. I am wondering

Re: fulltext indexing and query speeds?

Sergei, Thank you for the nice help. Try to experiment with bulk_insert_buffer variable. You need both big keycache and big bulk_insert_buffer. I lowered key_buffer_size from 512M to 256M and increased bulk_insert_buffer_size from 8M to 128M. When MERGE tables will support fulltext

Re: Select problem

Dermot Frost wrote: Hi all, I have a table with the following data: ++---+--+ | lpcval | smiles_id | crhash | ++---+--+ | 0.81 | 996 |

Re: Using data in one table to update data in another table

Chris Nighswonger wrote: Hi All, Is it possible in MySQL to use UPDATE to update fields in one table with data from another table? For example, the following code seems to be the answer but fails with a syntax error in MySQL: UPDATE test_demo1.products SET nontaxable=(SELECT IMFSalesTax FROM

Re: batch mode

azamka wrote: I am trying to right sql statement on the shell prompt but its not going through. Here is the statement: [EMAIL PROTECTED] usr]# mysql security select * from machine; -bash: select: No such file or directory echo select * from machine | mysql security or put your select

Re: Really slow shutdown with Innodb, db not accessible?

Nick, - Original Message - From: Nick Arnett [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, July 29, 2003 8:54 PM Subject: Really slow shutdown with Innodb, db not accessible? For the last four hours or so, I've been waiting for MySQL (4.0.12 on W2K) to complete

Mini PC Server Hardware Review

Hi All; These might be of interest to some on this list: http://www.vbmysql.com/articles/microserverhp.html I recently got my hands on a MicroServer HP by NorhTec in Calgary. It is an interesting box and could be useful for certain MySQL related applications.

Transactions

Most web hosting companies run the mysql standard. Which means one can't run transactions. If that is the case, then how do you handle many to many relationships with truely normalized manner without risking data corruption For example: You have an org, ctry tables and a middle table orgCtry.

Re: batch mode

On Tue, 2003-07-29 at 15:19, azamka wrote: [EMAIL PROTECTED] usr]# mysql security select * from machine; -bash: select: No such file or directory EEK! What you told the shell to do was open a file called select and redirect it to mysql. What you meant to do was echo 'select * from

What is the most effective structure for tables and indexes in this case??

Hi. Have one table with FIXED row length. Table name: thetable. Field 1: MemID (mediumint). (relates to another table members) Field 2: TheID (smallint). Primary key: MemID, TheID. Lots of fields. Fixed table length. I want to make it possible for users to search for records in this table

RE: Really slow shutdown with Innodb, db not accessible?

-Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 12:58 PM crash recovery is usually much faster than purge and merge. Killing the mysqld process is a legal (and the fastest :)) way of shutting down InnoDB. That's good to hear. W2K

Re: batch mode

In the last episode (Jul 29), Peter L. Berghold said: On Tue, 2003-07-29 at 15:19, azamka wrote: [EMAIL PROTECTED] usr]# mysql security select * from machine; -bash: select: No such file or directory EEK! What you told the shell to do was open a file called select and redirect

Re: Transactions

In the last episode (Jul 29), b b said: Most web hosting companies run the mysql standard. Which means one can't run transactions. If that is the case, then how do you handle many to many relationships with truely normalized manner without risking data corruption For example: You have an

Re: Left Join multiple tables

* Petre Agenbag I'm trying to return from multiple tables, the records that have field information_sent between two dates. The tables are all related by means of the id of the entry in the main table, ie.. main identity_name ... fof id_fofid information_sent ...

what does it mean? bug or feature?

Hello mysql, mysql version: 4.0.14-standard for linux linux kernel: 2.4.21 mysqladmin -umef -p shutdown Enter password: ./bin/mysqld_safe: line 1: 31500 Segmentation fault nohup /usr/local/mysql/bin/mysqld --defaults-file=/var/lib/mysql/my.cnf --basedir=/usr/local/mysql

Re: Really slow shutdown with Innodb, db not accessible?

Nick, - Original Message - From: Nick Arnett [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 1:24 AM Subject: RE: Really slow shutdown with Innodb, db not accessible? FYI, as I looked at the code that led up to this, I have

Re: Transactions

Well said Dan. While foreign keys, cascades and built-in transactions are convenient, atomicity and referential integrity are readily attained by proper implementation and the appropriate code. soap box Setting buffers,dirty flags and commit functions really is the responsibility of the

Re: Left Join multiple tables

Petre, What I think you want is, For each main, with at least one fof,pub... in the date range, a row with the id and for fof,pub a value within range or null What you are probably getting is, For each main, with at least one fof,pub... in the date range, several rows, where

innodb data file of different size

I just decided to use my.cnf and bumped into this error message 030729 22:04:22 mysqld started InnoDB: Error: data file /usr/local/mysql/data/ibdata1 is of a different size InnoDB: 81024 pages (rounded down to MB) InnoDB: than specified in the .cnf file 16384 pages! InnoDB: Could not open data

Re: Transactions

Good point. However, I disagree with you on fundemental points. Subsystems within an application should remain indepedant for a easier maintanance and better software development process. Here we have a multi tiered system whereby the database can't guarantee it's integrity without good

RE: SELECT problem

Hi, Rachel, It seems most people have missed this message. Since you didn't give enough information in your question, in order to answer your question, I need to make up some assumptions, which might or might not be correct :-( Suppose the same favsub could appear in either or both

A Complicated Join

I've been browsing through posts here, but I haven't found anything relevant to my issue, so I guess I'll just post it myself: I have three tables: users, groups (which define collections of users), messages, and replies (replies are completely different from messages and warrant their own

Re: A Complicated Join

I've been working on something similar to this for quite a while (few more steps, maybe), and this list helped me through it, so I suppose I can at least return the favor. You basically need to do the following (I'm using temporary tables to help me think through it - and because of the lack

Re: Updating a nested set

I'm about to dig a bit deeper into Celko's articles and love the idea of nested sets. Still trying to pull some time to start implementing this myself. Anyway, I don't really have an answer for you but you might want to take a look at PEAR::DB_NestedSet, as it sounds very able to work with nested

Re: using innodb

I use rpm to update the previous version. I can use innodb in redhat 9 with version 2.23.56. But it failed in redhat 7.2. I wonder it is the kernel problem. BTW, I want to ask whether I can do replication in the following case. innodb (master) --replication -- myisam (slave) unplug

RE: no subject

At 9:27 +0100 7/29/03, Peter Lovatt wrote: SELECT * FROM TABLE That will perform a complete table scan and transfer the entire contents of the table over the network. Much better to run SELECT COUNT(*) FROM tbl_name Which will be very quick (for MyISAM tables, at least), and in all cases will

Re: how listen queue size affect MySQL on RedHat

At 14:53 + 7/29/03, [EMAIL PROTECTED] wrote: Hi all, i want to know if the system parameter somaxconn affect the capabalities of MySQL to maintain more than five thousands of HTTP connections ? If so , any clarifications may help. think in advance MySQL doesn't have anything to do with HTTP

Re: Check table wildcard syntax?

At 16:26 +0200 7/29/03, Sigurd Urdahl wrote: I need to do CHECK TABLE on a lot of tables (actually on all tables in several databases), and hoped to do something like mysql CHECK TABLE reports.* which ddn't work. The only thing that seems to work is using cut'n'paste (or some scritpting)

  1   2   >