| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> ?
<1> lsmith, You going to be in Orlando next month?
<2> faljse: you can't use limit in subqueries in 5.0.18 so it's not so easy
<0> did you do a binary install?
<3> faceface: yes, random, but often
<3> faceface: RHEL 4
<0> Sonderblade, you want the single highest priced product?
<4> Keizer: yes
<0> wwalker, but your using perl to query right?
<5> Sonderblade: i said "or" ...where price=(select max(price)) or price=(select min(price))
<1> lsmith, I thought that was you on the PHPTek list. I live in Florida. I should probably go to it.
<2> faceface: the single highest priced product AND the single lowest priced product
<0> Sonderblade, and two queries is out of the question?
<0> faljse, that relies on each price being unique...
<0> faljse, or at least the highest and lowest...
<2> faceface: yes, there can only be one query
<0> Sonderblade, why?
<3> faceface: yes, all queries come thru perl DBI
<5> faceface: no.. it finds all lowest and all highest prices... the limit version relies on uniq prices..
<0> wwalker, I suspect some error inbetween mysql...
<0> like each query trying to get a new connection, and you running out of connections (max.connecitons)
<3> strange, it was failing every few seconds, now no failures in minutes
<0> wwalker, ghosts :)
<2> faljse: thanks, it seems like your query works
<3> max_connections = 5000, and show processlist never shows more than about 30
<0> Sonderblade, what happens if two products have the same highest price?
<3> faceface: ghosts! what is this Oracle support!!?? :)
<0> wwalker, still... it should only have 1
<0> wwalker, lol
<0> faceface, I mean, using one perl script you can reuse the same connection
<0> for multiple quereies
<0> I suspect DBI bug not mysql...
<2> faceface: i don't know. one is picked on random :)
<3> faceface: yes. there are about 35 perl processes, 1 connection each
<0> wwalker, ok
<0> and if each connection has the maximum amount of 'per connection' buffer size, does that add up to something reasonable?
<0> Sonderblade, I think your query returns 3 rows if highest or lowest price is a tie
<0> Sonderblade, 3 or more
<0> Sonderblade, use two queries ;)
<2> faceface: i added distinct and that solved it
<0> sorry wwalker, I don't have any more suggestions
<0> Sonderblade, if you say so
<3> ok, since problem 1 has just gone away, I can't trouble shoot it anymore. on to question 2.
<3> I have a dual processor HT xeon server. Which linux sees as 4 procs. When lots of queries hit the mysqld,
<3> 1 of the cpus in top hits 100% but the other 3 never get used at all. I thought mysql automatically used multiple processors?
<6> wwalker: dont work like that dor a LTO of reasons...
<6> oops FOR a lot of reasons ...
<7> Hey all
<7> I need some help with MySql
<8> how do i create a new mysql user?
<7> I'm trying to install vBulletin on my server
<8> Hotwires: just freaking ask!
<7> But I need an MySql account. I installed MySql and set it up. But now what?
<7> user even
<8> Hotwires: you _just_ installed mysql, right?
<7> And Apache and PHP
<8> you got into mysql root yet, or not?
<8> Hotwires: what os?
<7> No, I tried using root but it wouldnt let me in
<7> Windows Server 2003
<8> Hotwires: what p***word did you use..?
<7> p***word
<8> ...
<8> it's blank
<8> ""
<8> nothing
<8> empty
<7> My my.ini says p***word :/
<7> How do I check?
<8> go to command prompt
<7> I have remote desktop ready
<7> Okay
<8> type: mysql -h localhost -u root -p
<8> then click enter when asks for the p***word
<8> if you are not kicked out, type in show databases;
<7> It says not a command
<7> Im using XAMPP
<7> The all in one package
<8> xampp? then check their manual
<7> I have the Gui version of the mysql adim
<8> should have all the steps.
<7> In the mysql config file
<7> my.ini
<7> Is this okay?
<7> [WinMySQLadmin]
<7> Server=C:/Program Files/xampp/mysql/bin/mysqld-shareware.exe
<7> user=root
<7> p***word=
<8> well
<8> yes
<9> HOw can I disconnect a user's session (via a root SQL session)?
<8> in the command prompt,
<10> Hotwires, have you read this: http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html
<8> cd C:/Program*/xampp/mysql/bin
<7> No, I'm just trying to get some forums up
<7> Okay
<8> then mysql -u root -p
<8> i am just wondering, why is it mysql-shareware.exe =/
<7> It connected me
<8> Hotwires: yeey!
<8> ;]
<8> which mysql version?
<7> Now what?
<8> click enter if asking for p***word
<7> I need a user, p*** and db to give to vb
<7> I did
<7> It brought me a kinda shell up
<8> which mysql version?
<7> 5.0.18-nt
<8> right, http://dev.mysql.com/doc/refman/5.0/en/adding-users.html
<8> then you can provide that data you typed in..
<7> How do I create a database?
<10> Hotwires, http://tyson.homeunix.org/notes/mysql.html
<7> I just want a user called vbulletin with a p***word of vbulletin for a database called vbulletin
<7> The Apache and MySql are on the same server
<11> In a SELECT DISTINCT varcharfield, how are records that only differ in case treated?
<10> Hotwires, if this is going to be on the web, i suggest using different p***word
<7> Yeah but the firewall won't allow the MySql port
<9> till someoen breaks into your apache
<7> Therefore only my network can access the backend
<7> Fair point
<7> Okay
<9> or finds a PHP bug
<9> which is the most likely mode of failure anyway
<7> Give me the command with p***word and Ill put my own in
<12> And we all know those PHP forums are *so* secure.
<9> mhillyer: Military Grade.
<10> i gave you a link
<12> The only one I trust is FUDforum, but I don't trust it explicitly.
<7> Im still confused beebum. I just need these forums up asap
<10> did you look at the link i gave you?
<7> Yeah
<10> just replace the username and p***word whith what you want to use
<7> What about the database?
<7> Dont I need one?
<10> that's in there too
<10> create database, and create table
<7> Can I grant access to an entire db? Rather than table?
<10> db_name.*
<7> Okay
<7> I need to create a db first it says
<7> Ill do that
<10> are you realy going to put this on the dmz?
<7> No
<10> good
<9> beebum: d'you know how to knock off a user's session via SQL?
<7> It's going to be behind a firewall
<13> is there an option for mysqlimport to import into a table that's NOT based on the name of the text file????
<10> MyQuiL, revoke would do it
<10> you'll probably have to flush privs too
<9> beebum: but would that actually change the privs too? because the problem is that we have a java thing that's leaving lots of stale connections
Return to
#mysql
or
Go to some related
logs:
ubuntu error trying to exec 'cc1plus': execvp:
#web
#perl
jintxo
ubuntu mount a network drive
#python
site tab layout
fedora cpuspeed chkconfig
transcode export_mp3.so
ubuntu startx cannot stat
|
|