Hi,
I found the same thing running v4.1.9. To make it work I first had to
issue:
PURGE MASTER LOGS TO 'logfilename'
...only then was I was able to use the 'BEFORE' variant i.e.
PURGE MASTER LOGS BEFORE DATE_SUB(NOW(), INTERVAL 10 DAY);
The first one must resync some sort of log index file or
At 22:31 -0500 11/1/05, Ric Pennington wrote:
Hello,
MySQL Version Server version: 4.1.14-log
I've been gettting "random" truncate commands as seen below:
Once/day at a seemingly random time it happens.
I have no code that issues a truncate command and I've changed and limited
connections
Follow up at bottom:
On Tuesday 01 November 2005 04:15 pm, Hal Vaughan wrote:
> On Tuesday 01 November 2005 03:35 pm, [EMAIL PROTECTED] wrote:
> > Which tables can have duplicate records in them should be something
> > decided BEFORE you begin to populate the tables. 99.999% of the time,
> > each
Hello,
MySQL Version Server version: 4.1.14-log
I've been gettting "random" truncate commands as seen below:
Once/day at a seemingly random time it happens.
I have no code that issues a truncate command and I've changed and limited
connections to the MySQL server.
# at 2939766
#051101 16:5
never mind - found the paragraph in the manual..
The |SQL SECURITY| characteristic can be used to specify whether the
routine should be executed using the permissions of the user who creates
the routine or the user who invokes it. The default value is |DEFINER|.
This feature is new in SQL:200
Heikki,
We thanks vary much for your response.
The CPU usage is avg 10% during the test.
We think if you need we will give you our test source code.
Best regards,
george
Am I understanding this correctly?
SQL SECURITY DEFINER...
DEFINER - make sure the person who wrote this procedure had the
authority/permissions to do everything in it and runs or not based on that,
INVOKER - make sure the person who uses this procedure has the
authority/permissions to do ever
Because the SHOW FULL COLUMNS FROM command does not apply to temporary table, a
java program using Connector/J
is not able to use the sun.jdbc.rowset.CachedRowSet to retrieve the data from a
temporary table.
Does anyboby have any suggestions?
Thank you.
Here is the version of mysql server and
[EMAIL PROTECTED] wrote:
If I understand the InnoDB engine correctly, I don't see how they could
speed it up unless they start tracking how many records belong to each
active "version" within a database.
But one thing you can do to speed it up somewhat is to do a
COUNT(PK_column) (rather th
On Tue, Nov 01, 2005 at 02:38:29PM -0800, Kevin Burton wrote:
> Gangla and Cacti seem to do similar tasks (if you stretch them) but
> they really fall down fast.
Can you elaborate on 'fall down fast'? It should be a really
simple operation to do this in cacti.
-Jason Martin
--
SYSTEM ERROR: pre
Hey.
I'm looking for a decent tool which uses crontab to monitor the
COUNT of tables within MySQL. I'd also like to monitor other queries
as well. Ideally it would use RRDtool to log the data and a PHP to
draw the UI.
Gangla and Cacti seem to do similar tasks (if you stretch them) but
Hi,
When I migrated from 3.23 to 4.0 version (if I'm remember well), I think
I missed to upgrade something, so all my MySQL users are able to see the
list of the databases on my server. Currently, the MySQL version is
5.0.15, i ran the mysql database upgrade script, but it still is a
problem.
"ISC Edwin Cruz" <[EMAIL PROTECTED]> wrote on 11/01/2005 04:33:39 PM:
> Hi All!!
> I recently have migrated a database from SQL Server 7.0 to Mysql 5.0.14
> (I´ve used MySQL Migration tool), mi probem is that the queries where i
use
> foreing keys are tooo sloowww
>
> Specialy in two tables;
>
Are you sure? Finding a single record using an index may be O(logN),
but wouldn't reading all of the index be O(N)?
Yeah.. you're right. It would be O(N)... I was thinking this as I
hit the "send" button :)
Kevin
Kevin A. Burton, Location - San Francisco, CA
AIM/YIM - sfburtonator,
On 11/1/05, Kevin Burton wrote:
> MyISAM has a cool feature where it keeps track of the internal row
> count so that
>
> SELECT COUNT(*) FROM FOO executes in constant time. Usually 1ms or so.
>
> The same query on INNODB is O(logN) since it uses the btree to
> satisfy the query.
Are you sure? Fin
Hi All!!
I recently have migrated a database from SQL Server 7.0 to Mysql 5.0.14
(I´ve used MySQL Migration tool), mi probem is that the queries where i use
foreing keys are tooo sloowww
Specialy in two tables;
mysql> show create table trafico_guia\G;
*** 1. row **
Kevin Burton <[EMAIL PROTECTED]> wrote on 11/01/2005 03:39:59 PM:
> MyISAM has a cool feature where it keeps track of the internal row
> count so that
>
> SELECT COUNT(*) FROM FOO executes in constant time. Usually 1ms or so.
>
> The same query on INNODB is O(logN) since it uses the btree to
On Tuesday 01 November 2005 03:35 pm, [EMAIL PROTECTED] wrote:
> Which tables can have duplicate records in them should be something
> decided BEFORE you begin to populate the tables. 99.999% of the time, each
> row of any one table should be different from every other row on the same
> table. Tha
At 12:39 -0800 11/1/05, Kevin Burton wrote:
MyISAM has a cool feature where it keeps track of the internal row
count so that
SELECT COUNT(*) FROM FOO executes in constant time. Usually 1ms or so.
The same query on INNODB is O(logN) since it uses the btree to
satisfy the query.
I believe th
"Stephen Lewis" <[EMAIL PROTECTED]> wrote on 11/01/2005 02:39:16 PM:
> I am curious, can MySQL be used for Directory Sevices and act as an
> LDAP Server.
>
Not by itself. You will need to write the portion of the server that
sends, receives, and processes the actual LDAP messages (the LDAP
se
MyISAM has a cool feature where it keeps track of the internal row
count so that
SELECT COUNT(*) FROM FOO executes in constant time. Usually 1ms or so.
The same query on INNODB is O(logN) since it uses the btree to
satisfy the query.
I believe that MyISAM just increments an internal count
Comments embedded. See below
Hal Vaughan <[EMAIL PROTECTED]> wrote on 11/01/2005 02:50:13 PM:
> I want to be sure I understand "INSERT IGNORE..." correctly before I
start
> depending on it. Up until now, I have not been using any kind of key or
> unique index, since many of my tables are cre
Hi, all
I have a question like this:
There's a field in table_A, date_time, if I say this in Mysql:
select min(date_time), max(date_time) from table_A;
it returned something like this:
+-+-+
| min(date_time) | max(date_time) |
+
I am curious, can MySQL be used for Directory Sevices and act as an LDAP Server.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I want to be sure I understand "INSERT IGNORE..." correctly before I start
depending on it. Up until now, I have not been using any kind of key or
unique index, since many of my tables are created automatically and, until
now, it has been difficult for me to create a way to distinguish between
YL wrote:
Dear list,
I have a database backup from database in a 5.0.15 server and like to make it work in
5.0.1 server. The data need no anything new (like trigger etc) to 5.0.1.
After some testing, by editing the backup file, I was able to make a testing
database
work (from 5.0.15 to 5.0.1).
Dear list,
I have a database backup from database in a 5.0.15 server and like to make it
work in
5.0.1 server. The data need no anything new (like trigger etc) to 5.0.1.
After some testing, by editing the backup file, I was able to make a testing
database
work (from 5.0.15 to 5.0.1).
I'm wonder
Gleb, thanks for the forcing-recovery pointer, thats what we ended up
using to recover the data for the corrupted table. After that we dropped
the table and recreated it, and imported the data and everything seems
fine for now.
Here are the OS/MySQL details:
brand new 64bit dual xeon w/ 6gigs of
Can you search Chinese with mysql client (shell)?
- Original Message -
From: "Carol Ku" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, November 01, 2005 10:56 AM
Subject: Chinese Characters
> Hi:
> I downloaded mysql 4.0 for a opensource library software called Koha. Now
I have trouble storin
Gleb Paharenko wrote:
Hello.
Have a look here:
http://dev.mysql.com/doc/refman/5.0/en/not-enough-file-handles.html
thanks, i've upped the open-files-limit variable. we'll see how it goes.
-jsd-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscri
Hi:
I downloaded mysql 4.0 for a opensource library software called Koha. Now I
have trouble storing and searching in Chinese characters. I know that Mysql
should support unicode, is there a way for me to over come this?
Thank you.
Carol
-
This is an excellent example of WHY you need to always CC: the list on all
responses. I cannot specifically answer your response because I do not
use enough PHP to help. In extremely generic terms, what you need to do
is:
a) connect to the database server
b) send to the database server an INSE
"Brian e Boothe" <[EMAIL PROTECTED]> wrote on 10/31/2005 10:21:35 PM:
> I.m needing assistance in get a problem Solved ,
>
> What im attempting to do is have MySQL thru asp or PHP look thru
> Folders and add to a Mysql database the path and folder name and file
> located within that direct
Barry wrote:
Can someone plaese help? I have three tables 1st is a collection of
propertys, 2nd is a list of facilities(98 in total) and the third is a
list of property id's corresponding to the facilities id's offered at
each property,
The query I am running:
'SELECT'
'`'.$type.'`.`id`,'
'`'.$t
Barry wrote:
Can someone plaese help? I have three tables 1st is a collection of
propertys, 2nd is a list of facilities(98 in total) and the third is a
list of property id's corresponding to the facilities id's offered at
each property,
The query I am running:
'SELECT'
'`'.$type.'`.`id`,'
'`'.$t
I.m needing assistance in get a problem Solved ,
What im attempting to do is have MySQL thru asp or PHP look thru
Folders and add to a Mysql database the path and folder name and file
located within that directory into the database, can anyone help me ?? or
give me hints
--
No virus fou
Can someone plaese help? I have three tables 1st is a collection of
propertys, 2nd is a list of facilities(98 in total) and the third is a
list of property id's corresponding to the facilities id's offered at
each property,
The query I am running:
'SELECT'
'`'.$type.'`.`id`,'
'`'.$type.'`.`name`,'
Hello.
Have a look here:
http://dev.mysql.com/doc/refman/5.0/en/not-enough-file-handles.html
Jon Drukman wrote:
> Master and slaves are both Mysql 4.1.14 standard. There are six slaves,
> and this error kept happening on #2 and #4, but then it stopped. I
> thought it was all gone
Hello.
> nm: /usr/sbin/mysqld: no symbols
It seems strange because of your version - 4.1.14-debug-log.
Get MySQL which has symbols. See:
http://dev.mysql.com/doc/refman/5.0/en/compiling-for-debugging.html
Don Doumakes wrote:
> Gleb Paharenko wrote:
>
>> Follow links which have
Hello.
Please provide information about MySQL and operating system versions.
Include your configuration file. This link might be helpful in case you
want to save your data:
http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html
Mayuran Yogarajah wrote:
> Mayuran Yogarajah wrot
Hello.
Are you asking about GRANT statement? See:
http://dev.mysql.com/doc/refman/5.0/en/GRANT.html
http://dev.mysql.com/doc/refman/5.0/en/privilege-system.html
Alastair Roy wrote:
> Can someone please tell me what the command would look like to grant access
> for the root user to a
Hello.
> x86_64 x86_64 GNU/Linux
Linux AMD64 / Intel EM64T RPM (glibc-2.3, dynamic, gcc) downloads.
Logg, Connie A. wrote:
> I have just received a new machine to install mysql on and I do not know =
> how to tell which version of the rpm's I should use
>
> [EMAIL PROTECTED] confi
42 matches
Mail list logo