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 : > this is the inn

Re: deleting big tables

-- END OF INNODB MONITOR 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 : > Hi Pou, > Before killing thos

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

deleting big tables

p and delete 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: http://lists.m

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.

Table which can reference a number of other tables

ng login_id foreign keys 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]

Re: indexing tables using my owns functions

> Database development questions? Check the forum! > http://www.databasedevelopmentforum.com > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL 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]

indexing tables using my owns functions

erver version for the right syntax to use near ''P1','P4','P6','P7','P9','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 Bio

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: > &

indexing tables using my owns functions

erver version for the right syntax to use near ''P1','P4','P6','P7','P9','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 Bio

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 Bi

Problems with create procedure

ry logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators 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-0819

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, this

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

In other words, does /home/fleet/image.jpg exists : - when seen from 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

re memory constraints with the number of threads and the stack size for each thread. See 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]

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 lo

Slow query log

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

Question about interactive timeout

gives me: Interactive_timeout 28800 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.

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 1

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 us

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

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

How to insert CURDATE() as default

umn. I'm using knoda 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.

How to insert CURDATE() as default

phrase "CURDATE()". 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]

RE: mysqld crash with archive engine > 2gb

h a 1GB 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 --- "Loga

Re: mysqld crash with archive engine > 2gb

1 row in set (0.01 sec) Thanks for any assistance you can give. 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]

PHP/MySQL vs ASP/MSSQL?

ater. Basically, 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

Re: Edit MySQL through MS Access?

ady exists" 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 Pido

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,

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 o

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 PROT

turning off replication

ng 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

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é : j

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

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

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: This

performance on query with ORDER BY clause

25 % of buffer pool size 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://

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 To

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

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écemb

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

slow date query

| ALL | NULL | NULL |NULL | NULL | 122850 | Using 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: 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

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 novem

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 : Ric

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

Re: MySQL doesn't startup anymore

ou already have another mysqld 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 "Ca

MySQL doesn't startup anymore

. I've got 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]

Charset problem

. 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 a

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

Re: tuning suggestion for large query

an use without locking the table? > > > > > -Original Message- > 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 20

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 da

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 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.

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 > tab

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 do

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 r

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

Re: MySQL 4.0.x charset

es? When I 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

Re: MySQL 4.0.x charset

|___/ /\ \/~~~ Jean-Marc PULVAR (Web Programmer) Boonty SA 4 bis villa du mont tonnerre 75015 PARIS --- -- MySQL General Maili

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

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 doin

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 repli

Re: after upgrade unicode characters changed to question marks

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

Re: Multi-languages sites with Mysql 4.0

; Alec Jean-Marc PULVAR <[EMAIL PROTECTED]> wrote on 21/07/2004 10:45:22: 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 lat

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 comparisons

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 re

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

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 i

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. You'd need to run 3 instances of MySQL on DEPOT, one for each WWW server you'd like to mirro

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 configurat

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 >

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 transaction

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 lot

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)

# mysql --user=foo --password=password -h host foo 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 the

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

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 abl

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...

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

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 ve

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 n

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]

Replication Issue

OVIDER_ID' cannot be null 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 repl

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 > WHE

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 y

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 a

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: InnoDB Load Problem

ine if the 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 :

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. > > My

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 d

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 interc

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

RE: InnoDB

nt to use innodb you can add "skip-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

  1   2   3   >