MySql 4.0.3 Feature question.

In searching through the list archives to see if MySql 3.23 supported descending keys (which I didn't think it did, but it was worth a try), I found a post that said MySql 4.0.2 was expected to support this. MySql 4.0.3 is now out, but in reading through the website, I was not able to find any

Constant deletion/truncation = OK? (help with a scenario)

hi, i have a need for inserting into a table very frequently (several 1000s of records per minute). now, at the end of every hour or so, i need to tally the records in the first table, put ONLY the counts into a second table, and then delete the thousands of entries in the first one which are

need help on a SQL query: need LEFT JOIN?

I apologize for asking such a basic SQL question, but I am failing in finding the solution... Consider the following table: id | option --- 1 | a 2 | a 2 | b I want to find the ids with only a specific set of options. For example, if I wanted to get the ids which have option a only,

Re: stored procedures and triggers

I have to agree here.If one doesn't know the schema and has to figure out how to locate keys in related tables, then one's not paying too much attention to the constructs of the data set. Lets not forget joins, eh? What network traffic? The list of tables? How much traffic is there in a

Re: urgent ...

Sekhar.Thota wrote: Hi, I have did setup for MySQL - Innodb tables. But I am not getting support for row level locks. Whenever I am issuing a update the innodb tables are locking my tables. Please help me whether I need to set any variables in sqld file to get the support for row level

Re: mysql gcc 3

Lenz Grimmer [EMAIL PROTECTED] writes: On Tuesday 20 August 2002 10:33, Marc Roos wrote: When will testing be finished of compiling mysql with gcc 3? We already successfully compiled MySQL with gcc 3.1 and have just started some tests with gcc 3.2 - so far it looks good... Gcc 3.2

Linux vs Solaris

Hi I'm having a very weird problem. I switched my MySQL server from Solaris to Linux on Compaq. I applied the same configuration file but I'm experiencing problems. The new Compaq / Linux server is many times faster than the Solaris I had But when load comes, it crashes. It works great for a

Re: data migration

Hi, You may look up this URL for data migration: http://www.mysql.com/portal/software/html/software_comments-124.html Good Luck, /Khanh HI ALL, Does anyone know of a simple way of migrating JUST data from a sybase ASE server to mysql ? Please Help :) Thanks Tonino

Re: InnoDB locks disappear

Wouter, - Original Message - From: Wouter Zelle [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, September 04, 2002 10:59 AM Subject: Re: InnoDB locks disappear Heikki, Unfortunately it is not that easy. I've set the innodb_lock_wait_timeout to 1 because I want

Re: Re: Install questions

On Wed, 2002-09-04 at 04:42, Victoria Reznichenko wrote: 1. Check [MySQL] section of the php.ini, you can find mysql.default_socket here. This value is empty, indicating a default port 2. You can specify another path to the socket file for the MySQL server with --socket=# mysqld option.

RE: InnoDB Question

This implies that I have to preguess how large each data file will be. Correct. However, all InnoDB tables will share this space automatically. (Corrolary: A single table will automatically span several InnoDB data files if need be.) Now, I understand with MyISAM tables that they just grow

query problem

Hi. I have two tables with the following structure: Users: +--+--+--+-+-+-- --+ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+-+-- --+ | id

Re: Filemaker database to MYSQL

I have not done this, but I know you can do it in a round-about way. You can download the MSDE from Microsoft and convert it to one of numerous db formats, and from there MYSQL will import it. Filemaker Pro 5.0 with their ODBC driver is needed though. FMP is not 100% ODBC compliant, but you

2**32(4GB) problem on FreeBSD

Hello Everyone, I have a strange situation in that MySQL 3.23.49 on FreeBSD 4.6 installed from the ports collection seems to be having an issue with 4GB files. When I issue a checktable I get back the message of Datafile is almost full, 4026103700 of 4294967294 used. I thought this odd

RE: Auto_increment

MySQL Can the AUTO_INCREMENT feature be used to control a sequential number list that re-uses numbers that are subsequently removed ? Cheers Dave. - Before posting, please check: http://www.mysql.com/manual.php (the

Need help with Statically Compiled MySQLGUI 1.7.5-1

Hi, I am a not yet that experienced with System Administration and need a little holding hand here if possible. I am running Red Hat 6.2 with MySQL installed and running. Frankly I have read the README and HELP and still not sure as to what I am suppose to do with the my.cnf. When I try to

Re: mysql 'enum' column values

Hi. On Wed 2002-09-04 at 09:41:02 -0500, [EMAIL PROTECTED] wrote: At 07:05 AM 9/4/2002, you wrote: Is there a way I can get what the allowed values of an 'enum' coulmn are in mysql? I want to eventually list these values in a list box or something similar? mixo, I can't see an

RE: data migration

Hi, I am using sqlporter utility for the data migration. You can download the trail version and can use. Regards, Sekhar -Original Message- From: Khanh Pham-Phu [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 9:32 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject:

Creating indexes on large tables -- tmp directory is full

Is there a way to change the directory used when mySQL copies the table for creating indexes on large tables? My tmp directory is partitioned for 509 megs and adding an index via ATLER TABLE or CREATE TABLE yields this: ERROR 3: Error writing file '/tmp/STFgNG04' (Errcode: 28) the .MYI file

BeginTrans - Commit - Rollback on MySQL

Hi All, I am trying to establish a transaction-oriented method of posting changes on the MySQL database. I'm using MyODBC 3.51 and VB6. Using the ADO Controls, I use connection.BeginTrans to start the transaction, followed by a series of ado.updates, and finally a connection.committrans to

Date_Format

Hi, This might be a strange question, but can you do date_format when you do a myrow? Or does date_format as always have to be done in a sql statement? Does anyone have an easy of doing dates? Chuck Payne Magi Design and Support

performance with many clients

(description of the situation first, question at the end) Using: - MySQL-3.23.49a - Linux Red Hat 7.2 (SGI XFS patch) - 2xPIII/700, 1GB RAM, 4x36GB SCSI RAID5, Mylex DAC960 The system runs a custom syslogd ( http://sourceforge.net/projects/msyslog/ ) that logs the messages in MySQL instead of

Weird error message

Hi, I am getting a weird error message in mysql. I am doing this query SELECT t0.sid, t1.stid, t0.clubname, t1.longheadline FROM club t0, story t1 WHERE t0.sid = t1.siteid AND t1.hold='no' AND t0.test = 0 AND t1.synd = '1' AND t0.sport='football' ORDER BY `stid` DESC LIMIT 10; and I am

Re: simple update!!!

sql,query please respond directly, not part of list yet. This is crazy, ok. I am trying to update lot's of tables. Can I do this in one command? If so, what is the command. I've tried everything. Nothing works. I can only update one table at a time. I am s buying a book.

re-install on linux

Hi I was running my mysql 3.23. on redhat 6.2 I uninstall it using the rpm -e command then I went into var/lib/mysql deleted the dbase and all mysql directoring. I then re-install mysql mysql version,client,devel,shared when I run: rpm -qa | grep MySql result : I only see

Problem with TEMPORARY TABLES

Dear developer(s), I tried to use MySQLGUI 1.7.5 for Windows, downloaded from the mysql.com-website. I had problems with using temporary tables. First I created such a table. Then I did a INSERT ... SELECT statement to insert rows into this temporary table and then I tried to SELECT from this

Re: need help on a SQL query: need LEFT JOIN?

Does this work? select t.id,t.option,t2.option from tableName t left join tableName t2 on t.id=t2.id and t2.option!=t.option where t.option=a and isnull(t2.option); HTH, Jed On the threshold of genius, [EMAIL PROTECTED] wrote: I apologize for asking such a basic SQL question, but I am

Re: Fwd: Crash when adding field

Regarding the above crash after adding the ENUM column, I have tested it and it worked for me. Could you also verify this from our BK 4.0 repository ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__

Table partitioning functionality

Hi, Does MySQL offering a similar functionality as Oracle does with table partitioning? Oracle can split a table into several pieces where the pieces are - usually - identified by a range of valus. For example, one may split a table holding data on a daily basis into monthly partitions.

Re: Weird error message

Yup I used repair table as well. Also I have resarted mysql and that made no difference John - Original Message - From: Karthik [EMAIL PROTECTED] To: John Wards [EMAIL PROTECTED] Sent: Thursday, September 05, 2002 11:11 AM Subject: Re: Weird error message Hi, Try using this command

mysqldump --xml quasi-bug

(Sorry for posting this here, but [EMAIL PROTECTED] bounced this mail as off topic and suggested that i post it here.) Hello, mysqlers... (first post from a long-time mysql user) i recently learned that mysqldump has an --xml flag to dump out a db into XML. COOL! Except that it mangles data

Probem creating User Defined Functions

Hi All! I have created a user defined function exampleFun.c and have complied it to exampleFunc.so code for compiling exampleFunc.c to exampleFunc.so is gcc -I/usr/local/mysql/include -L/usr/local/mysql/lib/ \ -c -fpic exampleFunc..c ld -b -dy -G -lmysqlclient -lc

Corrupt table recovery

I recently posted about my corrupt table where no matter what options I tried REPAIR TABLE and myisamchk would recover the table but in the process reduce the size from 27,000 rows to just 1000. Not very useful. In the end I managed to get almost all my data back by using a hex editor and a

Re: Weird error message

John, and I am getting this error message ERROR 1030: Got error 28 from table handler # perror 28 Error code 28: No space left on device Free some disk space! I have figured out that it is t0.test that is causeing the problem as when i remove it the query works. This query has been

Re: Table partitioning functionality

Hi, No, I'm afraid. MyISAM tables cannot be cut in several pieces. But check ot the InnoDB table type, because they work very similar to Oracle. InnoDB uses tablespaces, and there can be many of them, maybe with autoextend functionality. I know it is not the same you would like, but maybe you

Re: Re: Re: Install questions

Matt, Thursday, September 05, 2002, 9:33:25 AM, you wrote: MTW On Wed, 2002-09-04 at 04:42, Victoria Reznichenko wrote: 1. Check [MySQL] section of the php.ini, you can find mysql.default_socket here. MTW This value is empty, indicating a default port You can specify location of the socket

Re: Need help with Statically Compiled MySQLGUI 1.7.5-1

PathFinder, Wednesday, September 04, 2002, 10:25:46 PM, you wrote: PS I am a not yet that experienced with System Administration and PS need a little holding hand here if possible. PS I am running Red Hat 6.2 with MySQL installed and running. PS Frankly I have read the README and HELP and

Recommend free MySQL host for webdev demos?

Can anyone recommend a decent free web host suitable for demo-ing MySQL-based web development projects? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Character set

Hi. I have installed SuSE Linux 8.0 Proffessional and the MySQL that came with it. If anyone of you has done the same he must have realized that many of the files are quite different than the files of MySQL that came with the standard installation described in the maual. My problem is that I have

Character set

Hi. I have installed SuSE Linux 8.0 Proffessional and the MySQL that came with it. If anyone of you has done the same he must have realized that many of the files are quite different than the files of MySQL that came with the standard installation described in the maual. My problem is that I have

Re: Character set

Hi. I have installed SuSE Linux 8.0 Proffessional and the MySQL that came with it. If anyone of you has done the same he must have realized that many of the files are quite different than the files of MySQL that came with the standard installation described in the maual. My problem is that

Client on windows SLOOOOOOOOOOOOOOOOOW

Hi all, I am a beginning user of mysql I installed the server, no problems there. Did some tests and it really looks nice to learn, I am a very beginning user so i tested a query on the server Select user,host,password from user; This works fine and fast but i installed the GUI on an winXP

Replace command

Hello everybody... I have a table with 3 columns (companyno, discountgroup, discount) it can look like this companyno, discountgroup, discount 12345,1,10 12345,2,20 12345,3,0 98765,1,15 98765,2,10 Can I use the

MySQL, perl, DBD and unique test problem

Trying to install DBD::mysql into a perl installation in my home directory. The MySQL server is installed on the same host, but it is managed by the web-hoster (i.e. I have to link to their libs, and can't upgrade MySQL). I have created a script (prep.sh) to run perl Makefile.PL with the

MySQL, perl, DBD and unique test problem

Trying to install DBD::mysql into a perl installation in my home directory. The MySQL server is installed on the same host, but it is managed by the web-hoster (i.e. I have to link to their libs, and can't upgrade MySQL). I have created a script (prep.sh) to run perl Makefile.PL with the

MySQL, perl, DBD and unique test problem

Trying to install DBD::mysql into a perl installation in my home directory. The MySQL server is installed on the same host, but it is managed by the web-hoster (i.e. I have to link to their libs, and can't upgrade MySQL). I have created a script (prep.sh) to run perl Makefile.PL with the

Informix Migration.

I have seen recently an article referencing a product called sqlporter. According to that article it was supposed to migrate informix to Mysql. On the website they do not quote this, and I have had no word from their tech support. Does anyone know of any other products / scripts that can do

Windows Lowercase issue

We have a database running on a linux box, we decided to replicated it to one of our NT boxes(this was a while ago, so a large amount of data has been transfered). So anyways, at the time I didn't know there would be an issue. So recently I dumped the data and imported it into our development

Re: Weird error message

perror 28 No space left on device. I guess your disk is getting full. John Wards wrote: Hi, I am getting a weird error message in mysql. I am doing this query SELECT t0.sid, t1.stid, t0.clubname, t1.longheadline FROM club t0, story t1 WHERE t0.sid = t1.siteid AND t1.hold='no' AND t0.test

One of those What the heck?! messages

Can anyone tell me what this means??? Master_User: repslave2 Master_Port: 3306 Connect_retry: 60 Log_File: QBSLXDB1-bin.058 Pos: 52706154 Slave_Running: No Replicate_do_db: qbslive Replicate_ignore_db: Last_errno: 4294967295

Re: Need help with Statically Compiled MySQLGUI 1.7.5-1

It is just a config file. You don't run it. PathFinder Software wrote: Hi, I am a not yet that experienced with System Administration and need a little holding hand here if possible. I am running Red Hat 6.2 with MySQL installed and running. Frankly I have read the README and HELP and still

Re: Problem with TEMPORARY TABLES

Myan GUI based clients use a new connection for each query, and therefore can not be used to test locking or transactions. Stefan Kroon wrote: Dear developer(s), I tried to use MySQLGUI 1.7.5 for Windows, downloaded from the mysql.com-website. I had problems with using temporary tables. First

Re: Client on windows SLOOOOOOOOOOOOOOOOOW

Check your DNS. Philippe Dhont (Sea-ro) wrote: Hi all, I am a beginning user of mysql I installed the server, no problems there. Did some tests and it really looks nice to learn, I am a very beginning user so i tested a query on the server Select user,host,password from user; This works

References to set up a caching mysql box

Hello all We want a fast box which will only handle username/password queries. I got a recommendation to look into a dedicated mysql box, setup so that it apparently caches large amounts of the data from the database in RAM for very fast lookups. Sounds great, but I have never done anything to

Re: One of those What the heck?! messages

Hi. On Thu 2002-09-05 at 09:29:41 -0400, [EMAIL PROTECTED] wrote: Can anyone tell me what this means??? Master_User: repslave2 Master_Port: 3306 Connect_retry: 60 Log_File: QBSLXDB1-bin.058 Pos: 52706154 Slave_Running: No

Replication problem: slave can't log into master

I am attempting to setup MySQL replication between the ctiadb1 (master) server and the ctiadb2 (slave) server. When I look at the mysql.log file on the slave, I see the following (repeated every 60 seconds): 020904 12:00:30 Slave thread: error connecting to master: Access denied for user:

ado/mysql problem

Hi After uppgrade mdac from 2.5 to 2.7 I get wrong types. An unsigned integer column was previously reported to be of type 3 (Integer) now it is returned as type 5(double). This atleast happens when im using getrows() in the recordset object. Can anybody tell what is going on here ? Im using

RE: ado/mysql problem

Yep, I had issues too... I've dropped back to MDAC2.5 and all is well. .b -Original Message- From: Dan Johansson [mailto:[EMAIL PROTECTED]] Sent: 05 September 2002 15:03 To: [EMAIL PROTECTED] Subject: ado/mysql problem Hi After uppgrade mdac from 2.5 to 2.7 I get wrong

MySQL performance questions

Rummaging through some docs on performance and have come up with some questions. Let me preface by saying, we don't have any performance problems. I inherited this monster of a database and am running through the configuration to make sure that it is indeed setup for optimum performance. For

Bad table conversion

I was using phpMyAdmin to do some user management and since it was fairly slow, decided to try upgrading my mysql.users and mysql.db tables to InnoDB format. It seems however that this is a bad thing as mysql told me when it refused to restart. I've recovered the users table from a backup

RE: One of those What the heck?! messages

On Thu 2002-09-05 at 09:29:41 -0400, [EMAIL PROTECTED] wrote: Can anyone tell me what this means??? Master_User: repslave2 Master_Port: 3306 Connect_retry: 60 Log_File: QBSLXDB1-bin.058 Pos: 52706154 Slave_Running: No

Re: ado/mysql problem

I know the same issus exist on XP. One can't downgrade mdac on XP ?? So I really would like an other solution. /Dan Ben Joyce wrote: Yep, I had issues too... I've dropped back to MDAC2.5 and all is well. .b -Original Message- From: Dan Johansson [mailto:[EMAIL PROTECTED]] Sent:

RE: ado/mysql problem

ahhh, hmm, erk... have you checked the MDAC site and MSKB for known bugs? -Original Message- From: Dan Johansson [mailto:[EMAIL PROTECTED]] Sent: 05 September 2002 15:19 To: Ben Joyce Cc: [EMAIL PROTECTED] Subject: Re: ado/mysql problem I know the same issus exist on XP. One

innodb questions about message board apps

Hi all, I've been reading a bit on the innodb table type for mysql here and on the site and some other board sites and just wanted to ask a quick question or two in general about it, as it relates mostly to message boards and compared to myisam. Is the only gotcha in forum code generally the

Re: 2**32(4GB) problem on FreeBSD

Hi JC, From http://www.mysql.com/doc/en/Table_size.html (I searched on size) If you need bigger tables than 4G (and your operating system supports this), you should set the AVG_ROW_LENGTH and MAX_ROWS parameter when you create your table. See section 6.5.3 CREATE TABLE Syntax. You can also

SQL error number -30996

I am getting error number -30996 when trying to update a MySQL BDB type table using transaction logging. Can anyone tell me what this number means, or where I can get a list of BDB error numbers? Thanks Vivien -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ -

Re: Re: simple update!!!

Grant, Thursday, September 05, 2002, 1:12:23 PM, you wrote: I am trying to update lot's of tables. Can I do this in one command? If so, what is the command. I've tried everything. Nothing works. I can only update one table at a time. Do you want to update lots of identical tables with the

Re: RE: Auto_increment

David, Thursday, September 05, 2002, 12:45:33 AM, you wrote: DJ Can the AUTO_INCREMENT feature be used to control a sequential number list DJ that re-uses numbers that are subsequently removed ? You can insert another rows with the same auto_increment value as in deleted row, if you directly

Performance Problems with InnoDB Row Level Locking...

Background: I've developed a simplistic Perl program to test database performance with concurrent session queries. The queries involve inserts, updates, and deletes in order to test database performance in an OLTP mult-user ACID compliant scenario. Obviously this is not a real world test but it

Re: Bad table conversion

Michael, - Original Message - From: Michael T. Babcock [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday, September 05, 2002 5:15 PM Subject: Bad table conversion I was using phpMyAdmin to do some user management and since it was fairly slow, decided to try

Cannot create tables with ODBC

Well, just that thing. I'm able to search, retrieve and update Mysql tables (server located on a Linux Box) but I cannot create tables, nor modify its structures. Does anyone knows why. Leonardo Belen. Afip AR PS: I tried with the last stable release of Mysql and MyODBC from MYSQL.COM.

Re: re-install on linux

Muzi, Thursday, September 05, 2002, 1:15:18 PM, you wrote: I was running my mysql 3.23. on redhat 6.2 I uninstall it using the rpm -e command then I went into var/lib/mysql deleted the dbase and all mysql directoring. I then re-install mysql mysql version,client,devel,shared

Re: Bad table conversion

Michael, Thursday, September 05, 2002, 5:09:47 PM, you wrote: MTB I was using phpMyAdmin to do some user management and since it was MTB fairly slow, decided to try upgrading my mysql.users and mysql.db tables MTB to InnoDB format. It seems however that this is a bad thing as mysql MTB told

Macromedia Flash and MySQL

Hi, I am thinking of using Macromedia Flash for graphical charting. After charting, I plan to store the info into MySQL. However, I am not sure if the Flash Remoting in Macromedia Flash can work with MySQL. My application is mainly JSP based but the charting is based on Flash. What kind of

Re: Bad table conversion

Heikki Tuuri wrote: what version you are using? mysql Ver 11.18 Distrib 3.23.51, for pc-linux-gnu (i686) It left the MyISAM user and db tables as they were. You have lost the db table? I guess that if you create the same databases in another server and copy the db table from there, it should

Re: Bad table conversion

Michael, - Original Message - From: Michael T. Babcock [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Heikki Tuuri [EMAIL PROTECTED] Sent: Thursday, September 05, 2002 6:03 PM Subject: Re: Bad table conversion Heikki Tuuri wrote: what version you are using? mysql Ver 11.18 Distrib

Re: Bad table conversion

Victoria Reznichenko wrote: Michael, MySQL privilege tables MUST be MyISAM: http://www.mysql.com/doc/en/InnoDB_restrictions.html Yes, thank-you; I must have missed / forgotten that warning at some point -- my next E-mail will be to the phpMyAdmin author suggesting a patch to

Syslog and MySql

Hello all! I'm looking at dumping various syslog files to a MySQL database. The problem is that most programs I've seen only accept linux/unix default syslog types to dump to MySQL. I'm looking at dumping logs from a variety of different sources though my first priority is PIX firewall logs.

MYSQLSTAT - A set of utilities to monitor, store and display Mysql DBMS usage statistics

Hello mysql, MYSQLSTAT - A set of utilities to monitor, store and display Mysql DBMS usage statistics: http://www.mysqlstat.org/en/ Best regards, Andrew Sitnikov e-mail : [EMAIL PROTECTED] GSM: (+372) 56491109

Re: re-install on linux

Egor Egorov wrote: Muzi, Thursday, September 05, 2002, 1:15:18 PM, you wrote: I was running my mysql 3.23. on redhat 6.2 I uninstall it using the rpm -e command then I went into var/lib/mysql deleted the dbase and all mysql directoring. I then re-install mysql mysql

RE: query problem

I am by no means an SQL-expert, but I'll give this a shot... :) -Original Message- From: Richard Brenner [mailto:[EMAIL PROTECTED]] Subject: query problem I have two tables with the following structure: Users: | Field| Type | id | int(10) unsigned | name

TIMESTAMP compare fails on RH 7.3

Hello. I have a problem where TIMESTAMP comparison fails on MySQL 3.23.52 on RedHat 7.3. I have installed the RPMS that came with the distro as well as the ones from the mysql.com site. The results are the same: mysql select TIMESTAMP from tblPositions; ++ | TIMESTAMP |

Re: Performance Problems with InnoDB Row Level Locking...

Heikki, one little question - is it a mistype, or can a flush log interval duration be controlled by this option? The value should only be 0 or 1 as the documentation says... On Thu, 5 Sep 2002, Heikki Tuuri wrote: You can try setting innodb_flush_log_at_trx_commit=2 if you can afford

Re: Bad table conversion

Michael, - Original Message - From: Michael T. Babcock [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday, September 05, 2002 6:37 PM Subject: Re: Bad table conversion Victoria Reznichenko wrote: Michael, MySQL privilege tables MUST be MyISAM:

Re: [MySQL] re-install on linux

Muzi Nkosi wrote: when I run: rpm -qa | grep MySql Wrong, the RPM is called MySQL, not MySql. Case matters. An easier solution would be to tell grep to ignore case: [root@serpico ~]# rpm -qa | grep -i mysql MySQL-client-3.23.52-1 MySQL-shared-3.23.52-1 MySQL-3.23.52-1

Re: Performance Problems with InnoDB Row Level Locking...

Alexander, - Original Message - From: Varshavchick Alexander [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, September 05, 2002 6:51 PM Subject: Re: Performance Problems with InnoDB Row Level Locking... Heikki, one little question - is it a

Re: One of those What the heck?! messages

Hi. On Thu 2002-09-05 at 10:13:12 -0400, [EMAIL PROTECTED] wrote: On Thu 2002-09-05 at 09:29:41 -0400, [EMAIL PROTECTED] wrote: [...] Last_error: error 'unexpected success or fatal error' on query 'bslive' [...] The query is then logged and send to the slave and is expected

Re: Character set

On Thu, 5 Sep 2002, National Theater of Greece wrote: Hi. I have installed SuSE Linux 8.0 Proffessional and the MySQL that came with it. If anyone of you has done the same he must have realized that many of the files are quite different than the files of MySQL that came with the standard

mysql re-install on linux

Hi I was running my mysql 3.23. on redhat 6.2 I uninstall it using the rpm -e command the went into var/lib/mysql deleted the dbase. I then re-install mysql mysql version,client,devel,shared when I run: rpm -qa | grep MySql result : I only see client,devel and shared ...I cannot see version

Replication problem: slave can't log into master (update)

I am still having problems with the slave server being able to connect to the master, but a thought occured to me while we were working another topic. Please let me know what I'm missing. I can do the following: mysql -hctiadb1 -urepl -preplctia and can access whatever database I wish. I

Re: MySQL performance questions

Hi. On Thu 2002-09-05 at 09:09:07 -0500, [EMAIL PROTECTED] wrote: For clarity sake, assume the following: Red Hat Linux 7.1 2.4.8 kernel MySQL 3.23.42 MyISAM databases 3GB RAM P3/700 x 4 15GB database spanned across ~200 tables Key_reads / Key_read_request = 0.00059875 Key_write

RE: query problem

You cna fix this problem with the HAVING keyword in the WHERE clause. HAVING is like WHERE, but on group-by functions, like COUNT(*). Change the query to: SELECT id,name,userid,correct,count(correct) as numcorrect FROM users,answers WHEREid=userid AND correct='true' GROUP BY id

Stopping Running Queries...

mysql,query Hello, Maybe I'm an idiot, but I can't find any documentation on how to stop running queries interactively. The only thing I can come up with is to stop and restart the server. I don't want to do that. Basically, if a user does something stupid, and sparks off a query that is

Re: Stopping Running Queries...

Hello, Use mysqladmin processlist command to see the thread that's eating up resources, then use mysqladmin kill to kill that thread. mysqladmin documentation offers much more information on this topic. You can also use SHOW PROCESSLIST and KILL SQL commands to achieve that. Regards, Iikka

relocating databases

I'm thinking of moving databases from their standard location to another disk. I'd like to set up a separate database for each user, so that their storage space is reflected in their home directory quota. Can anyone fill me in on how to manage this *without* using a huge pile of symlinks:

Re: ado/mysql problem

Yes, I have now. Do not find anything :( Ben Joyce wrote: ahhh, hmm, erk... have you checked the MDAC site and MSKB for known bugs? -Original Message- From: Dan Johansson [mailto:[EMAIL PROTECTED]] Sent: 05 September 2002 15:19 To: Ben Joyce Cc: [EMAIL PROTECTED] Subject: Re:

RE: ado/mysql problem

Hmm. I'm not sure what to suggest... sorry! :( -Original Message- From: Dan Johansson [mailto:[EMAIL PROTECTED]] Sent: 05 September 2002 18:30 To: Ben Joyce Cc: [EMAIL PROTECTED] Subject: Re: ado/mysql problem Yes, I have now. Do not find anything :( Ben Joyce wrote:

Re: Macromedia Flash and MySQL

Hello, I'm currently working with Macromedia Flash and MySQL. Actually I use PHP to connect MySQL and Flash. You can use loadVariables (GET or POST) or XML to the interface between Flash and PHP. Joao. Fook Cheon Khaw wrote: Hi, I am thinking of using Macromedia Flash for graphical

Re: Macromedia Flash and MySQL

Joco Borsoi Soares ([EMAIL PROTECTED]) écrivait: Hello, I'm currently working with Macromedia Flash and MySQL. Actually I use PHP to connect MySQL and Flash. You can use loadVariables (GET or POST) or XML to the interface between Flash and PHP. Sure ! or take a look to SwiftGenerator (Google

RE: Performance Problems with InnoDB Row Level Locking...

Hello again Heikki and thanks for your informative reply. Regarding... innodb_flush_log_at_trx_commit=2 This is not an option as we must guarantee no lost transactions. But I will test it out of curiosity just to see what the performance difference is. Regarding... InnoDB uses next-key

  1   2   >