#apache #archlinux #asterisk #centos #debian #gentoo #haskell #kde #kubuntu #lisp #math #mysql #perl #python #ruby-lang #rubyonrails #suse #ubuntu #vim #wikipedia 0 1 2 3 4 5 6 7 8 9 10 11 12
Top Prev 5415 5416 5417 5418 5419 5420 5421 5422 5423 5424 5425 5426 5427 5428 5429 5430 5431 5432 5433 Next
#mysql
<js_> sorry about that
<thekeeper> does anybody know how i can tell if a table repair has hung up, and/or if it's safe to kill a thread running repair (to restart)?
<fraggeln> is there any way to grow a innodb tablespace-file in advance?
<fraggeln> I want to allocate 50gb innodb, but not fill it right now.
<nils_> yes.
<fraggeln> how?
<praecox> hello guys
<snoyes> MidMark: I haven't found a good way to grab the results from a linked list without doing a query per row (for the same reason that people use nested sets instead of adjacency lists for hierarchical data)
<praecox> I've pretty weird question
<nils_> innodb_data_file_path=ibdata1:50GB:autoextend
<nils_> I think
<fraggeln> in my.cnf?
<nils_> yes
<nils_> it will fill it until 50GB, if you reach 50GB the file gets extended
<praecox> 070220 15:56:14 Error at /etc/init.d/mysql\nUnknown suffix '/' used for variable 'socket' (value '/tmp/mysqld.sock')
<praecox> /usr/bin/mysqladmin: Error while setting value '/tmp/mysqld.sock' to 'socket'
<praecox> that's what I'm getting when I try to start mysql.
<praecox> I changed the location of mysqld.sock from prior /var/run/mysqld/mysqld.sock
<fraggeln> nils_: and it will allocate 50gb from start?
<praecox> earlier I got:
<christefano> Yes, that's right
<Xgc> christefano: Strange. I know there are some applications design like this. It's still rather strange.
<christefano> All the tables will be the same (except for the prefixes) but will contain different data
<Xgc> christefano: No. There's no general tool for this, that I know of. There's good reason for it. You could write your own tool, designed for this specific application, since you know the table names.
<christefano> This is for a multisite configuration with the Drupal CMS
<christefano> There's no command line or phpMyAdmin command that will batch add prefixes to tables?
<Xgc> christefano: Just do it yourself. Be sure table names are the only issue.
<Xgc> christefano: None.
<christefano> There are many, many tables
<Xgc> christefano: It's not just the table names. You have constraints that refer to these tables as well.
<christefano> Hmm. OK.
<CicciuxLa> Hi. I have a sql logic problem. I need all the rows of a table, joined when matching to records on another table, however I need all the rows of the first table, not just the ones that match. How do I write the JOIN ON clause?
<Xgc> CicciuxLa: LEFT JOIN
<CicciuxLa> Please, explain.
<CicciuxLa> I know it's LEFT JOIN
<Xgc> CicciuxLa: SELECT ... FROM t1 LEFT JOIN t2 ON ...;
<Xgc> CicciuxLa: You do?
<Xgc> CicciuxLa: SELECT ... FROM t1 LEFT JOIN t2 ON t1.fx=t2.fy;
<CicciuxLa> Yes, however I am getting just the rows that match.
<CicciuxLa> with left join I get ALL the rows of t1
<CicciuxLa> and the rows of t2 that match. is that correct?
<CicciuxLa> Oh... it's a problem with my WHERE CLAUSE...
<Xgc> CicciuxLa: No. That's not possible unless you made a mistake in the WHERE clause. Don't use a WHERE clause for this.
<CicciuxLa> I will need a subquery.
<CicciuxLa> The problem is in the WHERE CLAUSE... I found it.
<Xgc> CicciuxLa: The point of the ON clause is to provide the join criteria. Don't use a WHERE clause for that.
<CicciuxLa> I am not using the WHERE clause for the JOIN criteria...
<CicciuxLa> the problem is that I only need the records of the second table that meet some criteria.
<Xgc> CicciuxLa: Actually, you did, by mistake. Any test of the right table of a left join can be thought of as join criteria.
<Xgc> CicciuxLa: SELECT ... FROM t1 LEFT JOIN t2 ON t1.fx=t2.fy AND t2.fz = 'blah';
Previous Page Next Page