On 6/26/07, Brown, Charles <[EMAIL PROTECTED]> wrote:
The MYSQL general query log does not include timestamp of queries that
it logs because queries are logged many many seconds before they are
executed.
Which version of MySQL are you running? I'm running 5.0.22 on my
desktop, but I'm fairly s
I am doing this to move data from one table to other and getting below
error.
How can check this particular record at this row number 921888 in dats_tem
table.
insert into reports1.dats1 select * from dats_tem;
ERROR 1292 (22007): Incorrect datetime value: '-00-00 00:00:00' for
column 'P_LAS
On 3/14/07, Clyde Lewis <[EMAIL PROTECTED]> wrote:
System Configuration: Sun Microsystems sun4u Sun Fire E2900
System clock frequency: 150 MHZ
Memory size: 65536 Megabytes
CPU: 12 @ 1200 MHz
I'm looking for a tool that will allow us to determine the max number
of databases that can run in a sin
On 3/13/07, Merlin <[EMAIL PROTECTED]> wrote:
I just compiled mysql4.1.22 on a suse 9.3 machine. All went fine, but
when I try to change the password I get prompted for one. So I hit
return as it is supposed to be blank, right? But it seems to be not:
/usr/local/mysql/bin # ./mysqladmin -u root
On 3/11/07, Jean-Sebastien Pilon <[EMAIL PROTECTED]> wrote:
I am running a mysql database server and we experienced a power failure.
The mysql server does not want to restart because innodb is corrupted.
Version info:
Mysql version 4.1.11-Debian_4sarge7-log
Debian sarge
Reiserfs filesystem
Wha
On 3/8/07, Gary Sewell <[EMAIL PROTECTED]> wrote:
I'm having a problem with a single repair query seemingly taking over the
whole server. I'll try and explain….
Large table or 1.2m rows, running a repair on this causes the query queue to
grow and grow and finally max out.
The problem isn't tabl
We're running mysql 4.1.20. If I understand the manual correctly, I can
change max_connections while mysqld is running without restart mysqld to
make the change take effect
Correct.
But what if mysqld restarts later in some
other situations, like machine reboot, would my (global) change on
ma
On 2/20/07, Clyde Lewis <[EMAIL PROTECTED]> wrote:
I'm looking to find a way to determine the number of transactions
that a particular database is processing each min/hour/day/month/year
http://dev.mysql.com/doc/refman/4.1/en/show-status.html
http://dev.mysql.com/doc/refman/4.1/en/server-statu
Would like to know what is the archive "db.opt".
http://www.google.co.uk/search?q=mysql+db.opt&start=0&ie=utf-8&oe=utf-8&client=firefox-a&rls=org.mozilla:en-US:official
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Master_SSL_Allowed: Yes
Master_SSL_CA_File: /root/.mysql/cacert.pem
Master_SSL_CA_Path: /root/.mysql/
Master_SSL_Cert: /root/.mysql/client-cert.pem
Master_SSL_Cipher:
Master_SSL_Key: /root/.mysql/client-key.pem
Seconds_Behind_Mast
I need to create an application where i will be requiring a backup server
like when one server fails i can switch automatically to the other server
hosted somewhere else , now the data needs to be consistent on both the
servers, one sol is i keep automated backups on the primary server and
restore
On 12/4/05, Luiz Rafael Culik Guimaraes <[EMAIL PROTECTED]> wrote:
> Dear Friends
>
> Is their an Page with data of how much bandwidth mysql consume when using
> remote servers?
mysql> show status like 'Bytes_%';
+++
| Variable_name | Value |
++---
Hi,
Our company is considering migrating some tablesfrom MyISAM to InnoDB,
as it has row-level locking and other improvements over MyISAM.
However, one of the things we do at the moment is rsync the MySQL data
directory to our development server every night over an 2Mbps ADSL
connection (as we h
Nico Sabbi wrote:
[...]
There are 3 GB of logs that no one needs anymore. Since the master knows
that all
the slaves are correctly aligned up to a certain MASTER_LOG_POS, can't
it automatically remove the logs up to that position?
The problem here is that MySQL masters aren't necessarily aware of
Juan Fernandez wrote:
I see 3 packges:
Mod_auto_mysql-20030510-3.i386.rpm
Mysql-3.23.58-4.i386.rpm
Php-mysql.
Which one to pick
Thanks !!
Mysql-3.23.58-4.i386.rpm
-- Alex
-Original Message-
From: Alex Greg [mailto:[EMAIL PROTECTED]
Sent: Monday, September 13, 2004 4:06 PM
To: Juan
Juan Fernandez wrote:
Hi !!
I am trying to install mysql without the server on fedora:
when I issue the command :
[EMAIL PROTECTED] snort-2.2.0]# cd ../mysql-3.23.52
[EMAIL PROTECTED] mysql-3.23.52]# ./configure --without-server
--prefix=/usr/local/mysql
everything is fine but after I issue the com
Hi,
We recently moved to new servers, and also upgraded from MySQL 3.23 to
4.0.20. We have one master database server and a second identical
machine configured to replicate all databases from the master.
Previously this has worked without a hitch, but we seem to be having
some problems.
The wa
Michael Winston wrote:
On Sep 1, 2004, at 9:10 AM, V. M. Brasseur wrote:
Michael Winston wrote:
Hi-
We've been running into a pretty serious problem for the past several
versions of mysql 4.0 running on OS X (both client and server).
Every once in a while we wake up to find the "too many connec
Hi,
I'm noticing this error in various script of ours that run on the cron:
DBI connect('general:10.1.1.80:3306;mysql_connect_timeout=3','root',...)
failed: Can't connect to MySQL server on '10.1.1.80' (115) at
/usr/local/apache/cgi-bin/Shared/DBStuff.pm line 214
This happens on a number of our
> Hi,
>
> I have recently had a system crash that required the
> installation of a new hard drive. I have access to the
> files on the old hard drive, on which is a database I
> need to recover.
>
> I am running MySql 3.23.37 and all the tables in the
> database to be recovered are MyISAM.
>
> How
> Stefan,
>
> it depends ...
>
> For MyISAM tables max size is limited by the maximum filesize of your
> OS/Filesystem.
Following on from that, the maximum file size you can have on 32-bit Linux is 2GB,
unless your distro has LFS (Large File Support),
in which case is is much larger (terabytes, n
>
> > Having just set up a RedHat Enterprise Server V.3 I am trying to add a
> > MySQL database function. I tried and failed using up2date (following
> > instructions from RH), so downloaded the rpms and began to install by
> > myself. My input and the output is shown below:
> >
> > # rpm -i
> Having just set up a RedHat Enterprise Server V.3 I am trying to add a MySQL
> database function. I tried and failed using up2date (following instructions
> from RH), so downloaded the rpms and began to install by myself. My input
> and the output is shown below:
>
> # rpm -i mysql-server-3.23
> Alex Greg wrote:
> > Hi,
> >
> >
> > Our main database server is a 2 x PIII 1.2Ghz with 1.5GB RAM and a 73GB SCSI
> > RAID-5 made up of 3 36GB disks. It does between 300
and
> > 1200 queries per second. The read to write ratio is about 4:1.
> >
Hi,
Our main database server is a 2 x PIII 1.2Ghz with 1.5GB RAM and a 73GB SCSI RAID-5
made up of 3 36GB disks. It does between 300 and
1200 queries per second. The read to write ratio is about 4:1.
My problem is that we're hitting our max_connections more and more frequently. Is it
safe to
> Please how can I remove a RPM installation. I used MySQL-server-4.1.1-1.i386.rpm to
> install MySQL, but how can I delete it.
rpm -e MySQL-server-4.1.1-1.i386
-- Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[E
this isn't an
option.
Any advice on this would be appreciated.
Alex Greg
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I have a select query which is selecting all records in a table (which has
around 8,000,000 rows in). "time" is a field of type "time". Should I be using
<= and >= or BETWEEN to find records in a certain range? Which does MySQL
optimise for?
select time,price from csq where id = 12345 and da
> Hi all. I am trying to install mySql on Solaris 2.6. I am getting the
following error during 'make':
>
> ld: fatal: library -lz: not found
> ld: fatal: File processing errors. No output written to
.libs/libmysqlclient.so.10.0.0
> make[2]: *** [libmysqlclient.la] Error 1
> make[2]: Leaving direct
> I try to grand some rights by using GRAND
You want GRANT, not GRAND.
-- Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> Hello,
>
> I am running two instances of mysql. They both run on different boxes, not
networked.
>
> Anyway, I have been developing on one machine, and trying to do a dump and
keep the other box updated with Database changes.
>
> I have ran this from the dev box.
> mysqldump --add-drop-table -u d
> Hi.
> I haven't mysql enabled in php. How may I do it? I have php 4.0.4, mysql
3.23.36, both installed on linux RH 7.3.
Install the php-mysql RPM.
-- Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECT
> Thx' Alex.
>
> do the old RPM's need to be removed first before upgrading ??
You can just do:
rpm -Uvh MySQL-*
in the directory with the new RPM's in - this will overwrite the old packages
with the new ones.
-- Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
> Hello,
>
> we are currently running MySQL 4.0.15 w/InnoDB tables on a RH/Linux 9.0 and
> would like to upgrade. the current RPM's installed are:
>
> MySQL-client-4.0.15-0
> MySQL-embedded-4.0.15-0
> MySQL-devel-4.0.15-0
> MySQL-shared-compat-4.0.15-0
> MySQL-shared-4.0.15-0
> MySQL-server-4.0.
34 matches
Mail list logo
