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]

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.

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

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]

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

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

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

Problem with query comparing to a DATE on Linux OpenOffice

ably related only to OpenOffice, and not a mysql problem, but I haven't gotten any answers on the OOo lists. So I'm hoping some kind soul on the mysql/myodbc lists might have experienced this and have an answer. Thanks for any ideas. -- Marc <[EMAIL PROTECTED]> -- MySQL Ge

Re: Problem with query comparing to a DATE on Linux OpenOffice

eet, ...) that also has a database interface. You can check it out at www.openoffice.org -Marc > > Marc <[EMAIL PROTECTED]> wrote:I'm using OpenOffice 1.1.0 as a front-end to MySQL > 4.0.14 on Gentoo > Linux and can't compare a field to CURDATE(). The error is, "The fi

Re: mysqlfront versus mysqlcc

It looks nice. Too bad it's not Linux, yet. Hopefully in 2004. -Marc On Fri, 2003-11-14 at 08:51, Daniel Kiss wrote: > Try SQLyog at www.sqlyog.com > > It is pretty good, and full of interesting features. > > >I currently use the excellent mysqlfront which is sadly

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

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

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

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

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]

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]

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

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.

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 lo

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

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.

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

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

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: Help me - please

You must be 'root' to do a "ulimit -n 1024". Marc. -Message d'origine- De : Carlos André Moura de Amorim [mailto:[EMAIL PROTECTED] Envoyé : vendredi 19 décembre 2003 14:55 À : Chris Elsworth Cc : [EMAIL PROTECTED] Objet : Re: Help me - please i added ulimit -n

Online Training for mysql

Does anyone know of a site that offers online training in mysql for the purpose of passing the certification tests? I am willing to pay for descent training, especially if the provider is recognized by mysql AB. Sincerely, Marc DVer -- MySQL General Mailing List For list archives: http

RE: MySQL on RAID server????

You can afterwards the installation specify the path to the data in the "my.cnf" config file. Marc. -Message d'origine- De : Kirti S. Bajwa [mailto:[EMAIL PROTECTED] Envoyé : mercredi 31 décembre 2003 01:08 À : [EMAIL PROTECTED] Objet : MySQL on RAID server Hello Li

Best Method for Learning mysql

lease feel free to send a private email. In fact, its probably better if people in general send me private emails, from which I shall endeavor to summarize to the public list. Sincerely, Marc DVer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

What is the limit of the history command file under Linux

Does anybody have an idea of the number of sql commands that can be saved inside the sql history command file ? Is there a way to set this limit ? Thanks, Marc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

RE: MYSQL 5 Stored Procedure

Documentation: http://www.mysql.com/doc/en/Stored_Procedures.html Marc. -Message d'origine- De : Peter Brawley [mailto:[EMAIL PROTECTED] Envoyé : mercredi 7 janvier 2004 16:32 À : [EMAIL PROTECTED]; [EMAIL PROTECTED] Objet : Re: MYSQL 5 Stored Procedure Matthew, You need to ru

Recommended Course

This might be a bit of a repeat, but I didn't get too many responses. Can someone recommend a course in the Northeast of the US that teaches the details of the use of mysql? Sincerely, Marc DVer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubs

mysql In Israel

are certified, etc. No, I don't want to talk about politics or religion. No, I'm not asking for a job. Sincerely, Marc DVer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: is this possible?

To drop all tables, yes do a drop database. To drop all with something like a exclude, no. What you can do is an export of the tables you don't want to drop, then do a drop database + create database + import Marc. -Message d'origine- De : Nitin Mehta [mailto:[EMAIL PROTECT

Certification Test Questions

aul Dubois, and "An Introduction to Database Systems" by C.J. Date. Would these materials, together with practice on a live server, suffice to give me the knowledge to pass the certification test? 3. What version is the test geared for? Sincerely, Marc DVer -- MySQL General M

Archiving Mail on mysql

a database. I'm a newbie at databases, so I'm wondering how would I handle messages that have binary attachments. I could send the whole thing as a blob, but then I would have problems with full text searching. I'm willing to work with other people on this and share whatever cod

RE: FKs in InnoDB

SHOW TABLE STATUS In the "Comment" Column you have the definition of the foreign keys. Marc. -Message d'origine- De : Don Vu [mailto:[EMAIL PROTECTED] Envoyé : mardi 27 janvier 2004 17:48 À : [EMAIL PROTECTED] Objet : FKs in InnoDB Hi, I'm using MySQL 4.0.1

RE: [Mysql-discussions] SQL CONNECTIVITY

libraries installed by MySQL, thus avoiding any conflicts. Marc. -Message d'origine- De : Seena Blace [mailto:[EMAIL PROTECTED] Envoyé : vendredi 30 janvier 2004 17:44 À : [EMAIL PROTECTED] Objet : RE: [Mysql-discussions] SQL CONNECTIVITY I installed php. what is linux9? =RED HAT 9 aCT

Re: select speed

On Thu, 26 Feb 2004, Lorderon wrote: > Hi All, > > If I got one table A_table with many columns, and a second table B_table is > the same but with just primary field and unique field... > How much meaningful is the time difference between these queries? > 1. SELECT unique_field FROM A_table WHERE

Re: Two indexing questions

On Thu, 26 Feb 2004, Keith Thompson wrote: > Given these two tables: > > create table t1 ( >id int unsigned auto_increment, >a int, >... [other fields] >primary key (id), >index aid (a,id) > ) type=innodb; > > create table t2 ( >id int un

New mtop/mkill version available

mtop (MySQL top) monitors a MySQL server showing the queries which are taking the most amount of time to complete. Features include 'zooming' in on a process to show the complete query, 'explaining' the query optimizer information for a query and 'killing' queries. In addition, server performance s

Re: Replication Performance

ave will use non-transactional MyISAM tables instead of BDB tables to get more speed. 2/ Is there any documentation on handling and configuring large tables? Hope this is not too confusing... Many thanks Todd Burke phbnyc.com Marc Prewitt -- MySQL General Mailing List For list archives: http:/

Re: Meaning of Column time in Show Processlist

ening table, closing table, ...) that is used for the amount of time ? What happens to the thread if the value of time is greater than interactive timeout or wait timeout ? Regards, Marc Mechain -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscri

RE: Meaning of Column time in Show Processlist

Thanks very much. Marc. -Message d'origine- De : Jeremy Zawodny [mailto:[EMAIL PROTECTED] Envoyé : mercredi 13 août 2003 17:01 À : Mechain Marc Cc : [EMAIL PROTECTED] Objet : Re: Meaning of Column time in Show Processlist On Wed, Aug 13, 2003 at 03:26:24PM +0200, Mechain Marc

Meaning of Column time in Show Processlist

the variables "wait timeout" and "interactive timeout" ? Regards, Marc Mechain Atos Origin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

What's the meaning of: "InnoDB: Warning: using a partial-field key prefix in search"

In one of my logfiles I have quite repeatedly the following message: InnoDB: Warning: using a partial-field key prefix in search What does this warning mean ? Regards, Marc Mechain Atos Origin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Need help optimizing query, awfully slow on only 20000 records

Two Questions: Is the same query running directly on the linux server thru mysql is also very slow ? Have you done a explain plan on the query ? Marc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: marking all records based on a text file

Another way to do it, create a temporary table load the content of your text file in it, and then do your update crossing the two tables. Marc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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

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

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

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

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

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

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

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; > +++--+--+-+---+- > +--++

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

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

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

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

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

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

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

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 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: Slow results with simple, well-indexed query

What is the value of "sort_buffer_size", may be you could increase the value for having faster ORDER BY (all in memory intead of using temporary file on disk). Marc. -Message d'origine- De : Jesse Sheidlower [mailto:[EMAIL PROTECTED] Envoyé : jeudi 21 août 2003 1

RE: differance between InnoDB and MyISAM tables ?

on disk Marc. -Message d'origine- De : sanjay gupta [mailto:[EMAIL PROTECTED] Envoyé : vendredi 22 août 2003 11:45 À : [EMAIL PROTECTED] Cc : [EMAIL PROTECTED] Objet : differance between InnoDB and MyISAM tables ? Hi all , can anybody tell me the differance between the innid

innodb use outside of explicit transactions

Suppose I have an innodb table in 4.0.14 and do: LOCK TABLE maggie INSERT INTO maggie values(123, 'simpson'); UNLOCK TABLES As soon as I issue LOCK TABLE, any transaction in progress is automatically committed. By what point is this INSERT guaranteed to be committed to disk (ie. redo log)? Is i

Re: innodb use outside of explicit transactions

On Sat, 23 Aug 2003, Heikki Tuuri wrote: > Marc, > > - Original Message - > From: "Marc Slemko" <[EMAIL PROTECTED]> > Newsgroups: mailing.database.mysql > Sent: Saturday, August 23, 2003 7:19 AM > Subject: innodb use outside of explicit transactions &

Re: Spam from this list

Strange, I never get those!! Marc - Original Message - From: "Thomas Andersson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, August 23, 2003 3:41 PM Subject: Re: Spam from this list > Joe Baptista wrote: > > > are you getting spam or a

RE: 64-Bit and INNODB

On Mon, 25 Aug 2003, Wendell Dingus wrote: > I didn't notice a reply to this when first posted. Surely someone has > stuffed a lot of memory into an Opteron or Itanium by now and knows the > answer. Is a 64-bit Malloc all that is necessary or does INNODB have to > specifically support more memory

RE: Very slow connexion

A DNS problem, may be ... Marc. -Message d'origine- De : JOUANNET, Rodolphe [mailto:[EMAIL PROTECTED] Envoyé : vendredi 5 septembre 2003 13:02 À : [EMAIL PROTECTED] Objet : Very slow connexion Hi, This problem is specific to the WAN connexion, not to the LAN connexion. I

RE: InnoDB, Replication, and Data warehouse: Oil, Water, and little floating plastic men

On Wed, 24 Sep 2003, Misaochankun wrote: > Error(using 2.5G RAM out of 4G total): > > 030924 15:39:55 mysqld started > Warning: Ignoring user change to 'mysql' because the user was set to > 'mysql' earlier on the command line > InnoDB: Fatal error: cannot allocate 2684370944 bytes of > InnoDB: me

slow performance with large "or" list in where

If I do a query such as: SELECT * from foo where fooid = 10 or fooid = 20 or fooid = 03 ... with a total of around 1900 "or fooid =" parts on a given table with 500k rows, it takes about four times longer than doing 1900 separate queries in the form: SELECT * from foo where fooid = 10 fooid is

Re: slow performance with large "or" list in where

the mysql command line client doesn't change the problem in any way. In any case, I can't do any of this by writing commands to a file and loading them using the mysql client, I need to do it using JDBC. I have no problem executing all my updates sequentially except for the fact that it

Re: slow performance with large "or" list in where

On Sun, 5 Oct 2003, Santino wrote: > Have You test in operator? > > select * from table where id in (10,20,30,50,60,90, ) Yes, IN does perform at the levels I want and works for the simplified example I gave, but doesn't work for the generalized case I need, which is matching individual rows

RE: Big difference in MyISAM and InnoDB SELECT speed

Innodb may not use an index (full scan) where MyIsam does (index crc which is the only relevant one). Have you done an EXPLAIN on your query ? May be an index on (origin,status,deleted) could help. Marc. -Message d'origine- De : Janusz Krzysztofik [mailto:[EMAIL PROTECTED] E

RE: Inefficient use of index (was: Big difference in MyISAM and InnoDB SELECT speed)

use very often, I still think that creating an index on (origin,status,deleted) is the good answer. Marc. -Message d'origine- De : Janusz Krzysztofik [mailto:[EMAIL PROTECTED] Envoyé : lundi 24 novembre 2003 16:48 A : Mechain Marc Cc : [EMAIL PROTECTED] Objet : Inefficient use of i

RE: What causes this error, and how do i fix it?

May be Unix acces permissions on /root/tmp (Errcode: 13) = EACCES Permission denied Like you are using an ORDER BY, mysql needs some temporary space to do the order. Marc. -Message d'origine- De : Søren Neigaard [mailto:[EMAIL PROTECTED] Envoyé : jeudi 18 mars 2004 13:29 À : [

  1   2   3   >