I'm using mysql 4.1.14 rpm's on Fedora Core 4.
I've setup max_heap_table_size to allow for 500M heap tables. Currently I
use roughly 435M in heap by about 16 different tables. Some use btree,
other's use default hash.
The problem is, over time mysql looks like this in top:
PID USER PR NI VIRT
Hi,
I am hoping you meen this:
You have to use the fields in your into -statement and select statement,
not including the field having the auto-numbering
so if e.g. field1 has autonumbering -
insert into table1 (field2, field3) select (field2, field3) from table1;
autonumbering will
That is the effect that I am looking for, but exactly the method that I
am trying to avoid. If I type the column names into my INSERT... SELECT
and someone later adds a column to the table, I would have to go back
into my program and update the statement. I am looking for a way to do
it
Well I haven't realy found a select method in which you can isolate a
field. Like a complementary method, in which you select like one field,
but shows the fields except the field which you have used in your
select-statement.
So you excually want to dynamically insert the records, not knowing
I am using Cold Fusion and as I stated in my original message, if I were
using MySQL 5, then I could use information_schema to retrieve the
column names in the table and do it with variables in Cold Fusion. I do
that on all my pages on the MySQL 5 servers with which I work. However,
the server I
How about BIRT?
http://www.eclipse.org/birt/
I have tried it with MySQL, and it works OK. Still investigating.
Andy
-Original Message-
From: Wiebe de Jong [mailto:[EMAIL PROTECTED]
Sent: Fri 23/09/2005 02:25
To: mysql@lists.mysql.com
Cc:
Subject:RE: Web-based
I am not familiour with Cold Fusion but: cant you use 'show columns from
table' ?? and use the result object?
This normally works in e.g. C or PHP
danny
Schimmel LCpl Robert B (GCE 2nd Intel Bn Web Master) wrote:
I am using Cold Fusion and as I stated in my original message, if I were
Hi Miguel,
Those files are the binary logs that MySQL keeps of its doings. You can find
more information here: http://dev.mysql.com/doc/mysql/en/binary-log.html.
Depending on the number of tables and the number of data-altering statements,
these logs may become very big very quickly.
Kind
Had problem with our database this weekend, apparently an app did an
insert query that was huge size wise and this totally boogered up
replication downstream. Also I cant read past that point in the binlog
using mysqlbinlog on the master server. It complains that:
ERROR: Error in
I think there are some required indexes missing in your table structure.
If you showed us your real SHOW CREATE TABLE CONTACTS \G and SHOW
CREATE TABLE LISTS \G as well as text of SELECTs that kill your
mysqld, you'd get better replies.
250k/60k records is not that huge tables really.
On 9/25/05,
Taking on online class for SQL and am down to the last two classes and
cannot make the following work. This is a MS SQL Server query that I
have not been able to solve through the MySQL Documentation:
CREATE PROCEDURE CountPhoneNumbers AS DECLARE @count INTEGER
SELECT @count = COUNT (*) FROM
Jim,
I have tried numerous variations of the following:
CREATE PROCEDURE CountPhoneNumbers () BEGIN DECLARE @count INT SELECT
@count = COUNT(*) FROM CUSTOMER WHERE HomePhone IS NOT NULL; END//
// was set to be the delimiter for the creation and have tried putting
various parts of the query
This is probably a FAQ, but I haven't been able to find the answer.
Briefly, I am looking for tools that will help me document a
database. Visualization would be nice too, so that I could quickly
see the relations between tables.
Less briefly. I am new to MySQL, SQL in general and
The long story short is we use the fact that MySQL has the ability to
run the SQL thread and the IO thread of replication separately, and
control them individually.
I'm fairly green with replication, but I have a simple cron job that
starts a PHP program that issues a slave start, watches for
I'll be setting up a second master to do this same
thing once per day to act as my daily backup.
Oops...I meant to say second slave.
-Hank
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I would start by writing down what you believe the database consists of:
1. The table structures -- write them down, commit them to paper.
2. The relationships you believe exist between the tables. Document them
in writing and visually. Use whatever tool works for now -- don't make
the mistake
No one can provide a perfect solution. It seems that this is really a
difficult problem for the MySQL.
YL wrote:
I tried from 4.1 to 5.01, everything works fine without change the data
files.
I used Chinese in both gb and b5 (different columns in the same table)
without
any encoding setting
On Sep 25, 2005, at 5:44 PM, Robert L Cochran wrote:
I would start by writing down what you believe the database
consists of:
1. The table structures -- write them down, commit them to paper.
Thanks, I've already printed out all of table structure information.
2. The relationships you
Jeffrey,
But I'm still left puzzled. If people haven't developed tailored tools
to document a database, then I find more than a bit of irony in the fact
that people who specialize in organizing data in useful ways would not
have developed a way to organize data that they need to make use of
Relevant bits of the conversation so far, with my thoughts at the end:
Schimmel LCpl Robert B (GCE 2nd Intel Bn Web Master) wrote:
Here is the problem that I am having. I am trying to make a copy of a
full record in a table that has a primary key with auto-increment. The
real problem is that I
Actually, both of your solutions worked. Thanks much for the input guys.
Rob
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Monday, September 26, 2005 12:20 AM
To: Schimmel LCpl Robert B (GCE 2nd Intel Bn Web Master)
Cc: Danny Stolle; mysql@lists.mysql.com
Peter Brawley wrote:
MySQL AB recently purchased such a tool, DB Designer, rechristened it
MySQL Workbench, just released an alpha version for Windows.
You're kidding? I thought I'd seen the last of DB Designer. Where can we
get it? I checked out the dev section of the website and looked
Hello
I've just read the users management, it is pretty clear but have a technical
doubt...
I have a server at the office and want to work on it from home sometimes. It
has not a fixed ip, is ADSL and address changes from time to time. Am able to
access the server via ssh by using a domain
23 matches
Mail list logo
