I have read the replicate document in reference manual.But i have some question.
1.If a deterministic storeprocedure only use in replication?
2.If a procedure within replication must be deterministic?
3.When a procedure result is non-deterministic?Can i get a example?
"Adam Lipscombe" <[EMAIL PROTECTED]> wrote on 12/13/2005 01:34:45
PM:
> Folks
>
> By default mysqldump uses linefeed as the line ending. This results in
the
> data looking odd in a Windows text editor, as they expect \r\n.
>
> I have experimented with the --tab and --line-terminated-by option
On Tue, Dec 13, 2005 at 06:33:47AM +, Duncan Hill wrote:
> The methods to defeat this, to the best of my knowledge, include limiting the
> privileges of the web script user (or any user) to only do what they need to
> do. So if the script only needs to select data, don't give it any rights
Octavian Rasnita wrote:
From: "Gleb Paharenko" <[EMAIL PROTECTED]>
Hello.
In my opinion, it is not a bug. REPLACE has returned the sum
of affected rows - one was deleted, and one was inserted. See:
http://dev.mysql.com/doc/refman/5.1/en/replace.html
Thank you. I have seen that's the true.
I
Hello.
See:
http://dev.mysql.com/doc/refman/5.0/en/the-dbug-package.html
P. Evans wrote:
> Hello Listers,
> Can anyone explain what are valid values for the 'debug options' on a
> mysqlimport ? The manuals just say :
> --debug[=debug_options], -# [debug_options]
> Write a d
From: "Gleb Paharenko" <[EMAIL PROTECTED]>
> Hello.
>
> In my opinion, it is not a bug. REPLACE has returned the sum
> of affected rows - one was deleted, and one was inserted. See:
> http://dev.mysql.com/doc/refman/5.1/en/replace.html
>
>
Thank you. I have seen that's the true.
Is there any
I just upgraded MySQL from 4.1.14 to 5.0.16 and I'm getting the following
error over and over again in my server log.
051213 15:55:21051213 15:55:21 [ERROR] The calling thread is holding the
adaptive search, latch though calling
innobase_query_caching_of_table_permitted.
I haven't been able to n
For the t/40 error, you can install the missing module which appears to
be missing.
There is also a Bundle::DBI module from CPAN which will install the DBI
and dependent modules.
Alfred
Lewis Ashley Foster wrote:
Ok, i had a look at the perl DBI installations and tried "make
test"i thi
Hello.
In my opinion, it is not a bug. REPLACE has returned the sum
of affected rows - one was deleted, and one was inserted. See:
http://dev.mysql.com/doc/refman/5.1/en/replace.html
Octavian Rasnita wrote:
> Hi,
>
> I have tried:
>
> mysql> create table z(id int unsigned not n
Hello.
> the first error, cant find Time/HiRes.pmthen later on 56/56 tests
Now it is rather a pure Perl problem than MySQL. However, have you
installed Time/HiRes.pm? As far as I know, you can use 'force install
...' instead of just 'install' command in the cpan shell. This should
cont
Hello.
> Do I have to build an index first and how often is it updated etc?
Yes, you should create FULLTEXT indexes. However I'm not sure if you
will get any benefits for searching inner part of the words (*$key1*),
because you can search using asterisk only on the left-most prefixes of
th
Hello.
If you database contained MyISAM tables, you should prevent any access
to the partition (or logical disk in Windows) and recover deleted files
(*.MYI, *.MYD, *.frm). I'm not sure what to do with InnoDB tablespace
(not per-file), but certainly you should shutdown MySQL and copy ibdata
Hello Listers,
Can anyone explain what are valid values for the 'debug options' on a
mysqlimport ? The manuals just say :
--debug[=debug_options], -# [debug_options]
Write a debugging log. The debug_options string often is 'd:t:o,file_name'.
What is d: ? t: ? o (ok,thats relative
Folks
By default mysqldump uses linefeed as the line ending. This results in the
data looking odd in a Windows text editor, as they expect \r\n.
I have experimented with the --tab and --line-terminated-by options, but
this results in a separate txt file for each table.
Is there any way to persu
Duncan Hill wrote:
On Tuesday 13 December 2005 02:25, Peter Lauri wrote:
Best group member,
How can I prevent people from hijacking a query? I read this in an article
about a few months ago, but now I can not find that article again. This
question is maybe not so exact, and I do not know
I made a major mistake with MySQL 4.1.x. While using Navicatt I
dropped my database when I meant to drop a table. Other than backups
which are not that up to date, is there an undo?
Help here is greatly appreciated.
Thanks, I'm desperate.
Rick
--
MySQL General Mailing List
For list archive
> I'm coding Stored Procedures in MySQL and as a precaution I want to trap
> any potential database errors thrown by MySQL. Does MySQL offer specific
> system variables that you can interrogate in an if test and take action
> accordingly?
>
> Please let me know.
http://dev.mysql.com/doc/refman/5.
Hi,
I've always done conventional searches Where ( title like '%$key1%')
or(isynopsis like '%$key2%')
etc etc
But the client has increased the complexity of the search and especially the
size of his database
and the search has really slowed. (particularly now that I have to search a
longtext fi
I'm coding Stored Procedures in MySQL and as a precaution I want to trap
any potential database errors thrown by MySQL. Does MySQL offer specific
system variables that you can interrogate in an if test and take action
accordingly?
Please let me know.
Thanks,
Brandon
--
MySQL General Mailing
Hi,
I have tried:
mysql> create table z(id int unsigned not null primary key, first_name
varchar(20), last_name varchar(20));
Query OK, 0 rows affected (0.06 sec)
mysql> insert into z values(1, 'John', 'Smith'), (2, 'George',
'Washington');
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplica
I don't have any experience with dual core yet (my first dual dual
core box is scheduled to arrive this week!!). I don't think I'd opt
for a dual core in place of 2 single cores. I'm hoping (expecting?) to
see an advantage in 2 DC over 2 SC.
As far as SCSI over SATA goes, I exclusively use SATA. I
Hello,
Yes, the binary log will probably get the job done if its just data
modifications you're after and you're archiving those logs to suit your
needs. However if you'd like to also track other things like SELECTs,
enabling the general query log might be a better option. Starting MySQL with
the
Thanks for all the feedback on this.
Is there any received wisdom on whether 1 dual core processor is better than 2
'normal' processors?
Also, is there any advantage to SCSI over SATA?
TIA,
James Harvard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscr
Thanks Jimmy,
I would like to get one thing clarified from you is: Am I able to create a
binary log (may be some other log) to know the changes done on my database(any
updations,deletion of records,addition of new records) in MySQL by different
users?
Thanks a lot,
Satyanarayana Reddy
_
Jan Pieter Kunst wrote:
I don't see why 40 tables is such a big deal? Normalizing data usually
results in more (but smaller) tables and crosstables. If you are
working with complicated normalized data, 40 tables does not sound so
excessive to me.
- I wish I only had 40 tables to worry about..
On 12/12/05, Peter M. Groen <[EMAIL PROTECTED]> wrote:
> Ehm.. To be blunt... 40 TABLES??? You call that small? What on earth are you
> going to store.
I don't see why 40 tables is such a big deal? Normalizing data usually
results in more (but smaller) tables and crosstables. If you are
working w
Hello,
Something to keep in the back of your mind, is in the latter part of next
year we will be enabling the option to log all/some DDL, DCL, SELECTs, DML
and Server Admin commands and its associated ID, IP, timestamp, etc.
At that point you'll be able to filter, sort or delete audit data to sui
Ok, i had a look at the perl DBI installations and tried "make test"i
think this explains a thing or two!
Both 1.32 and 1.49 fail massively it seems. I'll go for version 1.32 so the
output for the make test on 1.32 is below.
I seriously have no idea where to start with this lot, t/40 se
Hi,
MySQL 4.1.16, a new version of the popular Open Source Database
Management System, has been released. The Community Edition is now
available in source and binary form for a number of platforms from our
download pages at
http://dev.mysql.com/downloads/
and mirror sites.
Note that not all
Lewis,
As you already have perl installed, an easier way of getting modules
is by way of CPAN (www.cpan.org). Give this a try, as superuser:
cpan install DBI
Regards,
Imran
--
http://www.EjectDisc.com
Get your Digital Identity - Domain Names, Web Space, E-mail & More!
--
MySQL General Mailing L
30 matches
Mail list logo
