| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
Comments:
<0> msdfaasfdfasdsdfasfdafsda
<1> or that
<2> most distros protect config files but who knows
<3> i am running version 5.0.18-6
<1> it may be skip-networking issue then
<1> debian ?
<3> yeh
<1> !man debian
<3> ubuntu same same
<4> Nothing found.
<2> quotemstr: what would you group by?
<1> check to see if skip-networking is on
<3> how ?
<2> quotemstr: if you need information from the parent table, there is no way around joining (in a single query)
<2> quotemstr: disregard I misread. :D
<1> in your /etc/my.cnf or whatever debian puts my.cnf in
<3> ok hold on
<2> quotemstr: a join on indexed fields should be sufficiently fast
<5> tell me a good frontend for mysql
<5> graphical...
<3> # Instead of skip-networking the default is now to listen only onlocalhost which is more compatible and is not less secure.
<1> http://hashmysql.org/index.php?title=Conn-Config
<2> !tell salle about gui
<4> Alrighty.
<2> doh
<2> !tell salmiak about gui
<4> Alrighty.
<2> sorry salle
<2> :D
<6> shabbs: Well ... I'm not GUI guru you know :)
<5> thanks, mate.
<2> stupid tab complete
<2> it should read my mind and know what I meant
<1> the bot is stupid
<1> blahh: http://hashmysql.org/index.php?title=Conn-Config
<2> yes, it has nothing to do with the users incompetence
<1> never
<1> the bot authors incontinence only
<3> alphablue: commented that stupid line and still nada
<7> Hi. I've made a backup from MySQL 4.10 and restored it on MySQL 4.15. When the restored db is used, I get an error saying that it is missing a '_table_name_.idb' file. I've copied all the db directory. Any ideas ?
<8> hi guys. anyone know what the overhead will be if i JOIN tables with different engines? Like mixing MyISAM with InnoDB?
<9> hi quuxman
<10> my predecessor!
<3> everything is by the book and still no show
<2> wavefunction: a proper 'backup' involves a datadump, not just copying the files from the datadir
<11> hey, quick question, anyone know of a nice web application or similar that will give stats on mysql ?
<11> like, slow query log, bytes in/out etc. ?
<12> I'm getting the following errors in my log: "File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)" and "Character set '#33' is not a compiled character set and is not specified in the 'c:\mysql\share\charsets\Index' file"
<2> wavefunction: you're getting the error because innodb tables can't be copied the same way myisam tables can
<12> The thing is I don't have a C:/mysql directory at all
<7> Is it possible using mysqldump ?
<2> yes, dump your databases using mysqldump and then reload on the new server
<7> Okay. I'll try it. Thanks, shabbs !
<8> ken__: you might want to try phpMyAdmin. they have some stats. not really nice for this, but maybe sufficient for your use
<12> I seem to be missing an utf8.xml in mysql/share/charsets
<12> anywhere I can get it?
<12> 4.1.16 has problems with Unicode?
<12> ..
<13> does mysql 4.1 supports subqueries?
<11> fluffles: i use phpmyadmin, but like you said, that's not exactly what i need ;) i'm trying to get something like awstats so that i can get a daily summary on usage or whatever -- i need to track down some inefficiency problems, and i think this would be one of the best ways to start
<13> I found it, supports ;)
<12> what are the valid character sets for mySQL?
<14> I have two tables 1) news items 2) comments for each news item. the news item's id field is the comment tables threadid field. How would I formulate the most efficient SELECT statement to list the top 10 most popular news items determined by the number of comments?
<15> hi
<15> Whats wrong with this: UPDATE groups'WHERE user_id='8f1a35b92cb768534fab022273025ad9' (group_id, group_name) VALUES ('0', 'Individuals')
<16> !m Cctoide charset
<4> Cctoide: (Character Set Support) : http://dev.mysql.com/doc/mysql/en/Charset.html
<11> ChrisP: the ' between groups and WHERE
<15> I get: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE user_id='8f1a35b92cb768534fab022273025ad9' (group_id, grou
<11> yeah
<11> the ' that is three
<11> there
<17> kenn__ you can get those variables any time, use "show variables" for your qry also set the slow qry time to a lower value and check the slow qry log
<11> you're using INSERT INTO syntax
<15> Oh
<12> hm. Error 2003 now.
<11> archivist: thank you -- i'm already using those -- but i would like something that can keep some kind of a log and graph the usage, specically in kilobytes transferred over timespans
<12> now it refuses to start 0.o
<11> here's one: http://pqa.projects.postgresql.org/
<14> Trying to create a "Popular" List of news items based on number of comments. First I SELECT * FROM news, then I SELECT * FROM comments where threadid = newsid
<14> then what do I do? I am stuck there
<11> Delistick`: insert into `news` (`column_name`) values ('blah');
<18> Hello guys, quick question: can I use triggers in ver 4.1??
<14> ken, wrong person
<11> Delistick`: err -- i misunderstood the question
<16> Delistick`: select news_article, count(comments_ID) from news JOIN comments on news.ID = comments.news_ID
<14> ken, I am trying to display the news items with the most comments
<11> Delistick`: sorry -- you should use a GROUP BY and COUNT()
<16> Delistick`: errr, add group by news.ID to the end of that
<14> ok will try that
<16> !tell _Thor about 5.0
<4> Alrighty.
<14> inviso, there is no comments_id in the news table
<14> only a newsid in the comments table
<14> the newsid is the threadid for the comments
<16> Delistick`: sure. it should read count(comments.ID)
<16> Delistick`: of course, I'm making up column names based on how you *might have your tables structured :)
<14> I realize that
<14> man, this is brainteasing
<14> I am trying to do the following
<14> http://www.phpriot.com/2675
<14> to post Popular Posts... not having much luck, any help will do please
<19> huh?
<19> oscommerce requires register_globals ?
<20> nope
<13> hi, how could I have this query working with mysql 4.0 SELECT ID, Title, Attr1 FROM TABLE1 WHERE (linkedContentID =(SELECT ID FROM TABLE1 WHERE Attr1 = '3z1'))
<19> gorgory, nope what ?
<14> whats wrong with this? SELECT anews.id, anews.headline, count(acomments.id) as popular from anews JOIN acomments on anews.id = acomments.tid GROUP BY anews.id WHERE verified = 1 && xmlsitetype = 0 ORDER BY popular DESC LIMIT 10
<14> gives an error with the WHERE
<14> wrong paste
<14> I meant this:
<14> SELECT anews.id, anews.headline, count(acomments.id) as popular from anews JOIN acomments on anews.id = acomments.tid GROUP BY anews.id WHERE anews.verified = 1 && anews.xmlsitetype = 0 ORDER BY popular DESC LIMIT 10
<21> Delistick`, you need to move the where clause before the aggregat function
<14> ty SW
<22> I'm trying to get just the records from a given month, but this always results empty: SELECT blah FROM table WHERE DATE_FORMAT(time_submitted,'%m-%Y)='2004-02';
<22> time_submitted is YYYY-MM-DD
<23> I have a strange problem with mysqld_safe... when I start it with the mysqld_safe --user=mysql & it starts and stops right away, but when I change the user to one that doesn't even exist, it will start, give an error and stay running, any thoughts?
<16> [fields]: where month(time_submitted) = 2
<16> [fields]: and year(time_submitted=2004 I suppose
<2> [fields]: and if you had the month and year in the right order it might even work the way you had it
<22> shabbs: yep
<16> [fields]: or even time_submitted BETWEEN "2004-02-01" AND "2004-03-01"
<22> inviso: oooooh
<22> thanks all
<16> :) np
<16> bch2: that *is wierd :) How about putting some of those errors into pastebin?
<23> ok
<24> hi there, how do I import a MySQL script/dump via the mysql client?
<25> mysql -u<user> -p<p***> <database> < dump.sql
<26> can anyone here make an argument for not publishing identity keys in an application?
<26> is there a better channel to ask database related questions?
<27> I'm optimizing someone else's code. They have done integer_field='123' a lot. Does that create overhead converting integer_field to a string (or the string to an integer?) ?
<16> mmunky: maybe it does that anyway when processing input? No idea really and you won't know unless you benchmark it. It's unlikely to be the most productive thing you can do though
<28> is there a way to turn off table name case sensitivity in mysql 5 ?
<16> !man mode
<4> (Single User Mode) : http://dev.mysql.com/doc/mysql/en/MySQL_Cluster_Single_User_Mode.html
<16> !man strict mode
<4> (The Server SQL Mode) : http://dev.mysql.com/doc/mysql/en/Server_SQL_mode.html
<27> i'm looking at indexes against a log of executed SQL in the general running of the site, and optimising multiple queries that could be JOINed or combined into one.. is there any other obvious stuff? (PHP web app)
<16> GhettoJava: not that I'm aware of
<26> can anyone suggest a good channel to discuss database design issues?
<16> ekkis: if you're using mysql, this is a fine place
<16> mmunky: do you have the slow query log turned on?
<27> nope, i'll check that out.
<16> !m mmunky slow query log
<4> mmunky: (The Slow Query Log) : http://dev.mysql.com/doc/mysql/en/Slow_query_log.html
<16> mmunky: make sure you adjust the slow_query_time (something like that anyway)
<27> ok, thanks
<16> mmunky: and you might take a look at some server settings. thread_cache_size, key_buffer, query_cache, etc. They can make a rather large difference if they're not tuned
<16> !m mmunky server system variables
<4> mmunky: (Server System Variables) : http://dev.mysql.com/doc/mysql/en/Server_system_variables.html
Return to
#mysql
or
Go to some related
logs:
how to uinstall fluxbox
on ubuntu server can't load root terminal
service iptables status rhel5
#perl
#python
mysql_safe hang
imagerotate ubuntu
#lgp
PAYAL KODE
#css
|
|