Hello everyone, I'm just trying to grab one column of information and I
keep getting the exception thrown by this snippet of code in
coonection.cpp
if (lock()) {
if (throw_excptns) {
throw BadQuery("lock failed");
}
else {
Hi,
I am new to the list and mysql for that matter. I am trying to
configure a centralized syslog server using mysql, msyslog and php.
Works great until the DB grows to about 2GB. After the database gets
over 2GB, running queries on a particular hostname (that has a lot of
records) takes a long t
Are you sure this kind of constraint is supported in MySQL 4.1?
I'm not saying they aren't, I just don't remember. Unless you're sure they
are, you should check the manual.
Rhino
- Original Message -
From: "Rodrigo Sakai" <[EMAIL PROTECTED]>
To:
Sent: Friday, May 20, 2005 6:49 PM
Subje
Hi, I need to do a constraint that checks if the field 'salary' of one table
is not smaller than zero. Like:
create table employee (
name varchar(30),
salary numeric(10,2)
constraint ck_salary check (salary > 0)
);
What´s the sintaxe? I'am not finding the correct sintax
"Alan Scott" <[EMAIL PROTECTED]> wrote on 05/20/2005 03:47:55 PM:
> MySQL Server v4.1.x
>
>
>
> Is there a table in any instance of mysql that I write some queries and
> insert/update statement against for moving databases between systems?
>
>
>
> Any assistance would be appreciated.
>
You
MySQL Server v4.1.x
Is there a table in any instance of mysql that I write some queries and
insert/update statement against for moving databases between systems?
Any assistance would be appreciated.
At 12:29 -0700 5/20/05, Michael wrote:
Greetings,
I looking at using mysqlhotcopy to back-up my server's database.
However mysqlhotcopy doesn't include backing-up the user/password
file (am I wrong?).
I'd like to also include a back-up of the DB access control list but
I can't seem to find it..
Michael,
They, passwords, stored in "mysql" database that comes with every
install of MySQL.
Mikhail Berman
-Original Message-
From: Michael [mailto:[EMAIL PROTECTED]
Sent: Friday, May 20, 2005 3:29 PM
To: mysql@lists.mysql.com
Subject: Where is mysql user/password list kept??
Gree
Greetings,
I looking at using mysqlhotcopy to back-up my server's database.
However mysqlhotcopy doesn't include backing-up the user/password file
(am I wrong?).
I'd like to also include a back-up of the DB access control list but I
can't seem to find it...
I'm also a beginner in using mysql.
Hi All,
Does anyone know how to convert Berkeley db to ISAM type? I have many
Berkeley db files sitting on my hard drive. I want to port it to MySQL
as ISAM tables. I understand I can directly load it to MySQL 4.0 by
specifying the directory location. Instead I want to convert them ISAM
type on
"Matthew Simpson" <[EMAIL PROTECTED]> wrote on 05/20/2005 02:21:54 PM:
> I use Mysql to store call detail records from telephone calls. I have
> around 20 voice switches that send the call detail records in real time
> using INSERT statements.
>
> I am having a problem where I need to delete "
Hi,
I have two identical machines in terms of OS and software installed (more info
at the end of the message).
I need to dump a database on the first machine and restore it on the second
one.
Here is step by step what I'm doing.
==> on server1
$mysqldump cerberus_database > cerberus_database-
Also try running the delete more frequently. It won't cause much of a
lock if there is an index on accountcode and mysql doesn't find any rows
to delete.
gerald_clark wrote:
Matthew Simpson wrote:
I use Mysql to store call detail records from telephone calls. I
have around 20 voice switches th
Is MyISAM a bad choice for this kind of table?
- Original Message -
From: "Dathan Pattishall" <[EMAIL PROTECTED]>
To: "Matthew Simpson" <[EMAIL PROTECTED]>;
Sent: Friday, May 20, 2005 1:48 PM
Subject: RE: slow DELETE query
DELETE LOW_PRIORITY
But since your using myISAM the table will ha
Matthew Simpson wrote:
I use Mysql to store call detail records from telephone calls. I have
around 20 voice switches that send the call detail records in real
time using INSERT statements.
I am having a problem where I need to delete "junk" call records that
get generated [old call records, c
DELETE LOW_PRIORITY
But since your using myISAM the table will have to lock.
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: Matthew Simpson [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 20, 2005 11:22 AM
> To: mysql@lists.mysql.com
> Sub
Hi Matthew,
have you any foreign keys, if yes can you show :
- show create table cdr
- show create referenced in foreign keys and foreach the indexes
Mathias
Selon Matthew Simpson <[EMAIL PROTECTED]>:
> I use Mysql to store call detail records from telephone calls. I have
> around 20 voice
If it's an option, buy more RAM and more disks..
Is it a 17gb table or 17gb of data spread across several tables? If
it's across several tables, you won't have as much trouble rebuilding
the indexes.
Another option is to build another machine with a bunch of ram and a
RAID1 or RAID10 (SATA or SCS
I use Mysql to store call detail records from telephone calls. I have
around 20 voice switches that send the call detail records in real time
using INSERT statements.
I am having a problem where I need to delete "junk" call records that get
generated [old call records, call records with no acc
On Fri, May 20, 2005 at 10:50:29AM -0700, Fredrick Bartlett wrote:
> The documentation indicates that there are three active versions being
> worked on. Is this true? Why not just release the current one with the most
> bug fixes?
>
> D.1.1. Changes in release 5.0.7 (not released yet)
> D.1.2. Cha
Whatever it was, looks like they recovered.
-Original Message-
From: Rahul S. Johari [mailto:[EMAIL PROTECTED]
Sent: Friday, May 20, 2005 1:38 PM
To: [EMAIL PROTECTED]; 'mysql@lists.mysql.com '
Subject: Re: Hashmysql.org 0wn3d?
Ave,
I was wondering the same. Looks like hacked to me. Som
The documentation indicates that there are three active versions being
worked on. Is this true? Why not just release the current one with the most
bug fixes?
D.1.1. Changes in release 5.0.7 (not released yet)
D.1.2. Changes in release 5.0.6 (not released yet)
D.1.3. Changes in release 5.0.5 (to be
It was taken offline temporarily.
It's back now.
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I doubt there is much to do. Your hardware is the bottleneck I would
think. You will completely kill the server regenerating the indexes
afterwards as well, so if the idea is to get is up and running fast, it
may not be so fast once you get it up.
-Original Message-
From: Mikel - [mailto:[
Ave,
I was wondering the same. Looks like hacked to me. Something's up.
Rahul S. Johari
Coordinator, Internet & Administration
Informed Marketing Services Inc.
251 River Street
Troy, NY 12180
Tel: (518) 266-0909 x154
Fax: (518) 266-0909
Email: [EMAIL PROTECTED]
http://www.informed-sources.com
Was hashmysql.org hacked?
The wiki is gone and now all I get is:
"Stupidity is a crime against humanity."
Which is redundant btw...
Kevin
--
Use Rojo (RSS/Atom aggregator)! - visit http://rojo.com.
See irc.freenode.net #rojo if you want to chat.
Rojo is Hiring! - http://www.rojonetworks.com/JobsA
There is a variable called --network-timeout ! You can set it to 300 (5
minutes, etc.).
"Tony Yau" <[EMAIL PROTECTED]> wrote:
>Hi Guys,
>you can always set a max time out for your php script (php.ini)
>Tony
>
>- Original Message -
>From: "Gleb Paharenko" <[EMAIL PROTECTED]>
>To
Hi Guys,
you can always set a max time out for your php script (php.ini)
Tony
- Original Message -
From: "Gleb Paharenko" <[EMAIL PROTECTED]>
To:
Sent: Friday, May 20, 2005 12:45 PM
Subject: Re: MySQL give up on a query after a certain length of time
> Hello.
>
> I don't remember
> Check with SHOW PROCESSLIST in what state your query hangs.
It hangs while sending data. I only ask for 7 rows, and normally this
goes very fast.
Have a nice weekend.
Thanks,
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.my
Hi list,
I have a 17G dump from my DB, any suggestions to recover that dump faster,
any variables to tune up?... I don't have an accurate binary backup, so I
have to restore it from my 17G text file.
I remove the indexes, foreign keys, I will create them after I've recovered
all the data.
I ha
Hi Sven,
Last_insert_id is not what your're looking for, for the same reason you give
about max(id) : your insert can find a duplicate key because another user
inserted an id between two of yours.
Last_insert_id gives just the last auto_increment id for success in insertion.
Suppose that your inse
On Fri, May 20, 2005 at 09:28:40AM -, [EMAIL PROTECTED] wrote:
> Hint: Did you specify a password for the login ?
I suspect the original poster was saying that he doesn't
remember setting a password, so he doesn't know what password to
enter.
-Jason Martin
--
Unrecoverable Application ERROR -
Computer Programmer <[EMAIL PROTECTED]> wrote on 05/20/2005 07:56:39 AM:
> SELECT t2.`col1`, t3.`title`, t3.`col3`, t4.`published` FROM t1 LEFT
JOIN
> t2 ON (t2.`catid`=t1.`id`) LEFT JOIN t3 ON (t3.`id`=t2.`sid`) CROSS JOIN
> `main_data` t4 ON (t4.`id`=t2.`sid`) WHERE t2.`catid`='7' AND
> t4.
Hello.
See:
http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html
>Dear there,
>I have some problems when installing mysql under rpm. Hope some people
>can give me help.
>I install MySQL-server-4.1.12-0.i386 package and
>MySQL--client--4.1.12-0.i386 package
>under roo
Hello.
Table cache formula is present at:
http://dev.mysql.com/doc/mysql/en/table-cache.html
Usually key_buffer should be as big as possible, to be able to store
a lot of index blocks. If you're using group by queries increasing a
tmp_table_size might be helpful.
Stephen M
Hello.
See:
http://dev.mysql.com/doc/mysql/en/access-denied.html
http://dev.mysql.com/doc/mysql/en/resetting-permissions.html
>Hello all,
> I'm having a bit of trouble:.
> Welcome to phpMyAdmin 2.5.0-rc1
>
>
> Error
>
> MySQL said:
>
>
> Access denied for user: '[E
Hello.
I don't remember such way (except your transaction could abort due to
lock timeout). Check with SHOW PROCESSLIST in what state your query
hangs.
Jacob Friis Larsen <[EMAIL PROTECTED]> wrote:
> Hello.
>
> Is there a way to have MySQL give up on a query after a certain length o
If things were that easy, there probably wouldn't be a DBA job title.
Tuning a database requires knowledge of the data, how it is accessed
and what variables will affect those access patterns. There are some
basic formulas for speeding up a typical database with typical access
patterns.
If you
SELECT t2.`col1`, t3.`title`, t3.`col3`, t4.`published` FROM t1 LEFT JOIN
t2 ON (t2.`catid`=t1.`id`) LEFT JOIN t3 ON (t3.`id`=t2.`sid`) CROSS JOIN
`main_data` t4 ON (t4.`id`=t2.`sid`) WHERE t2.`catid`='7' AND
t4.`published`=1 GROUP BY `sid` ORDER BY t3.`title`;
What this does is to show all the
Hello.
Is there a way to have MySQL give up on a query after a certain length of time?
I use Debian Linux Sarge, MySQL 4.1 and Php 5.
Sometimes I have queries that take forever although the same query
returns fast at other times.
Thanks,
Jacob
--
MySQL General Mailing List
For list archives: ht
Hi Stone,
no offense, but that one you should really be able to answer yourself
> Hello all,
> I'm having a bit of trouble:.
> Welcome to phpMyAdmin 2.5.0-rc1
>
>
> Error
>
> MySQL said:
>
>
> Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
>
>
> how can I find my password?
Lo
41 matches
Mail list logo