Hi,
Michael Fernández M. wrote:
2 CPU Pentium III 700 Mhz Aprox.
4 GB RAM.
Redhat 7.2
Mysql version: 4.0.14-standard-log
Kernel: Kernel 2.4.18-17.7 (highmem)
It is possible that mysqld could use up to key_buffer_size +
(read_buffer_size + sort_buffer_size)*max_connections = 3666809 K bytes
of
Carlos Soria wrote:
Thank you for your answers.
gcc (GCC) 4.1.1 20060724 (prerelease) (4.1.1-3mdk)
mysql Ver 14.12 Distrib 5.0.24a, for mandriva-linux-gnu (i586) using
readline 5.1
GNU C Library development release version 2.4,
I think MySql 5.0 requires glibc 2.3. I do not know if v2.4
Hi,
I'm looking for using FIELD CONSTRAINTS on Mysql but I can´t find it ...
Doesn´t Mysql implement it??
For example:
age int 0
MySQL doesn't support declarative CHECK CONSTRAINTs,
you could use triggers as a workaround.
Martijn Tonies
Database Workbench - development tool for
First at all, i`m spanish so please, apologize for my english
Hello to everybody, i`m a newby with mysql and i have a problem with a select
I`m making a database for a hostel
I have 2 tables for reservations, one is called rooms and have 2 fields
(id_room, tipo)and the other one is ocupation
I'm spanish speaker too .. but I write it in english for everyone can read
it.
The version 5 implements subqueries. You can do something like:
SELECT id_room
FROM rooms
WHERE id_room NOT IN (SELECT id_room FROM reservations WHERE date =
'22-03-07');
Regards,
RAUL DUQUE
Bogotá, Colombia
Hello,
Is it possible to restaure a .sql file encoded in utf8 to mysql with
mysql client set to latin1?
I've got a forum on a server which has got it's client set to utf8
I need to move the forum to a new server. But this new server has got
postfix and proftp that seem to need the mysql
I need to create an inline view that will give me all dates between two
specified. Here is the question posed to me that I need to answer:
This basic query gets me the last 6 hours of history table entries for
an item, grouped into minutes (if an item has a delay of 5 seconds, it
takes the max
Juan,
InnoDB Hot Backup is non-free. A 1-year license costs 390 euros + VAT,
and a perpetual license 990 euros + VAT.
http://www.innodb.com/order.php
The Perl script innobackup can be used to make consistent backups of
MyISAM tables also, but those backup require the locking of MyISAM
hi to all!
I have a table that contains ratings of suppleirs. almost 2000 records.
administrator uses a form with radio buttons (values R, A and NR) to
chanage rating for each supplier.
after he submit I have an array where index is $supp_id and value is
$new_rating.
Since, admin changes the
Whats wrong with using the --single-transaction switch for backing up
InnoDB tables? What does the Hot Backup product do that this doesn't?
Thanks,
-Ryan
Juan Eduardo Moreno wrote:
Ananda,
For Innodb the best is Innodb Hot Backup ( www.innodb.com (US$) )
For MyISAM you can use a simple
Bryan
A subqueryless (ie join) version of your query will likely be faster:
select
from_unixtime(t.clock),
DATE_FORMAT(from_unixtime(t.clock),'%j %h:%i %p') as mins,
MAX(t.value) as value_max
from history t
join items i using (itemid)
where t.itemid = @iid
and i.hostid = @hid
and
I have a potential client that is anticipating rapid growth of a web
site they want me to build. Some quick research tells me that there is
the potential for as many as 50 million users that will access the site
for an hour or two every day. All of those users will be located in the
USA so
On 2/26/07, Chris W [EMAIL PROTECTED] wrote:
Can someone here give some insight and suggest other options I could
look into?
you could replicate all the data between web/application servers, and
use the local store as a read-only database, and push all your
updates to a central update
I would use three queries, as in your first example, but use IN followed by
a list of IDs that you construct. That would be easier to build than all of
those OR conditions. Loop through the input something like this (not tried,
and probably a little sloppy):
$rating_list = array(); // Build
Complementing Chris :
http://www.onlamp.com/lpt/a/6549Asume that your Application Server is
Tomcat.
BALANCING SERVERS:
You can implement some servers or appliance only for balancing your primary
connections. This servers or appliance you must implement using Hearbeat (
only). For example one
If you can wait for 5.1 (in beta now), you can use partitioning to store
a client on a different database in a different geographical site. You'd
need to partition by region/state (assuming you capture address info).
If you wanted to do any reporting, however, you'd need to set up a data
Hi
I have looked up earlier postings on disk partitions and mysql and couldn't
find any discussion threads. Mysql is storing data in the /usr partition of
Redhat 9. The /usr partition is about 50% full. Within a year it will outlast
the available space on /usr.
The /var partition on
At 10:42 PM 2/25/2007, mos wrote:
At 06:13 PM 2/25/2007, Miles Thompson wrote:
Would someone please check this delete query?
This should delete all rows from the geodesic_user_data that have no
match in the subscriber table, but another set of eyes would be appreciated.
DELETE
At 07:51 PM 2/26/2007, Miles Thompson wrote:
At 10:42 PM 2/25/2007, mos wrote:
At 06:13 PM 2/25/2007, Miles Thompson wrote:
Would someone please check this delete query?
This should delete all rows from the geodesic_user_data that have no
match in the subscriber table, but another set of
19 matches
Mail list logo