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
Hi all,
I just noticed this in the manual yesterday:
http://www.mysql.com/doc/en/Windows_running.html
"MySQL supports TCP/IP on all Windows platforms. The mysqld-nt and
mysql-max-nt servers support named pipes on NT, 2000, and XP. The default is
to use TCP/IP regardless of the platform, because n
I'm not sure what your request is. My gut instinct is to suggest for you
to write some code (PERL / etc).
Headers what headers, headers from the mysql client?
-->-Original Message-
-->From: sjonnalagadda [mailto:[EMAIL PROTECTED]
-->Sent: Friday, August 22, 2003 9:00 AM
-->To: [EMAIL PR
[EMAIL PROTECTED] wrote:
> > I say go with RAID 5, on a controller card.
>
> > Mirroring just gives you backup, and you lose half your diskspace. It
> offers
> > no performance benefit, and actually the computer might have to work
> harder
> > to make sure the drives are in sync.
>
> I do not thi
>Description:
High Resolution Science Imaging experiment(HiRISE) project for one of
important instrument on MRO spacecraft which will be launched to MAR in
2005 are using MySQL server 4.0.13 as database management system.
we recently encounter a unstable privilege problem.what we do like that:
(1)
Hi, I'm currently using the following mysql statement to perform a search.
Right now it is only returning the results which are found in the
description field. How do I modify this statement so that it is searching
the following fields: company_name, product_name, description.
SELECT product_id,
Jon Drukman unknowingly asked us:
Antony Dovgal wrote:
try to use error_reporting(E_ALL); and to see what happends.
maybe error logging will help you to solve your trouble.
I don't beleive in such bugs, it's a problem of your code imho.
here's my code:
mysql_connect() or die("mysql connect fail
Hello All,
I am trying to find out how I can change my timestamp(14) to timestamp(8).
Thanks in Advance,
-Dan
On Fri, Aug 22, 2003 at 12:42:27PM -0700, Steven Roussey wrote:
>
> But since this data is read only, why not reformulate the data for the
> queries you are going to make? This is the opposite of normalizing, and
> will require more disk space, and is not flexible, but it will be fast.
> Of course
Hello All,
I am trying to find out how I can change my timestamp(14) to timestamp(8).
Thanks in Advance,
-Dan
does shutting down the database server and restarting it have the same
effect?
jeff
Heikki Tuuri wrote:
>
> Per,
>
> I think a 'null' alter table operation:
>
> ALTER TABLE innodbtable TYPE=INNODB;
>
> does the defragmentation with just one build of the table. And I think it
> also preserves
G'day Bob
>> I'm a novice Unix user, and I can't get MySQL set up properly on my
>> Mac. It seems to have installed OK, but when I try to run the
>> mysql_install_ db script, I get errors. I can't set the root password
>> either that the documentation tells me to.
There is an alternative inst
Antony Dovgal wrote:
try to use error_reporting(E_ALL); and to see what happends.
maybe error logging will help you to solve your trouble.
I don't beleive in such bugs, it's a problem of your code imho.
here's my code:
mysql_connect() or die("mysql connect failed: $php_errmsg / " .
mysql_error())
After looking over your results, I would keep the dir1 index at least on
the first and last table.
But since this data is read only, why not reformulate the data for the
queries you are going to make? This is the opposite of normalizing, and
will require more disk space, and is not flexible, but i
Hi
I builded a little propert database. I added a search function to the site
but have the following problem:
I used "SELECT *
FROM table1 WHERE area ='province' and type like'%type_1%' and town
like'%town_1%' and descr like '%descr_1%' and suburb like '%sub_1%'"
But it do not do the like thing.
On Fri, Aug 22, 2003 at 10:07:46AM -0700, Steven Roussey wrote:
> Hmmm, just in case you can't change the table layout...
>
> Run this through MySQL. First I get rid of the other index I made, then
> add chained indexes so there is no need for data file lookup. Also, one
> direction of the query t
On Fri, Aug 22, 2003 at 09:03:55AM -0700, Steven Roussey wrote:
> > All the indexes were single indexes, partly because I haven't
> > yet made the effort to understand composite index. I guess it's
> > time ;-).
>
> Oh.
>
> There are better places to start than this list. ;) The manual can be a
>
Our virus detector has just been triggered by a message you sent:-
To: <[EMAIL PROTECTED]>
Subject: Re: Thank you!
Date: Fri Aug 22 19:30:49 2003
Any infected parts of the message have not been delivered.
This message is simply to warn you that your computer system may have a
virus present a
-Original Message-
From: news [mailto:[EMAIL PROTECTED] Behalf Of Jon Drukman
Sent: Thursday, August 21, 2003 9:24 PM
To: [EMAIL PROTECTED]
Subject: Re: RAID or not?
Lefevre, Steven wrote:
> I say go with RAID 5, on a controller card.
>
> Mirroring just gives you backup, and you lose h
Hmmm, just in case you can't change the table layout...
Run this through MySQL. First I get rid of the other index I made, then
add chained indexes so there is no need for data file lookup. Also, one
direction of the query table join chain was not always using the indexes
for the where. One direct
Thank you for the Email. I will contact you within 24 hours.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi
I am running MySQL 4.0.13 with my-medium.cnf (attached) on a Solaris 8, 4x450
Mhz, 4gb RAM. All my tables are InnoDB. Currently my ibdata1 is 1.8 gb. I have
about 1 gig space left on the same partition. Also it is excruciatingly slow
now. How do prevent the ibdata1 from filling up the disk part
On Fri, Aug 22, 2003 at 09:20:08AM -0500, Christensen, Dave wrote:
> This may seem like a stupid question, but I haven't been able to track down
> an answer yet. We're going to try to access a remote MySQL server that is
> protected behind a firewall. I know that we need to open a port, such as
>
Joseph,
How big your table files are? Are they MyISAM or Innodb ? Do you have
indexes? How much memory do you have? Is your MySQL running on a
dedicated server or do you run anything else on your db server?
This questions needs to be answered before suggesting anything logical.
But general sugges
On Fri, Aug 22, 2003 at 09:20:08AM -0500, Christensen, Dave wrote:
> I know that we need to open a port, such as
> 3306, to access the server. My question is whether that port requires TCP,
> UDP or both to be open.
TCP.
> Thanks!
>
> David Christensen
> Brokers International, Ltd.
> 1200 E Mai
> All the indexes were single indexes, partly because I haven't
> yet made the effort to understand composite index. I guess it's
> time ;-).
Oh.
There are better places to start than this list. ;) The manual can be a
great starting place, and several people on this list have written books
about
Hello All,
By default Mysql select statement displays column names header only once
at the first row.
I want the column names for the select statment to be displayed after
every say 15 rows of display. ( This is very much equal to set line size 15
in oracle) .
can any one Help ASAP.
I have noticed the binary distributions (OSX) are not complied for SSL
which is exactly what we need to have for our database transactions
using the cross-platform product Navicat.
*Source-distribution*
I have gotten as far as having to edit the "configure" file and change
the library from "li
Christensen, Dave wrote:
This may seem like a stupid question, but I haven't been able to track
down
an answer yet. We're going to try to access a remote MySQL server that
is
protected behind a firewall. I know that we need to open a port, such
as
3306, to access the server. My question is wheth
On Fri, Aug 22, 2003 at 07:33:56AM -0700, Steven Roussey wrote:
> > Here's the CREATEs, somewhat edited to remove parts not relevant
> > to this discussion, to save space:
>
> I never actually looked at your JOIN statement more than a quick
> glimpse, but I will (though not just right now). Before
On Fri, Aug 22, 2003 at 10:23:37AM -0400, Keith C. Ivey wrote:
> On 21 Aug 2003 at 21:38, Jesse Sheidlower wrote:
>
> > Huh, I was told the exact opposite, that if most of the
> > entries are smaller than the maximum length of the field, you
> > should use an index about the size you expect most e
Thank you for the Email. I will contact you within 24 hours.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi!
On Aug 21, Nils Valentin wrote:
> Hello MySQL Fans,
>
> This time I am using 4.0.13-max (tar format from www.mysql.com) on
> Redhat 9.
>
> I have an understanding question why would the command SHOW VRAIABLES
> give me once the real output and once the symlink ouput for directory
> names
On Fri, Aug 22, 2003 at 10:55:49AM +0530, Rupak Banerjee wrote:
> Hi,
>
> We are using MySql version 3.27.53 on a Red Hat Linux platform version
> 7.2. For the past couple of months we are noticing that the performance
> of the server has gone down very badly. Every, single insertion is
> taking
"Kim G. Pedersen" <[EMAIL PROTECTED]> wrote:
>
> How can I see the lastest Sql Commands/statements which
> has been send to my mySql server ??
>
> Are there Any Logfile or command to use ???
Yes, you can check log file. You can enabled general query log with --log option of
mysqld.
--
For t
Bob Goldberg <[EMAIL PROTECTED]> wrote:
> I'm a novice Unix user, and I can't get MySQL set up properly on my
> Mac. It seems to have installed OK, but when I try to run the
> mysql_install_ db script, I get errors. I can't set the root password
> either that the documentation tells me to.
What
Once you get everything up and running, and get the basics of MySQL
down, here are some tools that can make database administration on the
Mac a little simpler in terms of doing every day things, like creating
databases, tables, searching, sorting and exporting:
Cocoa MySQL- http://versiontrack
> Here's the CREATEs, somewhat edited to remove parts not relevant
> to this discussion, to save space:
I never actually looked at your JOIN statement more than a quick
glimpse, but I will (though not just right now). Before I do, can you
try this (I still don't have data or I'd play with it mysel
Hello!
Sorry not to have given any signs of life...
Thank you for your answer. Changing the number of connections to 100 solved
the problem of the Server configuration error, but I've gone back to
getting java.sql.SQLException: DBCP could not obtain an idle db connection,
pool exhausted (whole exc
On 21 Aug 2003 at 21:38, Jesse Sheidlower wrote:
> Huh, I was told the exact opposite, that if most of the
> entries are smaller than the maximum length of the field, you
> should use an index about the size you expect most entries to
> be. Why would you ever use a shorter index than the full colu
This may seem like a stupid question, but I haven't been able to track down
an answer yet. We're going to try to access a remote MySQL server that is
protected behind a firewall. I know that we need to open a port, such as
3306, to access the server. My question is whether that port requires TCP
iH
you may find this site helpful in getting MySQL running for the first
time
http://www.entropy.ch/software/macosx/mysql/
also recommend that you spend some time learning how to be root, unix
permissions, etc
- hcir
On Thursday, Aug 21, 2003, at 22:53 America/Anchorage, Bob Goldberg
wrote:
Hello
How can I see the lastest Sql Commands/statements which
has been send to my mySql server ??
Are there Any Logfile or command to use ???
Thanks in advance
Kim G. Pedersen
macaos/elprint Development
+45 35373808
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mys
[EMAIL PROTECTED] wrote:
>I downloaded MySQL 3.23.57 for Windows as I wish to learn MySQL
> locally and then use the one I already have installed on my UNIX server.
> I ran setup and rebooted but the WinMySQLadmin program will not start
> the Server as it has a MyODBC error "Driver 3.
"Rupak Banerjee" <[EMAIL PROTECTED]> wrote:
> Hi,
> We are using MySql version 3.27.53 on a Red Hat Linux platform version
> 7.2. For the past couple of months we are noticing that the performance
> of the server has gone down very badly. Every, single insertion is
> taking a hell lot of time.The
Hello Tim,
Do've an example on using Rebol to connect to mySQL via TCP/IP?
How do you do it? How do you execute SQL quieries? Return results etc ?
Kind Regards,
Lennie De Villiers
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
Hello,
starting from some software database spesification,
defined in some Enhanced entity relationship diagram,
resulting in all kinds of
relationships,
1:1
1:Many
Many:1
Many : many
And last but not least:
Subclass/superclass relationship
This seems to be a small problem for me,
With the cu
But it is procedure that the MySQL documentation states MySQL uses themselves without
any problems. Perhaps the documentation isn't stated clear enough.
Quote 4.4.7 Setting Up a Table Maintenance Regimen
--
You should also check your tables regularly during normal system operation. At My
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Luong Phan wrote:
> Hi all,
>
> In my web application, I use mysql supported by Redhat Linux 7.3 to
store database, jakarta-tomcat-3.2.4,
> mysql-connector-java-3.0.6-stable-bin.jar, and JSP.
>
> Every time, I run the program:
>
> import java.io.IOExc
Nils Wisiol wrote:
>
> hi
> There is a Bug in the InstallWizard Engine. If I install mysql on my winxp
> professional system WITHOUT sp1, install shield say goodbye when the setup is almost
> ready. i've tried custom and completly installation. maybe its a failied download.
> the mysql version
Merhaba,
Fri, 22 Aug 2003 15:15:22 +0530 tarihinde "sanjay gupta"
<[EMAIL PROTECTED]> soyle yazdi:
SG> can anybody tell me the differance between the innidb and myisam tables
SG> types .
Try having a look at the MySQL Manual -- described both in brief and in
detail.
http://www.mysql.com/doc/en/T
hi
There is a Bug in the InstallWizard Engine. If I install mysql on my winxp
professional system WITHOUT sp1, install shield say goodbye when the setup is almost
ready. i've tried custom and completly installation. maybe its a failied download. the
mysql version is: mysql-4.0.14b-win.zip
cya
Hi All,
Has the MBREquals function been implemented in the latest 4.1.1-alpha
build. I am finding problems with that command. It says that problem is
there in sql syntax. If it has been implemented. Can you please help me
in the syntax of the command.
I am finding the same problems with the
Inter
Per,
I think a 'null' alter table operation:
ALTER TABLE innodbtable TYPE=INNODB;
does the defragmentation with just one build of the table. And I think it
also preserves FOREIGN KEY constraints.
Please test it!
Best regards,
Heikki
Innobase Oy
http://www.innodb.com
InnoDB - transactions, fo
I have your same problem in my network where the master i 3.23.52 and then
slave are 4.0.14; before, in all 4.0.13, it was ok, without this bug.
It will be solved in 4.0.15 ?
Best regards
Massimo
- Original Message -
From: "I.P." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday,
Hi,
I am hopping to get mysql compiled for arm in an i386 redhat pc.
I have the cross compiler and some arm distribution, the version of the
gcc is 2.95.3, and mysql distribution is 3.23.57.
I do a:
./configure --prefix=/usr/local/arm/arm-linux --host=arm-linux
--build=i386-linux
and after a w
For the most important diferences:
INNODB: Foreign Keys, Row level Locking, Transactions
Tablespaces for the storage of data and index (quite similar to
Oracle)
MYISAM: Table level locking, No transaction, No Foreign key
Storage using One file per table or index
Hi all,
In my web application, I use mysql supported by Redhat Linux 7.3 to store database,
jakarta-tomcat-3.2.4,
mysql-connector-java-3.0.6-stable-bin.jar, and JSP.
Every time, I run the program:
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import
Hi, it's my story.
I have two 4.0.14 mysql server on one machine with win XP Professional
polish version.
First acts as master: on port 3300
Second acts as slave: on port 3301
below my configuration:
### FOR MASTER #
# This will be passed to all mysql clients
[client]
#pass
Hi all ,
can anybody tell me the differance between the innidb and myisam tables
types .
sanjay
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
"Song, Jay" <[EMAIL PROTECTED]> wrote:
> I am sure if it's possible to do that, but I want to use mysqldump to backup
> my databases. However, there is only one large table I want to exclude. Can
> this be easily done?
You can't.
Use --tables option to dump needed tables.
--
For technical suppo
> I say go with RAID 5, on a controller card.
> Mirroring just gives you backup, and you lose half your diskspace. It
offers
> no performance benefit, and actually the computer might have to work
harder
> to make sure the drives are in sync.
I do not think it is true that mirroring gives no per
Hi Rupak!
> We are using MySql version 3.27.53 on a Red Hat Linux platform version
> 7.2. For the past couple of months we are noticing that the performance
> of the server has gone down very badly. Every, single insertion is
> taking a hell lot of time.The particular table has only 150,000 reco
Hi,
We have an InnoDB database which is get quite fragmented. We defragment
it about once a month, converting the table from innodb to myisam and
back. After a defragmentation our database performance is more or less
doubled. IO-strain is reduced with 50%.
Would it be possible to have "alter tabl
I'm a novice Unix user, and I can't get MySQL set up properly on my
Mac. It seems to have installed OK, but when I try to run the
mysql_install_ db script, I get errors. I can't set the root password
either that the documentation tells me to.
As background, I just want to use MySQL to work with
On Thu, 21 Aug 2003 17:56:55 -0400
Rajesh Kumar <[EMAIL PROTECTED]> wrote:
> But does anyone know of a way to find out the number of seconds it took
> to execute a particular query using PHP?
use microtime(); - http://php.net/microtime
---
WBR,
Antony Dovgal aka tony2001
[EMAIL PROTECTED]
--
M
66 matches
Mail list logo
