Hi,
i did it. If you have myisam tables tables rather than innodb say it.
if you have specific os, say it.
i think you should elaborate, or read carrefully dev.mysql.com/doc
Mathias
Selon °l||l° Jinxed °l||l° <[EMAIL PROTECTED]>:
> i used start transaction before using SET AUTOCOMMIT=0; also i
I created a search app with fulltext, boolean, etc. i have two forms,
one that allows the user to just enter a basic search in a single input
field and a more advanced form with additional input areas for advanced
boolean searches.. now, when you do not specify a boolean operator, what
does it
Hi,
If we forget the first method which i mis-adviced, i can give a third which is
generic.
suppose that you have an indexed "type" column on each table (what i did). You
can work with 3 variables. If they are different, you query for a join, if they
are equal, you transform the join to a simple q
That all depends on how you have configured your caching, but it is easy
to do.
'mysqld --help':
--query_cache_type=#
0 = OFF = Don't cache or retrieve results. 1 = ON = Cache
all results except SELECT SQL_NO_CACHE ... queries. 2 =
I am running a test on mysql. In a specific condition I need avoid using
the cache system in mysql how can I do this? If I can't, is there anyway to
remove the cached tables from cache manually?
_
与联机的朋友进行交流,请使用 MSN Messenger: ht
Thank you for your detailed response.
It seems my problem is trying to define the path to my data file and this is
where I seem to be missing something. Permissions on all directories in the
path are by default set to 755 except for the director at the top of the
directories in my hosting account
I am running a test on mysql. In a specific conditiob I need avoid using
the cache system in mysql how can I do this? If I can't, is there anyway to
remove the cached tables from cache manually?
_
享用世界上最大的电子邮件系统― MSN Hotmail。 htt
We are running 4.0.20 on two servers (AMD Opteron and Xeon).
Our slave has died twice in the last month with the following error:
"Could not parse relay log event entry. The possible reasons are: the
master's binary log is corrupted (you can check this by running
'mysqlbinlog' on the binary lo
There is an option starting in 4.0.14 called read-only that will allow
only the slave i/o thread and users with the super priv to execute write
queries.
Jeremiah Gowdy wrote:
Is there a way to make MySQL Slaves read only in regards to all UPDATE, INSERT,
DELETE, DROP, TRUNCATE, etc, except
Conceptually, what I'd like to do is join two tables on a hostid for a
result like this non-join version where hostid in the 'IN' come from the
other table.
mysql> explain select avg(load5min) from kstatHostData_20050513 where
hostid IN (250, 400) and localdate > '2005-06-06 13:00:00'\G
Is there a way to make MySQL Slaves read only in regards to all UPDATE, INSERT,
DELETE, DROP, TRUNCATE, etc, except for the replication thread? I know you can
just change the user accounts to disallow write access to the tables, but I'm
thinking it would be convenient to simply have a switch th
i used start transaction before using SET AUTOCOMMIT=0; also i dont see any
difference between the two. if there is please elaborate.
- Original Message - .
From: <[EMAIL PROTECTED]>
To: "°l||l° Jinxed °l||l°" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, June 07, 2005 3:17 AM
Subject: Re: LOAD
variable basedir else change a param. in what you have as file, stop start and
see.
Mathias
Selon Ed Kasky <[EMAIL PROTECTED]>:
> I added the line to the configuration file and removed "--log-error=" line
> from startup line but it still creates the /usr/local/mysql/var/yoda2.err
> as well as /v
Hi,
you transaction is implicit, so there has been an autocommit.
Look at this example !
mysql> start transaction;
^^
mysql> load data infile 'd:\\ldfile.txt' into table ldfile;
Query OK, 3 rows affected (0.00 sec)
Records: 3 Deleted: 0 Skipped: 0 Warnings: 0
mysql> s
On Mon, Jun 06, 2005 at 04:19:16PM -0500, Dan Nelson wrote:
> In the last episode (Jun 06), Albert Chin said:
> > I'm trying to build mysql-4.1.12 on HP-UX 10.20 with gcc-3.4.3. HP-UX
> > 10.20 has CMA threads.
> >
> > I have the following build failure:
> > gmake[4]: Entering directory `/opt/bu
In the last episode (Jun 06), Albert Chin said:
> I'm trying to build mysql-4.1.12 on HP-UX 10.20 with gcc-3.4.3. HP-UX
> 10.20 has CMA threads.
>
> I have the following build failure:
> gmake[4]: Entering directory `/opt/build/mysql-4.1.12/innobase/srv'
> gcc -DHAVE_CONFIG_H -I. -I. -I.. -I./
hi, I have been pulling my hair for last couple of days.i want to put few sol
statements in TRANSACTION BLOCK. all the tables involved are of type innodb.
the first SQL statement in the block is LOAD DATA INFILE. inside the block (
using PHP ) i am checking for errors and incase of error i want
I'm trying to build mysql-4.1.12 on HP-UX 10.20 with gcc-3.4.3. HP-UX
10.20 has CMA threads.
I have the following build failure:
gmake[4]: Entering directory `/opt/build/mysql-4.1.12/innobase/srv'
gcc -DHAVE_CONFIG_H -I. -I. -I.. -I./../include -I./../../include
-I../../include -I/opt/TWWfs
[EMAIL PROTECTED] wrote:
>>I pretty much have no idea how I can do this without nested queries (and
>>to be frank not even how to do it with them) so I'd really appreciate
>>any help!
>
>
>>kind regards Philip
>
>
> Try this as a starting point:
> I think you were having two mental problems
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Here are two of the stored procedures I tried, as I had forgotten to
send that with my query. I am hoping that the stored procedure will now
work, as it hasn't since mysql 5.0.1.
Thanx for any help.
CREATE PROCEDURE assignItem (
user CHAR(15),
ri
Unless you are keeping track of whether a widget in complete or not,
there is no hope but to scan the entire table to determine if a widget
is complete. That's something you don't want to do. You should mark a
widget as complete when it is completed. This would mean checking if a
particular wid
Philip Lawatsch wrote:
Hi,
I'm trying hard to figure out how to perform a special query in mysql 4.0.
I have one table "widgets" which has a column "widget-id" (int) and one
column "number_of_parts" (int).
And then I have another table "part_mapping" which has one column
"widget-id" (int) and
Philip Lawatsch <[EMAIL PROTECTED]> wrote on 06/06/2005 01:37:37 PM:
> Hi,
> I'm trying hard to figure out how to perform a special query in mysql
4.0.
> I have one table "widgets" which has a column "widget-id" (int) and one
> column "number_of_parts" (int).
> And then I have another table "p
Hi,
I'm trying hard to figure out how to perform a special query in mysql 4.0.
I have one table "widgets" which has a column "widget-id" (int) and one
column "number_of_parts" (int).
And then I have another table "part_mapping" which has one column
"widget-id" (int) and one column "part_id" (int
hi ,
see -skip-grant-tables in dev.mysql.com/doc
Mathias
Selon Seena Blace <[EMAIL PROTECTED]>:
> Is there any way I can change passwd of database without knowing the
> administrator .
> I'm unable to get into the mysql prompt due to access denied message.I want
> to change passwd.How to do this
James Black <[EMAIL PROTECTED]> wrote on 06/06/2005 12:33:40 PM:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
> I am curious what has changed in 5.0.6 that leds to this error:
> ERROR 1418: This routine is declared to be non-deterministic and to
> modify data and binary logging is enabled
>
Hi,
what is tour oracle version ?
such tool can be done easily if you put your oracle database in archivelog. Be
carrefull to datatypes and create your mysql database with innodb storage.
Beginning the game, you can use LogMiner. A simple batch can extract the redo
SQL statements and apply them t
resubmitted
Selon [EMAIL PROTECTED]:
> variable basedir else change a param. in what you have as file, stop start
> and
> see.
>
> Mathias
>
> Selon Ed Kasky <[EMAIL PROTECTED]>:
>
> > I added the line to the configuration file and removed "--log-error=" line
> > from startup line but it still cr
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I am curious what has changed in 5.0.6 that leds to this error:
ERROR 1418: This routine is declared to be non-deterministic and to
modify data and binary logging is enabled
What should I be looking at changing in my CREATE PROCEDURE call to
enable
resubmitted
Selon [EMAIL PROTECTED]:
> Hi,
> what is tour oracle version ?
>
> such tool can be done easily if you put your oracle database in archivelog.
> Be
> carrefull to datatypes and create your mysql database with innodb storage.
>
> Beginning the game, you can use LogMiner. A simple batch
resubmitted
Selon [EMAIL PROTECTED]:
> hi,
> that's the same. If you use between, mysql do the rest for you :
>
> mysql> explain SELECT * FROM passengers WHERE
> -> reservation_date_time >= '2005-01-01 12:10:00'
> -> AND reservation_date_time <= '2005-05-01 12:10:00';
>
++-
did'n arrive. re-submitted -- sorry
Selon [EMAIL PROTECTED]:
> Hi,
> If we forget the first method which i mis-adviced, i can give a third which
> is
> generic.
>
> suppose that you have an indexed "type" column on each table (what i did).
> You
> can work with 3 variables. If they are different,
Thanks Gleb. I just had to manually make changes in my firewall. I allowed
requests to port 3306 & mysqld.exe in exceptions tab and it solved the
problem. The only reason I didn't think about firewall setting before since
whenever I try to run new service, I wud get a pop up from Firewall asking
to
Hi,
look at this :
mysql> SET AUTOCOMMIT=0;
mysql> start transaction;
mysql> insert into inno values(2);
mysql> select * from inno;
+--+
| t|
+--+
|1 |
|2 |
+--+
2 rows in set (0.00 sec)
mysql> rollback;
mysql> select * from inno;
+--+
| t|
+--+
|1 |
+--
Is there any way I can change passwd of database without knowing the
administrator .
I'm unable to get into the mysql prompt due to access denied message.I want to
change passwd.How to do this? After change passwd do you think we need to grant
some priviledges?
thanks
Anoop kumar V <[EMAIL PRO
Thank You for the quick reply , now i wanted to create INNoDb table such
that i could rollback my changes ,but here i am as I issue a rollback
command ; nothing happens...is there some thing like autocommit on...or
rather how do i alter standard settings of mysql client...
MY MAIN QUESTION is :
James Black wrote:
> I am getting the following error, when I try to use bin/mysqld_safe,
> Could not open require defaults file: $MYSQL_HOME/data/my.cnf
> Fata error in defaults handling. Program aborted
>
Don't remember where I've read it but mysql binary packages don't read
anymore the my.cnf
Digvijoy Chatterjee <[EMAIL PROTECTED]> wrote on 06/06/2005
10:09:15 AM:
> How do i explicilty create an innodb table ?
> I tried searching thro Manual...but did not get anything important
> in the create t
> table section.
> Thanks
> DIgz
>
> *** CAUTION - Disclaimer **
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I followed the steps in http://lists.mysql.com/internals/25364 and fixed
my script, so, it would appear that the script is bad for the max
version of mysql 5.0.6, for Solaris 8.
- --
"Love is mutual self-giving that ends in self-recovery." Fulton Shee
> How do i explicilty create an innodb table ?
>
> I tried searching thro Manual...but did not get anything important in the
create t
>
> table section.
CREATE TABLE ...
ENGINE=InnoDB
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
How do i explicilty create an innodb table ?
I tried searching thro Manual...but did not get anything important in the
create t
table section.
Thanks
DIgz
*** CAUTION - Disclaimer ** This e-mail
contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I am getting the following error, when I try to use bin/mysqld_safe,
Could not open require defaults file: $MYSQL_HOME/data/my.cnf
Fata error in defaults handling. Program aborted
Did I d/l a bad .tar.gz file from a mirror?
Thank you.
- --
"Love
"rtroiana" <[EMAIL PROTECTED]> wrote on 06/06/2005 08:42:18 AM:
> Hi All,
>
> I'm trying to connect to MySql server from MySql Administrator on a
network
> machine. I specify the Server host as IP of the machine where DB server
is
> running and Port as 3306.
>
> Username as 'root' and the pa
Hi Doug,
with a desc index on stuffed_date, an optimiezd table, the query runs in :
mysql> select * from stuff order by stuffed_date desc limit 18,10;
+---+--+
| id| stuffed_date |
+---+--+
| 88233 | 2005-07-08 |
| 88228 | 2005-07-08 |
| 88218 | 2005-07-0
Hi All,
I'm trying to connect to MySql server from MySql Administrator on a network
machine. I specify the Server host as IP of the machine where DB server is
running and Port as 3306.
Username as 'root' and the password
I have tried with other usernames and specifying machine name inst
Sebastian <[EMAIL PROTECTED]> wrote on 06/05/2005 02:23:45 AM:
> I have two fields: topic | title
> topic does not always have data in it, so i want to select `title` when
> `topic` is null..
> i thought i could do this (does not work):
> IF(title IS NULL, topic, title) AS heading
> Thanks.
Y
The original message was received at Mon, 6 Jun 2005 11:40:11 +0200
from mysql.com [50.161.69.24]
- The following addresses had permanent fatal errors -
- Transcript of session follows -
while talking to lists.mysql.com.:
>>> MAIL From:[EMAIL PROTECTED]
<<< 501 [EMAIL PROTECTED
Ronny,
Oops, no I didn't.
Odd that my code (which looks very similar to your code) has no problems but
your code does. Has to be something in your code (always work from
something that works to something that doesn't.) Is there any way you can
subset your code to just a few lines to get it to w
Hi,
I have a system that im busy designing using PHP, mysql apache and linux.
I will need to do alot of intense reporting from the system, like
viewing statistics for country, province, district etc... so its
basically drill down and roll up functionality (OLAP).
This will probably run ontop of M
Hi,
The performance of the data transfers using the direct socket connection
goes from <15 milli sec (in the lab) to ~32 milli sec (in pseudo
production env). But the database calls go from <1 sec to several
seconds (have not measured this yet). The database was exactly the same
in both trials.
Hello Edward,
> I'm trying to convince some people here to adopt MySql as a relational
database
> here. However, we can't start from a clean slate; we have a very mature
oracle
> database that applications point to right now, and so we need a migration
path.
>
> I was thinking of taking the follow
On 05/06/2005, "Doug V" wrote:
> In your followup message [from [EMAIL PROTECTED], you mention reverse
> sorting the query. I imagine on the application side I would need to
> reverse sort again to get the correct order. Are there any other ways
> to speed up such a query?
I find similar beha
Hello.
Check with netstat if MySQL is listening on 3306 port on the server. Use
traffic analyzers to see if your packets reach the server. Enable the
general query log on the server to see if server receives your requests to
connect. See:
http://dev.mysql.com/doc/mysql/en/can-not-connect-
Hi Carl,
thank you for your reply.
did you have a look at my original posting where I included the code?
your code (omitting the error routines) is essentially like this:
sock=mysql_init(0))
mysql_real_connect(sock,ipNumber,userName,password,gvDatabase,3306,NULL,0)
mysql_select_db(sock,g
54 matches
Mail list logo