CanIt Vote for ID 62298InnoDB still has the major issue about the slow access of
database...
I use mysql database for website..
- Original Message -
From: Daniel Kasak
To: starofframe ; [EMAIL PROTECTED]
Sent: Friday, July 02, 2004 11:08 AM
Subject: Re: referential integrity
Hi,
I have enabled the binary log on MySQL (4.0.20). The name of the binary
log is hostname-bin.001, hostname-bin.002, etc ...
What will happen if the suffix become 999? Will error occurs when flush
logs is executed?
Regards,
Michael
--
From: "starofframe" <[EMAIL PROTECTED]>
> CanIt Vote for ID 62298InnoDB still has the major issue about the slow
access of database...
> I use mysql database for website..
For a new application we're building we performed some tests to decide upon
MyISAM/InnoDB and two table lay-outs. We ran two pr
On Wed, 30 Jun 2004, Aaron Wolski wrote:
> Hi Guys,
>
> I'm trying to figure out of this is possible. I know I could do it in
> PHP but I am dealing with a ton of records and would rather put the
> processing on the DB than PHP/client side.
>
> Question is. can I do a SELECT query on a column that
Hi everyone
We have some tables to record different data of the activity in our website.
The number of INSERT, DELETE and UPDATE operations in these tables is huge
(it could be more than 3000 a second). So far we don't have any speed
problems, all these tables are optimised using the right indexes
Dear ALL:
Some time the slave would crushed by I/O error.It happen at the server with the lower
CPU.( per 45 days )
All of the slave database has block the binary log,it reduce the CPU loading.
The database would replicate text,int,varchar but no blob.
Network connection hasn't drop frequently,it
Javier Diaz <[EMAIL PROTECTED]> wrote on 02/07/2004 10:28:32:
> We have some tables to record different data of the activity in our
website.
> The number of INSERT, DELETE and UPDATE operations in these tables is
huge
> (it could be more than 3000 a second). So far we don't have any speed
> prob
Hi,
I'm looking for an automatic method to purge the master logs. I know I can
do it with "PURGE MASTER LOGS TO 'mysql-bin.010';", but I need know the last
log file to automate it.
Somebody know the way.
TIA
Hi all-
I just downloaded and installed 4.1.3 on a WinXP environment. Does anyone
happen to have the data that should be loaded into all the new time zone
catalog tables? And the doc that describes the convert_tz() function and a
little more on general use of the time zone capability? My time zo
Hello everybody,
I'm experiencing problems with a 4.0.15 MySQL-Server running on a SuSE
Linux 8.2 box with 512 MB RAM, some one-point-something GHz CPU and 40
GB IDE Harddisk.
We have a database with some administrative tables and one large data
table (now ~ 30 M rows, ~ 1GB index file and ~ 80
Hi,
I'm getting some unexpected behaviour from a query and was
hoping someone could shed some light on whether it's a user
error or something else.
I have two tables:
customers, oems which both have a companyID field (marked
as a foreign key).
When I do:
SELECT * FROM customers WHERE customers.c
I am not sure what you are trying to do.
Do you want a join, or a union.
Your query is neither, and the results are correct as written.
Dave Gibson wrote:
Hi,
I'm getting some unexpected behaviour from a query and was
hoping someone could shed some light on whether it's a user
error or something el
It is telling you that your hard drive is failing.
Replace it.
Hanno Fietz wrote:
Hello everybody,
I'm experiencing problems with a 4.0.15 MySQL-Server running on a SuSE
Linux 8.2 box with 512 MB RAM, some one-point-something GHz CPU and 40
GB IDE Harddisk.
We have a database with some administr
SHOW MASTER STATUS will show you where you currently are on the master.
You should connect to each slave, and do a SHOW SLAVE STATUS to find where
the slaves are, and delete the logs lower than the lowest one in use by
the slaves.
Luis Mediero wrote:
Hi,
I'm looking for an automatic method to
MaFai wrote:
>Dear ALL:
>
>Some time the slave would crushed by I/O error.It happen at the server with the lower
>CPU.( per 45 days )
>All of the slave database has block the binary log,it reduce the CPU loading.
>The database would replicate text,int,varchar but no blob.
>Network connection ha
hi...
i'm investigating what needs to be done to allow mysql on a server to be
used remotely by client machines. each machine is running iptables. so i'm
wondering what has to be in the iptables for the machine being used as the
mysql server, as well as the client machines that will be communicati
Hello List,
It sounds like a simple query but I have spent quite a few hours already, and still do
not have a solution. Would greatly appreciate your response.
Here is what I am trying to do:
---
create table C (cId tinyint(4) NOT NULL);
insert into C values (1), (2)
Yes, I was suspecting that as well, but: Why do I get these messages
whenever I run myisamchk and (almost) never at any other time? Is
myisamchk using the hd more extensively than e. g. MySQL itself? Can the
rather large demand for temporary disk space account for that?
Thanks,
Hanno
gerald_cla
Hi,
> It sounds like a simple query but I have spent quite a few hours already,
and still do not have a solution. Would greatly appreciate your response.
>
> Here is what I am trying to do:
> ---
> create table C (cId tinyint(4) NOT NULL);
> insert into C values (1), (
bruce wrote:
i'm investigating what needs to be done to allow mysql on a server to be
used remotely by client machines. each machine is running iptables. so i'm
wondering what has to be in the iptables for the machine being used as the
mysql server, as well as the client machines that will be commu
On Fri, 2 Jul 2004 06:34:39 -0700
"bruce" <[EMAIL PROTECTED]> wrote:
> i'm investigating what needs to be done to allow mysql on a server
> to be used remotely by client machines. each machine is running
> iptables. so i'm wondering what has to be in the iptables for the
> machine being used as th
Try this:
dd if=/dev/hda of=/dev/null
This will exercise the entire drive.
You should see lots of errors if your drive is failing.
Another possibility is a bad cable. Cables don't usually go bad if
they are
not disturbed. Drives do.
A failing IDE contoller is another unlikely possibility.
I wo
This is not a mysql question, and please do not cross post.
Any good book un Linux networking will cover this.
Open port 3306.
bruce wrote:
hi...
i'm investigating what needs to be done to allow mysql on a server to be
used remotely by client machines. each machine is running iptables. so i'm
wonde
we disagree on this...
properly configuring/securing the mysql app is both a linux/mysql issue...
it's an issue that would be useful to anyone running a mysql box, who's
interested/needs security...
we're looking for actual iptable examples, for both mysql server box, as
well as client boxes tha
I’m confused and obviously missing something really
fundamental here…
I would appreciate it if you could glance at my code for the
above. Basically I’m trying to write information to the database now I
have managed to resolve the connection issue.
It’s the “Data Capture section that
On 06/30/2004 02:46 PM Andrew Pattison spoke:
The way I do this is within PHP is to echo the value stored in mysql_error
after each SQL statement. If you're not using PHP then this probably doesn't
help though ;-)
I'm not using PHP.
I'm loading tons of data with SQL statements from the command line
Moved from a PHP list to a MySQL list. :-)
On 06/30/2004 09:55 PM John W. Holmes spoke:
Bob Lockie wrote:
If I select rows with a limit clause I need to know if there are more
rows than the limit.
Either do a SELECT COUNT(*) prior to your LIMIT query to see how many
total rows there are, or use
On 07/01/2004 11:48 PM [EMAIL PROTECTED] spoke:
I have MySQL 3.23 installed, which comes with RedHat ES3. I find that
innoDB is not enabled. Anybody knows can I enable it?
Thanks,
Joseph
Recompile the binary or upgrade to one that includes it.
I don't think there is a runtime switch.
--
MySQL Gener
bruce wrote:
we disagree on this...
properly configuring/securing the mysql app is both a linux/mysql issue...
and reading the manual is an admin issue *sigh*... do so...
http://dev.mysql.com/doc/mysql/en/Starting_server.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
You're missing a closing " at the end of your sql on the last line
which may be throwing up an error.
Cheers,
Matt
On 2 Jul 2004, at 15:05, Michael Mason wrote:
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECT
> It's the "Data Capture section that's causing issues. I keep getting an
> error telling me there's an "Unexpected $" on a line that's actually
outside
> even the HTML tag.
You forgot to end the $sql = ".. with a closing quote. The line now ends
with ); while you probably want it to be )";
B
If I want 20 rows to display, I ask for 21.
If I get 21, I know to ask for another page.
Bob Lockie wrote:
Moved from a PHP list to a MySQL list. :-)
On 06/30/2004 09:55 PM John W. Holmes spoke:
Bob Lockie wrote:
If I select rows with a limit clause I need to know if there are
more rows than the
It it possible to allow access to all tables in a database *except* one...
What I was hoping to do was say:
GRANT ALL ON mydb.* TO [EMAIL PROTECTED] ;
REVOKE ALL ON mydb.secrettable TO [EMAIL PROTECTED] ;
-- but it doesn't work like that... I can only revoke stuff that's previously
been specifi
Yes it does, as it is a 'special' file (it's a socket), notice the 's' in the file
definition.
Link this to /tmp/mysql.sock and you should be ok
-Original Message-
From: Nguyen, Long P (Mission Systems) [mailto:[EMAIL PROTECTED]
Sent: 01 July 2004 21:14
To: Yiannis Mavroukakis; [EMAIL PRO
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
hi there,
hope this haven't been discussed in that kind of detail in older topics:
the facts in short:
- - we have the same mysql-version (4.0.18) for an intel-machine and a
sparc-machine.
- - we have a table with about 5,500,000 rows
- - we do a "real
Sorry - didn't read your email closely enough. The Windows version is
not native - runs under Cygwin. Is there a version of Cygwin for the
Itanium 2?
The Windows versions are quite a bit slower than the Linux/Unix
versions, so you might not get the benefits from that fast 64-bit processor.
Dai
Are you running Linux or Solaris on these servers?
Andrew.
- Original Message -
From: "mac" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, July 02, 2004 4:42 PM
Subject: INTEL vs. SPARC
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> hi there,
>
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
hi andrew,
Are you running Linux or Solaris on these servers?
sparc: solaris 9
intel: debian-linux (2.4.21-kernel)
with regards
klaus
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.3 (Darwin)
iD8DBQFA5acJvkHn/oGTPXURAlG4AJ9iAHBuX3n/RhCFzN9uj1ssC2VRAg
Essentially, I think, you are asking about organizing hierarchical data.
This is something which I always find tricky to wrap my head around, but,
one approach I seen used successfully is to use (initially) two tables:
1. A table such as 'Places' which contains the actual data (or Locations,
any
All:
We discovered a rather odd situation where some space characters where
being displayed as "?".
In tracking this down, it was determined that the server had stored the
hex value "A0" rather than "20" by using this query:
select LocationId, LevelId, Hex(NameLn),NameLn
from Location
w
I recently added a column and Index to an existing table. I wanted to also add a
Foreign Key. I have done this before defining the commands outside MySQL and souring
the file in for new tables, but would prefer to not have to dump the current table
just for the modification. I tried to add one b
On Fri, Jul 02, 2004 at 01:52:06PM -0500, Boyd E. Hemphill wrote:
> We discovered a rather odd situation where some space characters where
> being displayed as "?".
>
> In tracking this down, it was determined that the server had stored the
> hex value "A0" rather than "20" by using this query:
I'm working on some tables with more than 3,000 rows
that I import from csv files and notice that they're
consistently truncated at 16 pages in phpMyAdmin. In
other words, my table apparently features about 480
rows.
Why can't I insert the remaining 2,600 rows?
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
hi andrew,
I don't have a vast experience of MySQL on Solaris, but I suspect this
is
more down to the operating system than any hardware issues. Which
version of
Solaris are you running on the SPARC box?
it's Solaris 9 - SunOS 5.9 64bit.
the mysql is
Bartis, Robert M (Bob) wrote:
I recently added a column and Index to an existing table. I wanted to also add a Foreign Key. I have done this before defining the commands outside MySQL and souring the file in for new tables, but would prefer to not have to dump the current table just for the modific
Hi, guys
I would like to write a query to return all records which has the closest date to the
end of month. (Assume that date will be 6/30/2004)
| id | product_id | price | snapshot_date |
++++---+
| 1 | 1 | 99.95 |2004-06-23 |
| 2 |
On Fri, Jul 02, 2004 at 10:27:04AM -0700, David Griffiths wrote:
>
> Sorry - didn't read your email closely enough. The Windows version is
> not native - runs under Cygwin. Is there a version of Cygwin for the
> Itanium 2?
The Windows version of MySQL doesn't require Cygwin.
Jeremy
--
Jeremy
Hi,
Check if column PlanName is the primary key (and the only one) in table
testplans.
If so, check if both fields PlanName in testplans and PlanName in
runload_list are exactly of the same type and size.
Regards,
Hector
--
Ing. Hector Maldonado Melgar
Dpto. Desarrollo de Software
TCI S.A.
Michael, you're missing a quote just before the last semi-colon. PB
- Original Message -
From:
Michael Mason
To: 'MySQL Mailing List'
Sent: Friday, July 02, 2004 9:05 AM
Subject: Writing to an MySQL
Database
Im confused and obviously missing
something real
On Fri, 2004-07-02 at 09:05, Michael Mason wrote:
> It’s the “Data Capture section that’s causing issues. I keep getting
> an error telling me there’s an “Unexpected $” on a line that’s
> actually outside even the HTML tag.
Errors like "unexpected $" that are output by a code or statement parser
a
Hi,
Just following up with some more information...
I've been seeing a bit better behaviour by going from LinuxThreads to
FreeBSD native threads.
My hunch is also that this is somehow related to qmail; something of a
contention issue between qmail and mysql. As I said, system load remains
low.
--- Rhino <[EMAIL PROTECTED]> wrote:
> I would try to track the problem down as follows:
>
> 1. Are there any error messages from the import? If
> yes, what do they say?
No. I import my data as csv files using Navicat, and I
fix any errors until they import with 0 errors.
> If the import
> actu
Hello, I have a huge problem that you guys may be able to help me with.
I did a mysqldump all databases into a sql71.sql file.
when I try and I get the following error when trying to restore
ERROR 1050 at line 204528: Table 'columns_priv' already exists
I'm sure that this is for the mysql dat
In the last episode (Jul 02), David Blomstrom said:
> Rhino <[EMAIL PROTECTED]> wrote:
> > 2. What happens when you do 'select count(*)' on your new table?
>
> I'm not familiar with that command. If I type select count (*) into
> the "query" box on phpMyAdmin, it says count(*) = 0 Or is this a typ
Try these:
http://www.sitepoint.com/article/1105
http://www.evolt.org/article/Four_ways_to_work_with_hierarchical_data/17/4047/
olinux
> > -Original Message-
> > From: David Blomstrom
> [mailto:[EMAIL PROTECTED]
> > Sent: 02 July 2004 03:13
> > To: [EMAIL PROTECTED]
> > Subject: Re: Pa
I'm learning more about SQL all the time--I'm new to
things now but I'm trying to read. I now realize
the importance of normalizing my data, but what I
can't figure out is what the easy way is of getting it
done
now that I already have a database set up.
Suppose I have a table "books", consisting
On Fri, 2 Jul 2004, Chuck Barnett wrote:
> Hello, I have a huge problem that you guys may be able to help me with.
>
> I did a mysqldump all databases into a sql71.sql file.
>
> when I try and I get the following error when trying to restore
>
> ERROR 1050 at line 204528: Table 'columns_priv' al
57 matches
Mail list logo
