On Fri, 2006-07-14 at 09:47 -0300, Miles Thompson wrote:
> At 09:15 AM 7/14/2006, Jeremiah Foster wrote:
> >Nearly once or twice a day the mysql daemon on our FreeBSD server has to
> >be restarted since it is taking up most of the processor.
> >
> >That is about 3 hours and a billion rows examined.
Ritesh Shetty wrote:
Hello,
My mysql server sometime just slows responding to database queriesIt
is as slow as less than 1 per sec.
But it speeds up by itself after some time , I have noticed that when it
speeds up there are lot more MYsql thread than just one thread when it
is slow.
So
Kay C. Tien wrote:
Hi All,
The simple script I'm testing works on a Linux server. I got tired of
having to upload and test them, so I decided to install MySQL on my
computer, which is running Win XP.
MySQL works fine on it's own, I've set the the database and etc., but
nothing happened whe
Xueron Nee wrote:
Hi all,
There is a table contains about 60,000 rows. where select from this
table with 'order by xxx' statement, it is tooo slow. but if i do it
without 'order by xxx', it works fine.
Is there any tips and suggestion for me? Thanks!
Add an index to the 'xxx' column?
That
thomas Armstrong wrote:
I created this very-simple '/etc/my.conf':
[mysqld]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/var
socket=/tmp/mysql.sock
---
But it doesn't still work.
'/usr/local/mysql/var' hosts the data, but within 'mysql'
subdirectory, there are
only two fil
L P wrote:
Folks,
say I have a need to add multiple rows at the same time.
for instance, say I'm collecting customer information and I want to add 3
addresses and 3 phone numbers at the same time for a customer.
The above is quite straightforward to accomplish when there is only one set
of data
[EMAIL PROTECTED] wrote:
I'm using MySQL 3.23.36 on RH 7.1. I've created a table photos (in
database album) with the following colums:
ID NUM AUTO_INCREMENT PRIMARY KEY
IMAGE MEDIUMBLOB
I'm running mysql from the command line:
mysql -u root
'root' has all privileges.
The file I'm trying to lo
On Wednesday 12 July 2006 20:58, Chris White wrote:
> performance?". From what I know of MySQL, not really, because MySQL does a
> good amount of work in memory. The only time I'd see disk access being a
> factor is if you had a large mass of swap/virtual memory.
I have to play with 300 gig of
Duncan Hill wrote:
Oh, as a small example - the DB server attached to the SAN can pull data
faster than my personal server, even though the personal server is only
dealing with one request and the DB/SAN is dealing with hundreds per second
(and the personal server is no slouch). Fun to watch a
Hi to all,
I am using MySql 5.0.15 windows version and java application to access
the database using MySql JDBC driver.
I come to one interesting issue regarding memory used by "mysqld-nt"
service and displayed in the task manager.
The service memory constantly increases as I write or r
I am stumped by a table lock issue. First, some details.
I am running MySQL 5.0.22 on an AMD 64 machine.
mysqld -V outputs:
/usr/local/libexec/mysqld Ver 5.0.22-debug-log for unknown-linux-gnu
on x86_64 (Source distribution)
uname -a:
2.6.8-11-amd64-generic #1 Wed Jun 1 00:42:47 CEST 2005
I´m having the same trouble a long time ago and still looking for the
solution.
""Kay C. Tien"" <[EMAIL PROTECTED]> escreveu na mensagem
news:[EMAIL PROTECTED]
> Hi All,
>
> The simple script I'm testing works on a Linux server. I got tired
> of having to upload and test them, so I decided to
I'm using mysql on Linux and all is going well but I can't find the
proper way to write a CREATE VIEW. I'm using 4.1 and is this function
still in mysql?
Karl Larsen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMA
Recently I deleted ~200.000.000 rows out of a history table. Still there
are 20.000.000 rows in the table.
So now I want to clear some discspace by copying the table, dropping the
old one and renaming the copy afterwards.
Is there another (faster) way to do that and how does one copy such a
Hi Dominic,
Why not just use an OPTIMIZE TABLE ? This will map to an ALTER table
command for an InnoDB table which will free the now unused space. From
the manual at http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html
For InnoDB tables, OPTIMIZE TABLE is mapped to ALTER TABLE, which
re
Hello.
I have a question about on delete cascade.
If i have 2 tables such as this:
Table1Table2
PrikeyPrikey
Table2foreinkey name
name description
description
Now if I delete a row from table1 that has a foreign
Thank you very much. I did not know this command. Well at least I never
looked up what it does.
I'll give it a try and see how it works out.
Why not just use an OPTIMIZE TABLE ? This will map to an ALTER table
command for an InnoDB table which will free the now unused space. From
the manua
On Monday 17 July 2006 13:26, Karl Larsen wrote:
> I'm using mysql on Linux and all is going well but I can't find the
> proper way to write a CREATE VIEW. I'm using 4.1 and is this function
> still in mysql?
If the MySQL manual for 4.1 does not list views as a feature of that version,
odds a
At 05:37 PM 7/17/2006 Monday, Chris wrote:
Kay C. Tien wrote:
Hi All,
The simple script I'm testing works on a Linux server. I got tired
of having to upload and test them, so I decided to install MySQL on
my computer, which is running Win XP.
MySQL works fine on it's own, I've set the the dat
Fleet, I'd also humbly suggest that the version you're using is VERY
old and you should update to at least the latest 3.23 (3.23.58 I
think), or 4.x, or maybe even 5.0 (production since last Fall).
Untold numbers of bugs fixed since 3.23.36.
Dan
On 7/17/06, Chris <[EMAIL PROTECTED]> wrote:
[EM
If I understand your question correctly - and I'm not sure I do - Table 2 is
the parent and Table 1 is the child. In other words, there is a one-to-many
relationship between the parent, Table 2, and the child, Table 1.
Therefore, if the parent table, Table 2, contains one row for each
departme
SHORT SYNOPSIS:
The statement
INSERT INTO table (blob_column) VALUES
(load_file('/home/somebody/image.jpg'));
Produces no error; but fails to load the image file.
SOLUTION:
The image file (or other binary file, I assume) MUST reside in / or /tmp,
ie /image.jpg or /tmp/image.jpg. (At least in MySQ
Hi Fleet
[EMAIL PROTECTED] wrote:
> SHORT SYNOPSIS:
> The statement
> INSERT INTO table (blob_column) VALUES
> (load_file('/home/somebody/image.jpg'));
>
> Produces no error; but fails to load the image file.
>
> SOLUTION:
> The image file (or other binary file, I assume) MUST reside in / or /tm
On Mon, 17 Jul 2006, Marc Alff wrote:
> Just to check, is the /home partition actually mounted on the server,
> and at the same place ?
>
> In other words, does /home/fleet/image.jpg exists :
> - when seen from the host running mysql
> - when seen from the host running mysqld
In answer to the abo
At 05:37 PM 7/17/2006 Monday, Chris wrote:
Kay C. Tien wrote:
Hi All,
The simple script I'm testing works on a Linux server. I got tired
of having to upload and test them, so I decided to install MySQL on
my computer, which is running Win XP.
MySQL works fine on it's own, I've set the the dat
Howdy all,
I'm trying to clean up a development server so that we
can retask it. I tried dropping a very large but no
longer necessary database that uses INNODB tables
exclusively. Unfortunately the disk usage on the box
didn't change. We're using a completely default MySQL
5.0.15 install on the b
Hi, i'm sorry for my english, i'm from México and i'm gonna do my best,
i've made a store procedure but i have some problems becouse when a
make a simple operation with double datas the result is not what i
wait.
look
cantidad_origen = 30.5
cantidad_ = 30.4
suma = 0
UPDATE detalle_tanque set c
Kay C. Tien wrote:
At 05:37 PM 7/17/2006 Monday, Chris wrote:
Kay C. Tien wrote:
Hi All,
The simple script I'm testing works on a Linux server. I got tired
of having to upload and test them, so I decided to install MySQL on
my computer, which is running Win XP.
MySQL works fine on it's own,
Obed Soto Déctor wrote:
Hi, i'm sorry for my english, i'm from México and i'm gonna do my best,
i've made a store procedure but i have some problems becouse when a
make a simple operation with double datas the result is not what i
wait.
We can't tell much without seeing at least the stored pro
> -Original Message-
> From: Obed Soto Déctor [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 17, 2006 7:28 PM
> To: mysql@lists.mysql.com
> Subject: problem with double data
>
> Hi, i'm sorry for my english, i'm from México and i'm gonna do my best,
>
> i've made a store procedure but i
Hi ALL
I would like to know following 2 things.
1) if i would like to take mysql incremental backup weekly
cp /var/lib/mysql/ /backup/mysqlbak/
how can i do it by above command as i would like to run cron weekly
for take mysql backup.
i would like to take backup using cp command only as we ha
Kaushal Shriyan wrote:
Hi ALL
I would like to know following 2 things.
1) if i would like to take mysql incremental backup weekly
cp /var/lib/mysql/ /backup/mysqlbak/
how can i do it by above command as i would like to run cron weekly
for take mysql backup.
i would like to take backup using
Hi All,
I've tried to upgrade mysql from MySQL 4.1.12 to MySQL 5.0.22.
Before upgrading, I have like below :
# rpm -qa | grep mysql
mysql-4.1.12-3.RHEL4.1
mysql-server-4.1.12-3.RHEL4.1
mysqlclient10-3.23.58-4.RHEL4.1
mysql-devel-4.1.12-3.RHEL4.1
And after upgrading, I have like below :
#rpm -q
Dan Trainor wrote:
Kaushal Shriyan wrote:
Hi ALL
I would like to know following 2 things.
1) if i would like to take mysql incremental backup weekly
cp /var/lib/mysql/ /backup/mysqlbak/
how can i do it by above command as i would like to run cron weekly
for take mysql backup.
i would like t
Fauzan Azhary wrote:
Hi All,
I've tried to upgrade mysql from MySQL 4.1.12 to MySQL 5.0.22.
Before upgrading, I have like below :
# rpm -qa | grep mysql
mysql-4.1.12-3.RHEL4.1
mysql-server-4.1.12-3.RHEL4.1
mysqlclient10-3.23.58-4.RHEL4.1
mysql-devel-4.1.12-3.RHEL4.1
And after upgrading, I have
35 matches
Mail list logo
