Hello,
I am using a MySQL database for a somewhat odd application. In this
application I will have relatively small tables and relatively few tables.
I would like to set the variables so that all the operations on the database
takes place in RAM and that it does not write to disk unless
All priviliges for that user in mysql.user are set to N.
I know this is hard to read but here are the outputs from user and db.
+---++--+-+-+---
--+-+-+---+-+---+---
Ralf E. Stranzenbach wrote:
i have a mysterious problem regarding a replication set-up of two mysql
databases (4.0.18).
If i change data in the mysql database, this data is not replicated.
If i create a new database on the master, this database does not show on the
slave.
If i change the existing
Hi Skip,
See my remarks interspersed in your note.
By the way, I'm copying the mailing list so that others can benefit from the
discussion, either now or somewhere down the road via the archives.
Rhino
- Original Message -
From: Skip Taylor [EMAIL PROTECTED]
To: Rhino [EMAIL
In article [EMAIL PROTECTED],
John Mistler [EMAIL PROTECTED] writes:
I need help coming up with the following query:
My table:
+-+--+
| rowID | dateOfPurchase |
+-+--+
| 1 | '2004-1-17 08:00:00' |
Those 2 variables are explained in the manual
http://dev.mysql.com/doc/mysql/en/Server_system_variables.html.
flush
This is ON if you have started mysqld with the --flush option. This
variable was added in MySQL 3.22.9.
flush_time
If this is set to a non-zero value, all tables
On 10/17/2004 7:12 AM, Michael J. Pawlowsky [EMAIL PROTECTED] wrote:
All priviliges for that user in mysql.user are set to N.
I know this is hard to read but here are the outputs from user and db.
[snip]
Paul DuBois wrote:
At 10:02 -0400 10/16/04, Michael J. Pawlowsky wrote:
I just
Hi,
I have the following two tables in my database:
mysql DESCRIBE Projects;
+--+--+--+-+-++
| Field| Type | Null | Key | Default | Extra |
+--+--+--+-+-++
|
Hi,
Tihs looks to me as too few information.
What is in your tables (the information)?
What does the query return (a empty set)? Maybe 'cause in your where clause
where you have Project_ID 2 you should have Project_ID=2? Or you have
several projects with ID2 and you want tasks for all of
On Sun, 17 Oct 2004 19:36:34 +, shaun thornburgh
[EMAIL PROTECTED] wrote:
A Project will have 1 or more tasks assigned to it. Using the following
query, how can I modify it so that I can find out the largest number of
tasks assigned to a group of projects.
SELECT P.*, T.*
FROM Projects
Hi Shaun!
A Project will have 1 or more tasks assigned to it. Using the
following
query, how can I modify it so that I can find out the largest
number of
tasks assigned to a group of projects.
SELECT P.*, T.*
FROM Projects P, Tasks T
WHERE P.Project_ID = T.Project_ID
AND Project_ID
Frederic Wenzel wrote:
On Sun, 17 Oct 2004 19:36:34 +, shaun thornburgh
[EMAIL PROTECTED] wrote:
A Project will have 1 or more tasks assigned to it. Using the following
query, how can I modify it so that I can find out the largest number of
tasks assigned to a group of projects.
SELECT P.*,
Hi Shaun!
I beg you pardon, my last message was incomplete! I will quote the
last lines from my previous post:
---8- Cut here ---8---
- Thanks to the LIMIT clause, we get only the first result, which by
the way is one of the projects with the most assigned tasks. If
this is a working example i found on mysql.com
this is my example of fullsearch
mysql desc fullsearch;
+---+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
Thanks for this. Very useful.
In particular your idea of using a RAM disk sounds interesting but I am not
sure how you imagine I use it? I presume that on power down everythign on a
ramdisk is lost so on every power=up I would have to put my data directory on
the RAM-disk while the settings in
15 matches
Mail list logo