locknet.ro

17 June 2007 · TRUE

StartServers 5
MinSpareServers 5
MaxSpareServers 10
ServerLimit 150
MaxClients 150
MaxRequestsPerChild 10000

innodb_buffer_pool_size = 64M
innodb_additional_mem_pool_size = 16M

Transactions:               91179 hits
Availability:                   99.87 %
Elapsed time:             1801,60 secs
Data transferred:           86.96 MB
Response time:               0.43 secs
Transaction rate:            50.61 trans/sec
Throughput:                    0.05 MB/sec
Concurrency:                 21.62
Successful transactions: 91175
Failed transactions:           116
Longest transaction:        30.01
Shortest transaction:         0.01

Transactions:              2561 hits
Availability:                99.38 %
Elapsed time:            181,32 secs
Data transferred:          2.38 MB
Response time:             2.64 secs
Transaction rate:         14.12 trans/sec
Throughput:                  0.01 MB/sec
Concurrency:               37.24
Successful transactions: 2559
Failed transactions:           16
Longest transaction:      30.61
Shortest transaction:      0.07

Transactions:               10279 hits
Availability:                 100.00 %
Elapsed time:              185.94 secs
Data transferred:            9.52 MB
Response time:               0.40 secs
Transaction rate:           55.28 trans/sec
Throughput:                    0.05 MB/sec
Concurrency:                 21.91
Successful transactions: 10279
Failed transactions:              0
Longest transaction:         6.64
Shortest transaction:        0.01

Transactions:              14501 hits
Availability:                 99.18 %
Elapsed time:             189.25 secs
Data transferred:         36.94 MB
Response time:             0.62 secs
Transaction rate:         76.62 trans/sec
Throughput:                  0.20 MB/sec
Concurrency:               47.82
Successful transactions: 1881
Failed transactions:         120
Longest transaction:     25.28
Shortest transaction:      0.00

Transactions:                11410 hits
Availability:                   99.78 %
Elapsed time:               214.80 secs
Data transferred:            10.88 MB
Response time:                2.14 secs
Transaction rate:            53.12 trans/sec
Throughput:                     0.05 MB/sec
Concurrency:                113.65
Successful transactions:  11408
Failed transactions:              25
Longest transaction:        24.69
Shortest transaction:         0.03

./configure --prefix=/wwwroot --enable-mods-shared=all --enable-so
./configure --prefix=/wwwroot 
--with-mysqld-user=mysql 
--localstatedir=/wwwroot/data 
--disable-maintainer-mode --without-debug
./configure --prefix=/wwwroot 
--with-pdo-mysql=/wwwroot 
--with-mysql=/wwwroot 
--with-apxs2=/wwwroot/bin/apxs 
--enable-memory-limit 
--enable-mbstring 
--with-zlib 
--with-gd 
--with-jpeg-dir=/usr/include 
--with-png-dir=/usr/include 
--with-freetype-dir=/usr/include 
--with-zlib-dir=/usr/include 
--enable-gd-native-ttf 
--enable-exif 
--with-curl
./configure --enable-apc-mmap 
--with-apxs=/wwwroot/bin/apxs 
--with-php-config=/wwwroot/bin/php-config
class User extends ActiveRecord {
  protected function before_insert() {
    // conditiile impuse nu au fost aceptate:
    if ($this->terms_and_conditions != 1) {
      // adaugam un mesaj de eroare:
      $this->getField('terms_and_conditions')->addError('Conditiile nu au fost acceptate');
      return FALSE;
    }
    // setarea unui camp cu valoare initiala:
    $this->created_at= time();
  }
[ ... ]
}
// utilizare (in controller de exemplu):
$user= new User();
$user->insert(); // filtrul este executat!
// sau:
$user->save(); // filtrul este si in acest caz executat!

class User extends ActiveRecord {
  protected function before_update() {
    [....]
    // setarea unui camp cu valoare initiala:
    $this->updated_at= time();
    return TRUE;
  }
[....]
}
// utilizare:
$user= User::find(1); // gaseste user-ul cu id=1
$user->update(); // filtrul este executat
// sau:
$user->save(); // filtrul este executat si in acest caz.

class User extends ActiveRecord {
  protected function before_update() {
    $this->validates_presence_of('name');
    return TRUE;
  }
[....]
}
// utilizare:
$user= User::find(1); // gaseste user-ul cu id=1
$user->save(); // filtrul este executat
// sau
$user= new User();
$user->name= 'Mihai';
$user->save(); // filtrul este executat

class User extends ActiveRecord {
  protected function before_delete() {
    // gaseste mesajele detinute de acest user
    $messages= Message::find('all', array('condition'=>'user_id=?'), array($this->id));
    // sterge mesajele.
    [....]
    return TRUE;
}
[....]
}
// utilizare:
$user= User::find(1); // gaseste user-ul cu id=1
$user->delete(); // filtrul este executat

class Person extends ActiveRecord {
  protected function before_save() {
    $this->validates()->presence_of('name', 'address');
    $this->validates()->uniqueness_of('name');
    return TRUE;
  }
[...]
}
if (strlen($this->name) <= 3) {
  $this->row->getFieldByName('name')->addError('should have at least 4 chars.');
}
[....]
protected function validates_presence_of() {
  return new PresenceOfValidator($this, func_get_args());
}
[...]
class PresenceOfValidator extends Validator {
[...]
}
$this->validates_presence_of('name')->message('%s trebuie completat!'); // => Name trebuie completat
SELECT node.*, (COUNT(parent.name) - 1) AS depth
  FROM categories AS node, categories AS parent 
WHERE
  node.lft BETWEEN parent.lft AND parent.rgt
  AND parent.id !=1 
GROUP BY node.name ORDER BY node.lft;

$last_depth = -1;
$output= '<ul>';  // rezultatul final

while($rs->next()) {
  $current_depth = $rs->getInt('depth'); // adancimea nodului curent
  // conditie cheie:
  if ($last_depth > $current_depth) {
    $output .= str_repeat('</ul></li>', ($last_depth - $current_depth));
  }
  $output .= '<li>' . $rs->getString('name');

  // conditie echivalenta cu intrebarea hasChildren()?,
  // urmata de getChilds() si parcurgerea recursiva 
  // a noului arbore
  if ($rs->getInt('rgt') - 1 != $rs->getInt('lft')) {
    $output .= '<ul>';
  } else {
    $output .= '</li>';
  }
  $last_depth = $current_depth;
}
echo $output . '</ul>';

<script>alert('foo');</script>

class Article extends ActiveRecord {
  protected function before_save() {
    $this->title= htmlentities($this->title);
  }
  [....]
}

[aurelian@gremlin ~]$ ll /mnt/win_d/30-07-2005/.../CreoleSession.php
-r-xr-xr-x  2 root root 4097 Mar  8  2005 /mnt/win_d/30-07-2005/.../CreoleSession.php*

class CreoleSessionContainer extends Object implements ISessionContainer

$container = new CreoleSessionContainer();
session_set_save_handler(array($container, 'open'),
                         array($container, 'close'),
                         array($container, 'read'),
                         array($container, 'write'),
                         array($container, 'destroy'),
                         array($container, 'gc'));

Fatal error: Exception thrown without a stack frame in Unknown on line 0

class Article extends ActiveRecord {
    const PUBLISHED= 1;
    const DRAFT= 0;
    [...]
}

class ArticleController extends ApplicationController {
    // prints the form, and assign article template variable
    public function add() {
        $this->article = new Article();
    }
    // saves the article in the database
    public function create() {
        $this->article= new Article($this->request->getParameter('article'));
        // explicit check:
        if (!isset($this->params['article']['status'])) {
            // the check box is not checked, so we define the
            // default value for this case:
            $this->article->status= Article::DRAFT;
        } else {
            // checked check-box:)
            // default value for this case:
            $this->article->status= Article::PUBLISHED;
        }
        // do actions on article, like save and the redirect if succes or render
        // the form again if it`s a failure.
        [...]
    }
}

[...]
<?=FormHelper::check_box($article,'status');?>
[...]

<input type="checkbox" id="article_status" name="article[status]"  />

$this->request->getParameter('article');

Altceva

Browse

Archives

Recent Entries

Help wanted

Tunning

Test 1: 30 minute, 50 Utilizatori Concurenti, APC Activat

Test 2: 3 minute, 50 Utilizatori Concurenti, APC Dezactivat

Test 3: 3 minute, 50 Utilizatori Concurenti, APC Activat

Test 4: 3 minute, 150 Utilizatori Concurenti, APC Activat

Concluzii

Ce am invatat?

Test Hardware

Test Software

Medick setup:

Consideratii

Apache/2.0.55 (mod_php)

MySQL 5.0.21

PHP 5.1.4

APC-3.0.10

Medick-0.3.0pre1

Update: (11.07.2006)

1) Filtre before_

1a) before_insert

1b) before_update

1c) before_save

1d) before_delete

Lectura suplimentara:

Changelog

Ce nu merge?

Ce lipseste?

Ce urmeaza in medick 0.2.2?