| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12
Comments:
<0> how can i list all users that are created into mysql?
<1> channel debianfans
<2> USE mysql; SELECT user,host FROM user;
<0> tks
<3> I am formatting an /db partition for database usage (with largefile4). The question is which is better, ext3 or ext2? Does not mysql already has transactional logic, so ext3 only takes redudant time? What do you say?
<0> i'd recommand reiserfs
<4> hi
<2> Migo1: wait
<0> makes it faster for dbs and caches
<3> le_mackeux: thanks for offtopic :)
<2> Migo1: is the db partition ONLY for MySQL databases?
<0> ;)
<3> Darien: yes
<2> !m Migo1 raw device
<5> Migo1: (Using Raw Devices for the Tablespace) : http://dev.mysql.com/doc/mysql/en/InnoDB_Raw_Devices.html
<2> Migo1: seriously consider that solution
<2> Migo1: that will be faster than any other option
<2> Migo1: you can byp*** filesystems entirely
<3> thank you, never heart about it, reading
<4> i was wondering how to implement a shop with totally different products... say different types of fruit and computer parts. how do you deal with the different properties of the product. i.e say you got a products table, but fruits have properties like Ripeness, Color, and come in bundles, and COmputer parts have stuff like, for exmaple CPUs: clock speed, L1 cache, etc, etc ,etc
<4> i've been thinking of evil things.. but note sure if they make sense
<3> Darien: well, I don't think this is what I want, I need to access table files, to occationally backup/remove them manually (yes, after shutdowning mysqld)...
<2> Migo1: you can backup the raw partition
<3> I need individual files.
<3> moreover I want to run 2 mysqls with base on /db/mysql1 and /db/mysql2. So the question is still stays. ext2 or ext3? :)
<2> ext2
<3> thanks
<2> keep one thing in mind
<2> MySQL's transactionality only works if you ***ume no failures in your disk controller
<2> i.e. if you ***ume all writes complete
<2> I'd probably use reiserfs, actually, to ensure that files stay in a consistent state
<2> but you can still lose your data if your disks fail (e.g. power outage)
<3> losing some last data is ok, not having to repair on every clean reboot (without mysql shutdown) is more critical
<2> reiserfs
<6> and UPS
<6> :)
<3> does it support largefile4? 4Mb per block?
<2> largefile4?
<6> you can define your custom fs parameters
<3> man mkfs.ext2/3 :)
<6> reiserfs is perfectly capable of supporting larger block sizes
<7> good evening all...
<8> how can i show what the current MASTER settings are on a slave?
<2> SHOW SLAVE STATUS; should do it
<2> !m hypnox replication
<5> hypnox: (Replication in MySQL) : http://dev.mysql.com/doc/mysql/en/Replication.html
<7> I've a little sql-query problem... maybe someone can help? (question follows...)
<8> Darien good job, i would have never thought of that :P
<7> Following table: http://phpfi.com/101848 ... I want to get the two newest entries of the topic_id's... in this cas post_id 5 and post_id 6... how should the query look like? I've tried with "SELECT DISTINCT topic_id, post_id, ..., FROM table ORDER BY post_time DESC", but this gives me all five entries... I've also tried with "GROUP BY topic_id ORDER BY post_time", but then it gives me the first two entries and not the last ones.
<7> "GROUP BY topic_id ORDER BY post_time DESC"
<2> wow, the question really did follow
<2> I'd given up
<7> Darien: because of my bad english or because it is too complicated? *g*
<2> hmm
<2> dma147: like SELECT ... FROM table ORDER BY post_time DESC LIMIT 2 ?
<2> or... ?
<7> Darien: erm, no...
<7> wait..
<7> Darien: I need unique topic_ids in the result with the newest post_time
<2> ok
<2> SELECT topic_id, max(datetime) FROM table GROUP BY topic_id ?
<9> Is this even possible with SQL? - http://hastur.ext.fi:8000/friend-fan.txt
<7> Darien: again no...
<2> I need food
<7> Darien: hum:... I really don't know how to explain it better with my broken english... :((
<2> dma147: no, I just can't think very well
<2> what you want makes sense though
<7> Darien: think of it like a result which should give me the latest posts of a discussion forum but not two posts in the same topic.
<8> replication is so flaky :|
<10> how can I rename column "foo" to "bar" in table "test" with MySQL 4.1?
<7> Another one who can help me with this table: http://phpfi.com/101848 ? I want to get the latest posts of a discussion forum but not two (or more) posts with the same topic_id...
<11> i got a problem with my MySQL server and i was wondering if anyone here could connect to it its at http://mysql5.streamline.net/phpmyadmin/
<10> ALTER TABLE foo RENAME foo to bar; as a description
<12> dbe: ALTER TABLE t CHANGE oldname newname
<13> Is there any way to shut down a MySQL server without it flushing its cache to the tables?
<7> Anyone here who can help me with this table: http://phpfi.com/101848 ? I want to get the latest posts of a discussion forum but not two (or more) posts with the same topic_id...
<12> NeoThermic: why would you want to do that?
<13> elJo: to perserve "MAC" times (modfied/accessed/created) for data forensic reasons.
<7> *sad*
<12> NeoThermic: well, plug the power :)
<13> elJo: heh, but thats a bit distructive in general, and might require writing to the data to fix it.
<12> NeoThermic: so you should do a "sync" before ;)... but shutting down mysql without flushing the cache is a bit distructive too
<13> hmm, a catch-22
<12> NeoThermic: a kill -9 could walk though
<14> what's the difference between concat and coalesce?
<12> s/walk/work/
<14> they seem redundant to me, or at least interchangeable
<3> sorry about the faq question, but google is silent when I enter 'mysql "insert into host"'. Is not it correct to just add a row to table "host" and "flush priviledges"? Does not work for me...
<14> argh, this is my day for nasty SQL challenges i didn't plan on
<14> i need to display one table in order of name, UNLESS there is no name, in which case i need to display any ones that have the same foreign key after it
<14> so, show attendees in order of attendee's name, unless there ISN'T any attendee name, so show it underneath the same tickets with the same ticket_id
<14> if that makes any sense
<12> muhoo_: what? :)
<3> muhoo_: do you want pure sql, or 2 queries and some scripting language in between is ok too?
<3> dma147: me too, but I am optimistic yet :)
<7> gn8@all
<15> hey, quick question -- should this work on version 4.0? SELECT EXTRACT(WEEK FROM '2006-02-01') AS result;
<15> i'm getting an error, but the documentation says that EXTRACT uses the same date parts as DATE_ADD ... and i believe date_add works correctly ...
<15> hmm
<16> Can someone help me get MySQL Connector/J running in Linux?
<16> I've downloaded it and untarred it so that the mysql-connector-java-3.1.12 direcotry is in /urs/local
<15> oh well, f it, i'll just leave 'week's out of my application ...
<16> I meant /usr/local
<17> hi all, when restoring/importing data from a file like so (mysql --user=user --p***=p*** < "/home/sofa/some dir/some back sql file.sql") What is the correct way to do this with the spaces in the dir names and the sql name?
<0> guys i totally can't make mysql server accessable from a user outside the machine
<0> i can't grand a user correctly so that i can't connect from a remote host
<18> Hi guys, is there a query I can use to determine the field with the highest ID within a table?
<0> i need help
<19> le_mackeux: are you using phpMyAdmin or the CLI?
<0> cli
<19> let me look up what to type
<0> i can't use phpmyadmin cuz i'm using php5 and it makes error with phpmyadmin
<0> tks
<8> whats a .ibd file?
<19> le_mackeux: is this is new mysql install or do you have data in it?
<8> and whats ibdata1 ?
<0> i have data
<19> here is one way: mysql> grant usage on *.* to dbuser@localhost identified by 'somep***word'; I would ***ume you can change dbuser@localhost to be someone@publicdomain.com but I'm looking it up still
<8> anyone?
<19> that makes a superuser though
<4> If you want to connect remotely check 1) comment skip-networking and set bind-address in my.cnf 2) restart mysqld and check that it's listening on the external interface with netstat 3) make sure the host that is connecting is granted in the `host` column of your mysql table for that user
<19> thanks Jax, I was trying to be helpful :) I'm kinda a newb so am much slower heh
<14> Migo1: elJo: sorry my brain exploded from trying to fix this
<4> malchias people ask that so many times a day, i made a shortcut to that message ;)
<14> instead i decided to leave it broken
<4> hypnox what was your question?
<19> muhoo_: you need more dura'ble matter
<14> i need a pure SQL solution, and i'll just have to leave it for now, thanks though.
<3> muhoo_: :)
<0> malchias: is the 'user' that i grand privileges can be a user that don't exing into mysql db?
<8> jax, i was asking what a .ibd file was and why it would be missing
<19> le_mackeux: I believe that makes the user into the db
<20> any sql help here? #sql is nonresponsive..
<4> it's an innoDB index file
<4> rxvtman yeah probly, what's up
<8> jax, can they be re-created ?
<0> malchias: it makes a syntax error with/out an existing user
<20> i'm trying to update a table
<20> using the group results
<20> like i want to update a table with the MAX of another table
<4> hypnox couldn't say. i never use innoDB really
<0> malchias: the 'on' was missing
<20> i was going to join them and use group by, but thats not working, update doesn't allow group by
<0> malchias: still not working to connect to the db
<19> did you see what Jax posted?
<0> the grant usage on *.* .... worked though
<4> hypnox actually it's the table AND index in one file.
Return to
#mysql
or
Go to some related
logs:
error 1064 mysql myisam default charset utf8
#lgp
gentoo superuseradd
#linux
#oe
PHP curl throw exception
undefined _zend_list_delete
(555 syntax error (#5.5.4))
unmask dvdrtools gentoo
#kde
|
|