Rajesh Kumar wrote:
Peter Brawley unknowingly asked us:
Interestingly, use of date_add() and date_sub() on 'odd' dates such
as Feb 31 does produce sane results.
Subtract one from 2000 Feb 31, and you'll get 2000-03-01.
This is sane!!??
This is where Unix Timestamps come into action (and
On Thu, 21 Aug 2003 18:18:37 -0700
Jon Drukman [EMAIL PROTECTED] wrote:
that is true, but in this case, neither $php_errmsg nor mysql_error()
return anything. i print them both out when the connect fails and they
are both just blank.
try to use error_reporting(E_ALL); and to see what
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]
--
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
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
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
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
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 support
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]
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]
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
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,
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
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,
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,
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
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
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.
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 is:
-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.IOException;
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
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
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:
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
[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.51
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:
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
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
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 column
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
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
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-
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
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 technical
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 a
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 ?
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]
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 entries
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 I do,
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
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
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
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
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 Main St
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
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
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
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]
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
-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
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
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
great
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.
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
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());
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
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 FOREIGN
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, it
Hello All,
I am trying to find out how I can change my timestamp(14) to timestamp(8).
Thanks in Advance,
-Dan
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
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,
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)
[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 think it is
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
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
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
67 matches
Mail list logo
