cache in mysql Windows

Hello We are doing some performance tests and would like to disable the cache. We did set the query_cache_size=0 but it did not have any effect as well as a "select no_cache". The process is a select on MyISAM table. We are using a Mysql 5.0.27. We are wondering if Mysql uses a file to cache or

bug #16979 auto-inc: question about the patch

I have run into that bug with mysql 5.0.24a: bug #16979 auto-inc My application was running OK on 4.1.7. But after migration to 5, the problem started. My questions are: 1-Can I run the patch on 5.0.24a even if it is for 5.0.21. 2-Which patch finally is the good one : the one from [13 May 20

RE: 2 versions of mysql on Unix: problem with the socket

'/tmp/mysql.sock' (2) at /seqweb/mysql4/myscripts/4/check_innodb.pl line 62 Also this is a less attractive solution since the same user will work on version4 and version 5. Thank you -Message d'origine- De : Gerald L. Clark [mailto:[EMAIL PROTECTED] Envoyé : Tuesday, 12

2 versions of mysql on Unix: problem with the socket

I am running mysql 4.1.7 on solaris 9. I want to install 2 versions (versions 4.1.7 and 5) on the server. I am reconfiguring my scripts in that perspective. I have a script that start the mysql v4 so that I finally have: 7002 pts/4S 0:00 /bin/sh /seqweb/mysql4/bin/mysqld_safe --defaults

Starting Mysql from unix root account with --user=mysql

I have a very simple question about starting mysql. I start manually the server under the unix account "mysql" with the following: /seqweb/mysql4/bin/mysqld_safe --user=mysql & in order to get the unix user "mysql" to run the process. I get the following with "ps -ef | grep mysql": mysql

mysqldump large file (>2GBs) : some tests

Hello This is kind of a follow up of the previous thread "Got errno 27 on write. file too large" and kind of a survey. The problem was : on a solaris 9, 64 bits and mysql 4.1.7, I could not mysqldump in a file more than 2G . Thank you to the people that help me. I make a new thread since my

Upgrade from 4.1.7 to 4.1.20

hello I would like to upgrade from 4.1.7 to 4.1.20 on Solaris 2.9. I have looked at the upgrade section of the doc. But I can only see upgrade from 4.0 to 4.1. In the lists and forum, I have seen people doing the almost same upgrade (4.1.x to 4.1.y) having problems. My question is : do I have

RE: mysqldump: Got errno 27 on write. file too large

make sense? Thank you again -Message d'origine- De : Duhaime Johanne [mailto:[EMAIL PROTECTED] Envoyé : Friday, 07 July 2006 16:37 À : Daniel da Veiga; mysql@lists.mysql.com Objet : RE: mysqldump: Got errno 27 on write. file too large Thank you Of course this is a bad new. Much easi

RE: mysqldump: Got errno 27 on write. file too large

- -Message d'origine- De : Daniel da Veiga [mailto:[EMAIL PROTECTED] Envoyé : Friday, 07 July 2006 13:38 À : mysql@lists.mysql.com Objet : Re: mysqldump: Got errno 27 on write. file too large On 7/7/06, Duhaime Johanne <[EMAIL PROTECTED]> wrote: > Thank you to both of you. > > Ju

RE: mysqldump: Got errno 27 on write. file too large

-- De : Greg 'groggy' Lehey [mailto:[EMAIL PROTECTED] Envoyé : Wednesday, 05 July 2006 22:04 À : Duhaime Johanne; Michael Stassen Cc : mysql@lists.mysql.com; Dominik Klein Objet : Re: mysqldump: Got errno 27 on write. file too large On Wednesday, 5 July 2006 at 9:12:52 -0400, Duhaime Joh

RE: mysqldump: Got errno 27 on write. file too large

Thank you for your answer. Yes I have file larger than what mysqldump could manager. Here is an example of this. Both files are on the same partition. mercure{root}54: du -k mercure.log.jui2006 11948544mercure.log.jui2006 mercure{root}68: du -k myregendump 2098184 myregendump Which st

mysqldump: Got errno 27 on write. file too large

I have musql 4.1.7 on Solaris 9, 64 bits and I want to mysqldump a +-4 gigas db. The dump I want to do is from a myISAM tables databank. I used to do that dump wihtout any problem until recently while the size of the Db double (+-2 to +-4) The full directory that contains the *.frm, *.MYD,*.MYI

RE: java.lang.OutOfMemoryError

I had the same problem. I changed the memory settings for java: catalina.sh JAVA_OPTS='-Xms1024m -Xmx1024m' But still I had the problem By rebooting tomcat every week-end I do not have any more problem. Of course you might not be able to do that. Johanne -Message d'origine- De :

Second call: How many innodb_log_file and how many groups

Hello I have sent this e-mail 2 weeks ago and did not get any answers. Please allow me to give a second try. I have Mysql 4.1.7 on Solaris / innodb tables I have 2 innodb_log_files of 100M each. A group of statements (19000 insert) does that both logfiles are stamped with the same time. It might

How many innodb_log_file and how many groups

Hello I have Mysql 4.1.7 on Solaris / innodb tables I have 2 innodb_log_files of 100M each. A group of statements (19000 insert) does that both logfiles are stamped with the same time. It might be because one has just finished filled and the other start or it might be because they both rotated

innodb, log_bin and ib_logfiles

I have looked around in the documentation but I do not have a clear idea of log_bin vs ib_lofile for innodb. Regarding only INNODB tables, am I right if I say that: log_bin are the commit transactions and it is what is use in an automatic recovery or are to be apply in a manual recovery fro

RE: actual size of a innodb tablespace

RENCES `AliasGroup ` (`oid`) ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -Message d'origine- De : Jeff Mathis [mailto:[EMAIL PROTECTED] Envoyé : 14 janvier 2005 16:15 À : Duhaime Johanne Cc : mysql@lists.mysql.com Objet : Re: actual size of a innodb tablespace if y

actual size of a innodb tablespace

Hello Context: innodb per table. Is it possible to know the actual size of my innodb file? What part of the initial size (10M: autoextend) is actually used? I would like to have an idea of the data space progression? Per database (I have 3). Thank you in advance Johanne Duhaime IRCM courr

Recovering from a drop table with the Innodb per table setting

Hello I look throught the documentation but could not find what I was looking for (at least I could read between lines). I have mysql 4.1.7 on solaris and I have 3 differents databanks (let-s D1, D2, D3). Each of those databases are a mix of innob and MyIsam. If by mistake a table is dropped

Restart of Mysql and tomcat error

Hello Since that list is wonderfull to solve my problem, I will try again. But this might not be the best place since the problem concerns mysql access througt tomcat (jakarta-tomcat-5.0.28). The java application we have, when start after a mysql restart (night backup) , will give an error (r

RE : Mysql client that does export and import

Thank you everybody for the answers. Finally I downloaded SQLyog and it works fine for import /export Johanne -Message d'origine- De : Karam Chand [mailto:[EMAIL PROTECTED] Envoyé : 14 décembre 2004 22:32 À : Duhaime Johanne Cc : [EMAIL PROTECTED] Objet : Re: Mysql client that

Mysql client that does export and import

Hello I have looked at MySql browser and MySqlAdministration and then in the mysql lists but I could not find what I was looking for. A developper is working with one of the many databasees we have. We want to allow him to import and export data from this database throught a window client (m

RE : DBI->connect does not work in crontab but works interactively

Thank you very much. That solves my problem -Message d'origine- De : Dan Nelson [mailto:[EMAIL PROTECTED] Envoyé : 13 décembre 2004 12:03 À : Duhaime Johanne Cc : [EMAIL PROTECTED] Objet : Re: DBI->connect does not work in crontab but works interactively In the last episode

DBI->connect does not work in crontab but works interactively

Hello I have a script that check the status of all innodb tables. It works fine interactively. But not from the crontab tab. Here is the error message and also a list of the environment variables from the crontab The message is about libz.so that does not exit: but: l /usr/local/lib/libz.s

drop database after lost of synchro in innodb

Hello I am trying to drop a database but I have the following: ERROR 1016: Can't open file: 'Alias.InnoDB' (errno: 1) In fact it looks like the synchro is lost between FRM and IBD. (I use a multiple tablespace configuration) according to http://www.innodb.com/ibman.php section 15.1. Wh

innodb_log_archive : should I activate it?

Hello I have looked in the archive of the mailing list, to see if there was any discussion on that, but I have not seen any message. I just install mysql 4.3.1 and I am wondering if I should archive the logfiles. In the documentation it is said about innodb_log_archive : "This value should