I could not understand what you try to do. But generally mysql runs on a
server machine and the clients connect to it. Every client program you
write can connect to mysql server seperately. If you want and need you
can also write a server program too. But you have to be more clear about
your
Hello,
I have loaded MYSQL Version 4.0.12, and also loaded MySQL Control Centre 0.8.10-beta,
on Win 98
Now when i go to command prompt and issue the command as
mysql show processlist;
++--++---+-+--+---+--+
| Id | User | Host
Hello,
I have a table where misc data are stored. Right now this table has
about 30 columns, but for sure it will be more in the near future. So I
wonder how the big number (50-100) of table's columns affect for MySQL
DB performance. Maybe it's better to create more tables rather than more
table's
Neeraj Vasudeva [EMAIL PROTECTED] wrote:
I have loaded MYSQL Version 4.0.12, and also loaded MySQL Control Centre
0.8.10-beta, on Win 98
Now when i go to command prompt and issue the command as
mysql show processlist;
hi all,
i have this table filled with names.
Does anybody know how I can write a select statement which selects all names
starting with a certain letter in the alphabet or a strane sign like
[0...9 )(*[EMAIL PROTECTED]|?/,.] ???
any tips or help are most welcome!
Regards
Wilbert Enserink
Hi
Using the Square brackets with the characters within it and then a wildcard after the
closing square bracket works except for looking for special square brackets.
hi all,
i have this table filled with names.
Does anybody know how I can write a select statement which selects all names
Hi all, hope I can learn a lot from this mailing list!
_
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus
--
MySQL General Mailing List
For list archives:
Hey folks,
before posting to the bugs-list I would like to try it here to get some help :).
Every now and then MySQL-4.0.13 crashes on my Dual-Athlon-MP-machine.
Its not reproducible nor I know a query which does it.
(The log shows that at the end, so no query :-( :
Trying to get some variables.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 23 July 2003 03:59, W. Enserink wrote:
hi all,
i have this table filled with names.
Does anybody know how I can write a select statement which selects all
names starting with a certain letter in the alphabet or a strane sign like
Hi,
Tue, 22 Jul 2003 18:15:59 -0700 (PDT) tarihinde MySQL
[EMAIL PROTECTED] soyle yazdi:
DF I am compiling MySQL 4.0.14 with GCC 3.2.3, Glibc 2.3.1 and Linux
DF 2.4.21 on a x86.
...
DF CFLAGS=-O2 -march=athlon CXX=gcc CXXFLAGS=-march=athlon -O2
DF-felide-constructors ./configure
As far I remember full-text doesn't work with utf-8. Anybody knows the
estimated time when it will be supported ?? I next few months 4.1
version will be ready to use (I hope so...) and I wish to use utf-8
charsets, but very important issue is full-text search.
I'm also curious with InnoDB support
Hi,
I'd like to create a website with a MySQL database to store soccer players
details like goals scroed for the season. I want to use it to update my
fantasy soccer team through this season, does anyone know of a free host
that provides MySQL?
Or even better, does anyone have experience of
Hello,
Your solution has succeeded. Thank you very much.
All the servers are running well!
Iulian Teodosiu,
Economist/Analyst Programmer,
Primaria Falticeni,
Falticeni Town,
Romania, Europe
- Original Message -
From: Primaria Falticeni [EMAIL PROTECTED]
To: MySQL LIST [EMAIL
Hi,
I doubt you will find free host for MySQL because you seem to use ASP, which
is really not commun and i have not seen many host (paid host) provide ASP
may be i have looked at the wrong place.
Anyhow if you decide to use php then you will have more chance to find free
host with MySQL, I
I'm sorry, I'm very new at this. I only downloaded the live version
last week. Where do I find the setting you are referring to? By
attempt to run the servers, perhaps this is a correct answer to your
question: I am only using this for learning purposes. I am hoping to
attain new skills and
For the database/ASP link I created on our intranet all I did was drop an
Access database onto the server, and use the address in the ASP code
(actually I didn't need to - it was all local).
Can I not simply FTP upload the MySQL database to a regular website (that
supports ASP) and access it
http://www.etsetb.upc.es/download/sources/dump_grants/
DESCRIPTION
This tool dumps the permissions granted to the users of the MySQL
database. It also could print a report of dangerous grants.
USAGE
Dump Grants will retrieve the permissions granted as sql commands
and will store it in a flat
Hi, I just installed MySQL.
Does anybody know where to manage the databases, create, edit and delete tables?
Thanks.
Hi.
I need to replicate data (approx. 10,000 records) from a mySQL database into
a different (non mySQl) database automatically on a regular basis. I have no
control over the mySQL server (apart from allowing ODBC access) so I cannot
modify any tables or enable replication etc...
My initial
Hi,
I have a query that runs in Microsoft Access against my mysql database just fine. It
is:
UPDATE discussion_categories AS discussion_categories_1
INNER JOIN discussion_categories ON
discussion_categories_1.parent_1_text = discussion_categories.name
SET discussion_categories_1.parent_1
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 23 Jul 2003 [EMAIL PROTECTED] wrote:
before posting to the bugs-list I would like to try it here to get some
help :). Every now and then MySQL-4.0.13 crashes on my
Dual-Athlon-MP-machine.
Is that a self-compiled binary or one of
there must be a binary called 'mysql' ('mysql.exe' on windows).
call it, best from the computer where you have installed mysql on:
mysql -uroot
(if it's not in the PATH:
/usr/local/mysql/bin/mysql (i think)
or
c:\programme\mysql\bin\mysql.exe)
now you can enter SQL commands like
CREATE
get a broadband connection and host the website yourself
Martin
- Original Message -
From: awards [EMAIL PROTECTED]
To: Daniel Glenfield [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 4:23 AM
Subject: Re: MySQL on a website
Hi,
I doubt you will find free host for
Hi Lenz,
thanks a lot for your reply!
Is that a self-compiled binary or one of ours?
It are the MySQL-4.0.13-MAX-RPMs from your site.
Not very helpful. Does this occur under high load only?
Yeah I know, otherwise I would have tried to generate a reproducible testcase with a
given query or
I would like to know if there is a way of building an index on all the words
of a column.
We want to have an alphabetical search on all the words of a description of
a product.
So, how I treat this index when I change a part of the content of this
specific column where I want a word index.
Mysql column type of full text. Check the docs at
http://www.mysql.com/doc/en/Fulltext_Search.html
-Original Message-
From: Garon Jocelyn [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 11:07 PM
To: [EMAIL PROTECTED]
Subject: Word index
I would like to know if there is a way
Thanks for your help everyone!
From: Martin Gainty [EMAIL PROTECTED]
To: awards [EMAIL PROTECTED], Daniel Glenfield
[EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: MySQL on a website
Date: Wed, 23 Jul 2003 08:57:54 -0700
get a broadband connection and host the website yourself
Martin
-
If you are going to be needing to add columns and/or tables, you should
probably rethink your data model.
I'm not sure what data you are tracking, but perhaps you can
consolidate it a bit more. Make your columns into rows with a row type
field. A simple example would be tracking phone numbers.
I answered my own question, this works for joining a table on itself and doing an
update query:
update
discussion_categories discussion_categories1, discussion_categories
set
discussion_categories1.parent_1 = discussion_categories.category_id
where
Hello,
I have been backing up my db with the mysql dump command and it no longer
works. This is an example of the command I was running...
mysqldump -u dbuser -p -C mydb out.sql
but returns this
-- MySQL dump 8.21
--
-- Host: localhostDatabase: mydb
I am using php and mysql and I want to show the column names. How do I go
about doing this without hardcoding the headers in my php?
Regards,
Jake Johnson
[EMAIL PROTECTED]
__
Plutoid - http://www.plutoid.com - Shop Plutoid
I want to put a MySQL 4.1 database on a Win2k laptop but the problem is it
contains confidential client information. It has to be Window because
applications accessing the database are written in Windows.
The problem is laptops do get stolen quite often, even when running on
someone's
Did you try the -q option?
Jake Johnson wrote:
Hello,
I have been backing up my db with the mysql dump command and it no longer
works. This is an example of the command I was running...
mysqldump -u dbuser -p -C mydb out.sql
but returns this
-- MySQL dump 8.21
--
-- Host: localhost
There is a nice GUI on the MySQL site called MySQL Command Center. Follow this link
http://www.mysql.com/products/mysqlcc/
Ratmil Torres [EMAIL PROTECTED] wrote:Hi, I just installed MySQL.
Does anybody know where to manage the databases, create, edit and delete tables?
Thanks.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Nils Valentin wrote:
Hi MySQL Fans ;-),
Is it possible that the 3.08 series allows to connect to 4.0.14
versions but
not to the 4.1 alpha-versions ?
I get belows error when tryig to connect from DbVisualizer which was
working
fine until a
Hi,
Is there any way to create a symlink of table in two different databases which
belongs to the same user.
It will be great help if I get the solution for above mention task.
Regards,
Haq
On my p4 2gig
mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye));
+--+
| BENCHMARK(100,ENCODE(hello,goodbye)) |
+--+
|0 |
you want to show the column names of WHAT?
if you want to get those of a previous SELECT..., there's a special function for that.
here's some code from my mysql admin module:
$fields = array();
while ($meta = mysql_fetch_field($result))
{
array_push($fields, $meta-name);
}
if you want to
Jonathan Patton [EMAIL PROTECTED] wrote:
I have a query that runs in Microsoft Access against my mysql database just fine. It
is:
UPDATE discussion_categories AS discussion_categories_1
INNER JOIN discussion_categories ON
discussion_categories_1.parent_1_text =
Try:
$result = mysql_query(SHOW COLUMNS FROM table_name);
while ($row = mysql_fetch_array($result)) {
foreach ($row as $key=value) {
echo $key = $value;
}
}
-Jackson
On Wednesday 23 July 2003 9:32, Jake Johnson wrote:
I am using php and mysql and I want to show the column
On my 1.8GHz p4 with 512Gig of RAM I get:
mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye));
+--+
| BENCHMARK(100,ENCODE(hello,goodbye)) |
+--+
|0 |
Celeron 733
Windows 2000
MySQL 3.23.56-nt
1.63s 1.58s 1.58s
Athlon 1GHz
Debian 3 inside VMWare 3 (WinXP)
MySQL 4.0.14
1.21s 1.22s 1.18s
-yves
-Ursprüngliche Nachricht-
Von: Bryan Koenig [EMAIL PROTECTED]
An: [EMAIL PROTECTED]
Gesendet: Mittwoch, 23. Juli 2003 16:45
Betreff: RE:
On my 2 * 2.8Ghz 2GB RAM, Redhat 8:
mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye));
+--+
| BENCHMARK(100,ENCODE(hello,goodbye)) |
+--+
|0 |
Xserve 1ghz - 1.08 sec
G3 333mhz - 2.78 sec
- John
On my p4 2gig
mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye));
+--+
| BENCHMARK(100,ENCODE(hello,goodbye)) |
+--+
|
On my 1Ghz Mac PowerBook with 1GB RAM using version 4.0.13 with OS 10.2.6
mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye));
+--+
| BENCHMARK(100,ENCODE(hello,goodbye)) |
+--+
|
Still the same problem, but I am still able to select from the DB using
mysql.
Regards,
Jake Johnson
[EMAIL PROTECTED]
__
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
Rims, Car Audio, and Performance
Hello Guys,
I have Risc/AlphaServer ES40 with processor EV6 500mhz running RedHat
7.2/Mysql. Could you please send me Bench test ?
I like to try
tks,
Julio
-Mensagem original-
De: Bryan Koenig [mailto:[EMAIL PROTECTED]
Enviada em: quarta-feira, 23 de julho de 2003 11:46
Para: [EMAIL
Hello all,
I wonder if is there any way to select from a table all the records
which has a Date Field that is at least five minutes old?
In other words, I have a table with a date field and I need to select
all the records that are older than five minutes, has their date field
updated
before
Note: forwarded message attached.
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com---BeginMessage---
Hi All,
I have a database consisting of 2 tables.
patient_info ( Patient Information
Hello Guys,
AlphaServer EV6 processor 500mhz/1Gm memory with Linux
mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye));
+--+
| BENCHMARK(100,ENCODE(hello,goodbye)) |
+--+
|
How do I fix this error? My tables have data.
Regards,
Jake Johnson
[EMAIL PROTECTED]
__
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
Rims, Car Audio, and Performance Parts.
--
MySQL General Mailing
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 23 Jul 2003 13:27:53 +0100, Kevin Gale wrote:
I need to replicate data (approx. 10,000 records) from a mySQL database into
a different (non mySQl) database automatically on a regular basis. I have no
control over the mySQL server (apart from
I am trying to run MySQLcc(0.9.2) on Windows XP. When I try to bring it
up I get an hourglass for a second, then nothing happens. Has anyone
had similar issues or any ideas as to what could cause this?
Thanks
(mysql, query)
Scott Pippin
[EMAIL PROTECTED]
At 6:32 -0500 7/23/03, Degan, George E, JR, MGSVC wrote:
I'm sorry, I'm very new at this. I only downloaded the live version
last week. Where do I find the setting you are referring to? By
attempt to run the servers, perhaps this is a correct answer to your
question: I am only using this for
Hello,
Mysql Version 4.0.11a-gamma
When I try and run the following query
create temporary table russ1 as
select rcust.*
from rcust;
and I receive the error message:
Error Code : 1044
Access denied for user: '[EMAIL PROTECTED]' to database 'customer'
(0 ms taken)
I can run the
+--+
| BENCHMARK(100,ENCODE(hello,goodbye)) |
+--+
|0 |
+--+
1 row in set (1.91 sec)
PIII 850, with 1GB Ram.
-
snip
On my p4 2gig
mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye));
+--+
| BENCHMARK(100,ENCODE(hello,goodbye)) |
+--+
|0 |
At 8:45 +0500 7/23/03, Shahid M. Syed wrote:
Hello
Does any version (production or future) of mysql supports Bookmarks?
What is Bookmark capability in a database context?
Regards
Shahid M. Syed
Karachi, Pakistan
http://members.tripod.com/shahid_syed
--
Paul DuBois, Senior Technical Writer
Hello everyone. I have copied the results from and explain on a query that I want to
use. And I am wondering if anyone could tell me if these results are bad or good?
If everything below is coming up garbled for you I will basically I am using 7 tables
and the rows for 6 of the seven are 1 and
On my P3 600MHz 256MB RAM, Redhat 8:
1 row in set (2.01 sec)
Hubbard, Dan [EMAIL PROTECTED] 07/23/03 11:39AM
On my 2 * 2.8Ghz 2GB RAM, Redhat 8:
mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye));
+--+
| BENCHMARK(100,ENCODE(hello,goodbye)) |
personal Win98 Duron650 128MB Mysql 4.0.13 - 1.37 sec
busy server Redhat 7.0 Celeron 333 380MB Mysql 3.23.54 - 3.11 sec
-Original Message-
From: Jake Johnson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 5:34 PM
To: Mysql
Subject: What is a good benchmark?
I ran
1 row in set (0.54 sec)
2x Athlon2100
2GB Ram
Linux 2.4.20
-Original Message-
From: Jake Johnson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 9:34 AM
To: Mysql
Subject: What is a good benchmark?
I ran this benchmark on my pIII 500 and was wondering what everyone else
was
Ratmil
Check out the free dbTools at http://www.dbtools.com.br/EN/
Freddie
-Original Message-
From: Ratmil Torres [mailto:[EMAIL PROTECTED]
Sent: Mittwoch, 23. Juli 2003 14:22
To: [EMAIL PROTECTED]
Hi, I just installed MySQL.
Does anybody know where to manage the databases, create,
SETUP
Windows 2000, Version 5.0 (build 2195, Service Pack 2) (In case it
matters, I have about 20 GB available on my 40GB hard drive and 192MB of
RAM)
SETTINGS
Prior to attempting to put on the second server, I wasn't using any
options, which was logging me in as [EMAIL PROTECTED] (or more
Is it me or do these dual athlons seem rather responsive!
I use mySQL 4.0.13 running on FreeBSD 4.8.
Pentium 4 2.8Ghz
2GB DDR400
1 row in set (0.7 sec) | (0.68 sec) | (0.68 sec)
Andrew.
- Original Message -
From: Christopher Knight [EMAIL PROTECTED]
To: Mysql [EMAIL PROTECTED]
Sent:
Dual P3 933, 2 gig RAM, IDE RAID-5
+--+
| BENCHMARK(100,ENCODE(hello,goodbye)) |
+--+
|0 |
+--+
1 row in set (1.40
I have two tables: bc_post and bc_message. This is what I have so far:
select bc_post.*, count(bc_message.message_to) responses from
bc_post left join
bc_message on
bc_post.post_id = bc_message.message_topostid
where
bc_post.post_status = '1' and
bc_post.user_id = '1'
group by
bc_post.post_id
select bc_post.*, count(bc_message.message_to) responses from
bc_post left join
bc_message on
bc_post.post_id = bc_message.message_topostid and
bc_post.user_id = bc_message.message_to
where
bc_post.post_status = '1' and
bc_post.user_id = '1'
group by
bc_post.post_id
-Original Message-
I get the following on dual Athlon MP 1666MHz 1GB RAM which is 40% cpu
loaded
mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye));
+--+
| BENCHMARK(100,ENCODE(hello,goodbye)) |
+--+
|
Is it me or do these dual athlons seem rather responsive!
Yay!! I win (so far... heh)!
I ran it on one of our servers (not idle... running apache w/ CGIs and db calls ~
140,000 scripts/day )
We are using as many tricks as we can.
0. mysql 4.0 binary from mysql.com
1. we set the
Hi,
Has anyone ever had any problems with MySQL w/ all InnoDB tables just
stop processing queries? There doesn't seem to be any pattern to it, it
happens at times of relatively high load (load avg of 4 on a dual proc)
but the CPUs still have plenty of idle time, and the disks aren't maxing
out.
Hello,
I have a backup of a mysql v3.0.18 DB. I need to extract one of the DB's
from that backup and place it into my current production v4.0.14 mysql
DB.
Can this be done? How?
Sincerely,
- Henrik
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
At 13:01 -0500 7/23/03, Degan, George E, JR, MGSVC wrote:
SETUP
Windows 2000, Version 5.0 (build 2195, Service Pack 2) (In case it
matters, I have about 20 GB available on my 40GB hard drive and 192MB of
RAM)
SETTINGS
Prior to attempting to put on the second server, I wasn't using any
options,
Hi,
I don't know what type of applications are using your database but if I had
to guess at the problem, I would guess that you have a very slow query which
runs every now and again that is locking up certain tables/records causing
all the other queries to queue up and eventually running out of
I got disappointing results compared with the ones posted here:with a
dual xeon 2Ghz, 2GB ram, freebsd 5.1, mysql
mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye));
+--+
| BENCHMARK(100,ENCODE(hello,goodbye)) |
Is the backup a mysqldump or a copy of the data files?
Andrew
-Original Message-
From: Henrik Schmiediche [mailto:[EMAIL PROTECTED]
Sent: Wednesday 23 July 2003 19:48
To: 'Mysql'
Subject: Re-attaching DB to mysql
Hello,
I have a backup of a mysql v3.0.18 DB. I need to extract
At 01:45 PM 7/23/2003, you wrote:
Is it me or do these dual athlons seem rather responsive!
Yay!! I win (so far... heh)!
Beat you by a nose. (Of course I had to run it 2 or 3 times to shave a
couple hundreds of a second off the times)g
A single P4 2.4 Ghz 1g RAM running MySQL 4.1.0 Alpha running
Copy of the data files :-(
- Henrik
-Original Message-
From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 2:04 PM
To: 'Henrik Schmiediche'; 'Mysql'
Subject: RE: Re-attaching DB to mysql
Is the backup a mysqldump or a copy of the data files?
Andrew
Does MySQL automatically handle deleted row cleanup, or is it necessary to
periodically do this manually for tables with a lot of deletions? If it's
manual, what are the SQL commands to do this?
Also, what happens when changes are made to a field definition? From, say, int
to smallint, or
My responses are parenthesied in the text below.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 2:56 PM
To: Degan, George E, JR, MGSVC
Cc: [EMAIL PROTECTED]
Subject: RE: Can run two versions of MySQL in Windows 2000?
At 13:01 -0500
Hi All,
I am running mysql-3.23.52 on OS X (10.2.6) and I'd like to install the
mod_auth_mysql module for a job I'm working on that used it under a
different platform.
I compiled the module using:
apxs -c -D APACHE1 -L/usr/local/mysql/lib/ -I/usr/include/mysql/
-lmysqlclient -lm -lz
hi,
We're pretty careful about preventing that. Also, no queries are moving
forward, no inserts, updates, or selects, even the ones on tables that
are only a mixture of inserts and selects.
joe
On Wed, 2003-07-23 at 12:02, Andrew Braithwaite wrote:
Hi,
I don't know what type of
UGHH HELP!!
I need to write a sql statement that will take the data from my table and
use it as column headers. For example,
If I have a field named GoLiveDate and a field called Qty and a field called
Cars:
Cars | Qty | GoLiveDate
==
CarA | 5 | 7/21/2003
CarA | 10
Joe,
- Original Message -
From: Joe Shear [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, July 23, 2003 10:40 PM
Subject: RE: mysql stops processing
hi,
We're pretty careful about preventing that. Also, no queries are moving
forward, no inserts, updates, or
Hi,
If that backup uses the old .ISD .ISM architecture then I would install
an old version of MySQL, copy these files into the data dir of that
installation and mysqldump them to a file ready for import into your new
MySQL v4 install.
I'm not aware of any scripts to just munge the old style
Unfortunately, we haven't been able to connect to the database because
of the maxed out connections. This happens so fast that the maxed out
connections is usually the first sign. I've been hesitant to start the
monitor, since this has only been happening once every couple days.
It's been
Thanks for the reply.
I started a mysql v3 on a new system with the old backup data
directory and type:
mysqldump -p henrik henrik.sql
This dumps the DB? To restore, I move henrik.sql to the current 4.0.14
server and type:
mysql -p henrik henrik.sql
except it complains the DB does
And from the MySQL docs:
--clip
MySQL Version 3.23 supports tables of the new MyISAM type and the old ISAM
type. You don't have to convert your old tables to use these with Version
3.23. By default, all new tables will be created with type MyISAM (unless
you start mysqld with the
I was wondering if anyone had any experience with setting up large and
fairly high performance databases. We are looking at setting up
databases with each machine having somewhere between 500 gigs and 2
terabytes along with a slave box and we'd like to backup everything to
tape at a minimum of
Joe,
- Original Message -
From: Joe Shear [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 11:03 PM
Subject: Re: mysql stops processing
Unfortunately, we haven't been able to connect to the database because
of the maxed out
The mysqldump you use doesn't include the create databease so you'll need
to create the henrik DB on the new install. If you keep running it over and
over, it will keep inserting the same records over and over again and you'll
end up with duplicates. The thing to do is start with an empty db (call
On Wed, 2003-07-23 at 13:11, Heikki Tuuri wrote:
Joe,
- Original Message -
From: Joe Shear [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 11:03 PM
Subject: Re: mysql stops processing
Unfortunately, we haven't been
Hi,
I believe that MySQL v4 has a superuser privilege level that keeps a
connection available even when the regular connections are all used up just
for diagnosis/killing etc... May want to try that to get your processlist
too.
Cheers,
Andrew
-Original Message-
From: Joe Shear
Joe,
- Original Message -
From: Joe Shear [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 11:23 PM
Subject: Re: mysql stops processing
On Wed, 2003-07-23 at 13:11, Heikki Tuuri wrote:
Joe,
- Original Message -
At 03:08 PM 7/23/2003, you wrote:
I was wondering if anyone had any experience with setting up large and
fairly high performance databases. We are looking at setting up
databases with each machine having somewhere between 500 gigs and 2
terabytes along with a slave box and we'd like to backup
Hi,
We have similar numbers here.
A couple of questions:
- are they logfiles that could be rolled over on a daily basis or are they
constantly updated huge tables?
- is the type of backup you want incremental or a daily/weekly snapshot one?
- do you have a requirement for the speed of
Is there any way to restrict UPDATE without a WHERE clause?
Mohammad Khan
Software Engineer
Legal Computer Solutions, Inc.
107 Union Wharf
Boston, MA 02109
http://www.lextranet.com
(617) 227-4469 x 212
Jake Johnson wrote:
How do I fix this error? My tables have data.
But they probably are not owned by mysql.
Regards,
Jake Johnson
[EMAIL PROTECTED]
__
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
Currently we have a web based application that is mostly reads (4:1
r/w). It is using a single MySQL database server. Is there any way to
have two database servers in a master/master configuration such that
writes to either database server are replicated to eachother. Basically
even
The data is constantly updated. There are 3 or 4 huge tables, and
several smaller tables. We would love to have an incremental solution
that is *guaranteed* to be correct, but we haven't found a way to do
that, so what we've been thing is we'd do a complete snapshot once a
week, and do
1 - 100 of 136 matches
Mail list logo