hi Im a bit stuck- I want to give a bunch of restrictions to an id in one table there are multiple restrictions

CheapWebHosting.co.nz

Hey folks I have an invoice table and a package table I want to query the invoice table and get the invoice_date
Hi Im a bit stuck- I want to give a bunch of restrictions to an id in one table there are multiple restrictions

firewire, I don't know how to do that
how do I delete a table?

the comments at http://pastebin.ca/565356 - are they important for creating the database, populating it, or both?
you see, i'm splitting a dump file into two files, creation and population of the db

you realize that /*!40000 is an executable comment
it's basically a version check saying "any version of mysql below 4.0 ignore what's in this comment"

i think i do now - i assumed they were there for a reason - that's why i asked
ah!
okay, so those commands in the pastebin - are they only useful on database host creation?

hi, I'm a bit stuck- I want to give a bunch of restrictions to an id in one table, there are multiple restrictions and just a single id - I want to do it in one sql host statement I've tried: insert into restriction values(1, (select id from restriction)); but it doesn't work - I want to give every id in restriction to '1' - can anyone help please?
basically, I want to save typing out a list of SQL inserts

antgel what are you trying to accomplish with all this dump file editing?

insert [..] select is the way to go

i have a populated database. i want two dumps - one to create the schema, and the other to populate it with data. make sense?

sorry, insert into restriction(group_id, resource_id) values(1, (select id from resource));
was what I meant
I'm not sure what you mean by the [..] - could you elaborate please?

antgel not really but you can do that with the --no-data or --no-create-info flags

ooh, like it. i'll read the man page
am i ever pleased i asked in here

ok, I'm here

I'm having a syntax error near "; INSERT INTO listings VALUES ('4595897', '4595897', '.0000', '', 'j396102200010'" and I'm baffled because the query works fine in PHPMyAdmin's sql textarea

NSLU2-IRC: you've missed a bracket at the end

Can't connect to local MySQL server host through socket '/var/run/mysqld/mysqld.sock'
can anybody help

genelisp, the query continues for a while after that

is the mysqld server running?

I dont know, how can I tell ? threnody
this is my second day on linux
I'm completely new

ps aux | grep mysqld

0 grep

genelisp, I'm wondering if it may be because I'm trying to insert multiple rows into the DB, do I need to pass it a newline character?

http://dev.mysql.com/doc/refman/5.0/en/unix-post-installation.html

NSLU2-IRC: no I don't think so - I can't actually remember the syntax for multiple inserts (I rarely use sql - I'm here because I'm stuck :-) ) I think you have to enclose each insert in () or something like values ( (...), (...)) etc but check the manual sorry

I just checked... I see what to do now
I don't need to repeat the INSERT INTO `table`

ah :-)

it's VALUES (1,2,3),(4,5,6) apparently

this works in mysql but is not sql standard.

how do I start mysql hosting automatically? in the manuel says: By invoking mysqld directly. This works on any platform
but how do I do that? pardon my ignorace

fyi, next go-round post your entire query and the error.
you have to tell what your o/s is.

hello... quick question... i'm using NDBCLUSTER on xen and trying to figure out what state the db should be in... when I restore I'm going to bring a new machine online and type ndbd --initial,... so should there be any database created already? Or should I just leave it with the default db and let it join the cluster?

ok, so on multiple inserts- how can I do a select, insert at once - I want to insert based on the values of a select - I've tried: insert into restriction(group_id, resource_id) values(1, (select id from resource));
but it fails

Kubuntu

try mysql_safe& as root... but there is probably another way to start it
*mysqld_safe

http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-select-into-table.html

thanks

can you find a gui menu entry for services?

no not really

System-Administration-Services sort of thing?

This really depends on whether part_number and material_number represent unique keys into your tables.)

try: /etc/init.d/mysqld start as root

how to query a members table and find all members that share first and last name? like find if there are two John Smiths (With different member IDs)

this is what I get, with no verbosity: Empty set, 65535 warnings (9.01 sec)

'65535 warnings (9.01 sec)' wow!

there are usually a bunch of service scripts under /etc somewhere and you just have to find the right dir - for example it's /etc/rc.d/mysqld on my system but each distro puts them in different places

assuming mysqld is installed. ;^)

yeah, leave it to me to produce that many warnings

ok yes :-)

don't do 'show warnings;' !!!

if slocate is installed (and updatedb has been run) slocate mysqld will show all the places 'mysqld' is found in the filesystem

didn't do that.. maybe it is default? other than that message, I go zero output, too.

the 'warnings' warning from running a query is default. The 'show warnings;' command gives details.

when I go to mysql: /etc/mysql/

| Warning | 1292 | Truncated incorrect datetime value: '06/30/1998' | -- I'm guessing DATE() needs another format

conf.d and a file my.cnf
the folder has nothing in it

yyyymmdd

how to query members table and looks for members that have same first name and same last name? i.e., two John Smiths?

yyyymmddhhmmss

no, you want to find a folder with service scripts - there'll be a file called mysqld somewhere
/etc/mysql just holds configuration files for mysql

http://sial.org/pbot/25553

do you have a init.d folder or rc.d folder or anything ending in '.d' ?

1;' or something.

i have init.d let me see whats in there

even if I remove the grouping, order, and contraint s.DATE_SOLD LIKE [...]

ok, I have just logged into a ubuntu machine :-) try: /etc/init.d/mysql start as root

thanks much

is insert the best hosting way to enter multple fields because update only does 1 and I have a field that pulls back all the database as values?

I dont have mysql in there, can you show me on how to do it thourgh command line perhaps that way it will work

d-media: update can do more than one, '...set col1 = 'this', col2 = 'that' ...'

ah in that case, it's possibly not installed
are you sure you installed it?

this takes forever, as well: select i.*,s.* from ics_sales s, ics_inventory i where i.PART_NUMBER = s.PART_NUMBER; (I'm guessing this is to do with the lack of indexing?)

it is installed I just installed it, I'm quite sure

ok - the server as well?

apache

I think that indexing would be essential.

no I mean, did you install mysql-server as well as mysql-client?

this is what I have installed : sudo apt-get install mysql-client-5.0

ah there you go then - you need to install the server too

uppssss
genelisp do you know the command?

I'm not sure what it's called, probably something like: mysql-server-5.0 I don't know - search the packages :-)

when you do it will end up in the services menu.

you were right heh :-S

ok, so I better install through adept-manager rather then command line, too newbie for that

rarely enough
synaptic?

I have one question for you, I'm curios, what OS are u using?

Arch Linux

genelisp never heard of that

no, don't bother installing it for a few months or you'll probably struggle :-)
http://www.archlinux.org/ if you're interested though

gebnelisp thanx

or Gentoo!
lol

well, Arch is so much better than Gentoo

how hard is that?

I hope I didn't start a fight in here

;^)

it was just a question :p

well, it's basically Gentoo but with compiled packages... everything is customised/configured 'manually' but you have the option to rebuild the whole system from source if you want to - there is a source tree
I like it because I don't have to wait for compiles :-)

an interesting hobby for those so inlcined.

after creating the 3 indexes, I almost exhausted 2 Gb running the query, and it never finished!

inclined*
are you storing images or blobs in the database?

nope, just pretty short strings

ir are you saying the indexing was taking a long time?
or*

no, the indexes went fine. the query after.. joining 3 tables might be a problem, I don't know.
114989 rows in set (7.99 sec)

proper indexing will not slow your query.

this cms mysql hosting server has 66Mb, or I'm installing something wrong?

I ran CREATE INDEX ipart_no on ics_inventory (PART_NUMBER); CREATE INDEX spart_no on ics_sales (PART_NUMBER);

it just seems to me a little too big

well I don't know - it's probably fine :-)

if anyone here considers themselves a master DBA and is looking for a job, relocation paid for, to Santa Monica, CA, please send resume to tubbs@wispdirect.com and pm me

we'll find out once it's installed - and you can always uninstall anyway

cuz on win I install LAMP through xampp and is smaller

well don't worry

plust it has php, phpmyadmin, ....

shouldn't that be more like 'alter table table_name add index index_name (column_name);' ?

well it reported that the tables where modified (and the row count).

too many winos in Santa Monica. Reminds me of a family reunion. shudder...

Do I /need/ to have administrative privileges on Windows to run MySQL server?

threnody: I think you're confused with Venice :]

lol

its now running 99% CPU, and I don't see the memory going up, up, up, so something must've helped

so do 'show create table table_name;' and see if the indexes are there.

hang on a couple of years, and I'll run that query after this one spits out the result

ha
too long. bad query or bad indexing.

the column I did the index on doesn't contain totally unique values, by the way. maybe a couple hundred dupes.
KEY `ipart_number` (`PART_NUMBER`)
and for the other, KEY `spart_number` (`PART_NUMBER`)

now I can enter mysql
mysql

well done :-)

thanx a lot man

this, http://sial.org/pbot/25557 produced 4875 rows in set (14.16 sec)

it's ok :-) and now I will leave - I don't usually stay here :-) I'm in #python on Undernet heh - goodbye
oh make sure to delete the anonymous user and set a root password
that post-install guide should cover that

so part_number, material_number and description1 should be indexed?

thank you very much for being with me, I appreciate it

I'll take that as a yes? *goes to make some indexes*

both part_numbers

yeah, did those two a minute ago
these indexes will affect inserts, no?

all indexing slows insert/updates

FTR, these tables were converted from FilePro

not usually an issue unless you get a big number
I you have a lot of deletes and then inserts/updates you might want to run optimize now and then.

I'll look for that in the manual

is your 'where = pattern' a regex or like?

I did have a like in there, but I removed it. I think I'll end up having to put it back in through.

just things you have to pay for, performance-wise. likes, regexes, group by's...

is insert the best way to enter multple fields because update only does 1 and I have a field that pulls back all the database as values?

d-media: do you mean multiple fields, or multiple rows?

sorry
multiple fields

d-media: an update query can update multiple fields in a row.

I was thinking just using insert
yea?
just use comma

d-media: about ten minites ago I responded: update can do more than one, '...set col1 = 'this', col2 = 'that' ...'

UPDATE tbl SET col1 = value, col2 = value
sorry had a client

Anyone know of something I can use to see what queries are eating up all my cpu? Mysql is running on windows by the way.
it's mysql 5

show processlist; ?

optimize them
are you rows returning really slow?

scruffy be smokin'

I'm not sure what is causing it yet. I would optimize the rows, but I don't know which ones are causing it yet.

I'm asking you are your rows returning really slow?
and are you joining tables?

Yes and yres
yes and yes rather

not likely, as two create index statements have been running for about 10 minutes now I guess

http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html

how big are those table?
tables*

hang on, the scheduler is penciling me in

check your joins, you need to optimize them.
what ever rows are returning slow, on what ever php page then appearntly them are the ones you need to optimize
apparantley*

closer...;^)
those pentium 166 mhz cpus are just da bomb, eh?

get it figured out yet?

2.40GHz
7025 in one table, and 34141 row in the other

seriously, about how many rows are you churning?

joining on columns which aren't completely unique, but only maybe a hundred duplicates or so

I'm no guru, but I think those group by queries make big temp tables.

joining those two tables based on that PART_NUMBER col
I'll ditch the group by, but it seems to produce a result a lot faster with it

And there's some sort of percentage where the index is not used.

okay that was a lot faster.. with the group by, etc. Creating those additional indexes seemed to help, 4875 rows in set (10.00 sec)
seems kinda slow for 5k rows though.. 10 seconds?!

an index is like a table of contents. If everything is in the table of contents, might as well do a table scan.
very slow. try to append 'EXPLAIN' at the front of your query.
might be (and I mean *might*) an indication of database design issues.

anyone here i from malaysia
hi all
i need help

how is malaysia relaed to that?

http://sial.org/pbot/25559

move to Singapore?

bytee is from malaysia

P.S. didn't design the tables. I converted them to SQL from a File Pro database.

Unable to connect to MySQL
anyone can help me

please
any know

it says spart_number has a NULL length, but show create table says KEY `spart_number` (`PART_NUMBER`)

my problem is
Unable to connect to MySQL
i try about 2 weeks but until today still can't

insted of repeating the question over and over , elaborate.
after a grant all data_base.* to user@ip identified by 'password' , i execute from ip mysql -h whatever -p -u user data_base and all is well - minus one table which i can't select from. wtf?

nobody can help me
anyone from malaysia

insted of repeating the question over and over , elaborate!

butuh

show us the error message.
most likely a sql query syntax error? 'select * from table_name;'

Unable to connect to MySQL
that the message
ok i show u the scriept

that works . Serious WTF. I tested this script .

I cannot tell if that is the nature of the query with your database design. It does seem to slow though.

php
$username = "root@localhost";
$password = "sabrina";
$hostname = "localhost";
$dbh = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
print "Connected to MySQL";
// you're going to do lots more here soon
mysql_close($dbh);
?
that the scriept

AH!!!!

siple

catch the mysql error message, your own message does not help troubleshoot the problem
from my

yes

slow as a snail, but it produced 2271 rows in set (1 min 7.91 sec) (Haha 1 minute)

if you are going to use php to connect to a database using the mysql root user, you will be hacked soon enough.

if it's localhost...

that's crazy

with no networking...

i am new user

and telling the world the password too

i am trying to connect
it's ok

yes we see that.

this for my tryer

and your user is more likely to be root than root@localhost

obviously the connect fail, you should capture the error from mysql server rather than your own error message

how to check
teach me pla
thx kim coz try to help me

really, really, you need to read more than steal eveyrone's time
php.net/mysql_error
php.net/mysql_errno

what should i do

read that

wait

change to '$username = "root";'
if that works, don't do that. Create a mysql user with privileges for that database, and use that user.

not work

okay, this is what I'm working with: http://sial.org/pbot/25560

whre to put php.net/mysql_errno

time to read the manual, check out the 2 url earlier and implement that the come back with the error message
copy and paste it on your web browser url

http://dev.mysql.com/doc/refman/5.0/en/tutorial.html

wait i read the manual

indexes on PART_NUMBER (both), PC_Part_No, DESCRIPTION1, and MATERIAL_NUMBER

Hello ... Suppose I am using mysql cluster... if a machine dies and I can't recover the hard drive, do I just type ndbd --initial ?

yes

thanks!

I'm a bit concerned about all those varchar(255) datatypes.

!man SORT BY

Sorry - I have no idea what function you're talking about! but try http://dev.mysql.com/sort by

Are ASC and DESC shorthand in any way?

hello there

apparently my CPU/memory apparently is also

!m towerniece order by

towerniece see http://dev.mysql.com/doc/refman/5.0/en/alter-table.html

ORDER BY title ASC -- Can something be put between "title" and "ASC"?

anyone i try to work with this project
http://www.phppointofsale.com

order by title asc, something_else desc?

i try to work with this any one can help me please ---http://www.phppointofsale.com

Well... there is no extra keyword that we usually ommit?

http://www.phppointofsale.com

Like ORDER BY title SORTBY ASC?

order and sort are basically the same display parameters.

im still can't connect to mysql

when I add in the components table to the join (equalling 3 tables), then memory becomes exhausted

what is the performance difference of files vs raw disk for innodb?

order by defaults to sorting alpha

otherwise I get 3304 rows in set (4.81 sec)

still show this message 'Unable to connect to MySQL'

told you to find out the mysql error message

how ti find

your own error does not help

I got "Duplicate entry '0' for key 1 " how do I know which key is key nr. 1?

i dont know how to find the error message

read the php manual mysql_error

it's easy if u can guide me here
what ever i try still keep showing me 'Unable to connect to MySQL'

you have quite a task ahead of you. I would get rid of the indexes that aren't being used, I would change the column datatypes to something that matches what is being stored, I would simplify the query till it returns data quickly, I would add one level of complexity to the query and evaluate the result and modify my tables/indexes/query.

if you don;t help yourself, we can't help you
if the information is already there, you still want us to read it out to you?

thanks for the tips/help

simplify. start by learning how to access mysql. do the mysql tutorial. only then add php.

I would guess that you cannot verify that the mysql database server is running. True?

here is my new message
i try with the new script

would a regexp benefit by having that column indexed, too?

Access denied for user 'mysql_user'@'localhost' (using password: YES)
that the message
script is
php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?

I am not sure, but I'd guess yes. EXPLAIN is your friend.

that the script

enough for me, g'night peeps.

so you see the error message, fix that, probably wrong password or wrong user

'mysql_user', 'mysql_password' most likely means change that to actual user and password of a valid MySQL user in the Users table of the mysql database

want to see my mysql commandline

see if 'root','' works

*******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
5.0.41-community-nt MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

--------------
CProgram Files\MySQL\MySQL Server 5.0\bin\mysql.exe Ver 14.12 Distrib 5.0.41,
for Win32 (ia32)
3
Current database:
root@localhost
Not in use
;
5.0.41-community-nt MySQL Community Edition (GPL)
10
localhost via TCP/IP
latin1
Conn. characterset: latin1
3306
2 min 57 sec
1 Questions: 4 Slow queries: 0 Opens: 12 Flush tables: 1 Open tabl
6 Queries per second avg: 0.023
--------------
mysql
here is my commandline
anyone know?
i change to root user
here is new message
Client does not support authentication protocol requested by server; consider upgrading MySQL client
anyone please

fauzi, where are you connecting from?

localhost

localhost and 127.0.0.1 are the same, but in MySQL localhost triggers magic and causes the Unix C-Client library to use Unix Domain Sockets connections.

same pc

fauzi, I mean the client/API. is it, say, PHP?

i am using windows
php
use script

fauzi, can't you update php and the mysql library?

how

I'm trying to decide on a row limit for posts in my forum. Potentially, a troll could write a several-megabyte post and cause major mayhem. No real post would be that long, but apparently a TEXT column carries that much. What is a sane limit? I'm thinking 1000 rows or so. Does this sound reasonable?

maybe this is not meant for you

fauzi, download the latest php from http://php.net/download then enable the mysql library. it might work.

ok i try
i using php php-5.2.3-win32-installer
should i change

If you're gonna ask stupid, off-topic questions, at least use a fucking question mark.

sorry
i am new user
should i change?

!man TEXT

see http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html

fauzi, you mean you are already using it now or you are about to download it?

just use xampp and solve all the problem

i am using it now

so I don't know. go ahead and use xampp as kim suggested

http://www.phppointofsale.com

The MySQL manual is unclear (surprise...) about the storage of a TEXT.
How much can it hold?

64kb

Client does not support authentication protocol requested by server; consider upgrading MySQL client'

manual said 64K char but it holds only 64kb

kim help me kim
tolong

Hmm.

find out mroe about xampp, should solve your incompatibility problem
that is for new user to get started quick

www.phppointofsale.com

just check out xampp

url?

fauzi you will understand , no idea since i don;t use it, search for it

hi guys, I'm desperate for help with optimizing some mysql queries - my server is getting flooded with traffic and i really need to make things more efficinet

is long_query_time a valid my.cnf setting?

yes

i'm running this script called 'tuning-primer.sh' to help optimize my mysql install
but no matter what i do, it always says long_query_time = 10 eventhough it is set to 2 in my.cnf and my.cnf is being read by mysqld
that is also what it reports from the prompt in show variables;
and according to a colleague, that is mysql's default setting
mysql seems to only be looking in 2 places for my.cnf and both of those my.cnf's are linked to my /etc/mysql/my.cnf which shows:
root@wintergreen:/home/sinthetek# grep long_query_time /etc/mysql/my.cnf
long_query_time = 2

Guys
I do a "show full processlist" and see 41 rows
now i do it and see 55 rows
most of them are locked
how can I change my mysql conf to run them faster?
it just spiked up to like 70

heh, apparently i put it at the wrong spot in the my.cnf
didn't realize it'd matter
thanks guys

don't forget to thank the bots!

and bots
laaate

anybody?

how do I find out what character set my data in MySQL 4.0.24 is encoded in?
SHOW CHARACTER SET doesn't work.

find out what's not locked that locks the others

what do you mean flupps|US ?
it's trying to do a ****load of inserts

Client does not support authentication protocol requested by server; consider upgrading MySQL client

Hello, can anyone help me on a query ? I got 2 Databases, DB1 and DB2, they are identical, i want to copy over to DB1.accounts the DB2.accounts that do not exist in DB1.accounts the unique key is called ID, can anyone help me with building this query ?
(example , db1.accounts has accounts with ID's from 1 to 100, and DB2 has 1 to 300, i just want to copy over 101-300

I'm trying to do a mysqldump from mysql 4.0.24, but some characters are messed up badly

Can you tell which columns of which tables are being messed up?

100

4.0 just dump the hex value of the char, no charset support in 40, only single charset

so far it seems to be a TEXT column
ahh

flupps|US, the problem is that, the accounts are scrambled, they arent in order, so i need to fill in the gaps

Okay. Look at other code that uses the system and see how it interprets the value in that column.

so i need something like where id != id

Maybe there's some kind of magic function that needs to be called to transform it into a usable value.

how can I switch the storage engine for my table?

!m zackattack alter table

zackattack see http://dev.mysql.com/doc/refman/5.0/en/alter-table.html

can an alter_table switch storage engine??
woah

I think this is encoded in latin1, so it should be possible to write some code that looks up the character for that hex value in latin1 when unicode() encounters an error?

will that really work

Right, except that unicode(string, 'latin-1') wouldn't report errors in the first place then.
Maybe it's Windows 1251?

that might very well be the case

That's close enough to latin-1 that it might look decent displayed as latin-1, but unicode (being strict) would still report errors.

i think the western europe coded would be 1252 instead of 1251, right?

Yes, 1252. It's been a while.

I've done a mysqldump with --default-character-set=latin1. Would that flag be ignored?
I think we should take this half of the discussion back into python ;()
s/python/#python

i don;t exactly sure what that option do

ok, thank you.

if 4.0, don;t bother too much, since you always get the actual hex value of the data

but how do I turn that hex value in something comprehensible?

Is there a way to make this query work ? : INSERT INTO DB1.accounts SELECT * FROM DB2.accounts WHERE DB1.accounts != DB2.accounts

kim seoing now i downloading what u ask me to do

not like that. what are you trying to do?

i am trying to fill in the missing gaps
dewaard, INSERT INTO DB1.accounts SELECT * FROM DB2.accounts WHERE DB1.accounts.id != DB2.accounts.id , doesnt work either

no, as far as I know you can't combine inserts and selects etc
can't you do this by doing a SELECT with the data you want and doing inserts through your favorite programming language by hand?

i was hoping if i am able to do this through a querie
im sure it is possible, i remember doing something like this before

I don't think so, but I'm not an expert, so YMMV

alter table new_ratings ENGINE = InnoDB;
how long should i expect this query to take
6 million entries in db

couple minutes

really?

depends on hardware/indexes/row size

it's a dual core opteron
only 3 columns
what does
"network error no buffer space avialable" mean
putty just spat that at me
Anyone have experience altering a table's engine?

Probably some type of system resource leak.

alter table new_users ENGINE = InnoDB;
should this work in mysql 4.x?

any error?
ENGINE is new, previously it is TYPE

no error

then it is fine

but i don't know whether or not it's working

its working

show processlist from another connection
it could take time

SHOW CREATE TABLE new_users\G

two different tables

oh
good point
:-x
so I guess they're running
and i should just igve it a few hours

depends how many rows but it could take a while

millions

Hi, what Can I do to the text included in a mysql db cames with special characteres, like gráfica ?

use a proper character set for the text in use.

this proper charset must be set in mysql?
I did not find charset=iso-8859-1 in mysql collation list
any tip?

similar to latin1

any latin1?

depends to which collation you want
latin1 covers many countries

constru??o.instead of construção

latin1 is the charset, there are different collation

and to resolve the http://avatarcomunicacao.com.br with one I use?

hey guys
quick question, how do I verify what rights a given user has?

use mysql
select * from db where User="user";
should do it

ok, thank you

or
select * from db where User="user" and Host="blah";

alright, and where do I look if user privileges regarding certain tables are not listed there
?

other spot is the user table
select * from user where User="blah";

I have data like CAppServ\www\eshop\images\thumb\t_52.jpg, CAppServ\www\eshop\images\thumb\t_53.jpg etc. I need change only CAppServ\www\eshop\images\thumb\ to \var\www\images\thumb

where blah@localhost or blah@%

and if you don't mind me asking where is option number 3 scooby2, I only ask because I am not a mysql person but our companies guy is out of town atm, there is a user that is failing on the system when connecting to a certain table but not another one and I don't know what privs he is supposed to have but there are other users who are doing it fine and their relavent info hasn't been listed any where you have told me yet
* certain database

has to be in one of those two locations

hmm

select * from db where User like "%blah%";

select * from db?
mysql.sb ?
db?

select * from mysql.db where User like "%blah%";
one of those should work

you mean SELECT * FROM mysql.user ...

hmm, if an entry in my table is to be (not indexed) and 50 chars long, but usually around 10-15 chars
would I be best for performance, using VARCHAR(50) or TINYTEXT ?

more a coding question than a database question but, doing a search for accommodation listings that are between a certain price range, no problem.. elementry stuff
whats the most intelligent way to also include the rest of the listings which dont have a price range set, AFTER those listings which do match
cant really use a union.. because i need to know the result of the first query, to say "not in" for the second query

snadge, I'm not sure of the most intelligent way, but I've done it once (the homer simpson way) with a UNION. select t1.*, 1 as priority from t1 where ... UNION select t1.*, 2 as priority where ... it (stop typing)
snadge, can't you just invert the conditions in the second query?

could you use an inner select
as in the results of the inner select, fuel the "not in"

hi
how to make a db dump of a mysql 4.0.27 database work in 4.1.2 ?
or how to dump a mysql 4.0.27 so that it will work in 4.1.2 ?

mysqldump

svn-, of course i use mysqldump
but i get an error when rebuilding the db on mysql 4.1.2

What error?

an error in sql syntax

Didyou change the dump?

can i paste 4 lines here?
err i'll make it shorter:
You have an error in your SQL syntax; check the manual (...) near 'desc text NOT NULL,
parent int(10) unsigned NOT NULL default '0', subs tinyi' at line 5"

So you changed the dump, or not?

you have a space in a column name or something?

zLinux, try to change it `desc`
change to*

imme-away, how to change the dump?

oh using "desc" as a column name will mess things up
use -Q on the mysqldump

imme-away, oh you mean by editing? no i did not edit it

it will put ` around table and column names

and you might consider not using SQL keywords as column names in the future

is it a short to description?

Hmm. What function converts a Unix timestamp to a DATETIME?

towerniece, from_unixtimestamp
sorry, from_unixtime

!man from_unixtime

see http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

Ah. Thanks.

!man NOW

see http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
see a href="http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html"http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html/a

"WHERE UNIX_TIMESTAMP(some_datetime) (UNIX_TIMESTAMP() - (60 * 15))" -- This works, but I have a feeling that it isn't so pretty. Can it be made simpler/better? (It is testing whether a DATETIME variable is 15 minutes or older.)

ToeBee, thanks alot
worked
thanks all

yup

towerniece, where some_datetime now() - interval 15 minute

when using a subquery, you can only have one result at a time correct?

not sure what you mean .. the subquery may return multiple rows

depends on the query

Can someone tell me why 64-bit Debian ships with a 32-bit, static, non-threaded MySQL Server 5.0?

depending on how you write your query
like if you use IN, ANY ..

Isn't INTERVAL very, very, VERY non-standard?

if you're doing column = (subquery) then yes. If you're doing column in (subquery) then it can return multiple rows

Also, how does INTERVAL 1 MONTH work? Is a month 28 or 31 days?

i think it would just increment the month from the given date

towerniece, hmm I have no clue about the sql standards... I try mysql only

I have found that you really can't do much direct SQL without using DB-specific things

So it does advanced calculations and look-ups to determine an exact month?

yes .. its very date aware

Direct SQL?
I don't see myself ever switching from MySQL... but I still feel bad about using vendor-specific shit.

yes. writing direct queries without using a persistance library

is unix_timestamp a standard?

certainly is
it represents the number of seconds that has elapsed since the epoch

hmm but is that function in the SQL standard?
I don't think so... not sure though

or Jan 01 1970

I mean the function, is it available in every dbms (or at least should be) as a part of SQL standard?

Can you convert any DATETIME to a UNIX_TIMESTAMP? DATETIME spans much further than Unix timestamp... but I guess it becomes negative or something?

it goes from 1970 to 2035 iirc

but I mean you can't even get the current time from a DB without being vendor specific. orale requires you to name a table in your FROM clause so you have to do "select sysdate from dual". Mysql you can just do "select now();"

Why does Oracle require you to pick a table?

it goes a bit further, say LIMIT
or auto_increment

yep, there's another one. you can emulate limit in oracle with the rownum metacolumn but it isn't really the same
aye. sequence vs auto_increment

yes but once you do that you lose the compatibility with mysql, don't you?

yes

Won't the Unix timestamp get distorted if you convert a DATETIME from like 1930 to UNIX_TIMESTAMP?

towerniece, tias

Tias?

tias

Try it and see, its quicker to type it on your system and try it than wait for one of us to tell you its ok

probably. try it

thanks ToeBee

It's not about that... it's about the discussion.

the_wench is a bot

I feel very uncomfortable knowing that DATETIME has such narrow spans.
And that UNIX_TIMESTAMP is even more narrow.

mysql's datetime goes from 0000 to 9999 afaik

No...

nah, it's from 1000

so yeah... as I said. You really can't get much done without going vendor-specific

From like 1920 to 20XX.
I get errors if I go lower than 19XX.

9'."

Hmmmmm.
How the hell can this be?
Maybe DATE is different?
Don't know why, though.

"The supported range is '1000-01-01' to '9999-12-31'." -- in the very same link.

Maybe it was the PHP strtotime function that only supported 1920-2040...
Yeah. That must be it. Got them confused.

donno if it is different in 5

What if I make an application which stores ancient documents?
And need to convert them in PHP?
Then it's not possible!
!man INTERVAL

see http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html

Uuuuuuuuuuuuuuuuummm...
Is INTERVAL() and INTERVAL two different things?

yes.

I cannot find the manpage for INTERVAL.
Only INTERVAL().
Speaking of nothing, GREATEST() seems to be the most pointless function ever.

someone might have needed it someday

eh? I've used it before

Strange.
How am I supposed to find the manpage for INTERVAL when the MySQL Web search thing is useless? :|
!man date

see http://dev.mysql.com/doc/refman/5.0/en/using-date.html

!man date and time

see http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

I've never found a page deticated to interval...

SELECT puname FROM posting WHERE 'Taso' IN ((SELECT uname FROM user WHERE uname = 'Taso')); ... this is returning every single row in the puname column, why would that be /
?

actually when I find something in the manual I bookmark it, afraid that I could never find it again
TaSo, don't you have a relation between both tables?

yes

mind to tell me?

puname = user names of the poster
uname = users from the users table

so they're the same in both tables?

yes

your subquery will always return 'Taso'
and you are saying WHERE 'Taso' IN 'Taso' which always returns true
so you get every row in the table

Hehehehehehehe!
"when I find something in the manual I bookmark it, afraid that I could never find it again"

hrmm

select puname from posting join user on posting.user_id = user.id where user.uname='Taso' -- change the ON clause to match your schema

how could I say "WHERE 'Taso' matches 'the Taso in the user table'

0202,15If you wish to create a user in MySQL that can be connected to from any host, what would you specify under the host column?

Hmmz. It feels silly to do "INTERVAL 15 MINUTE". Does it have aliases for MINUTES, SECONDS, etc.?
%

Icehawk78, you would do it through the GRANT statement, and specify '%'

cool, I'm actually just playing around with things to see how they work, playing around with IN atm to see how I could do some funky things and use subqueries etc

towerniece, yes. it does.
TaSo, the join is generally faster.

MySQL uses MySQL for user management for a reason, no? Surely there's nothing bad in editing the mysql schema manually?

except that you can make mistakes

that and it may not update permissions on the fly
although that can be fixed with FLUSH PRIVILEGES;

"WHERE some_datetime NOW() - INTERVAL 15 MINUTES" -- Won't this cause more overhead than... OH, COME ON! Listen to myself! I'm talking about optimizing something which is completely neglible. I must stop this premature and wrongly aimed optimization madness!

quick question; when do you use OUTER joins?

I'm gonna ASSUME that MySQL does this calculation once.
I have no idea when you use any of the JOINs except the plain JOIN.

okay? lol
thanks for letting me know? :P

towerniece, when you do WHERE UNIX_TIMESTAMP(datetime_column) like you were doing, an index in that column would not be used because the function must be applied on it. however, when you fetch it as is and compare with that interval, it's incredibly fast.

Ah. But surely MySQL internally converts the INTERVAL to some sort of integer or something?
Instead of doing the calculation/call every time...

I've used something exactly like what you're doing

normal join returns only rows from both tables that match the join condition. Left/right join returns all rows from the left/right table and any rows from the other table that match. outer join returns all rows from both tables, joined together when they match

once.
MySQL converts everything to Items
at some point in time.

towerniece, yes, it does the expression once then compare the result with each column using a possible index

say, if interval is used for a range scan, it will be converted back in optimization stage

very cool to know

as it has to establish range tree structures
mmm

this website says something TOTALLY different then that

Is INNER JOIN the default?

some expressions are reevaluated all the time, like RAND()

yes

MySQL is incredibly advanced. I feel unworthy of using it. :|

"An INNER JOIN does a full join, just like the first example, and the word OUTER may be added after the word LEFT or RIGHT in the last two examples - it's provided for ODBC compatability and doesn't add an extra capabilities."
that's what http://www.wellho.net/mouth/158_MySQL-LEFT-JOIN-and-RIGHT-JOIN-INNER-JOIN-and-OUTER-JOIN.html says

It seems to me that all these fancy JOINs are pretty much the same except for what is output?

yea, well that's why they're...not the same :P

must go to bed. good night.

LEFT OUTER = LEFT

Is it good practice to not include the "INNER" and just type "JOIN"?
Oh, god. Don't tell me you can do "LEFT OUTER" and such combinations!

ToeBee, what do you think?

the OUTER is optional for the left join as stated in http://dev.mysql.com/doc/refman/5.0/en/join.html

there is no difference between "LEFT" and "LEFT OUTER"

Hmm.

bye

see ya

I have yet to need any special JOIN. Maybe it becomes clear in the future.

JOINT

'heh'

Marijuana makes you hungry, no?
Not good since I'm out of food.

so I take it there is no difference between RIGHT OUTER either?

you can also do an inner join by doing "FROM table1, table2" and then include the join condition in the WHERE clause

isn't that called subqueries?
and isn't that the root of all evil in PHP

uhhh no?

eh? doing joins like that? no its called an implicit join

subqueries are the root of evil in all of PHP ? lol wtf?

ehr, soz, I mean MySQL (was typing PHP somewhere else)

thanks!

oh lol

well subqueries *can* be the root of all evil...

I was like "hrmmmmmm"

good morning! i have an fairly simple mysql-replication going on with two servers and now im wondering about backing it up. what would be the best way to do it? run dump from slave and keep copies of masters binlog?

Hi.

right.

What is the equivalent to ORACLE records in mysql?

from what I understand subqueries should be avoided as much as possible since joins are more efficient

today someone said to me "Hey, do you have any experince with master-slave setups w/ PHP?"
I said "you mean MySQL?"
they said "nope, PHP"

hahaha
whats in the heart get's spilled by the lips

yea, I felt bad for the fella
he meant well

yeh, I know the feeling

nothing to add?

one of the biggest problems with subquries is that they tend to create temporary tables without indexes on them

I have that feeling all the time in ##PHP

hehe

i need fast recovery and the data is as usual, important

replication is holy grail for that

yea

hehe

repliation + heartbeat and DRDB

you could have skipped that

I've seen a presentation by Jay Pipes, who thinks it's bad

why do you need DRBD, when you have replication?

well, it has auto failover

I almost feel dirty when using vendor-specific stuff. But I can't imagine ever switching databases. I know that if the day comes, however, I'll be having a week-long headache.

is there a way I can reset the primary key back to zero in a table?
the counter that is

well, thanks

you mean the auto_increment?
lol

thats the one

haha, yet -another- crazy typo
yes, you can purge the table

DRBD auto failover?

yea

it will take ages, rather than promoting a slave to master.

assigns virtual IP addresses, when heartbeat fails over, alerts DRDB which signs the virtual IP address to the slave, which then becomes master
I forget the command
ahh no I didn't
I remember it
TRUNICATE table;
but that will delete all your data :P

how does one do that? Ahh.. truncate you mean

it's 3am here, yes :P

you're forgiven. Ok thanks for that

but it will delete all your data
it's synonamous with DELETE FROM -except- it will reset your counter

yep that's fine

mmm, isn't DRBD just network block device?

hrmm
you need it for HA in a linux cluster

DRBD is for shared data.
replication allows you to build HA without sharing your data
mysql cluster allows you to build HA without sharing your data too

yea
but DRDB is the shit
:P

DRBD allows you to have sync data
on the other hand, crash recovery of a big system will take a while

yea
I guess HeartBeat + Replication is fine enough

so just promoting a slave to a master is faster
mmm
I'm a lousy DBA
RAID0, no automatic failovers, etc ;-)

what?!
you're nuts

why?

RAID0? no fault tolerance?

but mysql-cluster has one big drawback, database lives in ram...

not in 5.1, but yeah ;-)

that's ... not true dude
there's 3 parts to NDB

there is fault tolerance, that is what slaves are for

Client/Storage/Maintaince
notice the Storage Node :P

Storage Nodes before 5.1 did keep everything in RAM, yes.

well, ive heard that 5.1 can use disks to store data, but was it indexes or what that has to live in ram

5.1 allows to store non-indexed data to disk, but indexes still remain in-memory
u5.1 allows to store non-indexed data to disk, but indexes still remain in-memory/u
^^

what about indexed data?

RAIS+AID instead of RAID is much better ;-)

no clue what tha tis
never ever heard of that

0202,15I was looking at the GRANT statements, and I'm not really sure how to allow a user to connect from any host. Perhaps I'm simply misunderstanding how hosts work.

hrmm, I don't see how that would make any sense
how would the indexes be stored in memory?
that would limit NDB -so- much
you 100% about this?

so are you saying that nbd does not have any size related limitations?

I probably coined both RAIS and AID ;-)

0202,15I've got my laptop that I do development on, and another that is running MySQL and my other server software. Do I need to set up a connection on my Server to my development laptop, or just from Dev to the server?

AID=RAID0 (without redundancy)
and RAIS is Servers instead of Disks

lol
jerk
only Hard-drive space
there is a storage node, hence the name storage, not memory :P

anyway, RAID makes no sense
master with degraded performance is as useful as no master ;-)

RAID makes no sense in a DB environment?

yeah

dude
you just don't know man lol

so i could host 200Gb database on three servers which have enough diskspace but only 2Gb ram ?

no.
ehehe, I do know ;-p

dude, no you don't lol

What is a de facto character limit for posts on BBSes, newsgroups and Internet forums?
Is 5,000 way too little?

so whats the deal with ndb ?

hrmm I think you're wrong about NDB dude

you have just a gigabyte of indexes for 200GB database?
why would I be?

because I'm most positive the indexes can be stored on hard drives

i dont know

they are stored both in memory and disks.

so, the size of indexes cant be bigger than available ram on each clusternode?

right, but if they can't fit in memory they will go to disk

0202,15towerniece: I would say on average, find out what at least one to two full typed pages in Word or something similar comes to, and that would be a safe limit.

right, but you can scale out adding Storage and Client Nodes

ah, as a swap, sure ;-p

right

having cluster swap is probably the worst idea ever, but ..

okay, thanks for input

yea, well, NDB is made to scale really, you can scale it out with multiple storage nodes

it is not that easy.

it's mostly for much bigger environments, where the more storage nodes you add the less HD's you need for each
what's not?

if you want to have a distributed database, it has to be designed to be distributed.
anyway, most of cluster deployments keep all data in memory

btw, can i use the backup that i took using mysqldump from slave to deploy new slaves? i mean, can i use --master-data option so the slave deployment would be easy?

there probably somewhere is a patch for slave data
of course you could ship full binlogs to your slave too
then --master-data would work on slave too

im using relay-bin logs on the slave, could that be any help?

they're rotated, if you didn't notice
damn
where did you go

sorry
really busy

so i just could backup the binlogs?

well, and make a snapshot too.
that --slave-data thing must be added some day
I guess there're multiple patches for mysqldump

do you mean snapshot as in dump?

yes
--singe-transaction et al.

so dump from slave with --single-transaction and copy the binlogs from master? sounds good, also sounds like it backups part of the data twice...

I guess thats better quality of backup
than not including some data
isn't it?

no, our company policy is "lose clients data, get promoted"

ah, thats my policy too.
no backups
we actually produce backups and let people to download them
so we don't have to store them ourselves

haha, and on the time of crisis you just ask for the data back on newspaper?

I can guarantee we'd have top post on slashdot and few other sites.
haha, last time we had all-datacenter power failure, it was on slashdot too
anyway, downtime is our most profitable product

well, if you tell me the name of your company ill make sure everyone will know that and your policies, free marketing

wikipedia ;-)

lol

the only concern when site is down is 'is the donation message up' ;-)

thats the only item that generates sms-alerts?

what sms-alerts?
what an alert is?

the ones that woke me up without good reason almos every night

haha
sucks to be you

i know

anyway, a good sleep is much more important, than site being down.

well, it would be so nice if our clients thought that way. allthou i could just say something not so nice the next time someone wokes me up

)

Wikipedia Downtime Story
your bedtime story?

hehe

lala

hey Lukas

moin domas

what is wrong with this country? Why are there still ads for dialup internet on the TV?!

you need to move some where where the tv-broadcasts arent 10years old

while others have 100 Mbps full duplex connections in their homes
NetZero is apparently still alive and kicking

can some one tell me how can i allow mysql user to see full processlist of mysql server

processlist privilege?

process privilege

humm
it have
but it just showing its own

and you're doing a "show full processlist;"?

yes

i should prefer --single-transaction over --lock-all-tables ?
but i have few myisam tables, does that change the fact?

L|NUX show grants for current_user(); to confirm the priv

single-transaction and lock-all-tables all mutual exclusive

do you care about consistency of your myisam tables?

yes i do

relative to all the other environment?

yes

then stop the slave, dump, restart replication

or use LVM snapshots

and plain dump with no options?

--opt could help
or LVM snapshots!

lock all the myisam tables with another connection, dump , then relesae them

everyone is so smart here today!

i have fixed that

yeah, it is possible to do teh smart locking yourself.

is lvm snapshot consistant?

PROCESS was not allowed

yuuup

do you mean that i should do 2 different dumps?

thanks domas and kimseong

1 dump, but lock the tables with another connection first

would not --lock-all-tables --all-databases be sufficient? if i stopped the slave first..

yes if you don;t use single-transaction

so is there really any good reason to use it?

if stop slave, no need to lock anymore, since no write is expected

oh yeah
did not see that

single transaction is good for online backup of innodb
no locks backup of innodb

it does lock though
but for a shorter time

is it?

yes, thats why i started to wonder about the myisam tables and stuff... but, ill stop slave and then do an "plain" dump

sure
or is that --master-data?
probably --master-data does the locking, don't remember now

master-data is to get the binlog file and pos

yeah
but you can't do that without acquiring an all-tables lock

any important things to consider about the binlogs, is plain scp/rsync sufficient or do i need to worry about locking and stuff?

so, to test, if i do a select .. for update on innodb then mysqldump will have to wait

binlogs are append-only

hi!

ALTER TABLE transaction DROP INDEX keyindex;

can this take over 15 minutes?

no need for 'for update'

append-only, yes. but does mysql freak out if it can not write to that file because its being used by another process?

i mean if another connection has a write row lock on innodb, then mysqldump will have to wait?

the very nice chain is: a) long query being executed b) mysqldump tries to acquire global lock c) hahaaaa, it did not get it, but no other queries can open tables, nice nice nice!
are you running on windows?

no
so no?
it depends on the size of your database/indexes

well, I guess there're few other platforms where that could be an issue

linux?

any long query will hold up 'flush tables with read lock'
but locks acquired by transaction probably will have no effect
table locks and row locks are slightly different

yes, the for update lock has no effect, table lock will block mysqldump
did a test

yup. on the other hand, every query has one or another table lock

read lock should be fine

try SELECT SLEEP(1) FROM table;
then run mysqldump ;-)

i use lock tables
seems to block on read lock too, weird

guys

update new_users set rank=@a:=@a+1 order by rating desc, num_rated desc;

Lock wait timeout exceeded; try restarting transaction

told you.

what does that mean?
i'm using InnoDB now
does this mean i won't be able to do m y update..?

other transaction has updated the very same table and didn't commit yet?

uhh...it's innodb - does it have transactions?

sure it tells you to restart transaction didn;t it

it does
surprised?
thanks for trying to correct me (and failing! ;-p )

What shall I ls for you master?

oh, you're righ domas

it's running heh

it's just taking a LOT longer than usual

hehe

ugh
also
a select count(*) is taking forever

is the table locked?

thats because it has to traverse whole table, surprise surprise

2
ups, i was changing window on irssi

bah, HydraIRC is so useless

irssi is the truth and the randomness of the masters of the net
irssi is the truth and the randomness of the masters of the net

but I want a gooey

howto insert unix time as timestamp to db ?
some manualpage says that timestamp is stored es epoch time

simplexio, FROM_UNIXTIME()
!man FROM_UNIXTIME()

see http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

ok here goes with irssi

thank you

kopete
oops

oohh... irssi is a lil confusing at the moment

what do you mean?

just switched, will get used to it

yes you will. there is no going back, har har

i have a question about a query syntax working in 5.0.38 and not in 5.0.41 - may i post it here?

insert into hits (codename,hits) VALUES ('305554',1) on duplicate key update hits = hits+1;
Query OK, 2 rows affected (0.00 sec)
But codename is a prikey, how could 2 rows be affected?
I don't get this.

maybe 1 for the failed insert and 1 for the update, difficult to interpret this number for this statement
1 means inserted, 2 means update, something like that

perhaps.. I'll try one that won't be a duplicate.

failed insert + update = two queries?

to differentiate from 1 succeed insert

yes

failed insert IMO wouldn't count as an affected row.
But yeah, when there is not a duplicate collision, the affected rows count is one

but if 2 rows and 2 failed insert with 2 update, not sure what is the number
1 means insert, 2 means update

perfect
I was just worried the second row was some unintended side-effect.

SELECT field_a, field_b FROM mytable WHERE (SELECT field_c FROM mysubtable WHERE mysubtable.field_c=mytable.field_b) != '' GROUP BY field_a, field_b
does anyone know why that works in .38 and not in .41?

what is the error?

!!!

ah, ok getting used to irssi, got it how I want it now
bah, ok getting used to irssi, got it how I want it now /b

xchat ftw

nah I think i've found one that I can finally use
after going through bitchx,xchat,mirc,hydrairc and kvirc..

I'm missing ircii in the list

morning !

morning

DELETE FROM tbl_person WHERE PERSON_ID IN (SELECT a.PERSON_ID FROM tbl_kunde a, tbl_person b WHERE a.KUNDE_ID NOT IN (SELECT KUNDE_ID FROM tbl_vertrag) AND (b.NAME IS NULL OR LENGTH(b.NAME)=0) AND (b.VORNAME IS NULL OR LENGTH(b.VORNAME)=0) AND (b.FIRMA IS NULL OR LENGTH(b.FIRMA)=0) AND b.IST_KUNDE=1 AND b.IST_HAENDLER=0 AND...
...b.IST_MITARBEITER=0 AND a.PERSON_ID=b.PERSON_ID)
error:You can't specify target table 'shopus_person' for update in FROM clause
how to rewrite that elegantly?
will i need to use a stored procedure?
or can this be done in one query?
problem is the delete criteria on the tbl_person (b)
i can't remove them

I'm updating a record
will this work

define "this"

hehe

SELECT * FROM table1 WHERE id != id
Actually its a select query
Aw let me rethink what I'm doing lol
nvm Its a bit late here I'm not sure why I thought of that solution lol

well, this will return nothing
and != should be written ""

Yep..

what do you want?

nvm L)
I'm solved now

over != ?

Never heard that before

used to it

is older

can be used?

aye
i think != has been introduced later to sql
fuck, a giant hornet just flew in through the window
can't believe how big them beasts are

i've changed my.cnf config of mysql to log slow queries, now i want to restart or reload without losing open connections, is that possible?

no
you can set it from within mysql though

without restarting?

yes

great
this is what i'm looking for

hangon, I'm not sure if the slow query log can be configured at runtime
SET slow_query_log 1

what about file path?

!man50 slow-query-log

see http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html
see a href="http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html"http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html/a

Related Topic: