IRC Logs

Network: freenode Channel: #mysql

	Enter your search terms Submit search form
	Web www.irclog.org

[11:10]<prdy>thanks
[11:10]<[z]pzgg2sm_pzg>my rc.conf wont start mysql anymore with this: mysql_enable="YES" i need to type later on: /usr/local/etc/rc.d/mysql-server start
[11:11]<[z]pzgg2sm_pzg>any ideas to fix this?
[11:11]<[z]pzgg2sm_pzg>if i try that latter command from rc.conf, it messes up my os :P
[11:11]<fjcus>tdd1984: give domas the test data
[11:12]<vmmwno9>k hold on
[11:12]<zjw>how would I ping the mysql server to keep a mysql connection alive?
[11:12]<vmmwno9>lokus: okay do you what the data from mysql?
[11:12]<djdrs>row: mysql_ping() ;-)
[11:13]<zjw>er who said I was using php....
[11:13]<djdrs>row: it's C function too
[11:13]<fjcus>tdd1984: pastebin the data, select and the output
[11:13]<zjw>whats the mysql command
[11:13]<djdrs>row: 'select 1' ;-)
[11:13]<vmmwno9>k
[11:13]<vmmwno9>hold on
[11:14]<zjw>domas: yeah good idea :P
[11:14]<fjcus>row: maybe can try to increase the timeout
[11:14]<zjw>its a long term connection that will stay open for good.
[11:14]<vmmwno9>http://papernapkin.org/pastebin/app/view/945
[11:14]<zjw>I can't afford the overheads of starting it up everytime incase it gets shutdown, should not need to ping it however.
[11:15]<djdrs>row: overhead of starting up? you must be dreaming
[11:15]<zjw>domas: as in time
[11:16]<djdrs>you must be dreaming
[11:16]<zjw>k...
[11:16]<zjw>I will leave it as is for the moment, I just can't afford to have to wait long for it to come up.
[11:17]<vmmwno9>lokus: you get the link i just posted
[11:17]<vmmwno9>thats the dumping data let me get you the select
[11:17]<fjcus>tdd1984: can't you have smaller test data
[11:17]<vmmwno9>sorry
[11:18]<vmmwno9>i will next time :)
[11:19]<xra>It's not that large. The largest table is 500 entries in images. The other two tables have just a handful of data.
[11:19]<vmmwno9>yea
[11:19]<xra>I suspect most of the images could have been removed from the test data.
[11:19]<fjcus>importing the data
[11:19]<vmmwno9>yea
[11:19]<djdrs>anyway, group by works properly for me with 4.0 ;-)
[11:20]<fjcus>tdd1984: the select statement
[11:20]<xra>domas: Oh? How many groups did you get?
[11:20]<vmmwno9> SELECT '1' cnt, user.*, items.* FROM user, items WHERE items.userId=user.ID GROUP BY user.ID, items.itemid
[11:20]<vmmwno9>yea probaly work until you get up to 3
[11:20]<djdrs>Xgc: as many as expected.
[11:20]<djdrs>it was with my own data
[11:20]<xra>domas: Sorry. When you test his data, I'll be interested.
[11:20]<fjcus>returns 9 rows on 4.1.9
[11:21]<fjcus>i should upgrade
[11:21]<vmmwno9>hmm
[11:21]<xra>5.0 was fine also.
[11:21]<fjcus>4.1.19
[11:21]<xra>lokus: That's correct.
[11:21]<vmmwno9>:)
[11:22]<vmmwno9>xgc: are you guys just importing the data into your database vai web server, or from your computer?
[11:22]<xra>tdd1984: You know, if domas comes up with 9 groups too, the problem might be you. :)
[11:22]<vmmwno9>lol yea
[11:22]<vmmwno9>xgc: but it didn't work for you did it?
[11:22]<xra>tdd1984: mysql command line client.
[11:22]<xra>tdd1984: Worked fine in 5.0.
[11:23]<fjcus>9 rows in 4.0.21 too
[11:23]<xra>Nice.
[11:23]<vmmwno9>hmmm
[11:23]<fjcus>but i have 4.0.21-debug on windows
[11:24]<xra>tdd1984 has 4.0.27-max-log
[11:24]<fjcus>and 4.0 is now at 4.0.27 already
[11:24]<vmmwno9>yes
[11:25]<xra>tdd1984: This is not looking good for *you*.
[11:25]<vmmwno9>I wonder why its doing this thow?
[11:25]<djdrs>9 rows on 4.0.28-debug
[11:26]<xra>tdd1984: Are you entirely sure you are testing against the same data?
[11:26]<djdrs>I guess I'm not needed here :-)
[11:26]<xra>tdd1984: You don't have more than one test database around?
[11:26]<vmmwno9>i can create one
[11:26]<xra>It still could be a strange bug.
[11:27]<xra>tdd1984: Take the dump you posted and create a new database.
[11:27]<vmmwno9>im using the database on godaddy.com
[11:27]<vmmwno9>k
[11:27]<vmmwno9>should i install anything on my pc?
[11:27]<vmmwno9>brb
[11:27]<vmmwno9>when i asked install anything on my pc like mysql command line editor
[11:28]<fjcus>tdd1984: how did you execute the select ?
[11:28]<xra>tdd1984: No. Just create another database on the web host.
[11:28]<fjcus>tdd1984: using the data in the pastebin
[11:29]<vmmwno9>k hold on
[11:29]<vmmwno9>lokus: with ;
[11:29]<fjcus>ignore me, take Xgc suggestion
[11:30]<vmmwno9>lol why you say that for
[11:30]<vmmwno9>xgc: i got yahoo.com web hosting too with newer mysql, but hold on
[11:31]<fjcus>oh, the select question, I want to ask what do you use to run the select, what client since it is from the webhost
[11:31]<xra>tdd1984: We just want you to test this with a new database and the data you posted for us, using the same MySQL server you are currently having trouble with.
[11:31]<xra>He's using phpmyadmin, I believe.
[11:31]<vmmwno9>yes
[11:31]<vmmwno9>phpmyadmin
[11:31]<fjcus>ok
[11:32]<vjgzgffgfyg>Greets everybody! Does anyone have an experience in using MySQL Embedded Server Library with DotNET programme?
[11:32]<zzjjgy>ok mysql buffs.. heres a problem for you... three tables: 1) user (id), 2) delivery (user_id, message_id), 3) message (id) .... for a specific message id, how would you find all the users who received it... (delivery is a rich join model and represents all deliveries of a message)
[11:32]<fjcus>vonZeppelin: does it work in dotnet? thought is is only with C api
[11:32]<zzjjgy>with one query
[11:33]<vmmwno9>k hold on creatin db
[11:33]<xra>arooni: Simple JOIN.
[11:33]<vmmwno9>ahhh
[11:33]<vmmwno9>xgc: it says pending setup right now

Back to #mysql
Or go to some related logs:
#gentoo
#gentoo
#gentoo
#gentoo
#cisco