#mysql
03 January 2008
Total 3 pages. You are browsing page 3/3.
First :: Prev :: [1] [2] [3] [4] [5] [...][...] [-1] [0] [1] [2] [3] :: Next :: Last
01:06 <****> Sembiance, RAID 0 if you have good failover.
01:06 <****> Sembiance, for a single server, don't use RAID 0.
01:06 <****> Use RAID 5 or RAID 10.
01:06 <****> no, RAID0 is when you have loony DBA
01:06 <****> anyone know of some mysql bitwise benchmarks
01:06 <****> \o/
01:07 <****> ebergen: well, so many problems we hit in whole LAMP stack were entirely not in our hands
01:07 <****> we ended up fixing them at least
01:07 <****> it helps to have core php and apache developers on the payroll
01:07 <****> Simetrical: thank you :)
01:08 <****> What does "MySQL server has gone away" indicate?
01:08 <****> the opposite of good
01:08 <****> haha
01:08 <****> you beat me to it
01:08 <****> !man gone away
01:08 <****> see http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
01:10 <****> $query = "UPDATE users SET money=money-$post_cost WHERE user_id='{$_SESSION[id]}' LIMIT 1";
01:10 <****> is my deduction syntax correct
01:10 <****> or am i missing quotes
01:11 <****> no idea
01:11 <****> what does mysql say?
01:14 <****> what's the MySQL equivalent of a no-op so I can just have it run periodically to prevent wait timeouts?
01:14 <****> blackjax, echo $query; so we can see what that actually amounts to when the variables are filled in.
01:14 <****> Anonycat ping
01:14 <****> If $post_count='' because it's misspelled, that query won't work. :)
01:15 <****> here's the $query echo'd: UPDATE users SET money=(money-0.5) WHERE user_id='54' LIMIT 1
01:15 <****> (i modified the query by adding brackets)
01:16 <****> still doesn't seem to change the money
01:17 <****> hehehe, amusing: http://ap.google.com/article/ALeqM5iVpozoN4SEv7fIbj-dSXBPinksWAD8TTR2T00
01:17 <****> Anonycat: 'select 1' is perfect
01:17 <****> Anonycat the mysql api has a ping command
01:17 <****> I believe that counts for wait_timeout
01:18 <****> maybe show master status ?
01:18 <****> anything that doesn't touch information schema will work :)
01:18 <****> ebergen: mysql_ping does nasty silent reconnects :)
01:18 <****> oh well, quite a few bits do nasty silent reconnects
01:20 <****> that's part of the point
01:20 <****> but yes you souldn't trust that your session still exists past a ping
01:22 <****> hmm this still isn't working
01:22 <****> it's not setting off an error
01:22 <****> but it's not changing the money amount
01:22 <****> what type is the field
01:23 <****> float
01:23 <****> blackjax: don't single quote numeric values
01:24 <****> blackjax: what data type is user_id?
01:24 <****> hello i was running a program and it said libmysqlclient.so.12 is missing. i uses opensuse. what shell i do
01:25 <****> thanks guys, i did some quote work and it works now
01:30 <****> I was just doing an import and realiezd I hadn't turned binary logging off
01:30 <****> I don't need it for this import, but:
01:30 <****> 080102 19:24:07 [ERROR] /usr/local/libexec/mysqld: Disk is full writing '/var/db/mysql/bin/mysql-bin.000010' (Errcode: 28). Waiting for someone to free space... Retry in 60 secs
01:30 <****> I free'd up space, and all is happy. Is there a chance I experienced data corruption?
01:31 <****> (the data partition did NOT fill up, just the partition with the binary logs on it)
01:32 <****> binlogs could be corrupted, yes
01:32 <****> so it seems i fail at benchmark()
01:32 <****> do benchmark(100000, select (15 | (1 << 10)));
01:32 <****> isnt that right?
01:33 <****> Hi all, simple question--I have a select statement that is like 'select user, pass from mbox where user like '$user%'; but there is a possibility that more than one line could be returned if someone tried to log in with a short username...I could use limit to return only one line, but I'd rather it return nothing if there's more than 1. is this possible?
01:33 <****> oh no select
01:34 <****> drj33, use exact selects on user names not like
01:35 <****> archivist, I'm changing email backends and am hoping to allow for users to log in as user_name or user_name@domain. It's a small userbase
01:36 <****> how do you export the framework of a table?
01:37 <****> MicMac_: mysqldump -d
01:37 <****> for the full thing at least
01:40 <****> MicMac_: or 'create table newtable like oldtable;'
01:41 <****> threnody: thanks but need to export and import in other server
01:41 <****> 10-4
01:42 <****> Database Design question, if I'm creating a group, should I have a group table with a primary key, then a table of user/group associations in a seperate table?
01:44 <****> MicMac_ to get the actual table schema, do mysqldump -p -d db_name table_name
01:44 <****> learath: why would you need a group table
01:44 <****> learath: if users can belong to multiple groups, and groups have several fields of info, then you should have a user's table, a group table and a linking table.
01:44 <****> learath: make your group names short&symbolic and put that into group association table
01:45 <****> :)
02:05 <****> domas: I understand the binlogs can be corrupted. I removed the binlogs.
02:05 <****> what about the data files?
02:05 <****> would any transactions be lost ? (it was an import of a mysqldump)
02:05 <****> nope
03:00 <****> if i want to select everything from table1 where column2 is not null, how should the query look like?
03:01 <****> exactly like that
03:01 <****> on replace everything with *
03:01 <****> hehe. damn. why wont it work.. I'll try again then :P
03:01 <****> *only
03:01 <****> select * from table1 where column2 is not null
03:03 <****> ok thanks.. i used = instead of is
03:07 <****> is there a way to turn off query caching for a single table?
03:08 <****> _hp_, not sure, but you can turn off query caching for individual queries, if that helps.
03:12 <****> is it possible to do something like NOW() - 5 min ?
03:12 <****> Yes
03:12 <****> NOW() - INTERVAL 5 MINUTES
03:12 <****> Or similar.
03:14 <****> 5 MINUTE actually, but that'll work.
03:16 <****> Simetrical: thanks
03:16 <****> How do I go about grouping number in a query so instead of 10000 I get 10,000?
--- Log closed Fri Jan 04 00:00:12 2008
Total 3 pages. You are browsing page 3/3.
First :: Prev :: [1] [2] [3] [4] [5] [...][...] [-1] [0] [1] [2] [3] :: Next :: Last