Re: deleting big tables

| ++--+---+--+-++-+--+ process with id 37 have been there for a long time, i tried to kill it and drop the table. what can i do? Pau Marc Muñoz Torres skype: pau_marc http://www.linkedin.com/in/paumarc http

Re: deleting big tables

i solved the problem by rebooting my computer. i just drop the table in seconds thanks Pau Marc Muñoz Torres skype: pau_marc http://www.linkedin.com/in/paumarc http://www.researchgate.net/profile/Pau_Marc_Torres3/info/ 2015-05-17 12:00 GMT+02:00 Pau Marc Muñoz Torres paum...@gmail.com

Re: deleting big tables

OUTPUT Pau Marc Muñoz Torres skype: pau_marc http://www.linkedin.com/in/paumarc http://www.researchgate.net/profile/Pau_Marc_Torres3/info/ 2015-05-17 10:31 GMT+02:00 Pothanaboyina Trimurthy skd.trimur...@gmail.com : Hi Pou, Before killing those connections first check

deleting big tables

are not equivalent but i want to get rid of all information inside thanks Pau Marc Muñoz Torres skype: pau_marc http://www.linkedin.com/in/paumarc http://www.researchgate.net/profile/Pau_Marc_Torres3/info/

Re: from excel to the mySQL

I'm needs a way to upload data from excel to the mySQL database. Dear all, I need help is how to upload data from excel columns and load into mysql database using php? http://www.sqldbu.com/eng/sections/tips/mysqlimport.html -- MySQL General Mailing List For list archives:

Re: Table which can reference a number of other tables

-- id name industry_id (FK) Are suggested solutions for this problem any different from those I've received for the previous example? The real problem is when a table (Newsletters) can be associated with 2 or more other tables (Contact Group or Industry). Thanks for any guidance. Marc

Table which can reference a number of other tables

to the contacts and employees tables, but none of these solutions seem very smart. Thanks, Marc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Select form a list

do that? Thanks Pau -- Pau Marc Muñoz Torres Laboratori de Biologia Computacional Institut de Biotecnologia i Biomedicina Vicent Villar Universitat Autonoma de Barcelona E-08193 Bellaterra (Barcelona) telèfon: 93 5812807 Email : [EMAIL PROTECTED]

indexing tables using my owns functions

','HLA-DRB13'))' at line 1 Some one knows where is the error? Thanks Pau -- Pau Marc Muñoz Torres Laboratori de Biologia Computacional Institut de Biotecnologia i Biomedicina Vicent Villar Universitat Autonoma de Barcelona E-08193 Bellaterra (Barcelona) telèfon: 93 5812807 Email : [EMAIL

Fwd: loading scripts to mysql

hi, Tanks for your help, finally i found the source command. It work like this: mysql source /Lhome/geruppa/mhc/Pack_Ref_web/prova.sql 2007/11/9, Michael Gargiullo [EMAIL PROTECTED]: On Fri, 2007-11-09 at 13:22 +0100, Pau Marc Munoz Torres wrote: Hi everybody I'm writing a function

indexing tables using my owns functions

','HLA-DRB13'))' at line 1 Some one knows where is the error? Thanks Pau -- Pau Marc Muñoz Torres Laboratori de Biologia Computacional Institut de Biotecnologia i Biomedicina Vicent Villar Universitat Autonoma de Barcelona E-08193 Bellaterra (Barcelona) telèfon: 93 5812807 Email : [EMAIL

Re: indexing tables using my owns functions

PROTECTED] -- Pau Marc Muñoz Torres Laboratori de Biologia Computacional Institut de Biotecnologia i Biomedicina Vicent Villar Universitat Autonoma de Barcelona E-08193 Bellaterra (Barcelona) telèfon: 93 5812807 Email : [EMAIL PROTECTED]

loading scripts to mysql

Hi everybody I'm writing a function script in a flat file using vim, now i would like load it into my sql, there is some command to do it similar to load data into to fill tables? thanks -- Pau Marc Muñoz Torres Laboratori de Biologia Computacional Institut de Biotecnologia i Biomedicina

Problems with create procedure

variable) Can some body tell me what should I do? thanks Pau -- Pau Marc Muñoz Torres Laboratori de Biologia Computacional Institut de Biotecnologia i Biomedicina Vicent Villar Universitat Autonoma de BarcelonaE-08193 Bellaterra (Barcelona) telèfon: 93 5812807 Email : [EMAIL PROTECTED]

mysqladmin claims password in crontab !

Hi, I work under Mandrake 10.1 First, I have a .my.cnf, which works quite well, since I can enter mysql without entering any password. Even mysqladmin works ! But, I have a batch process run by crontab as root, which tests if mysql is running (mysqladmin version --silent). Unfortunately,

Re: load-file() doesn't work [SOLVED]

the host running mysql - when seen from the host running mysqld Marc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Question on mysql-test-run sp failed

the following (it's not for 5.0/Solaris, but might help anyway) : http://dev.mysql.com/doc/refman/5.1/en/source-notes-linux.html Marc Alff. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Slow query log

Hello, Is there a way to enable the Slow Query Log on the fly without having to restart mysqld Regards, Marc.

RE: Slow query log

Hi, Thank you for your answer. But is there a chance to be able to do it one day? I think it could be a nice feature. Marc. -Message d'origine- De : Petr Chardin [mailto:[EMAIL PROTECTED] Envoyé : mercredi 5 avril 2006 13:06 À : Mechain Marc Cc : MySQL Objet : Re: Slow query log

Question about interactive timeout

Wait_timeout 28800 Why those connections do still remains on the server with a value of 61700s while in a Sleep Command? It is rather strange for me; they normally should have disappeared after 28800s of inactivity. Could you give me a clue? Marc.

install mysql on linux AMD64 processor

SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: root To: mysql@lists.mysql.com Subject: [50 character or so descriptive subject here (for reference)] Description: i try

install mysql-5.0.17 on linux AMD 64 processor

SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: root To: mysql@lists.mysql.com Subject: install mysql-SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be

Re: How to insert CURDATE() as default

Thanks, Danny. This little info was all I needed. It works perfectly now. Have a Happy New Year! --Marc On Fri, 2005-12-30 at 10:28 +0100, Danny Stolle wrote: Marc, In MySql (I am using 4.1.9 and 4.1.15; so i am not sure about 5) it is not possible to use functions as default values; you

Re: install mysql-5.0.17 on linux AMD 64 processor

Re: install mysql-5.0.17 on linux AMD 64 processor http://lists.mysql.com/mysql/193352 dir Duncan Hill , thank you to answer to my question ! my processeur is AMD 64 2800+ ( 64 Bits processeurs!) and linux is seeing an Athlon 32 bits processor (see previous message). My OS IS Linux Aurox ver

How to insert CURDATE() as default

(). I've got the column with Date for the ColummnType. Thanks. -- Marc [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How to insert CURDATE() as default

to worj with this table. How do I use knoda to get this done? I can enter CURDATE() in the default using the GridColumns button, but all that does is insert the phrase CURDATE(). I've got the column with Date for the ColummnType. Thanks. -- Marc [EMAIL PROTECTED] -- MySQL General Mailing List

RE: mysqld crash with archive engine 2gb

archive table. Using a separate MyISAM table for each day of data (~ 132mb/3.2m rows) gives me the response time I need -- plus there are no scenarios in which I will be performing cross-day queries (I would guess I could use the merge table if necessary). Thanks again, Marc --- Logan, David

Re: mysqld crash with archive engine 2gb

. I am also looking at alternative solutions in which I use multiple ARCHIVE dbs with each being 2 gb. Marc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysqld crash with archive engine 2gb

support. Any ideas? I tried to do the ALTER TABLE x AVG_ROW_LENGTH=x MAX_ROWS=y using inputs that would exceed 2GB, same results. TIA, Marc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Edit MySQL through MS Access?

Eh, eh, sorry, stupid question for some of you, I'm sure... I'm wondering if there is a way to edit a MySQL DB through MS Access like you can for an MSSQL DB? I want to edit a lot of data, tables etc... and doing it through phpMyAdmin just isn't very efficient. Thanks, Marc -- MySQL

Re: Edit MySQL through MS Access?

which makes sense but I want to update/overwrite it. Something like downloading the table from MySQL, edit some of the fields and data in MS Access and reupload the whole thing. Is this possible too? Thanks again! Marc Dan Nelson wrote: In the last episode (Nov 03), Marc Pidoux said: Eh

PHP/MySQL vs ASP/MSSQL?

, which option is the best between PHP/MySQL and ASP/MSSQL? It's not a giant project but it might include around 20'000 members interacting daily through forums, blogs, messages etc... Thanks, Marc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

RE: UNIONS 'Got error 12 from storage engine'

Memory problem. Error 12 = Cannot allocate memory Marc. -Message d'origine- De : Cliff Daniel [mailto:[EMAIL PROTECTED] Envoyé : jeudi 21 avril 2005 07:43 À : mysql@lists.mysql.com Objet : UNIONS 'Got error 12 from storage engine' Have a query that consists of 10 unions

RE: Regarding the loading of data usning load data infile

May be a clue, for the data records you load into the table, the value for numeric field such as DEPARTMENT_ID, LOCATION_ID should not be enclosed in quote. If it is the case, mysql has to make a translation from character to numeric. Marc. -Message d'origine- De : [EMAIL PROTECTED

turning off replication

to connect to barney because the values from CHANGE MASTER TO... are still there.. how do i completely clear this? so i don't have any problems when i bring barney back to life. Marc Dumontier -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Memory limit?

On Thu, 10 Feb 2005 10:19:32 +0900, Batara Kesuma [EMAIL PROTECTED] wrote: Hi Tobias, On Wed, 9 Feb 2005 14:48:16 +0100 (CET) Tobias Asplund [EMAIL PROTECTED] wrote: I try to install MySQL 4.1.9 (official RPM from mysql.com). My machine is running linux 2.6.9, and it has 4GB of RAM.

Re: Slow Replication

On Wed, 9 Feb 2005 22:07:19 +0100, Hannes Rohde [EMAIL PROTECTED] wrote: Hi all, We use MySQL as a database backend on a portal site. We have a two database server setup (one master, one slave). The master is a PIV 3,2 GHz., 2 GB Ram and a 80GB Raid-1 system. The slave is a PIV 3.2

RE: Slow Replication

I think he is talking about the innodb_flush_log_at_trx_commit parameter. Try to put it at a value of 0. innodb_flush_log_at_trx_commit = 0 If you have an IO bottleneck, this may help. Marc. -Message d'origine- De : Hannes Rohde [mailto:[EMAIL PROTECTED] Envoyé : jeudi 10 février

Re: performance on query with ORDER BY clause

Thanks for your reply, Just to be clear...performing my query without the order by clause will always return the list sorted by the primary identifier? so that SELECT SubmitId from BINDSubmit ORDER BY SubmitId == SELECT SubmitId from BINDSubmit in this case Marc Dathan Pattishall wrote

performance on query with ORDER BY clause

innodb_log_file_size = 64M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 Any help would be appreciated, so far query has been running for 3000 seconds Marc Dumontier -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Fixed with Fields

I was wondering if there is a way to create fixed width fields. Example: The field is set to 18 but data contained is 11. I need the length to remain 18. Is there anyway to do this? Thanks for your help. -Marc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

RE: MyODBC 3.5.9 and MySQL 4.1.8

Have a look at: http://dev.mysql.com/doc/mysql/en/Old_client.html Marc. -Message d'origine- De : nikos [mailto:[EMAIL PROTECTED] Envoyé : mercredi 5 janvier 2005 10:09 À : mysql@lists.mysql.com Objet : MyODBC 3.5.9 and MySQL 4.1.8 Hello list and happy new year. Recently I've

mysql-python compiling error on Fedora Core 3 x86_64

Dear List Members Can anybody give me a hint about how to compile mysql-python on a 64bit opteron system (see the error below) with mysql tarball? - Fedora Core 3 x86_64 - python-2.3.4 - MySQL-python-1.1.8 - mysql-standard-4.1.8-unknown-linux-x86_64-glibc23.tar.gz Thanks in advance Marc python

RE: Sum on Float type

You can use the format() function: select t.custcode, format(sum(t.cost),2) as Sub-Total from customer c, transaction t where c.custcode = t.custcode group by t.custcode Marc. -Message d'origine- De : sam wun [mailto:[EMAIL PROTECTED] Envoyé : vendredi 24 décembre 2004 11:23 À : mysql

slow date query

where | ++--+---+--+-+--++-+ 1 row in set (0.00 sec) thanks, Marc Dumontier -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: slow date query

Thanks, works like a charm. Marc Dathan Pattishall wrote: Well 1st of all Date_format doesn't allow the use of a key. Do this. SELECT .. WHERE DateLastRevised = '2004-12-07' AND DateLastRevisted '2004-12-08'; -Original Message- From: Marc Dumontier [mailto:[EMAIL PROTECTED] Sent

RE: Server Configuration Help

In your my.cnf there is no: Query_cache_size - http://dev.mysql.com/doc/mysql/en/Query_Cache_Configuration.html Thread_cache_size - http://dev.mysql.com/doc/mysql/en/Server_system_variables.html Marc. -Message d'origine- De : ManojSW [mailto:[EMAIL PROTECTED] Envoyé : lundi 6

RE: How to retrieve constraints and links from MySQL tables?

You can use: show create table employee; or show table status like 'employee'; in the column comment you have the information you are looking for. Marc. -Message d'origine- De : Varakorn Ungvichian [mailto:[EMAIL PROTECTED] Envoyé : vendredi 26 novembre 2004 09:32 À : [EMAIL

RE: mysql optimizing large table

If you don't want to have those error messages: Increase the value of Open File using ulimit shell command. Do a ulimit -a to see the current value Do a ulimit -n newvalue to increase it You can also modify the /etc/limits file Marc. -Message d'origine- De : Richard Bennett [mailto

MySQL doesn't startup anymore

a MySQL book and it doesn't help much. I also tried mysqld_safe --debug, but no trace file is created. Thanks for any help. -- Marc [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL doesn't startup anymore

server running on port: 3306 ? 041014 8:55:53 Aborting 041014 8:55:53 /usr/sbin/mysqld: Shutdown Complete 041014 08:55:53 mysqld ended == How do I check on what is binding port 3306? I don't see mysqld running and running mysql gets a Can't connect failure. --Marc On Thu

Re: MySQL doesn't startup anymore

Thanks to all for the help. I did find a mysqld running using ps -aux and killed that. Looks like I'm all set. --Marc On Thu, 2004-10-14 at 11:33, Melanie wrote: I had this problem too: I identified the pid with ps -aux and then kill them manually. (kill -9 pid) hope it will help you

Charset problem

on. The other problem is that he noticed mistake a few days after the import and he had trashed the correctly encoded dump in the meantime. So now we have only a base with wrongly encoded fields values. What is the way to fix that please ? Thanks in advance. Jean-Marc -- MySQL General Mailing List

init.d - need 'status' option

I am implementing mysql on a Redhat Cluster for high availability and will be using replication. I wanted to use 4.1.5, but learned that the cluster suite requires an init.d script that will answer to the 'status' command. 'status' does not seem to be included anymore. [RH will only support

Re: tuning suggestion for large query

On Wed, 1 Sep 2004 11:40:34 -0400, Sun, Jennifer [EMAIL PROTECTED] wrote: Hi, We have a job that do 'select * from big-table' on a staging mysql database, then dump to data warehouse, it is scheduled to run once a day, but may be run manually. Also we have several other small OLTP database

Re: tuning suggestion for large query

- From: Marc Slemko [mailto:[EMAIL PROTECTED] Sent: Thursday, September 02, 2004 2:24 PM To: Sun, Jennifer Cc: [EMAIL PROTECTED] Subject: Re: tuning suggestion for large query On Wed, 1 Sep 2004 11:40:34 -0400, Sun, Jennifer [EMAIL PROTECTED] wrote: Hi, We have a job that do 'select

Re: tuning suggestion for large query

On Thu, 2 Sep 2004 15:19:44 -0400, Sun, Jennifer [EMAIL PROTECTED] wrote: Thanks Marc, What version of myisam table you are talking about? We are on 4.0.20, when I ran the big table query, I tried to insert to it twice without any issues. The -q worked good for mysql client. Thanks

MIN and JOIN - USING TEMPORARY

) GROUP BY a.id ORDER BY low What can I do to speed up this query? I need to get a list of rows from table a with it's lowest reference number from table b. Thanks in advance, Marc

Re: InnoDB TableSpace Question

On Tue, 3 Aug 2004 10:07:25 -0400 , David Seltzer [EMAIL PROTECTED] wrote: Hi all, I've been searching the archives mysql documentation for a while and I can't seem to find an answer to my question - Is there a way to force InnoDB to shrink its filesize? I just dropped a 7GB table, but

Re: InnoDB TableSpace Question

On Tue, 3 Aug 2004 12:42:03 -0400 , David Seltzer [EMAIL PROTECTED] wrote: Thanks Marc, Is there really no way to reclaim unused space in an InnoDB table space? If not, why is this not considered a tremendous limitation? Some do consider it a tremendous limitation. It all depends on how

Re: using mysql in commercial software

On Mon, 2 Aug 2004 01:35:44 -0700, Jeremy Zawodny [EMAIL PROTECTED] wrote: On Mon, Jul 26, 2004 at 01:26:15PM -0500, gerald_clark wrote: Steve Richter wrote: exactly! Is Linux distributed under the same type of license as MySql? If I sell software that runs on linux I dont have to

better performance with optimize!?? (jboss)

I use Mysql with JBOSS as applicationserver. i have strange response-time differences, which i can't explain. 1) after reboot the computer, it takes about 300ms to read 12 entities (cmp, read ahead, 2 rows each entity) One entity is accessed by primary key, the others by foreign key. 2) when i

Re: InnoDB 4.1.3: count(*) and number of rows does not match

On Sat, 31 Jul 2004 17:50:38 -0500, Keith Thompson [EMAIL PROTECTED] wrote: I just discovered that two of my tables (out of about 300) show a very unusual behavior. This is that select count(*) ... and selecting all the rows and counting them do not produce the same number. This is on

Re: MySQL 4.0.x charset

-Marc PULVAR (Web Programmer) Boonty SA 4 bis villa du mont tonnerre 75015 PARIS --- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: MySQL 4.0.x charset

ran this command, character_set was not listed... the list seemed cut off just before it. Unless it is an issue with SSH only showing x amount of lines.. thanks, Yves A --- Jean-Marc PULVAR [EMAIL PROTECTED] wrote: You can see it by executing the SHOW VARIABLES query on your server. You will find

Re: INSERT if record NOT EXISTS

On Mon, 26 Jul 2004 17:47:37 +0100, Adaikalavan Ramasamy [EMAIL PROTECTED] wrote: This seems more like the solution I want. I am using perl-DBI and when there is an error (i.e. duplicate insert), the rest of the scrip it not executed. But this is gives me the following error. What am I doing

Re: SHOW INNODB STATUS

On Mon, 26 Jul 2004 18:03:25 -0700, Matt Solnit [EMAIL PROTECTED] wrote: How is it possible to have a hit rate of 1000/1000? Doesn't the buffer get inOn Mon, 26 Jul 2004 18:03:25 -0700, Matt Solnit [EMAIL PROTECTED] wrote: How is it possible to have a hit rate of 1000/1000? Doesn't the

Consolidating Data

Greetings! I have several (~12) web servers which all record web metrics to their own local mysql database. I would like to consolidate data from each web server database to one master DB to within the hour. I wish to avoid running multiple instances of mysql on the master server, so

Re: after upgrade unicode characters changed to question marks

-- ___ _ / __\ ___ ___ _ __ | |_ _ _ /__\/// _ \ / _ \| '_ \| __| | | | Jean-MARC PULVAR (Web Programmer) / \/ \ (_) | (_) | | | | |_| |_| | \_/\___/ \___/|_| |_|\__|\__, | Boonty SA |___/ 4 bis

Multi-languages sites with Mysql 4.0

Hi, I'm using a mysql 4.0 version and i wanted to know whether i can realize a multi-language site with eastern languages like japanese. I'm using a database which has already data encoded with the latin charset (iso-8859-1) and need to include japanese data. How may I proceed to have

Re: Multi-languages sites with Mysql 4.0

Thanks for your reply that's was really what i thought. My understanding is that you have to have MySQL 4.1 for this sort of thing to work at all. Which is why I am so keen to see 4.1 reach production ASAP. Pre-4.1, you can store UTF-8, but it will not sort correctly. Alec Jean-Marc

Re: RAM-usage and hardware upgrade 10gb RAM

On Mon, 19 Jul 2004 18:13:36 +0200, Jan Kirchhoff [EMAIL PROTECTED] wrote: Hi, We are currently using a 4.0.16-replication-setup (debian-linux, kernel 2.4.21, xfs) of two 2.4ghz Intel-Pentium4 systems with 3gig RAM each and SCSI-Hardware-Raid, connected via gigabit-ethernet. We are reaching

Re: Linux 2GB Memory Limit

On Tue, 13 Jul 2004 23:26:48 +0100, Marvin Wright [EMAIL PROTECTED] wrote: Hi, I'm now running redhat AS 3.0 with kernel version 2.4 and have 8GB of RAM. If I set my innodb_buffer_pool to 2048M, it just will not start, I get this error. 040713 22:10:24 mysqld started 040713 22:10:24

Re: Replication - multiple masters

Jeremy Zawodny writes: The web servers record web metrics to local mysql databases. I would like those local databases to be consolidated onto the DEPOT [as three separate DBs]. You cannot do that. snip You'd need to run 3 instances of MySQL on DEPOT, one for each WWW server you'd like to

Re: Replication - multiple masters

Jeremy Zawodny writes: Can you, or anyone comment on the praticality of doing so? I estimate 10,000 to 30,000 records per web server, per day using 3 remote web servers. The number of web servers would not likely grow to more than 12. That should be a problem at all. I know of much larger

Replication - multiple masters

I have 4 servers in my environment: DEPOT - master server WWW1 - web server #1 WWW2 - web server #2 WWW3 - web server #3 The web servers record web metrics to local mysql databases. I would like those local databases to be consolidated onto the DEPOT [as three separate DBs]. Is

Re: Linux 2GB Memory Limit

On Fri, 9 Jul 2004 15:46:37 +0100 , Marvin Wright [EMAIL PROTECTED] wrote: Hi, Current Platform RH version is 7.3 IBM Blade Server - 2 x Intel(R) Xeon(TM) CPU 3.20GHz 32 GB SCSI 4 GB Ram This is the platform we are moving to in a week or so RH Enterprise AS 2.1 or 3.0 4 x

Re: Concurrency Question

On Mon, 5 Jul 2004 16:07:58 +0100 , Javier Diaz [EMAIL PROTECTED] wrote: We have changed all our tables to InnoDB and now the server is not able to handle the load, even when we are not running the SELECTs statements against these tables yet. As I mentioned in my email we make a lots of

Re: Concurrency Question

On Mon, 5 Jul 2004 18:48:50 +0100 , Javier Diaz [EMAIL PROTECTED] wrote: I really don't like the idea to set innodb_flush_log_at_trx_commit to 2, the information in these tables is important. On the other hand there is nothing I can do from the point of view of the number of transactions.

RE: strange table speed issue

On Thu, 24 Jun 2004, MerchantSense wrote: Seems ok to me... It seems to be checking all the rows in the explain for some reason too... mysql show index from ip2org; +++--+--+-+---+- +--++-+ |

ERROR 1045: Access denied for user: 'foo@host' (Using password: YES)

ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) I've only managed to find a single thread about this issue which was a bug in the installation of mysql on RedHat 7. Many months have gone by since then so I wonder if this is still the same issue. -- Marc Tardif

RE: Replication is currupted ...Please help me...

May be a full off the filesystem where the relay logbin file is ? Marc. -Message d'origine- De?: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Envoye?: mercredi 9 juin 2004 09:46 A?: [EMAIL PROTECTED] Objet?: Replication is currupted ...Please help me... Hi all. My company has three

Re: Idea to speed up multiple jdbc connections?

On Mon, 7 Jun 2004, Haitao Jiang wrote: Marc mysqld runs on a very powerful Operton machine with 16GB memory and barely any other application process running, it is hard to believe that a simple select that runs under 2 second will utilize all the resources...that is why I tend to think

Re: Idea to speed up multiple jdbc connections?

On Tue, 8 Jun 2004, Haitao Jiang wrote: Each of 4 individual query only took 0.6 seconds, there is no other clients, it hardly to believe taht mysql query performance will degrade 300% (from 0.6s to ~1.9s) if we have 4 concurrent connections... As far as I know, MySQL should be able to

Re: Idea to speed up multiple jdbc connections?

On Mon, 7 Jun 2004, Haitao Jiang wrote: Yes. The time I measure like I said is purely around statement.execQuery() call. Connection creation is not a factor here at all. My database has 1.64 million rows and 4 queries are all selects, which are identical in both serial and parallel cases.

RE: Three quick questions about using MySQL

See answers in the message below. Marc. -Message d'origine- De : Ben Clewett [mailto:[EMAIL PROTECTED] Envoyé : vendredi 4 juin 2004 10:37 À : [EMAIL PROTECTED] Objet : Three quick questions about using MySQL Three quick questions, I hope you can help me. Using InnoDB on version

Is MySQL 4.1 ready?

I would like to hear from people who have tested version 4.1 to determine if I should upgrade now or wait until it's in production release? Marc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Is MySQL 4.1 ready?

Wait until 4.1.2 is out in the next few days. - Do you know where I can find any indication of when 4.1.2 is expected to be released? Marc. Donny Simonton [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Wait until 4.1.2 is out in the next few days. I've been using it since 4.1.0

Replication Issue

MYBCK.log.1:040503 17:44:18 Slave: error 'Column 'PROVIDER_ID' cannot be null' on query 'insert into DATA_TYPE values (1,@providerId,'DATA_TYPE',1)', error_code=1048 The question is: why is the value of @providerId not properly replicated ? Is it a bug ? Regards, Marc. -- MySQL General Mailing List

How to determine how fragmented a innodb table is ?

Is there a simple way to determine how fragmented a Innodb table is ? Thanks, Marc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: InnoDB Table Locking Issue

On Tue, 27 Apr 2004, Scott Switzer wrote: Hi, I am having a difficult time with a query. My environment is MySQL v4.0.16 (InnoDB tables) running on Linux (latest 2.4 kernel). Basically, I am running a query of the form: INSERT INTO temp_tbl SELECT c1,c2... FROM t1,t2,t3,t4 WHERE ...

Re: INNODB SHOW STATUS

On Tue, 20 Apr 2004, Emmett Bishop wrote: Howdy all, Quick question about what I'm seeing in the BUFFER POOL AND MEMORY section... I've configured the innodb_buffer_pool_size to be 128M and when I do a show variables like 'innodb%' I see | innodb_buffer_pool_size | 134217728

RE: Replication problem

Add this in your my.cnf slave file: slave-skip-errors = 1062 Marc. -Message d'origine- De : Georg Horn [mailto:[EMAIL PROTECTED] Envoyé : mercredi 21 avril 2004 17:31 À : [EMAIL PROTECTED] Objet : Replication problem Hi, i'm new to this list, but i use mysql for years an are very

Help with complex statement

Hi all, This is my first post on MySQL. Wondering if someone could help me with an sql statement MySQL version 4.0.18 I have three tables: 1. visitor_data (Visitor_ID, IP Address) 2. visit_data (Visit_ID, Visitor_ID) 3. page_data (Page_ID, Visit_ID, Visitor_ID, URI, Page_Time) If

RE: InnoDB Load Problem

is disk bound ? iostat -x 1 The right column of the display gives you the busy state (in percent) of the disk. If I can get some hard evidence of this ... Try to set innodb_flush_log_at_trx_commit to 0 (the default value is 1) Marc. -Message d'origine- De : Marvin Wright [mailto:[EMAIL

Re: Gripe with MySQL

On Mon, 19 Apr 2004, Stormblade wrote: Ok. Love MySQL and I will be using it for my personal use and recommending it to clients as a lower cost alternative. I've only been using it for a very short time but there one major gripe I have with it and I believe it's just a design thing. MySQL

Re: mysql/innodb configuration

On Fri, 16 Apr 2004, mayuran wrote: I would like to optimize the configuration settings for this beast of a machine, here are the specs: Quad Xeon 3ghz (4x2 = 8 cpus), 512 cache 16 gigs ram running Redhat Enterprise 3.0 AS All tables are InnoDB. I read this warning in the MySQL

RE: InnoDB

in the /etc/my.cnf Marc. -Message d'origine- De : Chen, Jenny [mailto:[EMAIL PROTECTED] Envoyé : jeudi 15 avril 2004 18:23 À : '[EMAIL PROTECTED]' Objet : InnoDB MySQL Experts: I am new for MySQL database. We have a 4.0.18 MySQL sit on Linux box. I am reading on InnoDB. And having

Re: MySQL Cluster

On Wed, 14 Apr 2004, Tim Cutts wrote: On 14 Apr 2004, at 10:57 pm, Adam Erickson wrote: (This is probably not the best place for this post, but here goes...) The (soon to be released) MySQL cluster software docs use a sample cluster node configured with Dual Xeons and 16GB of ram.

Re: Strange Index Usage: select ... where foo = 90 on a varchar

On Thu, 15 Apr 2004, Max Campos wrote: On Apr 13, 2004, at 2:01pm, Michael Stassen wrote: You shouldn't be surprised. This is normal behavior. interchangeStatus is a varchar, so select fileName from outDocInterchange where interchangeStatus = 91; requires that interchangeStatus

  1   2   3   >